What you see is not a bug, it’s an annoying heritage of C syntax. Might even
precede C. Here’s the problem:
select column1*(24/100);
And here’s what you’re meant to do for 24%:
select column1*(24.0/100.0);
Alternatively, the value in column1 should be real. That should also
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Tony Papadimitriou
Gesendet: Donnerstag, 14. Dezember 2017 17:36
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] Is this a bug with expression evaluation?
I’ve
2 matches
Mail list logo