diff options
author | unknown <gluh@gluh.(none)> | 2006-11-21 14:04:43 +0400 |
---|---|---|
committer | unknown <gluh@gluh.(none)> | 2006-11-21 14:04:43 +0400 |
commit | 3a64adc4ea0281eddfd7ba4a5262ef6d6b497ceb (patch) | |
tree | a32cc83008be0bc46d4d620a00273dfb2ff558f3 /mysql-test/t | |
parent | 25c21042dbfeebff42d1cf7880da64ba7cd2bbfa (diff) | |
parent | 1ae9f3b985c59f0c94922cb2bc3c186abae5c619 (diff) | |
download | mariadb-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.test | 14 |
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 |