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

QPSQL driver not working when using the same named bind several places in a prepared statement

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • P3: Somewhat important
    • Some future release
    • 4.4.0
    • SQL Support
    • None

    Description

      QPSQL driver not working when using the same named bind several places in a prepared statement, i.e. doing the following

      query.prepare("SELECT * FROM invoice WHERE nr = :nr AND nr2 = :nr");
      query.bindValue(":nr", 1001);
      query.exec();

      results in QPSQL sending the following to the database

      PREPARE qpsqlpstmt_a AS ( SELECT * FROM invoice WHERE nr = $1 AND nr2 = $2)
      EXECUTE qpsqlpstmt_a (NULL, 1001)

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            bilking Bill King
            admin Administrator
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes