diff options
| author | bar@bar.intranet.mysql.r18.ru <> | 2004-05-14 13:08:22 +0500 |
|---|---|---|
| committer | bar@bar.intranet.mysql.r18.ru <> | 2004-05-14 13:08:22 +0500 |
| commit | 6ecea2fa93b0f16d67562b2763b045ac7c30c9d0 (patch) | |
| tree | 9f412a87be87b312ec358f27c4d210b6b3936526 /mysql-test | |
| parent | 2fc1d5c1467421bae7405b1a5707bd53ba2b03e2 (diff) | |
| download | mariadb-git-6ecea2fa93b0f16d67562b2763b045ac7c30c9d0.tar.gz | |
Bug #3403 Wrong encoding in EXPLAIN SELECT output
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/explain.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/explain.test | 11 |
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 02e1ace71e1..d66dec741bd 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -44,3 +44,12 @@ explain select count(*) from t1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away drop table t1; +set names koi8r; +create table таб (кол0 int, кол1 int, key инд0 (кол0), key инд01 (кол0,кол1)); +insert into таб (кол0) values (1); +insert into таб (кол0) values (2); +explain select кол0 from таб where кол0=1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE таб ref инд0,инд01 инд0 5 const 1 Using where; Using index +drop table таб; +set names latin1; diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index ff1803368b9..050939e5ad2 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -30,3 +30,14 @@ explain select count(*) from t1; insert into t1 values(1); explain select count(*) from t1; drop table t1; + +# +# Bug #3403 Wrong encoding in EXPLAIN SELECT output +# +set names koi8r; +create table таб (кол0 int, кол1 int, key инд0 (кол0), key инд01 (кол0,кол1)); +insert into таб (кол0) values (1); +insert into таб (кол0) values (2); +explain select кол0 from таб where кол0=1; +drop table таб; +set names latin1; |