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

QSqlTableModel support column names with dots

    XMLWordPrintable

    Details

    • Platform/s:
      All
    • Commits:
      66acee69a1563488e5950645c171d6be73dd5f70 (qt/qtbase/dev) 6720519af758f2ef84930a4958a919c1f475d3b9 (qt/qtbase/6.1) f21a3a451ff531fc1ed6bcf24a188db49fc02cd2 (qt/tqtc-qtbase/5.15) 284d15bbec07fee6e695ea16bebd8f05d1601e19 (qt/qtbase/6.0)

      Description

      It should be possible to create and use table and column names with dots, like company.names. Various SQL driver implementations, like sqlite and mysql, removes the dots in QSqlDriver::escapeIdentifier when the column is defined like [company.names] or `company.names`, but even if "company.names" is used, it doesn't work.
      Returns:

      QSqlError("1", "Unable to execute statement", "no such column: company.firstname")

      Check the attached code for an example.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. QTBUG-92584 QSqlTableModel ORDER BY doesn't quote table name [with spaces]

          • P4: Low - Would be nice to fix, but it's not very important.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

              People

              Assignee:
              andysh Andy Shaw
              Reporter:
              karimpinter Karim Pinter (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews