~drizzle-trunk/drizzle/development

CREATE TABLE t1 (gvid int unsigned default NULL, hmid int unsigned default NULL, volid int unsigned default NULL, mmid int unsigned default NULL, hdid int unsigned default NULL, fsid int unsigned default NULL, ctid int unsigned default NULL, dtid int unsigned default NULL, cost int unsigned default NULL, performance int unsigned default NULL, serialnumber bigint unsigned default NULL, monitored int unsigned default '1', removed int unsigned default '0', target int unsigned default '0', dt_modified timestamp NOT NULL, name varchar(255) binary default NULL, description varchar(255) default NULL, UNIQUE KEY hmid (hmid,volid)) ENGINE=MyISAM;

1788

CREATE TABLE t1 (gvid int default NULL, hmid int default NULL, volid int default NULL, mmid int default NULL, hdid int default NULL, fsid int default NULL, ctid int default NULL, dtid int default NULL, cost int default NULL, performance int default NULL, serialnumber bigint default NULL, monitored int default '1', removed int default '0', target int default '0', dt_modified timestamp NOT NULL, name varchar(255) binary default NULL, description varchar(255) default NULL, UNIQUE KEY hmid (hmid,volid)) ENGINE=MyISAM;

1789

INSERT INTO t1 VALUES (200001,2,1,1,100,1,1,1,0,0,0,1,0,1,20020425060057,'\\\\ARKIVIO-TESTPDC\\E$',''),(200002,2,2,1,101,1,1,1,0,0,0,1,0,1,20020425060057,'\\\\ARKIVIO-TESTPDC\\C$',''),(200003,1,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,20020425060427,'c:',NULL);

1790

CREATE TABLE t2 ( hmid int unsigned default NULL, volid int unsigned default NULL, sampletid int unsigned default NULL, sampletime datetime default NULL, samplevalue bigint unsigned default NULL, KEY idx1 (hmid,volid,sampletid,sampletime)) ENGINE=MyISAM;

1790

CREATE TABLE t2 ( hmid int default NULL, volid int default NULL, sampletid int default NULL, sampletime datetime default NULL, samplevalue bigint default NULL, KEY idx1 (hmid,volid,sampletid,sampletime)) ENGINE=MyISAM;

1791

INSERT INTO t2 VALUES (1,3,10,'2002-06-01 08:00:00',35),(1,3,1010,'2002-06-01 12:00:01',35);

1792

# Disable PS becasue we get more warnings from PS than from normal execution

1793

--disable_ps_protocol

1967

DROP TABLE t1;

1968

1969

1970

# Bug#7425 inconsistent sort order on unsigned columns result of substraction

1970

# Bug#7425 inconsistent sort order on columns result of substraction

1971

1972

1973

create table t1 (a int unsigned, b int unsigned);

1973

create table t1 (a int, b int);

1974

insert into t1 values (1,0), (1,1), (1,2);

1975

select a-b from t1 order by 1;

1976

select a-b , (a-b < 0) from t1 order by 1;

1977

select a-b as d, (a-b >= 0), b from t1 group by b having d >= 0;

1978

select cast((a - b) as unsigned) from t1 order by 1;

1978

select a - b from t1 order by 1;

1979

drop table t1;

1980

1981

1995

# Test for BUG#10095

1996

1997

