~drizzle-trunk/drizzle/development

# Initialise

--disable_warnings

drop table if exists t1;

--enable_warnings

#

# varbinary as string and number

#

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

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

#

# Test of hex constants in WHERE:

#

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;

drop table t1;

#

# Test error conditions

#

--error ER_PARSE_ERROR

select x'hello';

--error ER_BAD_FIELD_ERROR

select 0xfg;

#

# Test likely error conditions

#

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

select x,xx from t1;

drop table t1;

# End of 4.1 tests

# Check that the fix does not affect table created with current version

create table t1(a varbinary(255));

insert into t1 values("aaa   ");

select length(a) from t1;

alter table t1 modify a varchar(255);

select length(a) from t1;

drop table t1;

#

# Bug#28127 (Some valid identifiers names are not parsed correctly)

#

--disable_warnings

drop table if exists table_28127_a;

drop table if exists table_28127_b;

--enable_warnings

create table table_28127_a(0b02 int);

--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/

show create table table_28127_a;

create table table_28127_b(0b2 int);

--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/

show create table table_28127_b;

drop table table_28127_a;

drop table table_28127_b;