Open mcronce opened 3 years ago
PS: I have pcaps I can attach if it helps, but given how easy it is to reproduce, I doubt they'll be needed :)
Note that ANSI
is a special mode that expands to the following individual sql_mode
values: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, and ONLY_FULL_GROUP_BY
The one that matters in this case is ANSI_QUOTES
We ran into this same thing while trying to migrate a project that used the Medoo PHP PDO wrapper library, see https://github.com/catfan/Medoo/issues/1044
Overview of the Issue
Found while testing Drupal. All indications were that they were trying to submit a query that looked like
CREATE TABLE {table_name} ...
(which made no sense) until I pulled a packet capture - turns out that the actual query going over the wire (and failing) is:Preceded by:
which reports success.
As an aside: Should this be a feature request instead of a bug?
Reproduction Steps
Binary version
For
vttestserver:mysql57
andvttestserver:mysql80
, respectively:Operating system and Environment details
In one of the
vttestserver
containers:On the host:
Log Fragments
Nothing from when these queries are executed