summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <gluh@gluh.(none)>2006-11-21 14:04:43 +0400
committerunknown <gluh@gluh.(none)>2006-11-21 14:04:43 +0400
commit3a64adc4ea0281eddfd7ba4a5262ef6d6b497ceb (patch)
treea32cc83008be0bc46d4d620a00273dfb2ff558f3 /mysql-test/t
parent25c21042dbfeebff42d1cf7880da64ba7cd2bbfa (diff)
parent1ae9f3b985c59f0c94922cb2bc3c186abae5c619 (diff)
downloadmariadb-git-3a64adc4ea0281eddfd7ba4a5262ef6d6b497ceb.tar.gz
Merge mysql.com:/home/gluh/MySQL/Merge/5.0-opt
into mysql.com:/home/gluh/MySQL/Merge/5.1-opt sql/sql_select.cc: Auto merged mysql-test/r/information_schema.result: SCCS merged mysql-test/t/information_schema.test: SCCS merged
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/information_schema.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test
index 4ae88736b98..19375cae269 100644
--- a/mysql-test/t/information_schema.test
+++ b/mysql-test/t/information_schema.test
@@ -974,6 +974,20 @@ SELECT COLUMN_NAME, MD5(COLUMN_DEFAULT), LENGTH(COLUMN_DEFAULT), COLUMN_DEFAULT=
DROP TABLE bug23037;
DROP FUNCTION get_value;
+
+#
+# Bug#22413: EXPLAIN SELECT FROM view with ORDER BY yield server crash
+#
+create view v1 as
+select table_schema as object_schema,
+ table_name as object_name,
+ table_type as object_type
+from information_schema.tables
+order by object_schema;
+explain select * from v1;
+explain select * from (select table_name from information_schema.tables) as a;
+drop view v1;
+
--echo End of 5.0 tests.
#
# Show engines