| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/t/ |
| H A D | implicit_char_to_num_conversion.test | 26 SELECT HEX(c1) FROM t5 ORDER BY c1;
45 SELECT c1 FROM t5 ORDER BY c1;
54 SELECT c1 FROM t5 WHERE c1 < '1' ORDER BY c1;
62 SELECT c1 FROM t5 ORDER BY c1;
77 SELECT c1 FROM t5 ORDER BY c1;
92 SELECT c1 FROM t5 ORDER BY c1;
107 SELECT c1 FROM t5 ORDER BY c1;
122 SELECT c1 FROM t5 ORDER BY c1;
137 SELECT c1 FROM t5 ORDER BY c1;
152 SELECT c1 FROM t5 ORDER BY c1;
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/t/ |
| H A D | implicit_char_to_num_conversion.test | 26 SELECT HEX(c1) FROM t5 ORDER BY c1;
43 SELECT c1 FROM t5 ORDER BY c1;
52 SELECT c1 FROM t5 WHERE c1 < '1' ORDER BY c1;
60 SELECT c1 FROM t5 ORDER BY c1;
75 SELECT c1 FROM t5 ORDER BY c1;
90 SELECT c1 FROM t5 ORDER BY c1;
105 SELECT c1 FROM t5 ORDER BY c1;
120 SELECT c1 FROM t5 ORDER BY c1;
135 SELECT c1 FROM t5 ORDER BY c1;
150 SELECT c1 FROM t5 ORDER BY c1;
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 73 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
76 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
147 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
150 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
221 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
224 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
404 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
478 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
552 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/engines/iuds/t/ |
| H A D | insert_decimal.test | 72 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
75 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
146 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
149 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
223 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
402 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
476 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
550 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
722 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
| H A D | order_by-mdev-10122.test | 13 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
14 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
15 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a;
16 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
19 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
26 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
27 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a LIMIT 1;
28 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a;
29 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a LIMIT 1;
32 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
| H A D | order_by-mdev-10122.test | 13 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
14 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
15 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a;
16 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
19 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
26 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
27 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a LIMIT 1;
28 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a;
29 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a LIMIT 1;
32 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
| H A D | order_by-mdev-10122.test | 13 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
14 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
15 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a;
16 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
19 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
26 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
27 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a LIMIT 1;
28 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a;
29 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a LIMIT 1;
32 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
| H A D | order_by-mdev-10122.test | 13 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
14 (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
15 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a;
16 (SELECT a FROM t1 GROUP BY a ORDER BY a,GROUP_CONCAT(a)) ORDER BY a LIMIT 1;
19 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY GROUP_CONCAT(a)) ORDER BY a;
26 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
27 (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a LIMIT 1;
28 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a;
29 (SELECT a FROM t1 GROUP BY a ORDER BY a,MAX(a)) ORDER BY a LIMIT 1;
32 SELECT 1 AS a UNION (SELECT a FROM t1 GROUP BY a ORDER BY MAX(a)) ORDER BY a;
[all …]
|