diff options
| author | jimw@rama.(none) <> | 2006-09-01 10:39:48 -0700 |
|---|---|---|
| committer | jimw@rama.(none) <> | 2006-09-01 10:39:48 -0700 |
| commit | bfb06f15fd119772f79939dd2624d513b402f693 (patch) | |
| tree | 227afaf6e33755616cbe37415b217a4d67a062c1 /mysql-test/t/show_check.test | |
| parent | ebf482c4474b8e7ce7c33a9d0db79a05cc7678d4 (diff) | |
| download | mariadb-git-bfb06f15fd119772f79939dd2624d513b402f693.tar.gz | |
Bug #19874: SHOW COLUMNS and SHOW KEYS handle identifiers containing \ incorrectly
Identifiers with embedded escape characters were not handled correctly by
some SHOW statements due to some old code that was doing some extra unescaping.
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index e99387bf695..553b3d9059b 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -539,4 +539,17 @@ show plugin; show plugins; --enable_result_log +# +# Bug #19874: SHOW COLUMNS and SHOW KEYS handle identifiers containing +# \ incorrectly +# +create database `mysqlttest\1`; +create table `mysqlttest\1`.`a\b` (a int); +show tables from `mysqlttest\1`; +show fields from `mysqlttest\1`.`a\b`; +show columns from `a\b` from `mysqlttest\1`; +show keys from `mysqlttest\1`.`a\b`; +drop table `mysqlttest\1`.`a\b`; +drop database `mysqlttest\1`; + --echo End of 5.1 tests |