SQL requests with double-quotes not working with managed database

This is related to the sql_mode used. There’s a sql_mode setting, ‘ANSI_QUOTES’ that will make the " an identifier character.

e.g.

mysql> set session sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES';
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1 where c3="foo";  <-- double quotes operating the same as `
ERROR 1054 (42S22): Unknown column 'foo' in 'where clause'

mysql> select * from t1 where c3='foo';  <-- single quotes works
+----+----+----+------+
| id | c1 | c2 | c3   |
+----+----+----+------+
|  3 |  5 |  6 | foo  |
+----+----+----+------+
1 row in set (0.00 sec)

mysql> set session sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1 where c3="foo";
+----+----+----+------+
| id | c1 | c2 | c3   |
+----+----+----+------+
|  3 |  5 |  6 | foo  |
+----+----+----+------+
1 row in set (0.00 sec)

I’ve removed the ANSI_QUOTES sql-mode setting at a session level.

You can change the global value under the settings tab of your instance(s).

Hope this solves your issue!

Andrew