Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
None
Description
Results:
MySQL:
The query returns NULL, 16 (no error).
PostgreSQL:
The query returns an empty value (NULL), 16 (no error).
MariaDB:
Error: ERROR 1054 (42S22): Unknown column 'FALSE' in 'GROUP BY'.
Details:
1. Results from mysql:
mysql> CREATE TABLE v0 ( v1 INTEGER, v2 INTEGER, v3 INTEGER );
|
Query OK, 0 rows affected (0.19 sec)
|
|
|
mysql> SELECT ( SELECT -1 FROM v0 GROUP BY FALSE, ( v2 ^ v2 ) > v2 ), 16;
|
+--------------------------------------------------------+----+
|
| ( SELECT -1 FROM v0 GROUP BY FALSE, ( v2 ^ v2 ) > v2 ) | 16 |
|
+--------------------------------------------------------+----+
|
| NULL | 16 |
|
+--------------------------------------------------------+----+
|
1 row in set (0.02 sec)
|
2. Results from pg:
postgres@cn001=# drop table v0;
|
CREATE TABLE v0 ( v1 INTEGER, v2 INTEGER, v3 INTEGER );
|
SELECT ( SELECT -1 FROM v0 GROUP BY FALSE, ( v2 ^ v2 ) > v2 ), 16;
|
DROP TABLE
|
CREATE TABLE
|
?column? | ?column?
|
----------+----------
|
| 16
|
(1 row)
|
3. Results from MariaDB:
mysql> CREATE TABLE v0 ( v1 INTEGER, v2 INTEGER, v3 INTEGER );
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
mysql> SELECT ( SELECT -1 FROM v0 GROUP BY FALSE, ( v2 ^ v2 ) > v2 ), 16;
|
ERROR 1054 (42S22): Unknown column 'FALSE' in 'GROUP BY'
|
mysql>
|
Steps to reproduce:
drop table v0; |
CREATE TABLE v0 ( v1 INTEGER, v2 INTEGER, v3 INTEGER ); |
SELECT ( SELECT -1 FROM v0 GROUP BY FALSE, ( v2 ^ v2 ) > v2 ), 16; |