Details
-
Bug
-
Resolution: Done
-
P3: Somewhat important
-
5.12.10, 5.15.2
-
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
- relates to
-
-
- Closed
-
| For Gerrit Dashboard: QTBUG-91885 | ||||||
|---|---|---|---|---|---|---|
| # | Subject | Branch | Project | Status | CR | V |
| 343670,6 | SQLite: Handle tables and fields with a dot in the name correctly | dev | qt/qtbase | Status: MERGED | +2 | 0 |
| 344991,2 | SQLite: Handle tables and fields with a dot in the name correctly | 6.1 | qt/qtbase | Status: MERGED | +2 | 0 |
| 344992,2 | SQLite: Handle tables and fields with a dot in the name correctly | 6.0 | qt/qtbase | Status: MERGED | +2 | 0 |
| 344993,2 | SQLite: Handle tables and fields with a dot in the name correctly | tqtc/lts-5.15 | qt/tqtc-qtbase | Status: MERGED | +2 | 0 |