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

PSQL driver table name case sensitivity

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Reported
    • Priority: P2: Important
    • Resolution: Unresolved
    • Affects Version/s: 5.15.2
    • Fix Version/s: None
    • Component/s: SQL Support
    • Labels:
      None
    • Platform/s:
      All

      Description

      I want to reopen QTBUG-86178
      C. Eichinger closed it with the remark: it's not a bug of Qt but a 'user-bug'.
      That is a little bit too simple. If you use qutation marks while accessing a Postgres-table, the name is case-sensitive. But if you don't use qutation marks the tablename is lowercase. This is absolutely correct and was considered in former Qt-versions (e.g. 5.12):

      if (isIdentifierEscaped(tbl, QSqlDriver::TableName))
        tbl = stripDelimiters(tbl, QSqlDriver::TableName);
      else
        tbl = std::move(tbl).toLower();

      I hope you will reimplement this feature soon.

       

        Attachments

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

          Activity

            People

            Assignee:
            mabrand Mark Brand
            Reporter:
            markus65 Markus Schmidt
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Gerrit Reviews

                There are no open Gerrit changes