Details
-
Bug
-
Resolution: Done
-
P3: Somewhat important
-
5.12.10, 5.15.2
-
-
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
-
QTBUG-92584 QSqlTableModel ORDER BY doesn't quote table name [with spaces]
- Closed