~drizzle-trunk/drizzle/development

# This test uses chmod, can't be run with root permissions

-- source include/not_as_root.inc

# 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 1064

select x'hello';

--error 1054

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

#

# Bug #19371 VARBINARY() have trailing zeros after upgrade from 4.1

#

# MySQL file formats are not compatible with Drizzle

# Test with a saved table from 4.1

copy_file std_data/bug19371.frm $MYSQLTEST_VARDIR/master-data/test/t1.frm;

chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.frm;

copy_file std_data/bug19371.MYD $MYSQLTEST_VARDIR/master-data/test/t1.MYD;

chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.MYD;

copy_file std_data/bug19371.MYI $MYSQLTEST_VARDIR/master-data/test/t1.MYI;

chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.MYI;

--error ER_NO_SUCH_TABLE

show create table t1;

--error ER_BAD_TABLE_ERROR

drop table t1;

--remove_file $MYSQLTEST_VARDIR/master-data/test/t1.frm

--remove_file $MYSQLTEST_VARDIR/master-data/test/t1.MYD

--remove_file $MYSQLTEST_VARDIR/master-data/test/t1.MYI 

# 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);

show create table table_28127_a;

create table table_28127_b(0b2 int);

show create table table_28127_b;

drop table table_28127_a;

drop table table_28127_b;