summaryrefslogtreecommitdiff
path: root/mysql-test/t/select.test
diff options
context:
space:
mode:
authorunknown <igor@rurik.mysql.com>2006-09-29 11:36:27 -0700
committerunknown <igor@rurik.mysql.com>2006-09-29 11:36:27 -0700
commitf66945aadb88bc66efebdd5333e7baf8acf0fe30 (patch)
tree09106c2af35d65c519afb9dc8a33a06334a467b4 /mysql-test/t/select.test
parentd1da520f9bc4366547d1b64f8a55e77a77127d61 (diff)
parent1643d0c5ed59826a03b294e38719012b3508c2eb (diff)
downloadmariadb-git-f66945aadb88bc66efebdd5333e7baf8acf0fe30.tar.gz
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into rurik.mysql.com:/home/igor/mysql-5.0-opt mysql-test/r/select.result: Manual merge mysql-test/t/select.test: Manual merge
Diffstat (limited to 'mysql-test/t/select.test')
-rw-r--r--mysql-test/t/select.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test
index 861b9160644..166b709f9b6 100644
--- a/mysql-test/t/select.test
+++ b/mysql-test/t/select.test
@@ -2999,6 +2999,14 @@ SELECT * FROM t1 LEFT JOIN t2 ON t2.b=t1.a INNER JOIN t3 ON t3.d=t1.id
DROP TABLE t1,t2,t3;
#
+# Bug#20503: Server crash due to the ORDER clause isn't taken into account
+# while space allocation
+#
+create table t1 (c1 varchar(1), c2 int, c3 int, c4 int, c5 int, c6 int,
+c7 int, c8 int, c9 int, fulltext key (`c1`));
+select distinct match (`c1`) against ('z') , c2, c3, c4,c5, c6,c7, c8
+ from t1 where c9=1 order by c2, c2;
+drop table t1;
# Bug #22735: no equality propagation for BETWEEN and IN with STRING arguments
#