1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
#
# Coverage tests to trace a backward compatibility with the 5.7 syntax.
#
# This file should not diverge between 5.7 and 8.0 without a huge reason
# like a feature deprecation in 5.7 and its removal in 8.0.
#
--echo #
--echo # Test pushing/not pushing of the LIMIT/ORDER BY clauses down into a
--echo # parenthesized query block.
--echo #
CREATE TABLE t1 (k SERIAL, i INT) ENGINE=InnoDB;
INSERT INTO t1 (i) VALUES (10), (2), (30), (4), (50);
--echo # push down -- standard compliant
(SELECT * FROM t1) LIMIT 4;
--echo # push down -- standard compliant
(SELECT * FROM t1) ORDER BY i;
--echo # push down -- standard compliant
(SELECT * FROM t1) ORDER BY i LIMIT 4;
--echo # push down -- standard compliant
(SELECT * FROM t1 LIMIT 3) LIMIT 4;
--echo # don't push down -- standard compliant
(SELECT * FROM t1 LIMIT 3) ORDER BY i DESC;
--echo # don't push down -- standard compliant
(SELECT * FROM t1 LIMIT 3) ORDER BY i DESC LIMIT 4;
--echo # push down -- standard compliant
(SELECT * FROM t1 ORDER BY i DESC LIMIT 3) LIMIT 4;
--echo # don't push down -- standard compliant
(SELECT * FROM t1 ORDER BY i DESC LIMIT 3) ORDER BY i;
--echo # don't push down -- standard compliant
(SELECT * FROM t1 ORDER BY i DESC LIMIT 3) ORDER BY i LIMIT 4;
((SELECT * FROM t1 ORDER BY i) ORDER BY i) ORDER BY i;
--disable_result_log
--echo # 8.0: push down -- standard compliant
--echo # or
--echo # 5.7: rejected syntax -- non-standard
--error 0,ER_PARSE_ERROR
((SELECT * FROM t1 LIMIT 1) LIMIT 2) LIMIT 3;
--enable_result_log
DROP TABLE t1;
|
