Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.4.10
-
None
-
Not for Release Notes
Description
MariaDB ORDER BY negative constant mistakenly interpreted as column name, unlike MySQL/TiDB. Expected: Query passes, returns empty set as on MySQL/TiDB.
Actual: ERROR 1054 (42S22): Unknown column '???' in 'ORDER BY'.
Details:
1. Results from mariadb:
mysql> SELECT t0.c0 FROM t10, t0 NATURAL RIGHT JOIN v0 GROUP BY 0.5208181595651438 ORDER BY -1899153712;
|
ERROR 1054 (42S22): Unknown column '???' in 'ORDER BY'
|
mysql> select version();
|
+-----------------+
|
| version() |
|
+-----------------+
|
| 11.4.10-MariaDB |
|
+-----------------+
|
1 row in set (0.00 sec)
|
2. Results from mysql:
mysql> SELECT t0.c0 FROM t10, t0 NATURAL RIGHT JOIN v0 ORDER BY-1899153712;
|
Empty set (0.00 sec)
|
|
|
mysql> select version();
|
+--------------+
|
| version() |
|
+--------------+
|
| 8.0.45-debug |
|
+--------------+
|
1 row in set (0.00 sec)
|
3. Results from tidb:
mysql> SELECT t0.c0 FROM t10, t0 NATURAL RIGHT JOIN v0 GROUP BY 0.5208181595651438 ORDER BY -1899153712;
|
Empty set (0.01 sec)
|
|
|
mysql> select version();
|
+------------------------------------------+
|
| version() |
|
+------------------------------------------+
|
| 8.0.11-TiDB-v8.4.0-this-is-a-placeholder |
|
+------------------------------------------+
|
1 row in set (0.01 sec)
|
Steps to reproduce:
drop table t10;
|
drop table t0;
|
drop view v0;
|
|
|
CREATE TABLE t10 (
|
c0 TEXT,
|
c1 CHAR NOT NULL,
|
c2 CHAR
|
);
|
|
|
CREATE TABLE t0 (
|
c0 DECIMAL NOT NULL
|
);
|
|
|
CREATE VIEW v0(c0, c1, c2) AS
|
SELECT (BINARY (((t10.c1) REGEXP (CAST(t10.c0 AS SIGNED))))), t10.c1, 'B\r\nMh'
|
FROM t10;
|
|
|
SELECT t0.c0 FROM t10, t0 NATURAL RIGHT JOIN v0 GROUP BY 0.5208181595651438 ORDER BY -1899153712;
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-