CREATE TABLE t1 (

1998

kunde_intern_id int unsigned NOT NULL default '0',

1999

kunde_id int unsigned NOT NULL default '0',

2000

FK_firma_id int unsigned NOT NULL default '0',

1998

kunde_intern_id int NOT NULL default '0',

1999

kunde_id int NOT NULL default '0',

2000

FK_firma_id int NOT NULL default '0',

2001

aktuell enum('Ja','Nein') NOT NULL default 'Ja',

2002

vorname varchar(128) NOT NULL default '',

2003

nachname varchar(128) NOT NULL default '',

2053

2054

2055

2056

# Test for Bug#8009, SELECT failed on bigint unsigned when using HEX

2056

# Test for Bug#8009, SELECT failed on bigint when using HEX

2057

2058

2059

CREATE TABLE t1 (b BIGINT UNSIGNED NOT NULL, PRIMARY KEY (b));

2060

INSERT INTO t1 VALUES (0x8000000000000000);

2061

SELECT b FROM t1 WHERE b=0x8000000000000000;

2059

CREATE TABLE t1 (b BIGINT NOT NULL, PRIMARY KEY (b));

2060

INSERT INTO t1 VALUES (0x4000000000000000);

2061

SELECT b FROM t1 WHERE b=0x4000000000000000;

2062

DROP TABLE t1;

2063

2064

2132

# Bug #11521 Negative integer keys incorrectly substituted for 0 during

2133

# range analysis.

2134

2135

create table t2 (a int unsigned);

2135

create table t2 (a int);

2136

create index t2i on t2(a);

2137

insert into t2 values (0), (254), (255);

2138

#explain select * from t2 where a > -1;

2299

# This test is here only to make sure that behavior is not changed in

2300

# 4.1 and 5.0

2301

2302

CREATE TABLE t1 (i BIGINT UNSIGNED NOT NULL);

2302

CREATE TABLE t1 (i BIGINT NOT NULL);

2303

INSERT INTO t1 VALUES (10);

2304

SELECT i='1e+01',i=1e+01, i in (1e+01,1e+01), i in ('1e+01','1e+01') FROM t1;

2305

DROP TABLE t1;

2741

# Bug #18895: Now tests for int

2742

2743

create table t1 (

2744

a int unsigned not null auto_increment primary key,

2744

a int not null auto_increment primary key,

2745

b int not null,

2746

c int not null

2747

);

2748

2749

create table t2 (

2750

a int unsigned not null auto_increment primary key,

2750

a int not null auto_increment primary key,

2751

b int not null,

2752

c int unsigned not null,

2752

c int not null,

2753

d varchar(50)

2754

);

2755

3019

AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";

3020

3021

DROP TABLE t1,t2;

3022

# Bug #22026: Warning when using IF statement and large unsigned bigint

3022

# Bug #22026: Warning when using IF statement and large bigint

3023

3024

3025

create table t1 (a bigint unsigned);

3025

create table t1 (a bigint);

3026

insert into t1 values

3027

(if(1, 9223372036854775808, 1)),

3028

(case when 1 then 9223372036854775808 else 1 end),

3029

(coalesce(9223372036854775808, 1));

3027

(if(1, 92233720368547758, 1)),

3028

(case when 1 then 92233720368547758 else 1 end),

3029

(coalesce(92233720368547758, 1));

3030

select * from t1;

3031

drop table t1;

3032

create table t1 select

3037

drop table t1;

3038

# Ensure we handle big values properly

3039

select

3040

if(1, cast(1111111111111111111 as unsigned), 1) i,

3041

case when 1 then cast(1111111111111111111 as unsigned) else 1 end c,

3042

coalesce(cast(1111111111111111111 as unsigned), 1) co;

3040

if(1, 1111111111111111111, 1) i,

3041

case when 1 then 1111111111111111111 else 1 end c,

3042

coalesce(1111111111111111111, 1) co;

3043

3044

3045

# Bug #22971: indexes on text columns are ignored for ref accesses

3252

# Bug #30666: Incorrect order when using range conditions on 2 tables or more

3253

3254

3255

CREATE TABLE t1 (c11 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY);

3256

CREATE TABLE t2 (c21 INT UNSIGNED NOT NULL,

3255

CREATE TABLE t1 (c11 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);

3256

CREATE TABLE t2 (c21 INT NOT NULL,

3257

c22 INT DEFAULT NULL,

3258

KEY(c21, c22));

3259

CREATE TABLE t3 (c31 INT UNSIGNED NOT NULL DEFAULT 0,

3259

CREATE TABLE t3 (c31 INT NOT NULL DEFAULT 0,

3260

c32 INT DEFAULT NULL,

3261

c33 INT NOT NULL,

3262

c34 INT UNSIGNED DEFAULT 0,

3262

c34 INT DEFAULT 0,

3263

KEY (c33, c34, c32));

3264

3265

INSERT INTO t1 values (),(),(),(),();

Older »