fails to quote column/table identifiers

Question

Closed this issue 14 years ago · 4 comments

A generated query: SELECT * FROM scrl_context WHERE (key = 'default');
Fails because "key" is a reserved word and must be quoted: key

Answer 1 · 2011-04-29T21:08:22.000Z

(quoted with backticks)

Answer 2 · 2011-04-30T03:44:19.000Z

Ugh. PDO still has no quoteIdentifier(), so fixing this requires sniffing out the DB type from PDO.

Answer 3 · 2011-04-30T05:14:00.000Z

This is a documented behavior. You can quote the column name by yourself but the best approach is to avoid keywords in your identifiers.

Answer 4 · 2012-05-25T14:12:27.000Z

This does not work:

$table()->where('"select".name = ?', $name);