Description: ------------ When calling quoteIdentifier() with a query that contains an email address the following error is generated: MDB2 Error: syntax error Test script: --------------- $query = "SELECT * FROM user WHERE email = 'foo@bar.com'"; $mdb2->quoteIdentifier($query, True); Expected result: ---------------- SELECT * FROM "user" WHERE "email" = 'foo@bar.com' Actual result: -------------- MDB2 Error: syntax error

Sorry that should be SELECT user.* FROM user WHERE user.email = 'foo@bar.com'

Did some more testing Ok it should return (using pgsql connection string) SELECT "user".* FROM "user" WHERE "user"."email" = 'foo@bar.com' Using mysql SELECT 'user'.* FROM 'user' WHERE 'user'.'email' = 'foo@bar.com' What it returns in both cases: "SELECT user.* FROM user WHERE user.email = 'foo@bar.com'" The syntax error was coming from trying to execute, so quoteIdentifier is just not properly parsing.

quoteIdentifier() doesn't "parse" anything, you're using it incorrectly. It's supposed to quote an identifier, not all the identifiers within a string. $query = "SELECT * FROM " . $mdb2->quoteIdentifier("user", true). " WHERE " . $mdb2->quoteIdentifier("user", true) . " = " . $mdb2->quote('foo@bar.com', 'text');