diff options
| author | unknown <jimw@rama.(none)> | 2006-09-01 10:39:48 -0700 |
|---|---|---|
| committer | unknown <jimw@rama.(none)> | 2006-09-01 10:39:48 -0700 |
| commit | fabdf62ffd71c6e7e4df07b68754a6a513957a61 (patch) | |
| tree | 227afaf6e33755616cbe37415b217a4d67a062c1 /mysql-test/r/show_check.result | |
| parent | adb650b23634a6b3f3e78be5adc2174a81923693 (diff) | |
| download | mariadb-git-fabdf62ffd71c6e7e4df07b68754a6a513957a61.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.
mysql-test/r/show_check.result:
Add new results
mysql-test/t/show_check.test:
Add new regression test
sql/sql_parse.cc:
Remove remove_escape() -- it is not actually necessary, and now harmful because
identifiers may include escape characters.
Diffstat (limited to 'mysql-test/r/show_check.result')
| -rw-r--r-- | mysql-test/r/show_check.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index 7759a6f1f7f..b473bbac923 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -695,4 +695,19 @@ Level Code Message Warning 1541 The syntax 'SHOW PLUGIN' is deprecated and will be removed in MySQL 5.2. Please use 'SHOW PLUGINS' instead show plugin; show plugins; +create database `mysqlttest\1`; +create table `mysqlttest\1`.`a\b` (a int); +show tables from `mysqlttest\1`; +Tables_in_mysqlttest\1 +a\b +show fields from `mysqlttest\1`.`a\b`; +Field Type Null Key Default Extra +a int(11) YES NULL +show columns from `a\b` from `mysqlttest\1`; +Field Type Null Key Default Extra +a int(11) YES NULL +show keys from `mysqlttest\1`.`a\b`; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +drop table `mysqlttest\1`.`a\b`; +drop database `mysqlttest\1`; End of 5.1 tests |