In a virtual column I have the simple test expression 20/16
.
The column type is TEXT.
In the expression assistant, the result is โ1โ.
In the App the result is โ1.25โ.
I know I can workaround this by using FLOOR(20/16)
.
But in fact itโs confusing, when the results are different.
Interesting
I just tried 20.0/16, thatโs how you produce non-integer results in many languages. Expression assistant returns 1.25.
Given that the expression assistant often throws an error about type mismatch between the return value and the column type, I assume there are two different processors happening, one to produce the expression result, and one to cast it into the column type, if possible.
Iโm not sure if this can be considered a โbugโ or not. I suppose knowing the end result, and not the intermediate result would be better though.
When the result is different, it means there is a small bug. They should give the same result.
@adam FYI
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |