diff options
| author | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
| commit | c0f40d14cc36f56f5b4dba288583acd345429e4e (patch) | |
| tree | c27e400395741740f2e230395445236b38db27c1 /mysql-test/t/varbinary.test | |
| parent | 361067e9150f7fa57d5b2ac722ed55df9c14cc53 (diff) | |
| download | mariadb-git-c0f40d14cc36f56f5b4dba288583acd345429e4e.tar.gz | |
Added support for hex strings to mysqlimport
A lot of new tests to mysqltest
Fixed bug with BDB tables and autocommit
Diffstat (limited to 'mysql-test/t/varbinary.test')
| -rw-r--r-- | mysql-test/t/varbinary.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/varbinary.test b/mysql-test/t/varbinary.test new file mode 100644 index 00000000000..0ab26f51e65 --- /dev/null +++ b/mysql-test/t/varbinary.test @@ -0,0 +1,16 @@ +# +# varbinary as string and number +# + +select 0x41,0x41+0,0x41 | 0x7fffffffffffffff | 0,0xffffffffffffffff | 0 ; +select 0x31+1,concat(0x31)+1,-0xf; + +# +# Test of hex constants in WHERE: +# + +create table t1 (ID int(8) unsigned zerofill not null auto_increment,UNIQ bigint(21) unsigned zerofill not null,primary key (ID),unique (UNIQ) ); +insert into t1 set UNIQ=0x38afba1d73e6a18a; +insert into t1 set UNIQ=123; +explain select * from t1 where UNIQ=0x38afba1d73e6a18a; +drop table t1; |