diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-29 17:27:30 +0500 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-29 17:27:30 +0500 |
| commit | 5babbd233b88d547b9642ac029c7b24113e709c1 (patch) | |
| tree | 2a9955ea05446234f82e9a8e823ef327b42d45be /mysql-test/r/binary.result | |
| parent | 0d47f003ec82e8e6d96668e5191a496a432d408a (diff) | |
| download | mariadb-git-5babbd233b88d547b9642ac029c7b24113e709c1.tar.gz | |
Better tests for BINARY
Diffstat (limited to 'mysql-test/r/binary.result')
| -rw-r--r-- | mysql-test/r/binary.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/r/binary.result b/mysql-test/r/binary.result index 9c3174ec606..f6ad190b05a 100644 --- a/mysql-test/r/binary.result +++ b/mysql-test/r/binary.result @@ -79,3 +79,34 @@ NULL select b from t1 having binary b like ''; b drop table t1; +create table t1 (a char(15) binary, b binary(15)); +insert into t1 values ('aaa','bbb'),('AAA','BBB'); +select upper(a),upper(b) from t1; +upper(a) upper(b) +AAA bbb +AAA BBB +select lower(a),lower(b) from t1; +lower(a) lower(b) +aaa bbb +aaa BBB +select * from t1 where upper(a)='AAA'; +a b +aaa bbb +AAA BBB +select * from t1 where lower(a)='aaa'; +a b +aaa bbb +AAA BBB +select * from t1 where upper(b)='BBB'; +a b +AAA BBB +select * from t1 where lower(b)='bbb'; +a b +aaa bbb +select charset(a), charset(b), charset(binary 'ccc') from t1 limit 1; +charset(a) charset(b) charset(binary 'ccc') +latin1 binary latin1 +select collation(a), collation(b), collation(binary 'ccc') from t1 limit 1; +collation(a) collation(b) collation(binary 'ccc') +latin1_bin binary latin1_bin +drop table t1; |