dble icon indicating copy to clipboard operation
dble copied to clipboard

Dble result set is inconsistent with MySQL when executing `selece @@sql_mode`

Open sevenFH opened this issue 8 years ago • 0 comments

dble:

mysql> select @@sql_mode;
+---------------------------------------------------------+
| @@sql_mode                                              |
+---------------------------------------------------------+
| IGNORE_SPACE,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------------------------------------------------+
1 row in set (0.00 sec)

Two-node result set consistent:

mysql> select @@sql_mode;
+--------------------------------------------+
| @@sql_mode                                 |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)

mysql> 

sevenFH avatar Dec 04 '17 07:12 sevenFH