diff options
| author | unknown <konstantin@mysql.com> | 2005-07-14 00:15:23 +0400 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2005-07-14 00:15:23 +0400 |
| commit | c663aa896194ee7320b1c17b8a598d5713d32bce (patch) | |
| tree | 845e4b7816b0f12134023dc8c8747fb702c38917 /mysql-test/r/ps.result | |
| parent | 98248f046fbaa30b098225f408f4b5529ae937e6 (diff) | |
| download | mariadb-git-c663aa896194ee7320b1c17b8a598d5713d32bce.tar.gz | |
A test case for Bug#9442 "Set parameter make query fail if column
character set is UCS2".
The bug is no longer repeatable.
mysql-test/r/ps.result:
Test results fixed (a test case for Bug#9442)
mysql-test/t/ps.test:
A test case for Bug#9442 "Set parameter make query fail if column
character set is UCS2
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index cdba113ae40..ee558e0ea89 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -641,3 +641,22 @@ execute stmt using @a, @b; ?=? 1 deallocate prepare stmt; +create table t1 (utext varchar(20) character set ucs2); +insert into t1 values ("lily"); +insert into t1 values ("river"); +prepare stmt from 'select utext from t1 where utext like ?'; +set @param1='%%'; +execute stmt using @param1; +utext +lily +river +execute stmt using @param1; +utext +lily +river +select utext from t1 where utext like '%%'; +utext +lily +river +drop table t1; +deallocate prepare stmt; |