~drizzle-trunk/drizzle/development

drop table if exists t1;

select 0x31+1,concat(0x31)+1,-0xf;

0x31+1	concat(0x31)+1	-0xf

50	2	-15

select x'31',X'ffff'+0;

x'31'	X'ffff'+0

1	65535

create table t1 (ID int not null auto_increment,UNIQ bigint not null,primary key (ID),unique (UNIQ) );

insert into t1 set UNIQ=0x38afba1d73e6a18a;

insert into t1 set UNIQ=123;

explain extended select * from t1 where UNIQ=0x38afba1d73e6a18a;

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	SIMPLE	t1	const	UNIQ	UNIQ	8	const	1	100.00	Using index

Warnings:

Note	1003	select '1' AS `ID`,'4084688022709641610' AS `UNIQ` from `test`.`t1` where 1

drop table t1;

select x'hello';

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'x'hello'' at line 1

select 0xfg;

ERROR 42S22: Unknown column '0xfg' in 'field list'

create table t1 select 1 as x, 2 as xx;

select x,xx from t1;

x	xx

1	2

drop table t1;

create table t1(a varbinary(255));

insert into t1 values("aaa   ");

select length(a) from t1;

length(a)

6

alter table t1 modify a varchar(255);

select length(a) from t1;

length(a)

6

drop table t1;

drop table if exists table_28127_a;

drop table if exists table_28127_b;

create table table_28127_a(0b02 int);

show create table table_28127_a;

Table	Create Table

table_28127_a	CREATE TABLE `table_28127_a` (

  `0b02` int DEFAULT NULL

) ENGINE=DEFAULT

create table table_28127_b(0b2 int);

show create table table_28127_b;

Table	Create Table

table_28127_b	CREATE TABLE `table_28127_b` (

  `0b2` int DEFAULT NULL

) ENGINE=DEFAULT

drop table table_28127_a;

drop table table_28127_b;