Yes it is expected. Strings always compare greater than numbers. Arithmetic operators will apply numeric affinity to their operands, allowing e.g. the addition of a string and an integer to produce the expected result.
-----Urspr?ngliche Nachricht----- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Brandon Gesendet: Freitag, 19. Februar 2016 18:14 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] SQLite as calculator We are using SQLite to do some simple expression evaluation in our app. In so doing - we have notices the following: sqlite> SELECT '1' > 100; 1 sqlite> SELECT '1' + 100; 101 From my point of view this seems somewhat inconsistent. I understand I am not really using SQLite in a way it was designed to be used - so I am not really 'complaining' - I am asking if this is exepected? Thanks in advance, Brandon -- *LEGAL DISCLAIMER:* The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: hick at scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation.
