Details
-
Type:
Bug
-
Status: Closed
-
Priority:
P3: Somewhat important
-
Resolution: Done
-
Affects Version/s: 5.12.10, 5.15.2
-
Fix Version/s: 5.15.5, 6.0.4, 6.1.1, 6.2.0 Alpha
-
Component/s: SQL Support
-
Labels:
-
Platform/s:
-
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
-
QTBUG-92584 QSqlTableModel ORDER BY doesn't quote table name [with spaces]
-
- Closed
-