Issue Bug Closed

#20439DBAL wildly quotes fields and table names

Xavier Perseguers 05/17/09, 20:18 updated 11/24/09, 23:25

Description

When issuing a query using $GLOBALS[‘TYPO3_DB’]->exec_SELECTgetRows() method for instance, the actual query being generated has all fields quotes with the proper quote for the selected DBMS.

This is however done in a fully uncontrolled manner as all stuff get quoted resulting in invalid SQL query being issued to the actual DBMS. E.g., using a MSSQL backend, a query is like this:

SELECT “Field1”, “Field2” FROM “MyTable” WHERE “Uid” = 1234

and that does not work, MSSQL complains that it cannot parse the query (at least with ADOdb because using Query Analyzer, the query is performed successfuly).

Solution: Use ADOdb built-in function to quote fields and table names and… as it performs a few tests to decide whether quoting is needed or not.

(issue imported from #M11108)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.