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

QSqlTableModel support column names with dots

    XMLWordPrintable

Details

    • All
    • 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

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

          Activity

            People

              andysh Andy Shaw
              karimpinter Karim Pinter
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews