Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-23895

false, and true in sqlite

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • P2: Important
    • 5.0.0
    • 4.8.0, 5.0.0
    • SQL Support
    • None
    • 156b9ab38e81ee074d384e8e5433afc96d587a11

    Description

      Sqlite driver put to querys values true, and false as string.
      I ask about true and false values at sqlite mailing list, and I think there is a bug in qt(sql driver).

      Because when I use:
      bindValue("someKey", true); // this put to query 'true' as string
      bindValue("someKey", 1); // this put to query 1 as integer

      My message on sqlite mailing list:
      http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036340.html

      And replays:
      http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036342.html
      http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036343.html

      I think, it should be unique as integer.

      Attachments

        For Gerrit Dashboard: QTBUG-23895
        # Subject Branch Project Status CR V

        Activity

          People

            zhongle honglei zhang
            zygmunt Zygmunt Ptak
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes