[sqlite] issue: % in expression with binding paramter.

[László Zoltán Buza]

Hello,



Today, i ?ve used the following expression, but I?ve got unexpected results:

((@korte % 2) + 1))



I binded ?@korte? to 5 as integer, using sqlite3_bind_parameter_index and
sqlite3_bind_int.

And I?ve got 6 as result, instead of 2.

It does the same with numbered paramters as well.

I?ve tried to use parentheses around the paramter but doesn?t help.

If I wrote the value directly into the query, it works fine.

I made a workaround: I?m giving +1 parameter with the value of the
expression. (it works either)



My sqlite version is:
3.8.11.1



Building with VS2015 (14.00), for x86 (32 bit, Windows).



Regards,



L?szl? Buza