diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-12-14 14:55:28 +0300 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-12-14 14:55:28 +0300 |
| commit | b603cbc3ba0e25d7e1fc27e796a8956551f40f55 (patch) | |
| tree | 8d78d00d1d24e1edf0361294bece261361b9f137 /mysql-test | |
| parent | a9973c1b9244486cf16cc24a5dd70265155f202c (diff) | |
| download | mariadb-git-b603cbc3ba0e25d7e1fc27e796a8956551f40f55.tar.gz | |
Fix bug#7222 information_schema: errors in "routines"
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/information_schema.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/information_schema.test | 6 |
2 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result index 3580a7f4f18..1237bae9d71 100644 --- a/mysql-test/r/information_schema.result +++ b/mysql-test/r/information_schema.result @@ -252,6 +252,11 @@ begin select * from t1; select * from t2; end| +select parameter_style, sql_data_access, dtd_identifier +from information_schema.routines; +parameter_style sql_data_access dtd_identifier +SQL CONTAINS SQL NULL +SQL CONTAINS SQL int show procedure status; Db Name Type Definer Modified Created Security_type Comment test sel2 PROCEDURE root@localhost # # DEFINER diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test index 123967f1c4a..b909e8b8e53 100644 --- a/mysql-test/t/information_schema.test +++ b/mysql-test/t/information_schema.test @@ -92,6 +92,12 @@ begin end| delimiter ;| +# +# Bug#7222 information_schema: errors in "routines" +# +select parameter_style, sql_data_access, dtd_identifier +from information_schema.routines; + --replace_column 5 # 6 # show procedure status; --replace_column 5 # 6 # |