diff options
| author | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2006-01-24 16:48:19 +0400 |
|---|---|---|
| committer | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2006-01-24 16:48:19 +0400 |
| commit | 333b1f8594922647278808a4c114c16695551343 (patch) | |
| tree | 847fce48cce8fd12c1deb74d0c82e424c197d071 /mysql-test/t | |
| parent | 74f670f291acd3ffaaca60a6659290c80f472c76 (diff) | |
| download | mariadb-git-333b1f8594922647278808a4c114c16695551343.tar.gz | |
Fix for bug#15307 GROUP_CONCAT() with ORDER BY returns empty set on information_schema(2nd ver)
Fill schema tables with data before filesort if it's necessary
mysql-test/r/information_schema.result:
Fix for bug#15307 GROUP_CONCAT() with ORDER BY returns empty set on information_schema(2nd ver)
test result
mysql-test/t/information_schema.test:
Fix for bug#15307 GROUP_CONCAT() with ORDER BY returns empty set on information_schema(2nd ver)
test case
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/information_schema.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test index 323c6b37059..85d56bfc78b 100644 --- a/mysql-test/t/information_schema.test +++ b/mysql-test/t/information_schema.test @@ -800,3 +800,12 @@ create table mysqltest.t1(a int); select table_schema from information_schema.tables where table_schema='mysqltest'; --exec chmod +r $MYSQL_TEST_DIR/var/master-data/mysqltest drop database mysqltest; + +# +# Bug#15307 GROUP_CONCAT() with ORDER BY returns empty set on information_schema +# +select column_type, group_concat(table_schema, '.', table_name), count(*) as num +from information_schema.columns where +table_schema='information_schema' and +(column_type = 'varchar(7)' or column_type = 'varchar(20)') +group by column_type order by num; |