[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.119.135.67: ~ $ 
# Testing of "strict" mode

-- source include/have_innodb.inc

set @org_mode=@@sql_mode;
set @@sql_mode='ansi,traditional';
select @@sql_mode;

--disable_warnings
DROP TABLE IF EXISTS t1, t2;
--enable_warnings

# Test INSERT with DATE

CREATE TABLE t1 (col1 date);
INSERT INTO t1 VALUES('2004-01-01'),('2004-02-29');
INSERT INTO t1 VALUES('0000-10-31');

# All test cases expected to fail should return 
#      SQLSTATE 22007 <invalid date value>
--error 1292
INSERT INTO t1 VALUES('2004-0-31');
--error 1292
INSERT INTO t1 VALUES('2004-01-02'),('2004-0-31');
--error 1292
INSERT INTO t1 VALUES('2004-10-0');
--error 1292
INSERT INTO t1 VALUES('2004-09-31');
--error 1292
INSERT INTO t1 VALUES('2004-10-32');
--error 1292
INSERT INTO t1 VALUES('2003-02-29');
--error 1292
INSERT INTO t1 VALUES('2004-13-15');
--error 1292
INSERT INTO t1 VALUES('0000-00-00');
# Standard says we should return SQLSTATE 22018
--error 1292
INSERT INTO t1 VALUES ('59');

# Test the different related modes
set @@sql_mode='STRICT_ALL_TABLES';
INSERT INTO t1 VALUES('2004-01-03'),('2004-0-31');
set @@sql_mode='STRICT_ALL_TABLES,NO_ZERO_IN_DATE';
--error 1292
INSERT INTO t1 VALUES('2004-0-30');
--error 1292
INSERT INTO t1 VALUES('2004-01-04'),('2004-0-31'),('2004-01-05');
INSERT INTO t1 VALUES('0000-00-00');
INSERT IGNORE INTO t1 VALUES('2004-0-29');
set @@sql_mode='STRICT_ALL_TABLES,NO_ZERO_DATE';
--error 1292
INSERT INTO t1 VALUES('0000-00-00');
INSERT IGNORE INTO t1 VALUES('0000-00-00');
INSERT INTO t1 VALUES ('2004-0-30');
--error 1292
INSERT INTO t1 VALUES ('2004-2-30');
set @@sql_mode='STRICT_ALL_TABLES,ALLOW_INVALID_DATES';
INSERT INTO t1 VALUES ('2004-2-30');
set @@sql_mode='ansi,traditional';
INSERT IGNORE INTO t1 VALUES('2004-02-29'),('2004-13-15'),('0000-00-00');

select * from t1;
drop table t1;

# Test difference in behaviour with InnoDB and MyISAM tables

set @@sql_mode='strict_trans_tables';
CREATE TABLE t1 (col1 date) engine=myisam;
--error 1292
INSERT INTO t1 VALUES('2004-13-31'),('2004-1-1');
INSERT INTO t1 VALUES ('2004-1-2'), ('2004-13-31'),('2004-1-3');
INSERT IGNORE INTO t1 VALUES('2004-13-31'),('2004-1-4');
--error 1292
INSERT INTO t1 VALUES ('2003-02-29');
INSERT ignore INTO t1 VALUES('2003-02-30');
set @@sql_mode='STRICT_ALL_TABLES,ALLOW_INVALID_DATES';
INSERT ignore INTO t1 VALUES('2003-02-31');
select * from t1;
drop table t1;

set @@sql_mode='strict_trans_tables';
CREATE TABLE t1 (col1 date) engine=innodb;
--error 1292
INSERT INTO t1 VALUES('2004-13-31'),('2004-1-1');
--error 1292
INSERT INTO t1 VALUES ('2004-1-2'), ('2004-13-31'),('2004-1-3');
INSERT IGNORE INTO t1 VALUES('2004-13-31'),('2004-1-4');
--error 1292
INSERT INTO t1 VALUES ('2003-02-29');
INSERT ignore INTO t1 VALUES('2003-02-30');
set @@sql_mode='STRICT_ALL_TABLES,ALLOW_INVALID_DATES';
INSERT ignore INTO t1 VALUES('2003-02-31');
select * from t1;
drop table t1;
set @@sql_mode='ansi,traditional';

# Test INSERT with DATETIME

CREATE TABLE t1 (col1 datetime);
INSERT INTO t1 VALUES('2004-10-31 15:30:00'),('2004-02-29 15:30:00');
INSERT INTO t1 VALUES('0000-10-31 15:30:00');

# All test cases expected to fail should return 
#      SQLSTATE 22007 <invalid datetime value>
--error 1292
INSERT INTO t1 VALUES('2004-0-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-0 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-09-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-32 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2003-02-29 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-13-15 15:30:00');
--error 1292
INSERT INTO t1 VALUES('0000-00-00 15:30:00');
# Standard says we should return SQLSTATE 22018
--error 1292
INSERT INTO t1 VALUES ('59');
select * from t1;
drop table t1;

# Test INSERT with TIMESTAMP

CREATE TABLE t1 (col1 timestamp);
INSERT INTO t1 VALUES('2004-10-31 15:30:00'),('2004-02-29 15:30:00');

# All test cases expected to fail should return 
#      SQLSTATE 22007 <invalid datetime value>
# Standard says we should return ok, but we can't as this is out of range
--error 1292
INSERT INTO t1 VALUES('0000-10-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-0-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-0 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-09-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-32 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2003-02-29 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-13-15 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-02-29 25:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-02-29 15:65:00');
--error 1292
INSERT INTO t1 VALUES('2004-02-29 15:31:61');
--error 1292
INSERT INTO t1 VALUES('0000-00-00 15:30:00');
--error 1292
INSERT INTO t1 VALUES('0000-00-00 00:00:00');
INSERT IGNORE INTO t1 VALUES('0000-00-00 00:00:00');
# Standard says we should return SQLSTATE 22018
--error 1292
INSERT INTO t1 VALUES ('59');

set @@sql_mode='STRICT_ALL_TABLES,ALLOW_INVALID_DATES';
--error 1292
INSERT INTO t1 VALUES('2004-0-31 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-0 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-10-32 15:30:00');
--error 1292
INSERT INTO t1 VALUES('2004-02-30 15:30:04');
INSERT INTO t1 VALUES('0000-00-00 00:00:00');
set @@sql_mode='STRICT_ALL_TABLES,NO_ZERO_IN_DATE';
INSERT INTO t1 VALUES('0000-00-00 00:00:00');
set @@sql_mode='STRICT_ALL_TABLES,NO_ZERO_DATE';
--error 1292
INSERT INTO t1 VALUES('0000-00-00 00:00:00');
set @@sql_mode='ansi,traditional';
SELECT * FROM t1;
DROP TABLE t1;


#### Test INSERT with STR_TO_DATE into DATE/DATETIME/TIMESTAMP

CREATE TABLE t1 (col1 date, col2 datetime, col3 timestamp);

INSERT INTO t1 (col1) VALUES (STR_TO_DATE('15.10.2004','%d.%m.%Y'));
INSERT INTO t1 (col2) VALUES (STR_TO_DATE('15.10.2004 10.15','%d.%m.%Y %H.%i'));
INSERT INTO t1 (col3) VALUES (STR_TO_DATE('15.10.2004 10.15','%d.%m.%Y %H.%i'));

## Test INSERT with STR_TO_DATE into DATE
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid date value>

--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('31.10.0000 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('31.0.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('0.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('31.9.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('32.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('29.02.2003 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('15.13.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col1) VALUES(STR_TO_DATE('00.00.0000','%d.%m.%Y'));

## Test INSERT with STR_TO_DATE into DATETIME
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>

--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('31.10.0000 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('31.0.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('0.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('31.9.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('32.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('29.02.2003 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('15.13.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col2) VALUES(STR_TO_DATE('00.00.0000','%d.%m.%Y'));

## Test INSERT with STR_TO_DATE into TIMESTAMP
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>

--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('31.10.0000 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('31.0.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('0.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('31.9.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('32.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1292
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('29.02.2003 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('15.13.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
INSERT INTO t1 (col3) VALUES(STR_TO_DATE('00.00.0000','%d.%m.%Y'));

drop table t1;


#### Test INSERT with CAST AS DATE/DATETIME into DATE/DATETIME/TIMESTAMP

CREATE TABLE t1 (col1 date, col2 datetime, col3 timestamp);

INSERT INTO t1 (col1) VALUES (CAST('2004-10-15' AS DATE));
INSERT INTO t1 (col2) VALUES (CAST('2004-10-15 10:15' AS DATETIME));
INSERT INTO t1 (col3) VALUES (CAST('2004-10-15 10:15' AS DATETIME));


## Test INSERT with CAST AS DATE into DATE
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid date value>

INSERT INTO t1 (col1) VALUES(CAST('0000-10-31' AS DATE));

--error 1292
INSERT INTO t1 (col1) VALUES(CAST('2004-10-0' AS DATE));
--error 1292
INSERT INTO t1 (col1) VALUES(CAST('2004-0-10' AS DATE));

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
# --error 1292
# INSERT INTO t1 (col1) VALUES(CAST('2004-9-31' AS DATE));
# --error 1292
# INSERT INTO t1 (col1) VALUES(CAST('2004-10-32' AS DATE));
# --error 1292
# INSERT INTO t1 (col1) VALUES(CAST('2003-02-29' AS DATE));
# --error 1292
# INSERT INTO t1 (col1) VALUES(CAST('2004-13-15' AS DATE));

# deactivated because of Bug#6145
#  Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col1) VALUES(CAST('0000-00-00' AS DATE));

## Test INSERT with CAST AS DATETIME into DATETIME
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>

INSERT INTO t1 (col2) VALUES(CAST('0000-10-31 15:30' AS DATETIME));

--error 1292
INSERT INTO t1 (col2) VALUES(CAST('2004-10-0 15:30' AS DATETIME));
--error 1292
INSERT INTO t1 (col2) VALUES(CAST('2004-0-10 15:30' AS DATETIME));

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
#--error 1292
#INSERT INTO t1 (col2) VALUES(CAST('2004-9-31 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CAST('2004-10-32 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CAST('2003-02-29 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CAST('2004-13-15 15:30' AS DATETIME));

# Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col2) VALUES(CAST('0000-00-00' AS DATETIME));

## Test INSERT with CAST AS DATETIME into TIMESTAMP
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>
--error 1292
INSERT INTO t1 (col3) VALUES(CAST('0000-10-31 15:30' AS DATETIME));
# should return OK
# We accept this to be a failure

--error 1292
INSERT INTO t1 (col3) VALUES(CAST('2004-10-0 15:30' AS DATETIME));
--error 1292
INSERT INTO t1 (col3) VALUES(CAST('2004-0-10 15:30' AS DATETIME));
# should return SQLSTATE 22007 <invalid datetime value>

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
#--error 1292
#INSERT INTO t1 (col3) VALUES(CAST('2004-9-31 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CAST('2004-10-32 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CAST('2003-02-29 15:30' AS DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CAST('2004-13-15 15:30' AS DATETIME));

# Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col3) VALUES(CAST('0000-00-00' AS DATETIME));

drop table t1;


#### Test INSERT with CONVERT to DATE/DATETIME into DATE/DATETIME/TIMESTAMP

CREATE TABLE t1 (col1 date, col2 datetime, col3 timestamp);

INSERT INTO t1 (col1) VALUES (CONVERT('2004-10-15',DATE));
INSERT INTO t1 (col2) VALUES (CONVERT('2004-10-15 10:15',DATETIME));
INSERT INTO t1 (col3) VALUES (CONVERT('2004-10-15 10:15',DATETIME));


## Test INSERT with CONVERT to DATE into DATE
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid date value>

INSERT INTO t1 (col1) VALUES(CONVERT('0000-10-31' , DATE));

--error 1292
INSERT INTO t1 (col1) VALUES(CONVERT('2004-10-0' , DATE));
--error 1292
INSERT INTO t1 (col1) VALUES(CONVERT('2004-0-10' , DATE));

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
#--error 1292
#INSERT INTO t1 (col1) VALUES(CONVERT('2004-9-31' , DATE));
#--error 1292
#INSERT INTO t1 (col1) VALUES(CONVERT('2004-10-32' , DATE));
#--error 1292
#INSERT INTO t1 (col1) VALUES(CONVERT('2003-02-29' , DATE));
#--error 1292
#INSERT INTO t1 (col1) VALUES(CONVERT('2004-13-15',DATE));

# Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col1) VALUES(CONVERT('0000-00-00',DATE));

## Test INSERT with CONVERT to DATETIME into DATETIME
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>

INSERT INTO t1 (col2) VALUES(CONVERT('0000-10-31 15:30',DATETIME));

--error 1292
INSERT INTO t1 (col2) VALUES(CONVERT('2004-10-0 15:30',DATETIME));
--error 1292
INSERT INTO t1 (col2) VALUES(CONVERT('2004-0-10 15:30',DATETIME));

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
#--error 1292
#INSERT INTO t1 (col2) VALUES(CONVERT('2004-9-31 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CONVERT('2004-10-32 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CONVERT('2003-02-29 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col2) VALUES(CONVERT('2004-13-15 15:30',DATETIME));

# Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col2) VALUES(CONVERT('0000-00-00',DATETIME));

## Test INSERT with CONVERT to DATETIME into DATETIME
#       All test cases expected to fail should return 
#       SQLSTATE 22007 <invalid datetime value>
--error 1292
INSERT INTO t1 (col3) VALUES(CONVERT('0000-10-31 15:30',DATETIME));
# should return OK
# We accept this to be a failure

--error 1292
INSERT INTO t1 (col3) VALUES(CONVERT('2004-10-0 15:30',DATETIME));
--error 1292
INSERT INTO t1 (col3) VALUES(CONVERT('2004-0-10 15:30',DATETIME));

# deactivated because of Bug#8294
# Bug#8294 Traditional: Misleading error message for invalid CAST to DATE
#--error 1292
#INSERT INTO t1 (col3) VALUES(CONVERT('2004-9-31 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CONVERT('2004-10-32 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CONVERT('2003-02-29 15:30',DATETIME));
#--error 1292
#INSERT INTO t1 (col3) VALUES(CONVERT('2004-13-15 15:30',DATETIME));

# Bug#6145: Traditional: CONVERT and CAST should reject zero DATE values
--error 1292
INSERT INTO t1 (col3) VALUES(CONVERT('0000-00-00',DATETIME));

drop table t1;


# Test INSERT with TINYINT

CREATE TABLE t1(col1 TINYINT, col2 TINYINT UNSIGNED);
INSERT INTO t1 VALUES(-128,0),(0,0),(127,255),('-128','0'),('0','0'),('127','255'),(-128.0,0.0),(0.0,0.0),(127.0,255.0);
# Test that we restored the mode checking properly after an ok query
SELECT MOD(col1,0) FROM t1 WHERE col1 > 0 LIMIT 2;
-- error 1264
INSERT INTO t1 (col1) VALUES(-129);
-- error 1264
INSERT INTO t1 (col1) VALUES(128);
-- error 1264
INSERT INTO t1 (col2) VALUES(-1);
-- error 1264
INSERT INTO t1 (col2) VALUES(256);
-- error 1264
INSERT INTO t1 (col1) VALUES('-129');
-- error 1264
INSERT INTO t1 (col1) VALUES('128');
-- error 1264
INSERT INTO t1 (col2) VALUES('-1');
-- error 1264
INSERT INTO t1 (col2) VALUES('256');
-- error 1264
INSERT INTO t1 (col1) VALUES(128.0);
-- error 1264
INSERT INTO t1 (col2) VALUES(-1.0);
-- error 1264
INSERT INTO t1 (col2) VALUES(256.0);
SELECT MOD(col1,0) FROM t1 WHERE col1 > 0 LIMIT 1;
--error 1264
UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;
--error 1264
UPDATE t1 SET col2=col2 + 50 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col1=col1 / 0 WHERE col1 > 0;
set @@sql_mode='ERROR_FOR_DIVISION_BY_ZERO';
INSERT INTO t1 values (1/0,1/0);
set @@sql_mode='ansi,traditional';
SELECT MOD(col1,0) FROM t1 WHERE col1 > 0 LIMIT 2;
# Should return SQLSTATE 22018 invalid character value for cast
--error 1366
INSERT INTO t1 (col1) VALUES ('');
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0,1/0);
set @@sql_mode='ansi';
INSERT INTO t1 values (1/0,1/0);
set @@sql_mode='ansi,traditional';
INSERT IGNORE INTO t1 VALUES('-129','-1'),('128','256');
INSERT IGNORE INTO t1 VALUES(-129.0,-1.0),(128.0,256.0);
UPDATE IGNORE t1 SET col2=1/NULL where col1=0;

SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with SMALLINT

CREATE TABLE t1(col1 SMALLINT, col2 SMALLINT UNSIGNED);
INSERT INTO t1 VALUES(-32768,0),(0,0),(32767,65535),('-32768','0'),('32767','65535'),(-32768.0,0.0),(32767.0,65535.0);

--error 1264
INSERT INTO t1 (col1) VALUES(-32769);
--error 1264
INSERT INTO t1 (col1) VALUES(32768);
--error 1264
INSERT INTO t1 (col2) VALUES(-1);
--error 1264
INSERT INTO t1 (col2) VALUES(65536);
--error 1264
INSERT INTO t1 (col1) VALUES('-32769');
--error 1264
INSERT INTO t1 (col1) VALUES('32768');
--error 1264
INSERT INTO t1 (col2) VALUES('-1');
--error 1264
INSERT INTO t1 (col2) VALUES('65536');
--error 1264
INSERT INTO t1 (col1) VALUES(-32769.0);
--error 1264
INSERT INTO t1 (col1) VALUES(32768.0);
--error 1264
INSERT INTO t1 (col2) VALUES(-1.0);
--error 1264
INSERT INTO t1 (col2) VALUES(65536.0);
--error 1264
UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;
--error 1264
UPDATE t1 SET col2 = col2 + 50 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col1 = col1 / 0 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;
--error 1366
INSERT INTO t1 (col1) VALUES ('');
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0,1/0);
INSERT IGNORE INTO t1 VALUES(-32769,-1),(32768,65536);
INSERT IGNORE INTO t1 VALUES('-32769','-1'),('32768','65536');
INSERT IGNORE INTO t1 VALUES(-32769,-1.0),(32768.0,65536.0);
UPDATE IGNORE t1 SET col2=1/NULL where col1=0;

SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with MEDIUMINT

CREATE TABLE t1 (col1 MEDIUMINT, col2 MEDIUMINT UNSIGNED);
INSERT INTO t1 VALUES(-8388608,0),(0,0),(8388607,16777215),('-8388608','0'),('8388607','16777215'),(-8388608.0,0.0),(8388607.0,16777215.0);
--error 1264
INSERT INTO t1 (col1) VALUES(-8388609);
--error 1264
INSERT INTO t1 (col1) VALUES(8388608);
--error 1264
INSERT INTO t1 (col2) VALUES(-1);
--error 1264
INSERT INTO t1 (col2) VALUES(16777216);
--error 1264
INSERT INTO t1 (col1) VALUES('-8388609');
--error 1264
INSERT INTO t1 (col1) VALUES('8388608');
--error 1264
INSERT INTO t1 (col2) VALUES('-1');
--error 1264
INSERT INTO t1 (col2) VALUES('16777216');
--error 1264
INSERT INTO t1 (col1) VALUES(-8388609.0);
--error 1264
INSERT INTO t1 (col1) VALUES(8388608.0);
--error 1264
INSERT INTO t1 (col2) VALUES(-1.0);
--error 1264
INSERT INTO t1 (col2) VALUES(16777216.0);

--error 1264
UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;
--error 1264
UPDATE t1 SET col2 = col2 + 50 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;
--error 1366
INSERT INTO t1 (col1) VALUES ('');
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0,1/0);
INSERT IGNORE INTO t1 VALUES(-8388609,-1),(8388608,16777216);
INSERT IGNORE INTO t1 VALUES('-8388609','-1'),('8388608','16777216');
INSERT IGNORE INTO t1 VALUES(-8388609.0,-1.0),(8388608.0,16777216.0);
UPDATE IGNORE t1 SET col2=1/NULL where col1=0;

SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with INT

CREATE TABLE t1 (col1 INT, col2 INT UNSIGNED);
INSERT INTO t1 VALUES(-2147483648,0),(0,0),(2147483647,4294967295),('-2147483648','0'),('2147483647','4294967295'),(-2147483648.0,0.0),(2147483647.0,4294967295.0);
--error 1264
INSERT INTO t1 (col1) VALUES(-2147483649);
--error 1264
INSERT INTO t1 (col1) VALUES(2147643648);
--error 1264
INSERT INTO t1 (col2) VALUES(-1);
--error 1264
INSERT INTO t1 (col2) VALUES(4294967296);
--error 1264
INSERT INTO t1 (col1) VALUES('-2147483649');
--error 1264
INSERT INTO t1 (col1) VALUES('2147643648');
--error 1264
INSERT INTO t1 (col2) VALUES('-1');
--error 1264
INSERT INTO t1 (col2) VALUES('4294967296');
--error 1264
INSERT INTO t1 (col1) VALUES(-2147483649.0);
--error 1264
INSERT INTO t1 (col1) VALUES(2147643648.0);
--error 1264
INSERT INTO t1 (col2) VALUES(-1.0);
--error 1264
INSERT INTO t1 (col2) VALUES(4294967296.0);

--error 1264
UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;
--error 1264
UPDATE t1 SET col2 =col2 + 50 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;
--error 1366
INSERT INTO t1 (col1) VALUES ('');
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0,1/0);
INSERT IGNORE INTO t1 values (-2147483649, -1),(2147643648,4294967296);
INSERT IGNORE INTO t1 values ('-2147483649', '-1'),('2147643648','4294967296');
INSERT IGNORE INTO t1 values (-2147483649.0, -1.0),(2147643648.0,4294967296.0);
UPDATE IGNORE t1 SET col2=1/NULL where col1=0;
SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with BIGINT
# Note that this doesn't behave 100 % to standard as we rotate
# integers when it's too big/small (just like C)

CREATE TABLE t1 (col1 BIGINT, col2 BIGINT UNSIGNED);
INSERT INTO t1 VALUES(-9223372036854775808,0),(0,0),(9223372036854775807,18446744073709551615);
INSERT INTO t1 VALUES('-9223372036854775808','0'),('9223372036854775807','18446744073709551615');
INSERT INTO t1 VALUES(-9223372036854774000.0,0.0),(9223372036854775700.0,1844674407370954000.0);

--error 1264
INSERT INTO t1 (col1) VALUES(-9223372036854775809);
--error 1264
INSERT INTO t1 (col1) VALUES(9223372036854775808);
--error 1264
INSERT INTO t1 (col2) VALUES(-1);

--error 1264
INSERT INTO t1 (col2) VALUES(18446744073709551616);
--error 1264
INSERT INTO t1 (col1) VALUES('-9223372036854775809');
--error 1264
INSERT INTO t1 (col1) VALUES('9223372036854775808');
--error 1264
INSERT INTO t1 (col2) VALUES('-1');
--error 1264
INSERT INTO t1 (col2) VALUES('18446744073709551616');

# Note that the following two double numbers are slighty bigger than max/min
# bigint becasue of rounding errors when converting it to bigint
--error 1264
INSERT INTO t1 (col1) VALUES(-9223372036854785809.0);
--error 1264
INSERT INTO t1 (col1) VALUES(9223372036854785808.0);
--error 1264
INSERT INTO t1 (col2) VALUES(-1.0);
--error 1264
INSERT INTO t1 (col2) VALUES(18446744073709551616.0);

# The following doesn't give an error as it's done in integer context
# UPDATE t1 SET col1=col1 - 5000 WHERE col1 < 0;
# UPDATE t1 SET col2 =col2 + 5000 WHERE col2 > 0;

--error 1365
UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;
--error 1366
INSERT INTO t1 (col1) VALUES ('');
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0,1/0);
INSERT IGNORE INTO t1 VALUES(-9223372036854775809,-1),(9223372036854775808,18446744073709551616);
INSERT IGNORE INTO t1 VALUES('-9223372036854775809','-1'),('9223372036854775808','18446744073709551616');
INSERT IGNORE INTO t1 VALUES(-9223372036854785809.0,-1.0),(9223372036854785808.0,18446744073709551616.0);
UPDATE IGNORE t1 SET col2=1/NULL where col1=0;
SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with NUMERIC

CREATE TABLE t1 (col1 NUMERIC(4,2));
INSERT INTO t1 VALUES (10.55),(10.5555),(0),(-10.55),(-10.5555),(11),(1e+01);
# Note that the +/-10.5555 is inserted as +/-10.55, not +/-10.56 !
INSERT INTO t1 VALUES ('10.55'),('10.5555'),('-10.55'),('-10.5555'),('11'),('1e+01');

# The 2 following inserts should generate a warning, but doesn't yet
# because NUMERIC works like DECIMAL
--error 1264
INSERT INTO t1 VALUES (101.55);
--error 1264
INSERT INTO t1 VALUES (101);
--error 1264
INSERT INTO t1 VALUES (-101.55);
--error 1264
INSERT INTO t1 VALUES (1010.55);
--error 1264
INSERT INTO t1 VALUES (1010);
# The 2 following inserts should generate a warning, but doesn't yet
# because NUMERIC works like DECIMAL
--error 1264
INSERT INTO t1 VALUES ('101.55');
--error 1264
INSERT INTO t1 VALUES ('101');
--error 1264
INSERT INTO t1 VALUES ('-101.55');
--error 1264
INSERT INTO t1 VALUES ('-1010.55');
--error 1264
INSERT INTO t1 VALUES ('-100E+1');
--error 1366
INSERT INTO t1 VALUES ('-100E');
--error 1264
UPDATE t1 SET col1 =col1 * 50000 WHERE col1 =11;
--error 1365
UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;
#--error 1265
--error 1366
INSERT INTO t1 (col1) VALUES ('');
#--error 1265
--error 1366
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1366
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 values (1/0);
INSERT IGNORE INTO t1 VALUES(1000),(-1000);
INSERT IGNORE INTO t1 VALUES('1000'),('-1000');
INSERT IGNORE INTO t1 VALUES(1000.0),(-1000.0);
UPDATE IGNORE t1 SET col1=1/NULL where col1=0;
SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with FLOAT

CREATE TABLE t1 (col1 FLOAT, col2 FLOAT UNSIGNED);
INSERT INTO t1 VALUES (-1.1E-37,0),(+3.4E+38,+3.4E+38);
INSERT INTO t1 VALUES ('-1.1E-37',0),('+3.4E+38','+3.4E+38');
# We don't give warnings for underflow
INSERT INTO t1 (col1) VALUES (3E-46);
--error 1264
INSERT INTO t1 (col1) VALUES (+3.4E+39);
--error 1264
INSERT INTO t1 (col2) VALUES (-1.1E-3);
--error 1264
INSERT INTO t1 (col1) VALUES ('+3.4E+39');
--error 1264
INSERT INTO t1 (col2) VALUES ('-1.1E-3');
--error 1264
UPDATE t1 SET col1 =col1 * 5000 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col2 =col2 / 0 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;
--error 1265
INSERT INTO t1 (col1) VALUES ('');
--error 1265
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 (col1) VALUES (1/0);
INSERT IGNORE INTO t1 VALUES (+3.4E+39,-3.4E+39);
INSERT IGNORE INTO t1 VALUES ('+3.4E+39','-3.4E+39');
SELECT * FROM t1;
DROP TABLE t1;

# Test INSERT with DOUBLE

CREATE TABLE t1 (col1 DOUBLE PRECISION, col2 DOUBLE PRECISION UNSIGNED);
INSERT INTO t1 VALUES (-2.2E-307,0),(2E-307,0),(+1.7E+308,+1.7E+308);
INSERT INTO t1 VALUES ('-2.2E-307',0),('-2E-307',0),('+1.7E+308','+1.7E+308');
# We don't give warnings for underflow
INSERT INTO t1 (col1) VALUES (-2.2E-330);
--error 1367,1264
INSERT INTO t1 (col1) VALUES (+1.7E+309);
--error 1264
INSERT INTO t1 (col2) VALUES (-1.1E-3);
--error 1264
INSERT INTO t1 (col1) VALUES ('+1.8E+309');
--error 1264
INSERT INTO t1 (col2) VALUES ('-1.2E-3');
--error ER_DATA_OUT_OF_RANGE
UPDATE t1 SET col1 =col1 * 5000 WHERE col1 > 0;
--error 1365
UPDATE t1 SET col2 =col2 / 0 WHERE col2 > 0;
--error 1365
UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;
--error 1265
INSERT INTO t1 (col1) VALUES ('');
--error 1265
INSERT INTO t1 (col1) VALUES ('a59b');
--error 1265
INSERT INTO t1 (col1) VALUES ('1a');
INSERT IGNORE INTO t1 (col1) VALUES ('2a');
INSERT IGNORE INTO t1 (col1) values (1/0);
--error 1367
INSERT IGNORE INTO t1 VALUES (+1.9E+309,-1.9E+309);
INSERT IGNORE INTO t1 VALUES ('+2.0E+309','-2.0E+309');
# stupid...
--replace_result -0 0 1.7976931348623e+308 1.79769313486232e+308
SELECT * FROM t1;
DROP TABLE t1;

# Testing INSERT with CHAR/VARCHAR

CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(6));
INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello   ', 'hello ');
--error 1406
INSERT INTO t1 (col1) VALUES ('hellobob');
--error 1406
INSERT INTO t1 (col2) VALUES ('hellobob');
INSERT INTO t1 (col2) VALUES ('hello  ');
--error 1406
UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he';
--error 1406
UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he';
INSERT IGNORE INTO t1 VALUES ('hellobob', 'hellobob');
UPDATE IGNORE t1 SET col2 ='hellotrudy' WHERE col2 ='he';
SELECT * FROM t1;
DROP TABLE t1;

# Testing INSERT with ENUM

CREATE TABLE t1 (col1 enum('red','blue','green'));
INSERT INTO t1 VALUES ('red'),('blue'),('green');
--error 1265
INSERT INTO t1 (col1) VALUES ('yellow');
--error 1265
INSERT INTO t1 (col1) VALUES ('redd');
--error 1265
INSERT INTO t1 VALUES ('');
--error 1265
UPDATE t1 SET col1 ='yellow' WHERE col1 ='green';
INSERT IGNORE INTO t1 VALUES ('yellow');
UPDATE IGNORE t1 SET col1 ='yellow' WHERE col1 ='blue';
SELECT * FROM t1;
DROP TABLE t1;

# Testing of insert of NULL in not NULL column

CREATE TABLE t1 (col1 INT NOT NULL, col2 CHAR(5) NOT NULL, col3 DATE NOT NULL);
INSERT INTO t1 VALUES (100, 'hello', '2004-08-20');
INSERT INTO t1 (col1,col2,col3) VALUES (101, 'hell2', '2004-08-21');
--error 1048
INSERT INTO t1 (col1,col2,col3) VALUES (NULL, '', '2004-01-01');
--error 1048
INSERT INTO t1 (col1,col2,col3) VALUES (102, NULL, '2004-01-01');
--error 1048
INSERT INTO t1 VALUES (103,'',NULL);
--error 1048
UPDATE t1 SET col1=NULL WHERE col1 =100;
--error 1048
UPDATE t1 SET col2 =NULL WHERE col2 ='hello';
--error 1048
UPDATE t1 SET col2 =NULL where col3 IS NOT NULL;
INSERT IGNORE INTO t1 values (NULL,NULL,NULL);
SELECT * FROM t1;
DROP TABLE t1;

# Testing of default values

CREATE TABLE t1 (col1 INT NOT NULL default 99, col2 CHAR(6) NOT NULL);
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (1, 'hello');
INSERT INTO t1 (col2) VALUES ('hello2');
--error 1048
INSERT INTO t1 (col2) VALUES (NULL);
--error 1364
INSERT INTO t1 (col1) VALUES (2);
--error 1364
INSERT INTO t1 VALUES(default(col1),default(col2));
--error 1364
INSERT INTO t1 (col1) SELECT 1;
--error 1048
INSERT INTO t1 SELECT 1,NULL;
INSERT IGNORE INTO t1 values (NULL,NULL);
INSERT IGNORE INTO t1 (col1) values (3);
INSERT IGNORE INTO t1 () values ();
SELECT * FROM t1;
DROP TABLE t1;

#
# Bug #9029 Traditional: Wrong SQLSTATE returned for string truncation
#

set sql_mode='traditional';
create table t1 (charcol char(255), varcharcol varchar(255),
binarycol binary(255), varbinarycol varbinary(255), tinytextcol tinytext,
tinyblobcol tinyblob);
--error 1406
insert into t1 (charcol) values (repeat('x',256));
--error 1406
insert into t1 (varcharcol) values (repeat('x',256));
--error 1406
insert into t1 (binarycol) values (repeat('x',256));
--error 1406
insert into t1 (varbinarycol) values (repeat('x',256));
--error 1406
insert into t1 (tinytextcol) values (repeat('x',256));
--error 1406
insert into t1 (tinyblobcol) values (repeat('x',256));
select * from t1;
drop table t1;

#
# Bug #5902: STR_TO_DATE() didn't give errors in traditional mode
#

set sql_mode='traditional';
create table t1 (col1 datetime);
--error 1292
insert into t1 values(STR_TO_DATE('31.10.2004 15.30 abc','%d.%m.%Y %H.%i'));
--error 1411
insert into t1 values(STR_TO_DATE('32.10.2004 15.30','%d.%m.%Y %H.%i'));
--error 1411
insert into t1 values(STR_TO_DATE('2004.12.12 22:22:33 AM','%Y.%m.%d %r'));
--error 1411
insert into t1 values(STR_TO_DATE('2004.12.12 abc','%Y.%m.%d %T'));
set sql_mode='';
insert into t1 values(STR_TO_DATE('31.10.2004 15.30 abc','%d.%m.%Y %H.%i'));
insert into t1 values(STR_TO_DATE('32.10.2004 15.30','%d.%m.%Y %H.%i'));
insert into t1 values(STR_TO_DATE('2004.12.12 22:22:33 AM','%Y.%m.%d %r'));
insert into t1 values(STR_TO_DATE('2004.12.12 abc','%Y.%m.%d %T'));

# Some correct values, just to test the functions
insert into t1 values(STR_TO_DATE('31.10.2004 15.30','%d.%m.%Y %H.%i'));
insert into t1 values(STR_TO_DATE('2004.12.12 11:22:33 AM','%Y.%m.%d %r'));
insert into t1 values(STR_TO_DATE('2004.12.12 10:22:59','%Y.%m.%d %T'));

select * from t1;

# Check that select don't abort even in strict mode (for now)
set sql_mode='traditional';

select count(*) from t1 where STR_TO_DATE('2004.12.12 10:22:61','%Y.%m.%d %T') IS NULL;

drop table t1;

#
# Check insert with wrong CAST() (Bug #5912)
#

create table t1 (col1 char(3), col2 integer);
--error 1292
insert into t1 (col1) values (cast(1000 as char(3)));
--error 1292
insert into t1 (col1) values (cast(1000E+0 as char(3)));
--error 1292
insert into t1 (col1) values (cast(1000.0 as char(3)));
--error 1292
insert into t1 (col2) values (cast('abc' as signed integer));
--error 1292
insert into t1 (col2) values (10E+0 + 'a');
--error 1292
insert into t1 (col2) values (cast('10a' as unsigned integer));
insert into t1 (col2) values (cast('10' as unsigned integer));
insert into t1 (col2) values (cast('10' as signed integer));
insert into t1 (col2) values (10E+0 + '0 ');
select * from t1;
drop table t1;

#
# Zero dates using numbers was not checked properly (Bug #5933 & #6145)
#

create table t1 (col1 date, col2 datetime, col3 timestamp);
--error 1292
insert into t1 values (0,0,0);
--error 1292
insert into t1 values (0.0,0.0,0.0);
--error 1292
insert into t1 (col1) values (convert('0000-00-00',date));
--error 1292
insert into t1 (col1) values (cast('0000-00-00' as date));

set sql_mode='no_zero_date';
insert into t1 values (0,0,0);
insert into t1 values (0.0,0.0,0.0);
drop table t1;
set sql_mode='traditional';
create table t1 (col1 date);
insert ignore into t1 values ('0000-00-00');
--error 1292
insert into t1 select * from t1;
insert ignore into t1 values ('0000-00-00');
insert ignore into t1 (col1) values (cast('0000-00-00' as date));
--error 1292
insert into t1 select * from t1;
--error 1292
alter table t1 modify col1 datetime;
alter ignore table t1 modify col1 datetime;
--error 1292
insert into t1 select * from t1;
select * from t1;
drop table t1;

#
# Test of inserting an invalid value via a stored procedure (Bug #5907)
#
create table t1 (col1 tinyint);
drop procedure if exists t1;
delimiter |;
create procedure t1 () begin declare exit handler for sqlexception
select'a'; insert into t1 values (200); end;|
delimiter ;|
call t1();
select * from t1;
drop procedure t1;
drop table t1;

#
# Restore mode
#
set sql_mode=@org_mode;

# Test fields with no default value that are NOT NULL (Bug #5986)
SET @@sql_mode = 'traditional';
CREATE TABLE t1 (i int not null);
--error 1364
INSERT INTO t1 VALUES ();
--error 1364
INSERT INTO t1 VALUES (DEFAULT);
--error 1364
INSERT INTO t1 VALUES (DEFAULT(i));
ALTER TABLE t1 ADD j int;
--error 1364
INSERT INTO t1 SET j = 1;
--error 1364
INSERT INTO t1 SET j = 1, i = DEFAULT;
--error 1364
INSERT INTO t1 SET j = 1, i = DEFAULT(i);
--error 1364
INSERT INTO t1 VALUES (DEFAULT,1);
DROP TABLE t1;
SET @@sql_mode = '';
CREATE TABLE t1 (i int not null);
INSERT INTO t1 VALUES ();
INSERT INTO t1 VALUES (DEFAULT);
# DEFAULT(i) is an error even with the default sql_mode
--error 1364
INSERT INTO t1 VALUES (DEFAULT(i));
ALTER TABLE t1 ADD j int;
INSERT INTO t1 SET j = 1;
INSERT INTO t1 SET j = 1, i = DEFAULT;
--error 1364
INSERT INTO t1 SET j = 1, i = DEFAULT(i);
INSERT INTO t1 VALUES (DEFAULT,1);
DROP TABLE t1;

#
# Bugs #8295 and #8296: varchar and varbinary conversion
#

set @@sql_mode='traditional';
--error 1074
create table t1(a varchar(65537));
--error 1074
create table t1(a varbinary(65537));

#
# Bug #9881: problem with altering table
#

set @@sql_mode='traditional';
create table t1(a int, b date not null);                                       
alter table t1 modify a bigint unsigned not null;
show create table t1;
drop table t1;

#
# Bug #5906: handle invalid date due to conversion
#
set @@sql_mode='traditional';
create table t1 (d date);
--error 1292
insert into t1 values ('2000-10-00');
--error 1292
insert into t1 values (1000);
insert into t1 values ('2000-10-01');
--error 1292
update t1 set d = 1100;
select * from t1;
drop table t1;

#
# Bug #11964: alter table with timestamp field
#

set @@sql_mode='traditional';
create table t1(a int, b timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
alter table t1 add primary key(a);
show create table t1;
drop table t1;
create table t1(a int, b timestamp not null default 20050102030405);
alter table t1 add primary key(a);
show create table t1;
drop table t1;

#
# BIT fields
#

set @@sql_mode='traditional';
create table t1(a bit(2));
--error 1406
insert into t1 values(b'101');
select * from t1;
drop table t1;

#
# Bug#17626 CREATE TABLE ... SELECT failure with TRADITIONAL SQL mode
#
set sql_mode='traditional';
create table t1 (date date not null);
create table t2 select date from t1;
show create table t2;
drop table t2,t1;
set @@sql_mode= @org_mode;

#
# Bug #13934 Silent truncation of table comments
#
set @@sql_mode='traditional';
--error ER_TOO_LONG_TABLE_COMMENT
create table t1 (i int)
comment '123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*
         123456789*123456789*123456789*123456789*123456789*';
--error ER_TOO_LONG_FIELD_COMMENT
create table t1 (
i int comment
'123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*
 123456789*123456789*123456789*123456789*');
set @@sql_mode= @org_mode;
create table t1
(i int comment
 '123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*
  123456789*123456789*123456789*123456789*');

select column_name, column_comment from information_schema.columns where
table_schema = 'test' and table_name = 't1';
drop table t1;

set names utf8;
create table t1 (i int)
comment '123456789*123456789*123456789*123456789*123456789*123456789*';
show create table t1;
drop table t1;

#
# Bug #39591: Crash if table comment is longer than 62 characters
#

#60 chars, 120 (+1) bytes (UTF-8 with 2-byte chars)
CREATE TABLE t3 (f1 INT) COMMENT 'כקבהחןכקבהחןכקבהחןכקבהחןכקבהחןכקבהחןכקבהחןכקבהחןכקבהחןכקבהחן';
SHOW CREATE TABLE t3;
DROP TABLE t3;

#
# Bug #26359: Strings becoming truncated and converted to numbers under STRICT mode
#
set sql_mode= 'traditional';
create table t1(col1 tinyint, col2 tinyint unsigned, 
  col3 smallint, col4 smallint unsigned,
  col5 mediumint, col6 mediumint unsigned,
  col7 int, col8 int unsigned,
  col9 bigint, col10 bigint unsigned);
--error 1366
insert into t1(col1) values('-');
--error 1366
insert into t1(col2) values('+');
--error 1366
insert into t1(col3) values('-');
--error 1366
insert into t1(col4) values('+');
--error 1366
insert into t1(col5) values('-');
--error 1366
insert into t1(col6) values('+');
--error 1366
insert into t1(col7) values('-');
--error 1366
insert into t1(col8) values('+');
--error 1366
insert into t1(col9) values('-');
--error 1366
insert into t1(col10) values('+');
drop table t1;

#
# Bug #27176: Assigning a string to an year column has unexpected results
#
set sql_mode='traditional';
create table t1(a year);
--error 1366
insert into t1 values ('-');
--error 1366
insert into t1 values ('+');
--error 1366
insert into t1 values ('');
--error 1265
insert into t1 values ('2000a');
--error 1265
insert into t1 values ('2E3x');
drop table t1;

#
# Bug#27069 set with identical elements are created
#
set sql_mode='traditional';
--error 1291
create table t1 (f1 set('a','a'));
--error 1291
create table t1 (f1 enum('a','a'));

#
# Bug #22824: strict, datetime, NULL, wrong warning
#
set @@sql_mode='NO_ZERO_DATE';
create table t1(a datetime not null);
select count(*) from t1 where a is null;
drop table t1;

--echo End of 5.0 tests

--echo #
--echo # Start of 5.6 tests
--echo #

--echo #
--echo # WL#946 TIME/TIMESTAMP/DATETIME with fractional seconds: CAST to DATETIME
--echo #

--echo #
--echo # STR_TO_DATE with NO_ZERO_DATE did not return NULL (with warning)
--echo # in get_date(). Only did in val_str() and val_int().
SET sql_mode='NO_ZERO_DATE';
SELECT
  STR_TO_DATE('2001','%Y'),
  CONCAT(STR_TO_DATE('2001','%Y')),
  STR_TO_DATE('2001','%Y')+1; 

--echo #
--echo # End of 5.6 tests
--echo #

Filemanager

DIR : / usr/ share/ mysql-test/ t/
Name Type Size Permission Actions
1st.test File 102 B 0644
alias.test File 9 KB 0644
almost_full.test File 848 B 0644
alter_table-big.test File 5.67 KB 0644
alter_table.test File 68.73 KB 0644
analyze.test File 2.25 KB 0644
ansi.test File 847 B 0644
archive-big.test File 41.09 KB 0644
archive.test File 106.4 KB 0644
archive_bitfield.test File 3.94 KB 0644
archive_debug.test File 395 B 0644
archive_gis.test File 103 B 0644
archive_no_symlink-master.opt File 22 B 0644
archive_no_symlink.test File 810 B 0644
archive_plugin-master.opt File 33 B 0644
archive_plugin.test File 972 B 0644
archive_symlink.test File 2.48 KB 0644
audit_plugin-master.opt File 17 B 0644
audit_plugin.test File 1.48 KB 0644
auth_rpl-master.opt File 35 B 0644
auth_rpl-slave.opt File 36 B 0644
auth_rpl.test File 1.86 KB 0644
auto_increment.test File 10.98 KB 0644
bench_count_distinct.test File 416 B 0644
bigint.test File 13.32 KB 0644
binary.test File 4.45 KB 0644
binary_to_hex.test File 2.24 KB 0644
blackhole.test File 762 B 0644
blackhole_plugin-master.opt File 35 B 0644
blackhole_plugin.test File 1009 B 0644
bool.test File 2.47 KB 0644
bootstrap-master.opt File 98 B 0644
bootstrap.test File 1.64 KB 0644
bug12427262.test File 1.7 KB 0644
bug12969156-master.opt File 32 B 0644
bug12969156.test File 498 B 0644
bug17076131-master.opt File 57 B 0644
bug17076131.test File 1.06 KB 0644
bug33509-master.opt File 33 B 0644
bug33509.test File 2.52 KB 0644
bug39022.test File 1.62 KB 0644
bug46080-master.opt File 69 B 0644
bug46080.test File 723 B 0644
bug46261-master.opt File 40 B 0644
bug46261.test File 405 B 0644
bug46760-master.opt File 53 B 0644
bug46760.test File 970 B 0644
bug47671-master.opt File 66 B 0644
bug47671.test File 448 B 0644
bug58669-master.opt File 12 B 0644
bug58669.test File 495 B 0644
bulk_replace.test File 311 B 0644
cache_innodb-master.opt File 21 B 0644
cache_innodb.test File 707 B 0644
case.test File 6.29 KB 0644
cast.test File 9.18 KB 0644
change_user-master.opt File 16 B 0644
change_user.test File 3.9 KB 0644
check.test File 1.59 KB 0644
check_auto_permission.test File 2.06 KB 0644
client_xml.test File 1.47 KB 0644
comment_column.test File 36.33 KB 0644
comment_column2.test File 131.05 KB 0644
comment_index.test File 22.08 KB 0644
comment_table.test File 13.99 KB 0644
comments.test File 1.37 KB 0644
commit.test File 15.16 KB 0644
commit_1innodb.test File 255 B 0644
compare.test File 2.25 KB 0644
compress.test File 827 B 0644
concurrent_innodb_safelog-master.opt File 29 B 0644
concurrent_innodb_safelog.test File 716 B 0644
concurrent_innodb_unsafelog-master.opt File 62 B 0644
concurrent_innodb_unsafelog.test File 718 B 0644
connect.test File 14.32 KB 0644
connect_debug.test File 2.12 KB 0644
consistent_snapshot.test File 2.02 KB 0644
constraints.test File 1.65 KB 0644
count_distinct.test File 7.47 KB 0644
count_distinct2-master.opt File 28 B 0644
count_distinct2.test File 1.83 KB 0644
count_distinct3.test File 1.35 KB 0644
create-big.test File 16.96 KB 0644
create.test File 65.6 KB 0644
create_not_windows.test File 1.06 KB 0644
create_select_tmp.test File 1.29 KB 0644
csv.test File 106.78 KB 0644
csv_alter_table.test File 1.81 KB 0644
csv_not_null.test File 3.24 KB 0644
ctype_ascii.test File 1.2 KB 0644
ctype_big5.test File 4.99 KB 0644
ctype_binary.test File 395 B 0644
ctype_collate.test File 9.18 KB 0644
ctype_cp1250_ch.test File 2.96 KB 0644
ctype_cp1251.test File 2.67 KB 0644
ctype_cp932.test File 1.01 KB 0644
ctype_cp932_binlog_row.test File 236 B 0644
ctype_cp932_binlog_stm.test File 4.57 KB 0644
ctype_create.test File 2.76 KB 0644
ctype_errors.test File 1.33 KB 0644
ctype_eucjpms.test File 29.89 KB 0644
ctype_euckr.test File 5.27 KB 0644
ctype_filename.test File 367 B 0644
ctype_filesystem-master.opt File 73 B 0644
ctype_filesystem.test File 233 B 0644
ctype_gb2312.test File 4.57 KB 0644
ctype_gbk.test File 5.7 KB 0644
ctype_gbk_binlog.test File 961 B 0644
ctype_hebrew.test File 398 B 0644
ctype_latin1.test File 7.15 KB 0644
ctype_latin1_de-master.opt File 67 B 0644
ctype_latin1_de.test File 5.79 KB 0644
ctype_latin2.test File 3.19 KB 0644
ctype_latin2_ch.test File 7.49 KB 0644
ctype_ldml-master.opt File 100 B 0644
ctype_ldml.test File 16.19 KB 0644
ctype_like_range.test File 3.91 KB 0644
ctype_many.test File 14.98 KB 0644
ctype_mb.test File 692 B 0644
ctype_recoding.test File 6.6 KB 0644
ctype_sjis.test File 5.71 KB 0644
ctype_tis620.test File 64.63 KB 0644
ctype_uca.test File 27.57 KB 0644
ctype_ucs.test File 23.66 KB 0644
ctype_ucs2_def-master.opt File 70 B 0644
ctype_ucs2_def.test File 1.49 KB 0644
ctype_ujis.test File 40.45 KB 0644
ctype_ujis_ucs2.test File 83.43 KB 0644
ctype_utf16.test File 22.01 KB 0644
ctype_utf16_def-master.opt File 36 B 0644
ctype_utf16_def.test File 227 B 0644
ctype_utf16_uca.test File 6.43 KB 0644
ctype_utf16le.test File 21.66 KB 0644
ctype_utf32.test File 24.79 KB 0644
ctype_utf32_uca.test File 7.31 KB 0644
ctype_utf8-master.opt File 32 B 0644
ctype_utf8.test File 52.04 KB 0644
ctype_utf8mb4-master.opt File 68 B 0644
ctype_utf8mb4.test File 58.88 KB 0644
ctype_utf8mb4_heap.test File 107 B 0644
ctype_utf8mb4_innodb-master.opt File 32 B 0644
ctype_utf8mb4_innodb.test File 162 B 0644
ctype_utf8mb4_myisam.test File 92 B 0644
ctype_utf8mb4_uca.test File 2.74 KB 0644
date_formats-master.opt File 46 B 0644
date_formats.test File 12.27 KB 0644
ddl_i18n_koi8r.test File 23.19 KB 0644
ddl_i18n_utf8.test File 23.47 KB 0644
deadlock_innodb.test File 358 B 0644
debug_sync.test File 13.71 KB 0644
debug_sync2-master.opt File 29 B 0644
debug_sync2.test File 559 B 0644
default.test File 5.76 KB 0644
delayed.test File 17.33 KB 0644
delete.test File 15.21 KB 0644
deprecated_features.test File 642 B 0644
derived.test File 46.85 KB 0644
dirty_close.test File 1.55 KB 0644
disabled.def File 1.25 KB 0644
disabled_replication-master.opt File 29 B 0644
disabled_replication.test File 2.08 KB 0644
disconnect_on_expired_password_default.test File 1.35 KB 0644
disconnect_on_expired_password_off-master.opt File 37 B 0644
disconnect_on_expired_password_off.test File 1.42 KB 0644
distinct.test File 24.88 KB 0644
drop-no_root.test File 2.38 KB 0644
drop.test File 7.89 KB 0644
drop_debug.test File 779 B 0644
ds_mrr-big.test File 1.99 KB 0644
dynamic_tracing.test File 3.92 KB 0644
empty_table.test File 302 B 0644
enable_cleartext_plugin-master.opt File 35 B 0644
enable_cleartext_plugin.test File 2.48 KB 0644
endspace.test File 4.36 KB 0644
eq_range_idx_stat.test File 2.04 KB 0644
error_simulation.test File 3.29 KB 0644
errors.test File 4.7 KB 0644
events_1.test File 16.1 KB 0644
events_2.test File 15.97 KB 0644
events_bugs-master.opt File 18 B 0644
events_bugs.test File 41.9 KB 0644
events_embedded.test File 79 B 0644
events_grant.test File 5.29 KB 0644
events_logs_tests-master.opt File 41 B 0644
events_logs_tests.test File 3.08 KB 0644
events_microsec.test File 748 B 0644
events_restart-master.opt File 18 B 0644
events_restart.test File 4.45 KB 0644
events_scheduling.test File 4.36 KB 0644
events_stress.test File 4.37 KB 0644
events_time_zone.test File 11.18 KB 0644
events_trans.test File 3.33 KB 0644
events_trans_notembedded.test File 1.7 KB 0644
execution_constants.test File 3.33 KB 0644
explain.test File 11.65 KB 0644
explain_json_all.test File 485 B 0644
explain_json_none.test File 616 B 0644
file_contents.test File 2.9 KB 0644
filesort_debug.test File 2.83 KB 0644
fix_priv_tables.test File 2.21 KB 0644
flush.test File 17.27 KB 0644
flush2-master.opt File 15 B 0644
flush2.test File 360 B 0644
flush_block_commit.test File 2.87 KB 0644
flush_block_commit_notembedded.test File 1.84 KB 0644
flush_read_lock.test File 72.45 KB 0644
flush_read_lock_kill.test File 2.32 KB 0644
flush_table.test File 15.58 KB 0644
foreign_key.test File 2.41 KB 0644
fulltext.test File 22.48 KB 0644
fulltext2.test File 8.12 KB 0644
fulltext3.test File 781 B 0644
fulltext_cache.test File 1.43 KB 0644
fulltext_distinct.test File 1.18 KB 0644
fulltext_left_join.test File 3.82 KB 0644
fulltext_multi.test File 666 B 0644
fulltext_order_by.test File 5.31 KB 0644
fulltext_plugin-master.opt File 19 B 0644
fulltext_plugin.test File 374 B 0644
fulltext_update.test File 907 B 0644
fulltext_var.test File 1.1 KB 0644
func_aes.test File 5.76 KB 0644
func_aes_cfb1.test File 445 B 0644
func_aes_cfb128.test File 455 B 0644
func_aes_cfb8.test File 445 B 0644
func_aes_misc.test File 6.11 KB 0644
func_aes_ofb.test File 440 B 0644
func_analyse.test File 9.37 KB 0644
func_compress.test File 3.3 KB 0644
func_concat.test File 3.67 KB 0644
func_crypt.test File 2.09 KB 0644
func_date_add.test File 3.28 KB 0644
func_default.test File 1 KB 0644
func_des_encrypt.test File 899 B 0644
func_digest.test File 109.12 KB 0644
func_encrypt-master.opt File 59 B 0644
func_encrypt.test File 5.4 KB 0644
func_encrypt_nossl.test File 1.16 KB 0644
func_encrypt_ucs2.test File 459 B 0644
func_equal.test File 1.1 KB 0644
func_gconcat.test File 26.84 KB 0644
func_group.test File 37.03 KB 0644
func_group_innodb.test File 3.57 KB 0644
func_group_innodb_16k.test File 605 B 0644
func_if.test File 5.08 KB 0644
func_in_all.test File 494 B 0644
func_in_icp.test File 567 B 0644
func_in_icp_mrr.test File 540 B 0644
func_in_mrr.test File 565 B 0644
func_in_mrr_cost.test File 575 B 0644
func_in_none.test File 607 B 0644
func_isnull.test File 1009 B 0644
func_like.test File 3.71 KB 0644
func_math.test File 17.27 KB 0644
func_misc-master.opt File 21 B 0644
func_misc.test File 25.73 KB 0644
func_op.test File 964 B 0644
func_regexp.test File 2.89 KB 0644
func_rollback.test File 14.3 KB 0644
func_sapdb.test File 7.58 KB 0644
func_set.test File 5.69 KB 0644
func_str.test File 58.46 KB 0644
func_str_debug.test File 421 B 0644
func_str_no_ps.test File 1.02 KB 0644
func_system.test File 1.47 KB 0644
func_test.test File 9.14 KB 0644
func_time.test File 43.13 KB 0644
func_timestamp.test File 661 B 0644
func_weight_string.test File 3.07 KB 0644
function_defaults.test File 737 B 0644
function_defaults_notembedded.test File 478 B 0644
gcc296.test File 526 B 0644
get_diagnostics.test File 18.25 KB 0644
gis-debug.test File 126 B 0644
gis-precise.test File 8.72 KB 0644
gis-rt-precise.test File 1.39 KB 0644
gis-rtree.test File 43.67 KB 0644
gis.test File 47.91 KB 0644
grant.test File 65.24 KB 0644
grant2.test File 32.51 KB 0644
grant3-master.opt File 19 B 0644
grant3.test File 6.59 KB 0644
grant4.test File 8.05 KB 0644
grant_cache-master.opt File 21 B 0644
grant_cache.test File 590 B 0644
grant_explain_non_select.test File 7.34 KB 0644
grant_lowercase_fs.test File 702 B 0644
greedy_optimizer.test File 30.6 KB 0644
greedy_search.test File 9.5 KB 0644
group_by.test File 64.36 KB 0644
group_min_max.test File 58.59 KB 0644
group_min_max_innodb.test File 13.24 KB 0644
handler_innodb.test File 571 B 0644
handler_myisam.test File 4.25 KB 0644
handler_read_last.test File 523 B 0644
having.test File 20.63 KB 0644
heap.test File 15.43 KB 0644
heap_auto_increment.test File 926 B 0644
heap_btree.test File 8.21 KB 0644
heap_hash.test File 9.69 KB 0644
help.test File 4.83 KB 0644
host_cache_size_functionality.test File 7.62 KB 0644
implicit_char_to_num_conversion.test File 7.63 KB 0644
implicit_commit-master.opt File 32 B 0644
implicit_commit.test File 19.42 KB 0644
import_schema_mismatch.test File 1018 B 0644
index_merge_delete.test File 261 B 0644
index_merge_innodb.test File 1.79 KB 0644
index_merge_insert-and-replace.test File 284 B 0644
index_merge_intersect_dml.test File 113 B 0644
index_merge_myisam.test File 5.38 KB 0644
index_merge_update.test File 261 B 0644
information_schema-big.test File 1.73 KB 0644
information_schema.test File 57.95 KB 0644
information_schema_chmod.test File 834 B 0644
information_schema_db.test File 7.01 KB 0644
information_schema_inno.test File 3.6 KB 0644
information_schema_parameters.test File 12.58 KB 0644
information_schema_part.test File 3.95 KB 0644
information_schema_routines.test File 13.19 KB 0644
init_connect-master.opt File 32 B 0644
init_connect.test File 5.53 KB 0644
init_file-master.opt File 51 B 0644
init_file.test File 944 B 0644
innodb_explain_json_non_select_all.test File 1.02 KB 0644
innodb_explain_json_non_select_none.test File 1.06 KB 0644
innodb_explain_non_select_all.test File 924 B 0644
innodb_explain_non_select_none.test File 960 B 0644
innodb_icp.test File 784 B 0644
innodb_icp_all.test File 679 B 0644
innodb_icp_none.test File 817 B 0644
innodb_ignore_builtin-master.opt File 38 B 0644
innodb_ignore_builtin.test File 441 B 0644
innodb_log_file_size_functionality.test File 5.4 KB 0644
innodb_mrr-master.opt File 35 B 0644
innodb_mrr.test File 825 B 0644
innodb_mrr_all-master.opt File 35 B 0644
innodb_mrr_all.test File 711 B 0644
innodb_mrr_cost-master.opt File 35 B 0644
innodb_mrr_cost.test File 824 B 0644
innodb_mrr_cost_all-master.opt File 35 B 0644
innodb_mrr_cost_all.test File 710 B 0644
innodb_mrr_cost_icp-master.opt File 35 B 0644
innodb_mrr_cost_icp.test File 779 B 0644
innodb_mrr_icp-master.opt File 35 B 0644
innodb_mrr_icp.test File 780 B 0644
innodb_mrr_none-master.opt File 35 B 0644
innodb_mrr_none.test File 831 B 0644
innodb_mysql_lock-master.opt File 31 B 0644
innodb_mysql_lock.test File 8.93 KB 0644
innodb_mysql_lock2.test File 29.1 KB 0644
innodb_mysql_sync.test File 21.04 KB 0644
innodb_pk_extension_off.test File 298 B 0644
innodb_pk_extension_on.test File 296 B 0644
innodb_recovery_with_upper_case_names-master.opt File 25 B 0644
innodb_recovery_with_upper_case_names.test File 1.75 KB 0644
insert.test File 17.1 KB 0644
insert_debug-master.opt File 29 B 0644
insert_debug.test File 2.39 KB 0644
insert_notembedded.test File 6.42 KB 0644
insert_select.test File 13.83 KB 0644
insert_update.test File 9.07 KB 0644
ipv4_as_ipv6-master.opt File 43 B 0644
ipv4_as_ipv6.test File 2.18 KB 0644
ipv6-master.opt File 20 B 0644
ipv6.test File 1.27 KB 0644
join.test File 40.06 KB 0644
join_cache_bka.test File 131 B 0644
join_cache_bka_nixbnl.test File 153 B 0644
join_cache_bkaunique.test File 198 B 0644
join_cache_bnl.test File 225 B 0644
join_cache_nojb.test File 249 B 0644
join_crash.test File 4.92 KB 0644
join_nested.test File 33.73 KB 0644
join_nested_bka.test File 2.29 KB 0644
join_nested_bka_nixbnl.test File 2.32 KB 0644
join_outer.test File 47.39 KB 0644
join_outer_bka.test File 169 B 0644
join_outer_bka_nixbnl.test File 191 B 0644
join_outer_innodb.test File 1.57 KB 0644
key.test File 16.98 KB 0644
key_cache-master.opt File 95 B 0644
key_cache.test File 8.25 KB 0644
key_diff.test File 554 B 0644
key_primary.test File 460 B 0644
keywords.test File 5.47 KB 0644
kill.test File 16.07 KB 0644
kill_debug.test File 1.34 KB 0644
limit.test File 3.54 KB 0644
loaddata.test File 20.75 KB 0644
loaddata_autocom_innodb.test File 98 B 0644
loadxml.test File 3.76 KB 0644
locale.test File 3.22 KB 0644
lock.test File 14.81 KB 0644
lock_multi.test File 27.89 KB 0644
lock_multi_bug38499.test File 4.46 KB 0644
lock_multi_bug38691.test File 2.77 KB 0644
lock_sync-master.opt File 32 B 0644
lock_sync.test File 40.24 KB 0644
lock_tables_lost_commit-master.opt File 24 B 0644
lock_tables_lost_commit.test File 845 B 0644
log_empty_name.opt File 43 B 0644
log_empty_name.test File 290 B 0644
log_errchk.test File 2.1 KB 0644
log_state-master.opt File 59 B 0644
log_state.test File 9.97 KB 0644
log_state_bug33693-master.opt File 60 B 0644
log_state_bug33693.test File 568 B 0644
log_tables-big-master.opt File 17 B 0644
log_tables-big.test File 1.19 KB 0644
log_tables-master.opt File 41 B 0644
log_tables.test File 30.45 KB 0644
log_tables_debug.test File 2.65 KB 0644
log_tables_upgrade.test File 1002 B 0644
long_tmpdir-master.opt File 141 B 0644
long_tmpdir-master.sh File 190 B 0755
long_tmpdir.test File 215 B 0644
lowercase_fs_off.test File 2.42 KB 0644
lowercase_fs_on.test File 1.33 KB 0644
lowercase_mixed_tmpdir-master.opt File 68 B 0644
lowercase_mixed_tmpdir-master.sh File 179 B 0755
lowercase_mixed_tmpdir.test File 305 B 0644
lowercase_mixed_tmpdir_innodb-master.opt File 68 B 0644
lowercase_mixed_tmpdir_innodb-master.sh File 180 B 0755
lowercase_mixed_tmpdir_innodb.test File 299 B 0644
lowercase_table-master.opt File 25 B 0644
lowercase_table.test File 2.74 KB 0644
lowercase_table2.test File 8.28 KB 0644
lowercase_table4-master.opt File 27 B 0644
lowercase_table4.test File 3.14 KB 0644
lowercase_table_grant-master.opt File 25 B 0644
lowercase_table_grant.test File 948 B 0644
lowercase_table_qcache-master.opt File 46 B 0644
lowercase_table_qcache.test File 697 B 0644
lowercase_utf8-master.opt File 58 B 0644
lowercase_utf8.test File 206 B 0644
lowercase_view-master.opt File 27 B 0644
lowercase_view.test File 6.19 KB 0644
main.lowercase_table_qcache-master.opt File 21 B 0644
mdl_sync-master.opt File 32 B 0644
mdl_sync.test File 144.7 KB 0644
merge-big.test File 3.04 KB 0644
merge.test File 84.28 KB 0644
merge_innodb.test File 1.06 KB 0644
merge_mmap-master.opt File 18 B 0644
merge_mmap.test File 4.06 KB 0644
metadata.test File 5.96 KB 0644
mix2_myisam-master.opt File 33 B 0644
mix2_myisam.test File 864 B 0644
mix2_myisam_ucs2.test File 847 B 0644
multi_plugin_load-master.opt File 92 B 0644
multi_plugin_load.test File 412 B 0644
multi_plugin_load_add-master.opt File 68 B 0644
multi_plugin_load_add.test File 495 B 0644
multi_plugin_load_add2-master.opt File 111 B 0644
multi_plugin_load_add2.test File 495 B 0644
multi_statement-master.opt File 80 B 0644
multi_statement.test File 761 B 0644
multi_update-master.opt File 22 B 0644
multi_update.test File 24.38 KB 0644
multi_update2-master.opt File 22 B 0644
multi_update2.test File 1.89 KB 0644
multi_update_innodb.test File 2.22 KB 0644
multi_update_tiny_hash-master.opt File 28 B 0644
multi_update_tiny_hash.test File 1.6 KB 0644
myisam-blob-master.opt File 80 B 0644
myisam-blob.test File 1.1 KB 0644
myisam-system.test File 593 B 0644
myisam.test File 67.22 KB 0644
myisam_crash_before_flush_keys-master.opt File 36 B 0644
myisam_crash_before_flush_keys.test File 1.49 KB 0644
myisam_debug.test File 1.37 KB 0644
myisam_explain_json_non_select_all.test File 825 B 0644
myisam_explain_json_non_select_none.test File 938 B 0644
myisam_explain_non_select_all.test File 696 B 0644
myisam_explain_non_select_none.test File 809 B 0644
myisam_icp.test File 612 B 0644
myisam_icp_all.test File 507 B 0644
myisam_icp_none.test File 644 B 0644
myisam_mrr.test File 789 B 0644
myisam_mrr_all.test File 675 B 0644
myisam_mrr_cost.test File 799 B 0644
myisam_mrr_cost_all.test File 674 B 0644
myisam_mrr_cost_icp.test File 753 B 0644
myisam_mrr_icp.test File 743 B 0644
myisam_mrr_none.test File 793 B 0644
myisam_recover-master.opt File 23 B 0644
myisam_recover.test File 5.61 KB 0644
myisam_row_rpl-master.opt File 54 B 0644
myisam_row_rpl-slave.opt File 54 B 0644
myisam_row_rpl.test File 1.82 KB 0644
myisampack.test File 12.31 KB 0644
mysql-bug41486.test File 1.54 KB 0644
mysql-bug45236.test File 1.41 KB 0644
mysql.test File 21.89 KB 0644
mysql_binary_mode.test File 5.52 KB 0644
mysql_client_test-master.opt File 150 B 0644
mysql_client_test.test File 1.13 KB 0644
mysql_client_test_embedded.cnf File 156 B 0644
mysql_client_test_embedded.test File 677 B 0644
mysql_client_test_qcache-master.opt File 21 B 0644
mysql_client_test_qcache.test File 858 B 0644
mysql_comments.sql File 4.58 KB 0644
mysql_comments.test File 1.44 KB 0644
mysql_config_editor.test File 7.44 KB 0644
mysql_cp932.test File 1.04 KB 0644
mysql_delimiter.sql File 1.48 KB 0644
mysql_delimiter_19799.sql File 13 B 0644
mysql_delimiter_source.sql File 122 B 0644
mysql_embedded-master.opt File 98 B 0644
mysql_embedded.test File 481 B 0644
mysql_embedded_client_test.test File 1.34 KB 0644
mysql_locale_posix.test File 6.97 KB 0644
mysql_not_windows.test File 399 B 0644
mysql_plugin-master.opt File 32 B 0644
mysql_plugin.test File 11.9 KB 0644
mysql_protocols.test File 715 B 0644
mysql_upgrade.test File 7.08 KB 0644
mysql_upgrade_ssl.test File 279 B 0644
mysqladmin.test File 2.5 KB 0644
mysqladmin_shutdown.test File 868 B 0644
mysqlbinlog-master.opt File 39 B 0644
mysqlbinlog.test File 19.19 KB 0644
mysqlbinlog_debug.test File 963 B 0644
mysqlbinlog_mixed_or_statment.test File 1.13 KB 0644
mysqlbinlog_raw_mode.test File 1.98 KB 0644
mysqlbinlog_raw_mode_win.test File 146 B 0644
mysqlbinlog_row_big.test File 4 KB 0644
mysqlcheck.test File 9.73 KB 0644
mysqld--defaults-file.test File 1.03 KB 0644
mysqld--help-notwin.test File 160 B 0644
mysqld--help-win.test File 156 B 0644
mysqldump-compat.opt File 31 B 0644
mysqldump-compat.test File 446 B 0644
mysqldump-max-master.opt File 32 B 0644
mysqldump-max.test File 40 KB 0644
mysqldump-no-binlog-master.opt File 15 B 0644
mysqldump-no-binlog.test File 194 B 0644
mysqldump.test File 86.47 KB 0644
mysqldump_restore.test File 3.85 KB 0644
mysqlhotcopy_archive.test File 180 B 0644
mysqlhotcopy_myisam.test File 145 B 0644
mysqlimport.test File 689 B 0644
mysqlshow.test File 1.63 KB 0644
mysqlslap.test File 5.45 KB 0644
mysqltest.test File 75.5 KB 0644
named_pipe-master.opt File 26 B 0644
named_pipe.test File 597 B 0644
negation_elimination.test File 3.93 KB 0644
no-threads-master.opt File 29 B 0644
no-threads.test File 373 B 0644
no_binlog.test File 165 B 0644
not_embedded_server-master.opt File 16 B 0644
not_embedded_server.test File 5.61 KB 0644
not_partition.test File 3 KB 0644
null.test File 8.55 KB 0644
null_key_all.test File 477 B 0644
null_key_icp.test File 569 B 0644
null_key_none.test File 609 B 0644
odbc.test File 923 B 0644
olap.test File 13.63 KB 0644
openssl_1.test File 9.39 KB 0644
optimizer_bug12837084.test File 14.16 KB 0644
optimizer_debug_sync.test File 2.23 KB 0644
optimizer_switch.test File 10.28 KB 0644
order_by_all.test File 497 B 0644
order_by_icp_mrr.test File 542 B 0644
order_by_none.test File 609 B 0644
order_by_sortkey.test File 2.16 KB 0644
order_fill_sortbuf-master.opt File 20 B 0644
order_fill_sortbuf.test File 578 B 0644
outfile.test File 4.03 KB 0644
outfile_loaddata.test File 10.18 KB 0644
overflow.test File 577 B 0644
packet.test File 3.49 KB 0644
parser.test File 21.89 KB 0644
parser_bug21114_innodb.test File 11.75 KB 0644
parser_not_embedded.test File 2.53 KB 0644
parser_precedence.test File 12.39 KB 0644
parser_stack.test File 12.07 KB 0644
partition.test File 66.34 KB 0644
partition_archive.test File 4.19 KB 0644
partition_binlog.test File 1.2 KB 0644
partition_binlog_stmt.test File 760 B 0644
partition_blackhole.test File 634 B 0644
partition_bug18198.test File 7.88 KB 0644
partition_cache-master.opt File 21 B 0644
partition_cache.test File 1.41 KB 0644
partition_charset.test File 675 B 0644
partition_column.test File 16.15 KB 0644
partition_column_prune.test File 2.24 KB 0644
partition_csv.test File 2.45 KB 0644
partition_datatype.test File 18.97 KB 0644
partition_debug_sync.test File 3.99 KB 0644
partition_disabled-master.opt File 23 B 0644
partition_disabled.test File 3.02 KB 0644
partition_error.test File 61.47 KB 0644
partition_exchange.test File 15.55 KB 0644
partition_explicit_prune.test File 30.93 KB 0644
partition_federated.test File 531 B 0644
partition_grant.test File 2.27 KB 0644
partition_hash.test File 5.57 KB 0644
partition_index_innodb.test File 5.81 KB 0644
partition_index_myisam.test File 3.88 KB 0644
partition_innodb.test File 29.42 KB 0644
partition_innodb_plugin.test File 5 KB 0644
partition_innodb_semi_consistent-master.opt File 61 B 0644
partition_innodb_semi_consistent.test File 4.09 KB 0644
partition_innodb_stmt.test File 1.17 KB 0644
partition_innodb_tablespace.test File 11.93 KB 0644
partition_key_cache.test File 10.82 KB 0644
partition_list.test File 8.04 KB 0644
partition_locking.test File 71.9 KB 0644
partition_locking_4.test File 1.53 KB 0644
partition_mgm.test File 3.67 KB 0644
partition_mgm_err.test File 6.18 KB 0644
partition_mgm_err2.test File 861 B 0644
partition_myisam.test File 8.14 KB 0644
partition_not_blackhole-master.opt File 23 B 0644
partition_not_blackhole.test File 875 B 0644
partition_not_windows-master.opt File 19 B 0644
partition_not_windows.test File 7.59 KB 0644
partition_open_files_limit-master.opt File 62 B 0644
partition_open_files_limit.test File 1.61 KB 0644
partition_order.test File 17.9 KB 0644
partition_pruning.test File 57.82 KB 0644
partition_range.test File 31.14 KB 0644
partition_rename_longfilename.test File 2.02 KB 0644
partition_symlink.test File 7.35 KB 0644
partition_sync.test File 2.15 KB 0644
partition_truncate.test File 806 B 0644
partition_utf8.test File 1.25 KB 0644
partition_windows.test File 1.24 KB 0644
perror-win.test File 915 B 0644
perror.test File 777 B 0644
plugin-master.opt File 20 B 0644
plugin.test File 7.53 KB 0644
plugin_auth-master.opt File 35 B 0644
plugin_auth.test File 19.86 KB 0644
plugin_auth_qa-master.opt File 35 B 0644
plugin_auth_qa.test File 14.16 KB 0644
plugin_auth_qa_1-master.opt File 35 B 0644
plugin_auth_qa_1.test File 15.1 KB 0644
plugin_auth_qa_2-master.opt File 55 B 0644
plugin_auth_qa_2.test File 8.31 KB 0644
plugin_auth_qa_3-master.opt File 49 B 0644
plugin_auth_qa_3.test File 1.51 KB 0644
plugin_auth_sha256-master.opt File 170 B 0644
plugin_auth_sha256.test File 4.76 KB 0644
plugin_auth_sha256_2-master.opt File 217 B 0644
plugin_auth_sha256_2.test File 2.06 KB 0644
plugin_auth_sha256_server_default-master.opt File 224 B 0644
plugin_auth_sha256_server_default.test File 3.06 KB 0644
plugin_auth_sha256_server_default_tls-master.opt File 48 B 0644
plugin_auth_sha256_server_default_tls.test File 3.42 KB 0644
plugin_auth_sha256_tls.test File 2.29 KB 0644
plugin_load-master.opt File 76 B 0644
plugin_load.test File 125 B 0644
plugin_load_option-master.opt File 85 B 0644
plugin_load_option.test File 265 B 0644
plugin_not_embedded-master.opt File 20 B 0644
plugin_not_embedded.test File 896 B 0644
preload.test File 2.43 KB 0644
profiling.test File 8.83 KB 0644
ps-master.opt File 73 B 0644
ps.test File 92.9 KB 0644
ps_10nestset.test File 2.75 KB 0644
ps_11bugs.test File 7.05 KB 0644
ps_1general.test File 28.22 KB 0644
ps_2myisam.test File 1.15 KB 0644
ps_3innodb-master.opt File 32 B 0644
ps_3innodb.test File 760 B 0644
ps_4heap.test File 1.53 KB 0644
ps_5merge.test File 2.71 KB 0644
ps_ddl.test File 52.87 KB 0644
ps_ddl1.test File 11.04 KB 0644
ps_grant.test File 3.9 KB 0644
ps_not_windows.test File 755 B 0644
query_cache-master.opt File 21 B 0644
query_cache.test File 43.88 KB 0644
query_cache_28249-master.opt File 21 B 0644
query_cache_28249.test File 4.2 KB 0644
query_cache_debug-master.opt File 21 B 0644
query_cache_debug.test File 10.7 KB 0644
query_cache_disabled-master.opt File 21 B 0644
query_cache_disabled.test File 496 B 0644
query_cache_merge-master.opt File 21 B 0644
query_cache_merge.test File 4.47 KB 0644
query_cache_notembedded-master.opt File 21 B 0644
query_cache_notembedded.test File 6.97 KB 0644
query_cache_ps_no_prot-master.opt File 21 B 0644
query_cache_ps_no_prot.test File 906 B 0644
query_cache_ps_ps_prot-master.opt File 21 B 0644
query_cache_ps_ps_prot.test File 840 B 0644
query_cache_size_functionality.test File 10.85 KB 0644
query_cache_type_functionality.test File 10.93 KB 0644
query_cache_with_views-master.opt File 21 B 0644
query_cache_with_views.test File 3.98 KB 0644
range_all.test File 490 B 0644
range_icp.test File 563 B 0644
range_icp_mrr.test File 536 B 0644
range_mrr.test File 561 B 0644
range_mrr_cost.test File 571 B 0644
range_none.test File 603 B 0644
read_many_rows_innodb.test File 417 B 0644
read_only.test File 8.16 KB 0644
read_only_innodb.test File 5.38 KB 0644
rename.test File 2.26 KB 0644
renamedb.test File 1.25 KB 0644
repair.test File 5.46 KB 0644
replace.test File 1.21 KB 0644
rewrite_general_log.test File 5.08 KB 0644
rewrite_slow_log.test File 3.23 KB 0644
rollback.test File 490 B 0644
round.test File 4.67 KB 0644
row.test File 9.01 KB 0644
rowid_order_innodb.test File 382 B 0644
rpl_mysqldump_slave.test File 1.06 KB 0644
schema.test File 4.68 KB 0644
secure_file_priv_win-master.opt File 34 B 0644
secure_file_priv_win.test File 2.77 KB 0644
select_all.test File 591 B 0644
select_all_bka.test File 268 B 0644
select_all_bka_nixbnl.test File 290 B 0644
select_found.test File 5.53 KB 0644
select_icp_mrr.test File 637 B 0644
select_icp_mrr_bka.test File 276 B 0644
select_icp_mrr_bka_nixbnl.test File 298 B 0644
select_none.test File 704 B 0644
select_none_bka.test File 270 B 0644
select_none_bka_nixbnl.test File 292 B 0644
select_safe.test File 2.31 KB 0644
server_uuid.test File 2.53 KB 0644
server_uuid_embedded.test File 1.13 KB 0644
shm-master.opt File 173 B 0644
shm.test File 1.46 KB 0644
show_check-master.opt File 93 B 0644
show_check.test File 32.42 KB 0644
show_processlist.test File 2.51 KB 0644
show_processlist_state.test File 208 B 0644
show_profile.test File 495 B 0644
signal.test File 55.55 KB 0644
signal_code.test File 854 B 0644
signal_demo1.test File 6.9 KB 0644
signal_demo2.test File 3.34 KB 0644
signal_demo3-master.opt File 33 B 0644
signal_demo3.test File 2.67 KB 0644
signal_sqlmode.test File 1.85 KB 0644
single_delete_update.test File 13.33 KB 0644
skip_grants-master.opt File 20 B 0644
skip_grants.test File 2.74 KB 0644
skip_log_bin-master.opt File 21 B 0644
skip_log_bin.test File 645 B 0644
skip_name_resolve-master.opt File 20 B 0644
skip_name_resolve.test File 1.56 KB 0644
sort_buffer_size_functionality.test File 9.2 KB 0644
sp-big.test File 2.15 KB 0644
sp-bugs.test File 5.3 KB 0644
sp-code.test File 20.71 KB 0644
sp-destruct.test File 8.06 KB 0644
sp-dynamic.test File 9.19 KB 0644
sp-error.test File 85.68 KB 0644
sp-fib-master.opt File 33 B 0644
sp-fib.test File 1.33 KB 0644
sp-lock-master.opt File 33 B 0644
sp-lock.test File 31.39 KB 0644
sp-master.opt File 54 B 0644
sp-no-code.test File 216 B 0644
sp-prelocking-master.opt File 33 B 0644
sp-prelocking.test File 8.43 KB 0644
sp-security.test File 25.06 KB 0644
sp-threads.test File 4 KB 0644
sp-ucs2.test File 3.38 KB 0644
sp-vars.test File 28.21 KB 0644
sp.test File 191.47 KB 0644
sp_debug.test File 1.03 KB 0644
sp_gis.test File 754 B 0644
sp_notembedded-master.opt File 21 B 0644
sp_notembedded.test File 13.09 KB 0644
sp_stress_case.test File 2.07 KB 0644
sp_sync.test File 4.88 KB 0644
sp_trans.test File 17.08 KB 0644
sp_trans_log.test File 1.35 KB 0644
sp_validation.test File 40.13 KB 0644
sql_mode.test File 12.7 KB 0644
ssl-big.test File 1.68 KB 0644
ssl-sha512-master.opt File 164 B 0644
ssl-sha512.test File 371 B 0644
ssl.test File 1.57 KB 0644
ssl_8k_key-master.opt File 118 B 0644
ssl_8k_key.test File 546 B 0644
ssl_and_innodb.test File 261 B 0644
ssl_ca-master.opt File 160 B 0644
ssl_ca.test File 2.07 KB 0644
ssl_cipher-master.opt File 24 B 0644
ssl_cipher.test File 588 B 0644
ssl_compress.test File 1.04 KB 0644
ssl_connect.test File 339 B 0644
ssl_crl-master.opt File 218 B 0644
ssl_crl.test File 2.47 KB 0644
ssl_crl_clients-master.opt File 234 B 0644
ssl_crl_clients.test File 1.85 KB 0644
ssl_crl_clients_valid-master.opt File 218 B 0644
ssl_crl_clients_valid.test File 1.24 KB 0644
ssl_crl_crlpath-master.opt File 206 B 0644
ssl_crl_crlpath.test File 1.4 KB 0644
ssl_mode.test File 1.78 KB 0644
ssl_mode_no_ssl-master.opt File 11 B 0644
ssl_mode_no_ssl.test File 1.29 KB 0644
ssl_verify_identity-master.opt File 181 B 0644
ssl_verify_identity.test File 4.04 KB 0644
status-master.opt File 24 B 0644
status.test File 12.91 KB 0644
status2.test File 1.54 KB 0644
status_bug17954.test File 1.7 KB 0644
status_debug.test File 1.42 KB 0644
strict-master.opt File 32 B 0644
strict.test File 43.22 KB 0644
strict_autoinc_1myisam.test File 117 B 0644
strict_autoinc_2innodb.test File 152 B 0644
strict_autoinc_3heap.test File 117 B 0644
subquery_all.test File 496 B 0644
subquery_all_bka.test File 173 B 0644
subquery_all_bka_nixbnl.test File 195 B 0644
subquery_bugs.test File 1.7 KB 0644
subquery_mat.test File 576 B 0644
subquery_mat_all.test File 484 B 0644
subquery_mat_none.test File 617 B 0644
subquery_nomat_nosj.test File 564 B 0644
subquery_nomat_nosj_bka.test File 187 B 0644
subquery_nomat_nosj_bka_nixbnl.test File 209 B 0644
subquery_none.test File 609 B 0644
subquery_none_bka.test File 175 B 0644
subquery_none_bka_nixbnl.test File 197 B 0644
subquery_sj_all-master.opt File 22 B 0644
subquery_sj_all.test File 502 B 0644
subquery_sj_all_bka-master.opt File 22 B 0644
subquery_sj_all_bka.test File 179 B 0644
subquery_sj_all_bka_nixbnl-master.opt File 22 B 0644
subquery_sj_all_bka_nixbnl.test File 201 B 0644
subquery_sj_all_bkaunique-master.opt File 22 B 0644
subquery_sj_all_bkaunique.test File 252 B 0644
subquery_sj_dupsweed-master.opt File 22 B 0644
subquery_sj_dupsweed.test File 809 B 0644
subquery_sj_dupsweed_bka-master.opt File 22 B 0644
subquery_sj_dupsweed_bka.test File 189 B 0644
subquery_sj_dupsweed_bka_nixbnl-master.opt File 22 B 0644
subquery_sj_dupsweed_bka_nixbnl.test File 211 B 0644
subquery_sj_dupsweed_bkaunique-master.opt File 22 B 0644
subquery_sj_dupsweed_bkaunique.test File 262 B 0644
subquery_sj_firstmatch-master.opt File 22 B 0644
subquery_sj_firstmatch.test File 2.36 KB 0644
subquery_sj_firstmatch_bka-master.opt File 22 B 0644
subquery_sj_firstmatch_bka.test File 193 B 0644
subquery_sj_firstmatch_bka_nixbnl.test File 215 B 0644
subquery_sj_firstmatch_bkaunique.test File 266 B 0644
subquery_sj_innodb_all.test File 550 B 0644
subquery_sj_innodb_all_bka.test File 193 B 0644
subquery_sj_innodb_all_bka_nixbnl.test File 215 B 0644
subquery_sj_innodb_all_bkaunique.test File 266 B 0644
subquery_sj_innodb_none.test File 663 B 0644
subquery_sj_innodb_none_bka.test File 195 B 0644
subquery_sj_innodb_none_bka_nixbnl.test File 217 B 0644
subquery_sj_innodb_none_bkaunique.test File 268 B 0644
subquery_sj_loosescan.test File 755 B 0644
subquery_sj_loosescan_bka.test File 191 B 0644
subquery_sj_loosescan_bka_nixbnl.test File 213 B 0644
subquery_sj_loosescan_bkaunique.test File 264 B 0644
subquery_sj_mat.test File 761 B 0644
subquery_sj_mat_bka.test File 179 B 0644
subquery_sj_mat_bka_nixbnl.test File 201 B 0644
subquery_sj_mat_bkaunique.test File 252 B 0644
subquery_sj_mat_nosj.test File 595 B 0644
subquery_sj_none.test File 615 B 0644
subquery_sj_none_bka.test File 181 B 0644
subquery_sj_none_bka_nixbnl.test File 203 B 0644
subquery_sj_none_bkaunique.test File 254 B 0644
subselect_debug.test File 508 B 0644
subselect_gis.test File 455 B 0644
subselect_innodb.test File 24.35 KB 0644
subselect_notembedded-master.opt File 33 B 0644
subselect_notembedded.test File 1.73 KB 0644
sum_distinct-big.test File 2 KB 0644
sum_distinct.test File 3.43 KB 0644
symlink.test File 9.68 KB 0644
symlink_windows.test File 2.21 KB 0644
synchronization.test File 1 KB 0644
sysdate_is_now-master.opt File 17 B 0644
sysdate_is_now.test File 297 B 0644
system_mysql_db.test File 452 B 0644
system_mysql_db_fix30020-master.opt File 30 B 0644
system_mysql_db_fix40123-master.opt File 30 B 0644
system_mysql_db_fix40123.test File 9.61 KB 0644
system_mysql_db_fix50030-master.opt File 30 B 0644
system_mysql_db_fix50030.test File 14.11 KB 0644
system_mysql_db_fix50117-master.opt File 30 B 0644
system_mysql_db_fix50117.test File 14.87 KB 0644
system_mysql_db_refs.test File 3.29 KB 0644
table_definition_cache_functionality.test File 8.56 KB 0644
table_open_cache_functionality.test File 12.95 KB 0644
tablelock.test File 1.37 KB 0644
tablespace.test File 5.17 KB 0644
temp_pool-master.opt File 31 B 0644
temp_pool.test File 1.05 KB 0644
temp_table-master.opt File 32 B 0644
temp_table.test File 7.45 KB 0644
temporal_literal.test File 6.05 KB 0644
timezone-master.opt File 15 B 0644
timezone.test File 1.83 KB 0644
timezone2.test File 9.73 KB 0644
timezone3-master.opt File 49 B 0644
timezone3.test File 2.54 KB 0644
timezone4-master.opt File 18 B 0644
timezone4.test File 310 B 0644
timezone_grant.test File 4.51 KB 0644
trans_read_only-master.opt File 29 B 0644
trans_read_only.test File 1.25 KB 0644
trigger-compat.test File 8.38 KB 0644
trigger-trans.test File 7 KB 0644
trigger.test File 73.28 KB 0644
trigger_notembedded.test File 24.73 KB 0644
truncate.test File 3.36 KB 0644
truncate_coverage.test File 5.58 KB 0644
type_binary.test File 3.19 KB 0644
type_bit.test File 12.96 KB 0644
type_bit_innodb.test File 4.53 KB 0644
type_blob.test File 22.43 KB 0644
type_date.test File 13.89 KB 0644
type_datetime.test File 21.45 KB 0644
type_decimal.test File 29.53 KB 0644
type_enum.test File 88.85 KB 0644
type_float.test File 9.26 KB 0644
type_nchar.test File 650 B 0644
type_newdecimal-big.test File 977 B 0644
type_newdecimal.test File 40.46 KB 0644
type_ranges.test File 8.93 KB 0644
type_set.test File 3.27 KB 0644
type_temporal_fractional.test File 287.94 KB 0644
type_temporal_upgrade.test File 3.51 KB 0644
type_time.test File 11.61 KB 0644
type_timestamp-master.opt File 36 B 0644
type_timestamp.test File 18.32 KB 0644
type_timestamp_explicit-master.opt File 34 B 0644
type_timestamp_explicit.test File 1.97 KB 0644
type_uint.test File 294 B 0644
type_varchar.test File 6.63 KB 0644
type_year.test File 4.64 KB 0644
udf-master.opt File 42 B 0644
udf.test File 15.87 KB 0644
udf_services-master.opt File 21 B 0644
udf_services.test File 765 B 0644
udf_skip_grants-master.opt File 41 B 0644
udf_skip_grants.test File 1.25 KB 0644
union-master.opt File 49 B 0644
union.test File 41.49 KB 0644
unsafe_binlog_innodb-master.opt File 67 B 0644
unsafe_binlog_innodb.test File 432 B 0644
update.test File 15.61 KB 0644
upgrade.test File 5.09 KB 0644
user_limits.test File 5.4 KB 0644
user_var-binlog.test File 924 B 0644
user_var.test File 12.64 KB 0644
validate_password_plugin-master.opt File 23 B 0644
validate_password_plugin.test File 11.44 KB 0644
varbinary.test File 2.85 KB 0644
variables-big.test File 1.93 KB 0644
variables-master.opt File 21 B 0644
variables-notembedded-master.opt File 47 B 0644
variables-notembedded.test File 10.74 KB 0644
variables-win.test File 393 B 0644
variables.test File 48.46 KB 0644
variables_community.test File 241 B 0644
variables_debug.test File 2.75 KB 0644
view.test File 114.56 KB 0644
view_alias.test File 4.03 KB 0644
view_grant.test File 63.28 KB 0644
wait_timeout.test File 5.31 KB 0644
warnings-master.opt File 34 B 0644
warnings.test File 5.53 KB 0644
warnings_engine_disabled.test File 762 B 0644
windows.test File 2.21 KB 0644
wl4435_generated.inc File 10.43 KB 0644
wl6219-csv.test File 109 B 0644
wl6219-innodb.test File 112 B 0644
wl6219-memory.test File 112 B 0644
wl6219-merge.test File 111 B 0644
wl6219-myisam.test File 112 B 0644
wl6219-upgrade.test File 3.92 KB 0644
wl6301_1_not_windows-master.opt File 20 B 0644
wl6301_1_not_windows.test File 455 B 0644
wl6301_2_not_windows-master.opt File 43 B 0644
wl6301_2_not_windows.test File 493 B 0644
wl6301_3-master.opt File 52 B 0644
wl6301_3.test File 903 B 0644
wl6443_deprecation-master.opt File 23 B 0644
wl6443_deprecation.test File 3.85 KB 0644
xa.test File 7.87 KB 0644
xml.test File 24.9 KB 0644