~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/range.test

  • Committer: Brian Aker
  • Date: 2010-12-20 19:20:57 UTC
  • mto: This revision was merged to the branch mainline in revision 2016.
  • Revision ID: brian@tangent.org-20101220192057-1ch4b9uo008d8rje
Merge in additional fixes for sign, plus alter table, plus TIME on
processlist.

Show diffs side-by-side

added added

removed removed

Lines of Context:
395
395
 
396
396
# Fix for bug#4488 
397
397
#
398
 
create table t1 (x bigint not null);
 
398
create table t1 (x bigint unsigned not null);
399
399
insert into t1(x) values (0x0ffffffffffffff0);
400
400
insert into t1(x) values (0x0ffffffffffffff1);
401
401
select * from t1;
440
440
#
441
441
# Bug #11185 incorrect comparison of int to signed constant
442
442
#
443
 
create table t1 (a bigint);
 
443
create table t1 (a bigint unsigned);
 
444
show create table t1;
444
445
create index t1i on t1(a);
 
446
show create table t1;
 
447
insert into t1 values (9223372036854775807);
 
448
truncate t1;
445
449
insert into t1 select 18446744073709551615;
446
450
insert into t1 select 18446744073709551614;
447
451