| List: | Commits | « Previous MessageNext Message » | |
| From: | John H. Embretsen | Date: | September 4 2008 8:38pm |
| Subject: | bzr commit into mysql-6.0-falcon branch (john.embretsen:2812) WL#4048 | ||
| View as plain text | |||
#At file:///export/home/tmp/je159969/mysql/bzr-repos/mysql-6.0-falcon-index-test/
2812 John H. Embretsen 2008-09-04
Tests for:
WL#4048 - Falcon: On-line add attribute, Falcon handler part
New regression tests for Falcon's ADD INDEX functionality,
especially ALTER ONLINE TABLE t ADD INDEX ... and
CREATE ONLINE INDEX ...
Also testing DROP INDEX functionality and to some degree
offline ALTERs.
added:
mysql-test/suite/falcon/r/falcon_index_datatypes.result
mysql-test/suite/falcon/r/falcon_online_index.result
mysql-test/suite/falcon/t/falcon_index_datatypes.test
mysql-test/suite/falcon/t/falcon_online_index.test
per-file messages:
mysql-test/suite/falcon/r/falcon_index_datatypes.result
Result file for new test of indexes for most supported datatypes.
mysql-test/suite/falcon/r/falcon_online_index.result
Result file for new test of ONLINE ADD/DROP INDEX.
mysql-test/suite/falcon/t/falcon_index_datatypes.test
New test for indexes with most supported datatypes.
This test is not specifying ONLINE or OFFLINE, which means that the
default will be used. The default may vary depending on the type
of statement used.
Tests executing INSERTs, UPDATEs and SELECTs to a table after adding
an index for a given datatype.
mysql-test/suite/falcon/t/falcon_online_index.test
New tests for adding and dropping indexes online with Falcon
(Worklog 4048 - Falcon: On-line add attribute, Falcon handler part).
In the MySQL context, "online" means that the entire table and all of
its indexes are _not_ recreated and copied for an alteration, as opposed
to the offline alternative.
Based on spec given in the Worklog and details given by its implementor and
the MySQL manual.
=== added file 'mysql-test/suite/falcon/r/falcon_index_datatypes.result'
--- a/mysql-test/suite/falcon/r/falcon_index_datatypes.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_index_datatypes.result 2008-09-04 18:38:48 +0000
@@ -0,0 +1,939 @@
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+CREATE TABLE t1 (
+a_int INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+a_tinyint TINYINT,
+a_bigint BIGINT,
+a_float FLOAT,
+a_double DOUBLE,
+a_decimal DECIMAL(10,2),
+a_date DATE,
+a_time TIME,
+a_datetime DATETIME,
+a_timestamp TIMESTAMP NOT NULL DEFAULT 0,
+a_year YEAR,
+a_char CHAR(10),
+a_varchar VARCHAR(255),
+a_binary BINARY(8),
+a_varbinary VARBINARY(255),
+a_enum ENUM('enumValueOne', 'enumValueTwo', 'enumValueThree')
+);
+SHOW CREATE TABLE t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `a_int` int(11) NOT NULL AUTO_INCREMENT,
+ `a_tinyint` tinyint(4) DEFAULT NULL,
+ `a_bigint` bigint(20) DEFAULT NULL,
+ `a_float` float DEFAULT NULL,
+ `a_double` double DEFAULT NULL,
+ `a_decimal` decimal(10,2) DEFAULT NULL,
+ `a_date` date DEFAULT NULL,
+ `a_time` time DEFAULT NULL,
+ `a_datetime` datetime DEFAULT NULL,
+ `a_timestamp` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `a_year` year(4) DEFAULT NULL,
+ `a_char` char(10) DEFAULT NULL,
+ `a_varchar` varchar(255) DEFAULT NULL,
+ `a_binary` binary(8) DEFAULT NULL,
+ `a_varbinary` varbinary(255) DEFAULT NULL,
+ `a_enum` enum('enumValueOne','enumValueTwo','enumValueThree') DEFAULT NULL,
+ PRIMARY KEY (`a_int`)
+) ENGINE=Falcon DEFAULT CHARSET=latin1
+CREATE TABLE t2 (
+a_int INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+a_bit BIT(8));
+SHOW CREATE TABLE t2;
+Table Create Table
+t2 CREATE TABLE `t2` (
+ `a_int` int(11) NOT NULL AUTO_INCREMENT,
+ `a_bit` bit(8) DEFAULT NULL,
+ PRIMARY KEY (`a_int`)
+) ENGINE=Falcon DEFAULT CHARSET=latin1
+INSERT INTO t1 (
+a_tinyint, a_bigint,
+a_float, a_double, a_decimal, a_date,
+a_time, a_datetime, a_timestamp, a_year,
+a_char, a_varchar, a_binary, a_varbinary,
+a_enum)
+VALUES
+(
+127, 9223372036854775807,
+999.99, 999.123456789, 111.99, '2008-07-09',
+'11:30:00', '2008-07-09 11:30:00', '2008-07-09 11:30:00', '2008',
+'aTestChar', 'aTestVarChar', 'aTestBin', 'aTestVarBinary',
+'enumValueOne'
+ ),
+(
+126, 9223372036854775806,
+998.88, 999.234567891, 112.00, '2008-07-10',
+'12:30:10', '2008-07-10 12:30:10', '2008-07-10 12:30:10', '2009',
+'bTestChar', 'bTestVarChar', 'bTestBin', 'bTestVarBinary',
+'enumValueTwo'
+ ),
+(
+125, 9223372036854775805,
+997.77, 999.345678912, 112.01, '2008-07-11',
+'13:30:20', '2008-07-11 13:30:20', '2008-07-11 13:30:20', '2010',
+'cTestChar', 'cTestVarChar', 'cTestBin', 'cTestVarBinary',
+'enumValueThree'
+ ),
+(
+124, 9223372036854775804,
+996.66, 999.456789123, 112.02, '2008-07-12',
+'14:30:30', '2008-07-12 14:30:30', '2008-07-12 14:30:30', '2011',
+'dTestChar', 'dTestVarChar', 'dTestBin', 'dTestVarBinary',
+'enumValueOne'
+ ),
+(
+123, 9223372036854775803,
+995.55, 999.567891234, 112.03, '2008-07-13',
+'15:30:40', '2008-07-13 15:30:40', '2008-07-13 15:30:40', '2012',
+'eTestChar', 'eTestVarChar', 'eTestBin', 'eTestVarBinary',
+'enumValueTwo'
+ );
+INSERT INTO t2 (a_bit) VALUES (b'0'), (b'1'), (b'10'), (b'11'), (b'100');
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 9223372036854775804 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+SELECT a_int, BIN(a_bit+0) FROM t2;
+a_int BIN(a_bit+0)
+1 0
+2 1
+3 10
+4 11
+5 100
+#-------- Test: BIT --------#
+ALTER TABLE t2 ADD INDEX index_bit (a_bit);
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a_int NULL 2 NULL NULL BTREE
+t2 1 index_bit 1 a_bit NULL 2 NULL NULL YES BTREE
+INSERT INTO t2 SET a_bit = b'11111';
+UPDATE t2 SET a_bit = b'101010' where a_int > b'101';
+SELECT a_int, BIN(a_bit+0) FROM t2;
+a_int BIN(a_bit+0)
+1 0
+2 1
+3 10
+4 11
+5 100
+6 101010
+SELECT a_int, BIN(a_bit+0) FROM t2 WHERE a_bit > b'1' LIMIT 1;
+a_int BIN(a_bit+0)
+3 10
+ALTER TABLE t2 DROP INDEX index_bit;
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+SELECT a_int, BIN(a_bit+0) FROM t2;
+a_int BIN(a_bit+0)
+1 0
+2 1
+3 10
+4 11
+5 100
+6 101010
+#-------- Test: TINYINT --------#
+ALTER TABLE t1 ADD INDEX index_tinyint (a_tinyint);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 2 NULL NULL BTREE
+t1 1 index_tinyint 1 a_tinyint NULL 2 NULL NULL YES BTREE
+INSERT INTO t1 SET a_tinyint = 99;
+UPDATE t1 SET a_tinyint = 88 where a_tinyint = 99;
+SELECT * FROM t1 ORDER BY a_tinyint;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+4 124 9223372036854775804 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+SELECT * FROM t1 WHERE a_tinyint > 1 LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_tinyint;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 9223372036854775804 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: BIGINT --------#
+ALTER TABLE t1 ADD INDEX index_bigint (a_bigint);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+t1 1 index_bigint 1 a_bigint NULL 3 NULL NULL YES BTREE
+INSERT INTO t1 SET a_bigint = 9223372036854775804;
+UPDATE t1 SET a_bigint = 911111111111111111 where a_bigint = 9223372036854775804;
+SELECT * FROM t1 ORDER BY a_bigint;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+SELECT * FROM t1 WHERE a_bigint > 1 LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_bigint;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: FLOAT --------#
+ALTER TABLE t1 ADD INDEX index_float (a_float);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+t1 1 index_float 1 a_float NULL 3 NULL NULL YES BTREE
+INSERT INTO t1 SET a_float = 994.44;
+UPDATE t1 SET a_float = 993.33 where a_float > 994 AND a_float < 994.5;
+SELECT * FROM t1 ORDER BY a_float;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+SELECT * FROM t1 WHERE a_float > 1 LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_float;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 4 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: DOUBLE --------#
+ALTER TABLE t1 ADD INDEX index_double (a_double);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 4 NULL NULL BTREE
+t1 1 index_double 1 a_double NULL 4 NULL NULL YES BTREE
+INSERT INTO t1 SET a_double = 999.678912345;
+UPDATE t1 SET a_double = 999.998877665 where a_double = 999.678912345;
+SELECT * FROM t1 ORDER BY a_double;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_double > 1 LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_double;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 4 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: DECIMAL --------#
+ALTER TABLE t1 ADD INDEX index_decimal (a_decimal);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 4 NULL NULL BTREE
+t1 1 index_decimal 1 a_decimal NULL 4 NULL NULL YES BTREE
+INSERT INTO t1 SET a_decimal = 112.04;
+UPDATE t1 SET a_decimal = 112.05 where a_decimal = 112.04;
+SELECT * FROM t1 ORDER BY a_decimal;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_decimal > 1 LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_decimal;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 5 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: DATE --------#
+ALTER TABLE t1 ADD INDEX index_date (a_date);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 5 NULL NULL BTREE
+t1 1 index_date 1 a_date NULL 5 NULL NULL YES BTREE
+INSERT INTO t1 SET a_date = '2008-07-14';
+UPDATE t1 SET a_date = '2008-08-14' where a_date = '2008-07-14';
+SELECT * FROM t1 ORDER BY a_date;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_date > '2008-01-01' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_date;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 5 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: TIME --------#
+ALTER TABLE t1 ADD INDEX index_time (a_time);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 5 NULL NULL BTREE
+t1 1 index_time 1 a_time NULL 5 NULL NULL YES BTREE
+INSERT INTO t1 SET a_time = '16:30:50';
+UPDATE t1 SET a_time = '17:31:00' where a_time = '16:30:50';
+SELECT * FROM t1 ORDER BY a_time;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_time > '11:00:00' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_time;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 6 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: DATETIME --------#
+ALTER TABLE t1 ADD INDEX index_datetime (a_datetime);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 6 NULL NULL BTREE
+t1 1 index_datetime 1 a_datetime NULL 6 NULL NULL YES BTREE
+INSERT INTO t1 SET a_datetime = '2008-07-14 16:30:50';
+UPDATE t1 SET a_datetime = '2008-08-14 17:31:00' where a_datetime = '2008-07-14
16:30:50';
+SELECT * FROM t1 ORDER BY a_datetime;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_datetime > '2008-07-10 00:00:00' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+ALTER TABLE t1 DROP INDEX index_datetime;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 6 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+#-------- Test: TIMESTAMP --------#
+ALTER TABLE t1 ADD INDEX index_timestamp (a_timestamp);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 6 NULL NULL BTREE
+t1 1 index_timestamp 1 a_timestamp NULL 6 NULL NULL BTREE
+INSERT INTO t1 SET a_timestamp = '2008-07-14 16:30:50';
+UPDATE t1 SET a_timestamp = '2008-08-14 19:20:21' where a_timestamp = '2008-07-14
16:30:50';
+SELECT * FROM t1 ORDER BY a_timestamp;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_timestamp > '2008-07-10 00:00:00' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+ALTER TABLE t1 DROP INDEX index_timestamp;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 7 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+#-------- Test: YEAR --------#
+ALTER TABLE t1 ADD INDEX index_year (a_year);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 7 NULL NULL BTREE
+t1 1 index_year 1 a_year NULL 7 NULL NULL YES BTREE
+INSERT INTO t1 SET a_year = '2013';
+UPDATE t1 SET a_year = '2020' where a_year LIKE '2013';
+SELECT * FROM t1 ORDER BY a_year;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_year > '1999' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_year;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 7 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+#-------- Test: CHAR --------#
+ALTER TABLE t1 ADD INDEX index_char (a_char);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 7 NULL NULL BTREE
+t1 1 index_char 1 a_char NULL 7 NULL NULL YES BTREE
+INSERT INTO t1 SET a_char = 'fTestChar';
+UPDATE t1 SET a_char = 'gTestChar' where a_char = 'fTestChar';
+SELECT * FROM t1 ORDER BY a_char;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+SELECT * FROM t1 WHERE a_char > 'afalcon' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_char;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 8 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+#-------- Test: VARCHAR --------#
+ALTER TABLE t1 ADD INDEX index_varchar (a_varchar);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 8 NULL NULL BTREE
+t1 1 index_varchar 1 a_varchar NULL 8 NULL NULL YES BTREE
+INSERT INTO t1 SET a_varchar = 'fTestVarChar';
+UPDATE t1 SET a_varchar = 'gTestVarChar' where a_varchar = 'fTestVarChar';
+SELECT * FROM t1 ORDER BY a_varchar;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+SELECT * FROM t1 WHERE a_varchar > 'afalcon' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_varchar;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 8 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+#-------- Test: BINARY --------#
+ALTER TABLE t1 ADD INDEX index_binary (a_binary);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 8 NULL NULL BTREE
+t1 1 index_binary 1 a_binary NULL 8 NULL NULL YES BTREE
+INSERT INTO t1 SET a_binary = 'fTestBin';
+UPDATE t1 SET a_binary = 'gTestBin' where a_binary = 'fTestBin';
+SELECT * FROM t1 ORDER BY a_binary;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+SELECT * FROM t1 WHERE a_binary > 'afalcon' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+ALTER TABLE t1 DROP INDEX index_binary;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 9 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+#-------- Test: VARBINARY --------#
+ALTER TABLE t1 ADD INDEX index_varbinary (a_varbinary);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 9 NULL NULL BTREE
+t1 1 index_varbinary 1 a_varbinary NULL 9 NULL NULL YES BTREE
+INSERT INTO t1 SET a_varbinary = 'fTestVarBinary';
+UPDATE t1 SET a_varbinary = 'gTestVarBinary' where a_varbinary = 'fTestVarBinary';
+SELECT * FROM t1 ORDER BY a_varbinary;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+SELECT * FROM t1 WHERE a_varbinary > 'afalcon' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+ALTER TABLE t1 DROP INDEX index_varbinary;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 9 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueThree
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+#-------- Test: ENUM --------#
+ALTER TABLE t1 ADD INDEX index_enum (a_binary);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 9 NULL NULL BTREE
+t1 1 index_enum 1 a_binary NULL 9 NULL NULL YES BTREE
+INSERT INTO t1 SET a_enum = 'enumValueThree';
+UPDATE t1 SET a_enum = 'enumValueOne' where a_enum = 'enumValueThree';
+SELECT * FROM t1 ORDER BY a_enum;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueOne
+20 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+SELECT * FROM t1 WHERE a_enum > 'afalcon' LIMIT 1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+ALTER TABLE t1 DROP INDEX index_enum;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 10 NULL NULL BTREE
+SELECT * FROM t1;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueOne
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+20 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL enumValueOne
+#-------- Test: Alternative CREATE INDEX --------#
+CREATE INDEX index_int on t1 (a_int);
+CREATE INDEX index_bit on t2 (a_bit);
+CREATE INDEX index_tinyint on t1 (a_tinyint);
+CREATE INDEX index_bigint on t1 (a_bigint);
+CREATE INDEX index_float on t1 (a_float);
+CREATE INDEX index_double on t1 (a_double);
+CREATE INDEX index_decimal on t1 (a_decimal);
+CREATE INDEX index_date on t1 (a_date);
+CREATE INDEX index_datetime on t1 (a_datetime);
+CREATE INDEX index_timestamp on t1 (a_timestamp);
+CREATE INDEX index_year on t1 (a_year);
+CREATE INDEX index_char on t1 (a_char);
+CREATE INDEX index_varchar on t1 (a_varchar);
+CREATE INDEX index_binary on t1 (a_binary);
+CREATE INDEX index_varbinary on t1 (a_varbinary);
+CREATE INDEX index_enum on t1 (a_enum);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 10 NULL NULL BTREE
+t1 1 index_int 1 a_int NULL 10 NULL NULL BTREE
+t1 1 index_tinyint 1 a_tinyint NULL 10 NULL NULL YES BTREE
+t1 1 index_bigint 1 a_bigint NULL 10 NULL NULL YES BTREE
+t1 1 index_float 1 a_float NULL 10 NULL NULL YES BTREE
+t1 1 index_double 1 a_double NULL 10 NULL NULL YES BTREE
+t1 1 index_decimal 1 a_decimal NULL 10 NULL NULL YES BTREE
+t1 1 index_date 1 a_date NULL 10 NULL NULL YES BTREE
+t1 1 index_datetime 1 a_datetime NULL 10 NULL NULL YES BTREE
+t1 1 index_timestamp 1 a_timestamp NULL 10 NULL NULL BTREE
+t1 1 index_year 1 a_year NULL 10 NULL NULL YES BTREE
+t1 1 index_char 1 a_char NULL 10 NULL NULL YES BTREE
+t1 1 index_varchar 1 a_varchar NULL 10 NULL NULL YES BTREE
+t1 1 index_binary 1 a_binary NULL 10 NULL NULL YES BTREE
+t1 1 index_varbinary 1 a_varbinary NULL 10 NULL NULL YES BTREE
+t1 1 index_enum 1 a_enum NULL 10 NULL NULL YES BTREE
+SELECT * FROM t1 ORDER BY a_int;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueOne
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+20 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL enumValueOne
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+t2 1 index_bit 1 a_bit NULL 3 NULL NULL YES BTREE
+SELECT a_int, BIN(a_bit+0) FROM t2 ORDER BY a_int;
+a_int BIN(a_bit+0)
+1 0
+2 1
+3 10
+4 11
+5 100
+6 101010
+#-------- Test: Alternative DROP INDEX --------#
+DROP INDEX index_int on t1;
+DROP INDEX index_bit on t2;
+DROP INDEX index_tinyint on t1;
+DROP INDEX index_bigint on t1;
+DROP INDEX index_float on t1;
+DROP INDEX index_double on t1;
+DROP INDEX index_decimal on t1;
+DROP INDEX index_date on t1;
+DROP INDEX index_datetime on t1;
+DROP INDEX index_timestamp on t1;
+DROP INDEX index_year on t1;
+DROP INDEX index_char on t1;
+DROP INDEX index_varchar on t1;
+DROP INDEX index_binary on t1;
+DROP INDEX index_varbinary on t1;
+DROP INDEX index_enum on t1;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a_int NULL 10 NULL NULL BTREE
+SELECT * FROM t1 ORDER BY a_int;
+a_int a_tinyint a_bigint a_float a_double a_decimal a_date a_time a_datetime a_timestamp a_year a_char a_varchar a_binary a_varbinary a_enum
+1 127 9223372036854775807 999.99 999.123456789 111.99 2008-07-09 11:30:00 2008-07-09
11:30:00 2008-07-09
11:30:00 2008 aTestChar aTestVarChar aTestBin aTestVarBinary enumValueOne
+2 126 9223372036854775806 998.88 999.234567891 112.00 2008-07-10 12:30:10 2008-07-10
12:30:10 2008-07-10
12:30:10 2009 bTestChar bTestVarChar bTestBin bTestVarBinary enumValueTwo
+3 125 9223372036854775805 997.77 999.345678912 112.01 2008-07-11 13:30:20 2008-07-11
13:30:20 2008-07-11
13:30:20 2010 cTestChar cTestVarChar cTestBin cTestVarBinary enumValueOne
+4 124 911111111111111111 996.66 999.456789123 112.02 2008-07-12 14:30:30 2008-07-12
14:30:30 2008-07-12
14:30:30 2011 dTestChar dTestVarChar dTestBin dTestVarBinary enumValueOne
+5 123 9223372036854775803 995.55 999.567891234 112.03 2008-07-13 15:30:40 2008-07-13
15:30:40 2008-07-13
15:30:40 2012 eTestChar eTestVarChar eTestBin eTestVarBinary enumValueTwo
+6 88 NULL NULL NULL NULL NULL NULL NULL 0000-00-00 00:00:00 NULL NULL NULL NULL NULL NULL
+7 NULL 911111111111111111 NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+8 NULL NULL 993.33 NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+9 NULL NULL NULL 999.998877665 NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+10 NULL NULL NULL NULL 112.05 NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+11 NULL NULL NULL NULL NULL 2008-08-14 NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+12 NULL NULL NULL NULL NULL NULL 17:31:00 NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+13 NULL NULL NULL NULL NULL NULL NULL 2008-08-14 17:31:00 0000-00-00
00:00:00 NULL NULL NULL NULL NULL NULL
+14 NULL NULL NULL NULL NULL NULL NULL NULL 2008-08-14
19:20:21 NULL NULL NULL NULL NULL NULL
+15 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 2020 NULL NULL NULL NULL NULL
+16 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL gTestChar NULL NULL NULL NULL
+17 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL gTestVarChar NULL NULL NULL
+18 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL gTestBin NULL NULL
+19 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL gTestVarBinary NULL
+20 NULL NULL NULL NULL NULL NULL NULL NULL 0000-00-00
00:00:00 NULL NULL NULL NULL NULL enumValueOne
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a_int NULL 3 NULL NULL BTREE
+SELECT a_int, BIN(a_bit+0) FROM t2 ORDER BY a_int;
+a_int BIN(a_bit+0)
+1 0
+2 1
+3 10
+4 11
+5 100
+6 101010
+DROP TABLE t1;
+DROP TABLE t2;
=== added file 'mysql-test/suite/falcon/r/falcon_online_index.result'
--- a/mysql-test/suite/falcon/r/falcon_online_index.result 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_online_index.result 2008-09-04 18:38:48 +0000
@@ -0,0 +1,1363 @@
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+DROP TABLE IF EXISTS t3;
+CREATE TABLE t1 (
+a int PRIMARY KEY,
+b VARCHAR(255),
+c int,
+d CHAR(10)
+);
+INSERT INTO t1 VALUES (0, 'TestRow0', 0*2, 'Char0');
+INSERT INTO t1 VALUES (1, 'TestRow1', 1*2, 'Char1');
+INSERT INTO t1 VALUES (2, 'TestRow2', 2*2, 'Char2');
+INSERT INTO t1 VALUES (3, 'TestRow3', 3*2, 'Char3');
+INSERT INTO t1 VALUES (4, 'TestRow4', 4*2, 'Char4');
+INSERT INTO t1 VALUES (5, 'TestRow5', 5*2, 'Char5');
+INSERT INTO t1 VALUES (6, 'TestRow6', 6*2, 'Char6');
+INSERT INTO t1 VALUES (7, 'TestRow7', 7*2, 'Char7');
+INSERT INTO t1 VALUES (8, 'TestRow8', 8*2, 'Char8');
+INSERT INTO t1 VALUES (9, 'TestRow9', 9*2, 'Char9');
+INSERT INTO t1 VALUES (10, 'TestRow10', 10*2, 'Char10');
+INSERT INTO t1 VALUES (11, 'TestRow11', 11*2, 'Char11');
+INSERT INTO t1 VALUES (12, 'TestRow12', 12*2, 'Char12');
+INSERT INTO t1 VALUES (13, 'TestRow13', 13*2, 'Char13');
+INSERT INTO t1 VALUES (14, 'TestRow14', 14*2, 'Char14');
+INSERT INTO t1 VALUES (15, 'TestRow15', 15*2, 'Char15');
+INSERT INTO t1 VALUES (16, 'TestRow16', 16*2, 'Char16');
+INSERT INTO t1 VALUES (17, 'TestRow17', 17*2, 'Char17');
+INSERT INTO t1 VALUES (18, 'TestRow18', 18*2, 'Char18');
+INSERT INTO t1 VALUES (19, 'TestRow19', 19*2, 'Char19');
+CREATE TABLE t2 (
+a int PRIMARY KEY,
+b int,
+c int,
+d VARCHAR(65)
+);
+INSERT INTO t2 VALUES (0, 0*2, 0+1, 'SomeString 0 for testing');
+INSERT INTO t2 VALUES (1, 1*2, 1+1, 'SomeString 1 for testing');
+INSERT INTO t2 VALUES (2, 2*2, 2+1, 'SomeString 2 for testing');
+INSERT INTO t2 VALUES (3, 3*2, 3+1, 'SomeString 3 for testing');
+INSERT INTO t2 VALUES (4, 4*2, 4+1, 'SomeString 4 for testing');
+INSERT INTO t2 VALUES (5, 5*2, 5+1, 'SomeString 5 for testing');
+INSERT INTO t2 VALUES (6, 6*2, 6+1, 'SomeString 6 for testing');
+INSERT INTO t2 VALUES (7, 7*2, 7+1, 'SomeString 7 for testing');
+INSERT INTO t2 VALUES (8, 8*2, 8+1, 'SomeString 8 for testing');
+INSERT INTO t2 VALUES (9, 9*2, 9+1, 'SomeString 9 for testing');
+INSERT INTO t2 VALUES (10, 10*2, 10+1, 'SomeString 10 for testing');
+INSERT INTO t2 VALUES (11, 11*2, 11+1, 'SomeString 11 for testing');
+INSERT INTO t2 VALUES (12, 12*2, 12+1, 'SomeString 12 for testing');
+INSERT INTO t2 VALUES (13, 13*2, 13+1, 'SomeString 13 for testing');
+INSERT INTO t2 VALUES (14, 14*2, 14+1, 'SomeString 14 for testing');
+INSERT INTO t2 VALUES (15, 15*2, 15+1, 'SomeString 15 for testing');
+INSERT INTO t2 VALUES (16, 16*2, 16+1, 'SomeString 16 for testing');
+INSERT INTO t2 VALUES (17, 17*2, 17+1, 'SomeString 17 for testing');
+INSERT INTO t2 VALUES (18, 18*2, 18+1, 'SomeString 18 for testing');
+INSERT INTO t2 VALUES (19, 19*2, 19+1, 'SomeString 19 for testing');
+INSERT INTO t2 VALUES (20, 20*2, 20+1, 'SomeString 20 for testing');
+INSERT INTO t2 VALUES (21, 21*2, 21+1, 'SomeString 21 for testing');
+INSERT INTO t2 VALUES (22, 22*2, 22+1, 'SomeString 22 for testing');
+INSERT INTO t2 VALUES (23, 23*2, 23+1, 'SomeString 23 for testing');
+INSERT INTO t2 VALUES (24, 24*2, 24+1, 'SomeString 24 for testing');
+INSERT INTO t2 VALUES (25, 25*2, 25+1, 'SomeString 25 for testing');
+INSERT INTO t2 VALUES (26, 26*2, 26+1, 'SomeString 26 for testing');
+INSERT INTO t2 VALUES (27, 27*2, 27+1, 'SomeString 27 for testing');
+INSERT INTO t2 VALUES (28, 28*2, 28+1, 'SomeString 28 for testing');
+INSERT INTO t2 VALUES (29, 29*2, 29+1, 'SomeString 29 for testing');
+INSERT INTO t2 VALUES (30, 30*2, 30+1, 'SomeString 30 for testing');
+INSERT INTO t2 VALUES (31, 31*2, 31+1, 'SomeString 31 for testing');
+INSERT INTO t2 VALUES (32, 32*2, 32+1, 'SomeString 32 for testing');
+CREATE TABLE t3 (
+a int PRIMARY KEY AUTO_INCREMENT,
+b int DEFAULT 9999,
+c int DEFAULT 8888 NOT NULL,
+d int NOT NULL,
+e VARCHAR(65)
+);
+INSERT INTO t3 (b, c, d, e) VALUES (0*2, 0+1, 0-1, 'SomeVarchar 0 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (1*2, 1+1, 1-1, 'SomeVarchar 1 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (2*2, 2+1, 2-1, 'SomeVarchar 2 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (3*2, 3+1, 3-1, 'SomeVarchar 3 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (4*2, 4+1, 4-1, 'SomeVarchar 4 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (5*2, 5+1, 5-1, 'SomeVarchar 5 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (6*2, 6+1, 6-1, 'SomeVarchar 6 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (7*2, 7+1, 7-1, 'SomeVarchar 7 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (8*2, 8+1, 8-1, 'SomeVarchar 8 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (9*2, 9+1, 9-1, 'SomeVarchar 9 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (10*2, 10+1, 10-1, 'SomeVarchar 10 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (11*2, 11+1, 11-1, 'SomeVarchar 11 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (12*2, 12+1, 12-1, 'SomeVarchar 12 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (13*2, 13+1, 13-1, 'SomeVarchar 13 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (14*2, 14+1, 14-1, 'SomeVarchar 14 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (15*2, 15+1, 15-1, 'SomeVarchar 15 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (16*2, 16+1, 16-1, 'SomeVarchar 16 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (17*2, 17+1, 17-1, 'SomeVarchar 17 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (18*2, 18+1, 18-1, 'SomeVarchar 18 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (19*2, 19+1, 19-1, 'SomeVarchar 19 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (20*2, 20+1, 20-1, 'SomeVarchar 20 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (21*2, 21+1, 21-1, 'SomeVarchar 21 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (22*2, 22+1, 22-1, 'SomeVarchar 22 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (23*2, 23+1, 23-1, 'SomeVarchar 23 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (24*2, 24+1, 24-1, 'SomeVarchar 24 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (25*2, 25+1, 25-1, 'SomeVarchar 25 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (26*2, 26+1, 26-1, 'SomeVarchar 26 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (27*2, 27+1, 27-1, 'SomeVarchar 27 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (28*2, 28+1, 28-1, 'SomeVarchar 28 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (29*2, 29+1, 29-1, 'SomeVarchar 29 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (30*2, 30+1, 30-1, 'SomeVarchar 30 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (31*2, 31+1, 31-1, 'SomeVarchar 31 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (32*2, 32+1, 32-1, 'SomeVarchar 32 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (33*2, 33+1, 33-1, 'SomeVarchar 33 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (34*2, 34+1, 34-1, 'SomeVarchar 34 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (35*2, 35+1, 35-1, 'SomeVarchar 35 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (36*2, 36+1, 36-1, 'SomeVarchar 36 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (37*2, 37+1, 37-1, 'SomeVarchar 37 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (38*2, 38+1, 38-1, 'SomeVarchar 38 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (39*2, 39+1, 39-1, 'SomeVarchar 39 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (40*2, 40+1, 40-1, 'SomeVarchar 40 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (41*2, 41+1, 41-1, 'SomeVarchar 41 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (42*2, 42+1, 42-1, 'SomeVarchar 42 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (43*2, 43+1, 43-1, 'SomeVarchar 43 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (44*2, 44+1, 44-1, 'SomeVarchar 44 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (45*2, 45+1, 45-1, 'SomeVarchar 45 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (46*2, 46+1, 46-1, 'SomeVarchar 46 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (47*2, 47+1, 47-1, 'SomeVarchar 47 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (48*2, 48+1, 48-1, 'SomeVarchar 48 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (49*2, 49+1, 49-1, 'SomeVarchar 49 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (50*2, 50+1, 50-1, 'SomeVarchar 50 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (51*2, 51+1, 51-1, 'SomeVarchar 51 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (52*2, 52+1, 52-1, 'SomeVarchar 52 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (53*2, 53+1, 53-1, 'SomeVarchar 53 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (54*2, 54+1, 54-1, 'SomeVarchar 54 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (55*2, 55+1, 55-1, 'SomeVarchar 55 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (56*2, 56+1, 56-1, 'SomeVarchar 56 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (57*2, 57+1, 57-1, 'SomeVarchar 57 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (58*2, 58+1, 58-1, 'SomeVarchar 58 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (59*2, 59+1, 59-1, 'SomeVarchar 59 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (60*2, 60+1, 60-1, 'SomeVarchar 60 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (61*2, 61+1, 61-1, 'SomeVarchar 61 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (62*2, 62+1, 62-1, 'SomeVarchar 62 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (63*2, 63+1, 63-1, 'SomeVarchar 63 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (64*2, 64+1, 64-1, 'SomeVarchar 64 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (65*2, 65+1, 65-1, 'SomeVarchar 65 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (66*2, 66+1, 66-1, 'SomeVarchar 66 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (67*2, 67+1, 67-1, 'SomeVarchar 67 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (68*2, 68+1, 68-1, 'SomeVarchar 68 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (69*2, 69+1, 69-1, 'SomeVarchar 69 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (70*2, 70+1, 70-1, 'SomeVarchar 70 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (71*2, 71+1, 71-1, 'SomeVarchar 71 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (72*2, 72+1, 72-1, 'SomeVarchar 72 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (73*2, 73+1, 73-1, 'SomeVarchar 73 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (74*2, 74+1, 74-1, 'SomeVarchar 74 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (75*2, 75+1, 75-1, 'SomeVarchar 75 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (76*2, 76+1, 76-1, 'SomeVarchar 76 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (77*2, 77+1, 77-1, 'SomeVarchar 77 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (78*2, 78+1, 78-1, 'SomeVarchar 78 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (79*2, 79+1, 79-1, 'SomeVarchar 79 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (80*2, 80+1, 80-1, 'SomeVarchar 80 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (81*2, 81+1, 81-1, 'SomeVarchar 81 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (82*2, 82+1, 82-1, 'SomeVarchar 82 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (83*2, 83+1, 83-1, 'SomeVarchar 83 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (84*2, 84+1, 84-1, 'SomeVarchar 84 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (85*2, 85+1, 85-1, 'SomeVarchar 85 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (86*2, 86+1, 86-1, 'SomeVarchar 86 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (87*2, 87+1, 87-1, 'SomeVarchar 87 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (88*2, 88+1, 88-1, 'SomeVarchar 88 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (89*2, 89+1, 89-1, 'SomeVarchar 89 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (90*2, 90+1, 90-1, 'SomeVarchar 90 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (91*2, 91+1, 91-1, 'SomeVarchar 91 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (92*2, 92+1, 92-1, 'SomeVarchar 92 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (93*2, 93+1, 93-1, 'SomeVarchar 93 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (94*2, 94+1, 94-1, 'SomeVarchar 94 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (95*2, 95+1, 95-1, 'SomeVarchar 95 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (96*2, 96+1, 96-1, 'SomeVarchar 96 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (97*2, 97+1, 97-1, 'SomeVarchar 97 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (98*2, 98+1, 98-1, 'SomeVarchar 98 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (99*2, 99+1, 99-1, 'SomeVarchar 99 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (100*2, 100+1, 100-1, 'SomeVarchar 100 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (101*2, 101+1, 101-1, 'SomeVarchar 101 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (102*2, 102+1, 102-1, 'SomeVarchar 102 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (103*2, 103+1, 103-1, 'SomeVarchar 103 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (104*2, 104+1, 104-1, 'SomeVarchar 104 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (105*2, 105+1, 105-1, 'SomeVarchar 105 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (106*2, 106+1, 106-1, 'SomeVarchar 106 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (107*2, 107+1, 107-1, 'SomeVarchar 107 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (108*2, 108+1, 108-1, 'SomeVarchar 108 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (109*2, 109+1, 109-1, 'SomeVarchar 109 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (110*2, 110+1, 110-1, 'SomeVarchar 110 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (111*2, 111+1, 111-1, 'SomeVarchar 111 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (112*2, 112+1, 112-1, 'SomeVarchar 112 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (113*2, 113+1, 113-1, 'SomeVarchar 113 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (114*2, 114+1, 114-1, 'SomeVarchar 114 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (115*2, 115+1, 115-1, 'SomeVarchar 115 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (116*2, 116+1, 116-1, 'SomeVarchar 116 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (117*2, 117+1, 117-1, 'SomeVarchar 117 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (118*2, 118+1, 118-1, 'SomeVarchar 118 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (119*2, 119+1, 119-1, 'SomeVarchar 119 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (120*2, 120+1, 120-1, 'SomeVarchar 120 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (121*2, 121+1, 121-1, 'SomeVarchar 121 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (122*2, 122+1, 122-1, 'SomeVarchar 122 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (123*2, 123+1, 123-1, 'SomeVarchar 123 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (124*2, 124+1, 124-1, 'SomeVarchar 124 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (125*2, 125+1, 125-1, 'SomeVarchar 125 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (126*2, 126+1, 126-1, 'SomeVarchar 126 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (127*2, 127+1, 127-1, 'SomeVarchar 127 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (128*2, 128+1, 128-1, 'SomeVarchar 128 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (129*2, 129+1, 129-1, 'SomeVarchar 129 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (130*2, 130+1, 130-1, 'SomeVarchar 130 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (131*2, 131+1, 131-1, 'SomeVarchar 131 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (132*2, 132+1, 132-1, 'SomeVarchar 132 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (133*2, 133+1, 133-1, 'SomeVarchar 133 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (134*2, 134+1, 134-1, 'SomeVarchar 134 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (135*2, 135+1, 135-1, 'SomeVarchar 135 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (136*2, 136+1, 136-1, 'SomeVarchar 136 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (137*2, 137+1, 137-1, 'SomeVarchar 137 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (138*2, 138+1, 138-1, 'SomeVarchar 138 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (139*2, 139+1, 139-1, 'SomeVarchar 139 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (140*2, 140+1, 140-1, 'SomeVarchar 140 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (141*2, 141+1, 141-1, 'SomeVarchar 141 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (142*2, 142+1, 142-1, 'SomeVarchar 142 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (143*2, 143+1, 143-1, 'SomeVarchar 143 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (144*2, 144+1, 144-1, 'SomeVarchar 144 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (145*2, 145+1, 145-1, 'SomeVarchar 145 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (146*2, 146+1, 146-1, 'SomeVarchar 146 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (147*2, 147+1, 147-1, 'SomeVarchar 147 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (148*2, 148+1, 148-1, 'SomeVarchar 148 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (149*2, 149+1, 149-1, 'SomeVarchar 149 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (150*2, 150+1, 150-1, 'SomeVarchar 150 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (151*2, 151+1, 151-1, 'SomeVarchar 151 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (152*2, 152+1, 152-1, 'SomeVarchar 152 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (153*2, 153+1, 153-1, 'SomeVarchar 153 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (154*2, 154+1, 154-1, 'SomeVarchar 154 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (155*2, 155+1, 155-1, 'SomeVarchar 155 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (156*2, 156+1, 156-1, 'SomeVarchar 156 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (157*2, 157+1, 157-1, 'SomeVarchar 157 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (158*2, 158+1, 158-1, 'SomeVarchar 158 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (159*2, 159+1, 159-1, 'SomeVarchar 159 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (160*2, 160+1, 160-1, 'SomeVarchar 160 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (161*2, 161+1, 161-1, 'SomeVarchar 161 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (162*2, 162+1, 162-1, 'SomeVarchar 162 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (163*2, 163+1, 163-1, 'SomeVarchar 163 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (164*2, 164+1, 164-1, 'SomeVarchar 164 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (165*2, 165+1, 165-1, 'SomeVarchar 165 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (166*2, 166+1, 166-1, 'SomeVarchar 166 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (167*2, 167+1, 167-1, 'SomeVarchar 167 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (168*2, 168+1, 168-1, 'SomeVarchar 168 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (169*2, 169+1, 169-1, 'SomeVarchar 169 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (170*2, 170+1, 170-1, 'SomeVarchar 170 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (171*2, 171+1, 171-1, 'SomeVarchar 171 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (172*2, 172+1, 172-1, 'SomeVarchar 172 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (173*2, 173+1, 173-1, 'SomeVarchar 173 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (174*2, 174+1, 174-1, 'SomeVarchar 174 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (175*2, 175+1, 175-1, 'SomeVarchar 175 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (176*2, 176+1, 176-1, 'SomeVarchar 176 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (177*2, 177+1, 177-1, 'SomeVarchar 177 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (178*2, 178+1, 178-1, 'SomeVarchar 178 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (179*2, 179+1, 179-1, 'SomeVarchar 179 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (180*2, 180+1, 180-1, 'SomeVarchar 180 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (181*2, 181+1, 181-1, 'SomeVarchar 181 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (182*2, 182+1, 182-1, 'SomeVarchar 182 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (183*2, 183+1, 183-1, 'SomeVarchar 183 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (184*2, 184+1, 184-1, 'SomeVarchar 184 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (185*2, 185+1, 185-1, 'SomeVarchar 185 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (186*2, 186+1, 186-1, 'SomeVarchar 186 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (187*2, 187+1, 187-1, 'SomeVarchar 187 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (188*2, 188+1, 188-1, 'SomeVarchar 188 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (189*2, 189+1, 189-1, 'SomeVarchar 189 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (190*2, 190+1, 190-1, 'SomeVarchar 190 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (191*2, 191+1, 191-1, 'SomeVarchar 191 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (192*2, 192+1, 192-1, 'SomeVarchar 192 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (193*2, 193+1, 193-1, 'SomeVarchar 193 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (194*2, 194+1, 194-1, 'SomeVarchar 194 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (195*2, 195+1, 195-1, 'SomeVarchar 195 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (196*2, 196+1, 196-1, 'SomeVarchar 196 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (197*2, 197+1, 197-1, 'SomeVarchar 197 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (198*2, 198+1, 198-1, 'SomeVarchar 198 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (199*2, 199+1, 199-1, 'SomeVarchar 199 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (200*2, 200+1, 200-1, 'SomeVarchar 200 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (201*2, 201+1, 201-1, 'SomeVarchar 201 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (202*2, 202+1, 202-1, 'SomeVarchar 202 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (203*2, 203+1, 203-1, 'SomeVarchar 203 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (204*2, 204+1, 204-1, 'SomeVarchar 204 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (205*2, 205+1, 205-1, 'SomeVarchar 205 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (206*2, 206+1, 206-1, 'SomeVarchar 206 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (207*2, 207+1, 207-1, 'SomeVarchar 207 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (208*2, 208+1, 208-1, 'SomeVarchar 208 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (209*2, 209+1, 209-1, 'SomeVarchar 209 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (210*2, 210+1, 210-1, 'SomeVarchar 210 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (211*2, 211+1, 211-1, 'SomeVarchar 211 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (212*2, 212+1, 212-1, 'SomeVarchar 212 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (213*2, 213+1, 213-1, 'SomeVarchar 213 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (214*2, 214+1, 214-1, 'SomeVarchar 214 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (215*2, 215+1, 215-1, 'SomeVarchar 215 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (216*2, 216+1, 216-1, 'SomeVarchar 216 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (217*2, 217+1, 217-1, 'SomeVarchar 217 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (218*2, 218+1, 218-1, 'SomeVarchar 218 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (219*2, 219+1, 219-1, 'SomeVarchar 219 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (220*2, 220+1, 220-1, 'SomeVarchar 220 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (221*2, 221+1, 221-1, 'SomeVarchar 221 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (222*2, 222+1, 222-1, 'SomeVarchar 222 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (223*2, 223+1, 223-1, 'SomeVarchar 223 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (224*2, 224+1, 224-1, 'SomeVarchar 224 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (225*2, 225+1, 225-1, 'SomeVarchar 225 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (226*2, 226+1, 226-1, 'SomeVarchar 226 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (227*2, 227+1, 227-1, 'SomeVarchar 227 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (228*2, 228+1, 228-1, 'SomeVarchar 228 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (229*2, 229+1, 229-1, 'SomeVarchar 229 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (230*2, 230+1, 230-1, 'SomeVarchar 230 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (231*2, 231+1, 231-1, 'SomeVarchar 231 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (232*2, 232+1, 232-1, 'SomeVarchar 232 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (233*2, 233+1, 233-1, 'SomeVarchar 233 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (234*2, 234+1, 234-1, 'SomeVarchar 234 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (235*2, 235+1, 235-1, 'SomeVarchar 235 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (236*2, 236+1, 236-1, 'SomeVarchar 236 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (237*2, 237+1, 237-1, 'SomeVarchar 237 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (238*2, 238+1, 238-1, 'SomeVarchar 238 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (239*2, 239+1, 239-1, 'SomeVarchar 239 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (240*2, 240+1, 240-1, 'SomeVarchar 240 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (241*2, 241+1, 241-1, 'SomeVarchar 241 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (242*2, 242+1, 242-1, 'SomeVarchar 242 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (243*2, 243+1, 243-1, 'SomeVarchar 243 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (244*2, 244+1, 244-1, 'SomeVarchar 244 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (245*2, 245+1, 245-1, 'SomeVarchar 245 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (246*2, 246+1, 246-1, 'SomeVarchar 246 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (247*2, 247+1, 247-1, 'SomeVarchar 247 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (248*2, 248+1, 248-1, 'SomeVarchar 248 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (249*2, 249+1, 249-1, 'SomeVarchar 249 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (250*2, 250+1, 250-1, 'SomeVarchar 250 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (251*2, 251+1, 251-1, 'SomeVarchar 251 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (252*2, 252+1, 252-1, 'SomeVarchar 252 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (253*2, 253+1, 253-1, 'SomeVarchar 253 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (254*2, 254+1, 254-1, 'SomeVarchar 254 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (255*2, 255+1, 255-1, 'SomeVarchar 255 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (256*2, 256+1, 256-1, 'SomeVarchar 256 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (257*2, 257+1, 257-1, 'SomeVarchar 257 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (258*2, 258+1, 258-1, 'SomeVarchar 258 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (259*2, 259+1, 259-1, 'SomeVarchar 259 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (260*2, 260+1, 260-1, 'SomeVarchar 260 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (261*2, 261+1, 261-1, 'SomeVarchar 261 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (262*2, 262+1, 262-1, 'SomeVarchar 262 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (263*2, 263+1, 263-1, 'SomeVarchar 263 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (264*2, 264+1, 264-1, 'SomeVarchar 264 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (265*2, 265+1, 265-1, 'SomeVarchar 265 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (266*2, 266+1, 266-1, 'SomeVarchar 266 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (267*2, 267+1, 267-1, 'SomeVarchar 267 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (268*2, 268+1, 268-1, 'SomeVarchar 268 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (269*2, 269+1, 269-1, 'SomeVarchar 269 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (270*2, 270+1, 270-1, 'SomeVarchar 270 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (271*2, 271+1, 271-1, 'SomeVarchar 271 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (272*2, 272+1, 272-1, 'SomeVarchar 272 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (273*2, 273+1, 273-1, 'SomeVarchar 273 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (274*2, 274+1, 274-1, 'SomeVarchar 274 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (275*2, 275+1, 275-1, 'SomeVarchar 275 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (276*2, 276+1, 276-1, 'SomeVarchar 276 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (277*2, 277+1, 277-1, 'SomeVarchar 277 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (278*2, 278+1, 278-1, 'SomeVarchar 278 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (279*2, 279+1, 279-1, 'SomeVarchar 279 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (280*2, 280+1, 280-1, 'SomeVarchar 280 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (281*2, 281+1, 281-1, 'SomeVarchar 281 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (282*2, 282+1, 282-1, 'SomeVarchar 282 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (283*2, 283+1, 283-1, 'SomeVarchar 283 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (284*2, 284+1, 284-1, 'SomeVarchar 284 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (285*2, 285+1, 285-1, 'SomeVarchar 285 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (286*2, 286+1, 286-1, 'SomeVarchar 286 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (287*2, 287+1, 287-1, 'SomeVarchar 287 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (288*2, 288+1, 288-1, 'SomeVarchar 288 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (289*2, 289+1, 289-1, 'SomeVarchar 289 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (290*2, 290+1, 290-1, 'SomeVarchar 290 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (291*2, 291+1, 291-1, 'SomeVarchar 291 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (292*2, 292+1, 292-1, 'SomeVarchar 292 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (293*2, 293+1, 293-1, 'SomeVarchar 293 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (294*2, 294+1, 294-1, 'SomeVarchar 294 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (295*2, 295+1, 295-1, 'SomeVarchar 295 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (296*2, 296+1, 296-1, 'SomeVarchar 296 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (297*2, 297+1, 297-1, 'SomeVarchar 297 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (298*2, 298+1, 298-1, 'SomeVarchar 298 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (299*2, 299+1, 299-1, 'SomeVarchar 299 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (300*2, 300+1, 300-1, 'SomeVarchar 300 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (301*2, 301+1, 301-1, 'SomeVarchar 301 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (302*2, 302+1, 302-1, 'SomeVarchar 302 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (303*2, 303+1, 303-1, 'SomeVarchar 303 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (304*2, 304+1, 304-1, 'SomeVarchar 304 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (305*2, 305+1, 305-1, 'SomeVarchar 305 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (306*2, 306+1, 306-1, 'SomeVarchar 306 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (307*2, 307+1, 307-1, 'SomeVarchar 307 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (308*2, 308+1, 308-1, 'SomeVarchar 308 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (309*2, 309+1, 309-1, 'SomeVarchar 309 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (310*2, 310+1, 310-1, 'SomeVarchar 310 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (311*2, 311+1, 311-1, 'SomeVarchar 311 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (312*2, 312+1, 312-1, 'SomeVarchar 312 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (313*2, 313+1, 313-1, 'SomeVarchar 313 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (314*2, 314+1, 314-1, 'SomeVarchar 314 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (315*2, 315+1, 315-1, 'SomeVarchar 315 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (316*2, 316+1, 316-1, 'SomeVarchar 316 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (317*2, 317+1, 317-1, 'SomeVarchar 317 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (318*2, 318+1, 318-1, 'SomeVarchar 318 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (319*2, 319+1, 319-1, 'SomeVarchar 319 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (320*2, 320+1, 320-1, 'SomeVarchar 320 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (321*2, 321+1, 321-1, 'SomeVarchar 321 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (322*2, 322+1, 322-1, 'SomeVarchar 322 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (323*2, 323+1, 323-1, 'SomeVarchar 323 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (324*2, 324+1, 324-1, 'SomeVarchar 324 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (325*2, 325+1, 325-1, 'SomeVarchar 325 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (326*2, 326+1, 326-1, 'SomeVarchar 326 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (327*2, 327+1, 327-1, 'SomeVarchar 327 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (328*2, 328+1, 328-1, 'SomeVarchar 328 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (329*2, 329+1, 329-1, 'SomeVarchar 329 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (330*2, 330+1, 330-1, 'SomeVarchar 330 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (331*2, 331+1, 331-1, 'SomeVarchar 331 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (332*2, 332+1, 332-1, 'SomeVarchar 332 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (333*2, 333+1, 333-1, 'SomeVarchar 333 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (334*2, 334+1, 334-1, 'SomeVarchar 334 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (335*2, 335+1, 335-1, 'SomeVarchar 335 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (336*2, 336+1, 336-1, 'SomeVarchar 336 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (337*2, 337+1, 337-1, 'SomeVarchar 337 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (338*2, 338+1, 338-1, 'SomeVarchar 338 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (339*2, 339+1, 339-1, 'SomeVarchar 339 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (340*2, 340+1, 340-1, 'SomeVarchar 340 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (341*2, 341+1, 341-1, 'SomeVarchar 341 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (342*2, 342+1, 342-1, 'SomeVarchar 342 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (343*2, 343+1, 343-1, 'SomeVarchar 343 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (344*2, 344+1, 344-1, 'SomeVarchar 344 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (345*2, 345+1, 345-1, 'SomeVarchar 345 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (346*2, 346+1, 346-1, 'SomeVarchar 346 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (347*2, 347+1, 347-1, 'SomeVarchar 347 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (348*2, 348+1, 348-1, 'SomeVarchar 348 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (349*2, 349+1, 349-1, 'SomeVarchar 349 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (350*2, 350+1, 350-1, 'SomeVarchar 350 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (351*2, 351+1, 351-1, 'SomeVarchar 351 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (352*2, 352+1, 352-1, 'SomeVarchar 352 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (353*2, 353+1, 353-1, 'SomeVarchar 353 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (354*2, 354+1, 354-1, 'SomeVarchar 354 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (355*2, 355+1, 355-1, 'SomeVarchar 355 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (356*2, 356+1, 356-1, 'SomeVarchar 356 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (357*2, 357+1, 357-1, 'SomeVarchar 357 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (358*2, 358+1, 358-1, 'SomeVarchar 358 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (359*2, 359+1, 359-1, 'SomeVarchar 359 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (360*2, 360+1, 360-1, 'SomeVarchar 360 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (361*2, 361+1, 361-1, 'SomeVarchar 361 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (362*2, 362+1, 362-1, 'SomeVarchar 362 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (363*2, 363+1, 363-1, 'SomeVarchar 363 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (364*2, 364+1, 364-1, 'SomeVarchar 364 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (365*2, 365+1, 365-1, 'SomeVarchar 365 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (366*2, 366+1, 366-1, 'SomeVarchar 366 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (367*2, 367+1, 367-1, 'SomeVarchar 367 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (368*2, 368+1, 368-1, 'SomeVarchar 368 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (369*2, 369+1, 369-1, 'SomeVarchar 369 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (370*2, 370+1, 370-1, 'SomeVarchar 370 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (371*2, 371+1, 371-1, 'SomeVarchar 371 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (372*2, 372+1, 372-1, 'SomeVarchar 372 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (373*2, 373+1, 373-1, 'SomeVarchar 373 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (374*2, 374+1, 374-1, 'SomeVarchar 374 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (375*2, 375+1, 375-1, 'SomeVarchar 375 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (376*2, 376+1, 376-1, 'SomeVarchar 376 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (377*2, 377+1, 377-1, 'SomeVarchar 377 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (378*2, 378+1, 378-1, 'SomeVarchar 378 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (379*2, 379+1, 379-1, 'SomeVarchar 379 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (380*2, 380+1, 380-1, 'SomeVarchar 380 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (381*2, 381+1, 381-1, 'SomeVarchar 381 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (382*2, 382+1, 382-1, 'SomeVarchar 382 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (383*2, 383+1, 383-1, 'SomeVarchar 383 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (384*2, 384+1, 384-1, 'SomeVarchar 384 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (385*2, 385+1, 385-1, 'SomeVarchar 385 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (386*2, 386+1, 386-1, 'SomeVarchar 386 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (387*2, 387+1, 387-1, 'SomeVarchar 387 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (388*2, 388+1, 388-1, 'SomeVarchar 388 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (389*2, 389+1, 389-1, 'SomeVarchar 389 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (390*2, 390+1, 390-1, 'SomeVarchar 390 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (391*2, 391+1, 391-1, 'SomeVarchar 391 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (392*2, 392+1, 392-1, 'SomeVarchar 392 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (393*2, 393+1, 393-1, 'SomeVarchar 393 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (394*2, 394+1, 394-1, 'SomeVarchar 394 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (395*2, 395+1, 395-1, 'SomeVarchar 395 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (396*2, 396+1, 396-1, 'SomeVarchar 396 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (397*2, 397+1, 397-1, 'SomeVarchar 397 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (398*2, 398+1, 398-1, 'SomeVarchar 398 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (399*2, 399+1, 399-1, 'SomeVarchar 399 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (400*2, 400+1, 400-1, 'SomeVarchar 400 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (401*2, 401+1, 401-1, 'SomeVarchar 401 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (402*2, 402+1, 402-1, 'SomeVarchar 402 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (403*2, 403+1, 403-1, 'SomeVarchar 403 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (404*2, 404+1, 404-1, 'SomeVarchar 404 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (405*2, 405+1, 405-1, 'SomeVarchar 405 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (406*2, 406+1, 406-1, 'SomeVarchar 406 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (407*2, 407+1, 407-1, 'SomeVarchar 407 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (408*2, 408+1, 408-1, 'SomeVarchar 408 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (409*2, 409+1, 409-1, 'SomeVarchar 409 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (410*2, 410+1, 410-1, 'SomeVarchar 410 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (411*2, 411+1, 411-1, 'SomeVarchar 411 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (412*2, 412+1, 412-1, 'SomeVarchar 412 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (413*2, 413+1, 413-1, 'SomeVarchar 413 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (414*2, 414+1, 414-1, 'SomeVarchar 414 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (415*2, 415+1, 415-1, 'SomeVarchar 415 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (416*2, 416+1, 416-1, 'SomeVarchar 416 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (417*2, 417+1, 417-1, 'SomeVarchar 417 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (418*2, 418+1, 418-1, 'SomeVarchar 418 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (419*2, 419+1, 419-1, 'SomeVarchar 419 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (420*2, 420+1, 420-1, 'SomeVarchar 420 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (421*2, 421+1, 421-1, 'SomeVarchar 421 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (422*2, 422+1, 422-1, 'SomeVarchar 422 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (423*2, 423+1, 423-1, 'SomeVarchar 423 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (424*2, 424+1, 424-1, 'SomeVarchar 424 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (425*2, 425+1, 425-1, 'SomeVarchar 425 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (426*2, 426+1, 426-1, 'SomeVarchar 426 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (427*2, 427+1, 427-1, 'SomeVarchar 427 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (428*2, 428+1, 428-1, 'SomeVarchar 428 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (429*2, 429+1, 429-1, 'SomeVarchar 429 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (430*2, 430+1, 430-1, 'SomeVarchar 430 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (431*2, 431+1, 431-1, 'SomeVarchar 431 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (432*2, 432+1, 432-1, 'SomeVarchar 432 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (433*2, 433+1, 433-1, 'SomeVarchar 433 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (434*2, 434+1, 434-1, 'SomeVarchar 434 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (435*2, 435+1, 435-1, 'SomeVarchar 435 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (436*2, 436+1, 436-1, 'SomeVarchar 436 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (437*2, 437+1, 437-1, 'SomeVarchar 437 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (438*2, 438+1, 438-1, 'SomeVarchar 438 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (439*2, 439+1, 439-1, 'SomeVarchar 439 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (440*2, 440+1, 440-1, 'SomeVarchar 440 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (441*2, 441+1, 441-1, 'SomeVarchar 441 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (442*2, 442+1, 442-1, 'SomeVarchar 442 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (443*2, 443+1, 443-1, 'SomeVarchar 443 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (444*2, 444+1, 444-1, 'SomeVarchar 444 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (445*2, 445+1, 445-1, 'SomeVarchar 445 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (446*2, 446+1, 446-1, 'SomeVarchar 446 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (447*2, 447+1, 447-1, 'SomeVarchar 447 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (448*2, 448+1, 448-1, 'SomeVarchar 448 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (449*2, 449+1, 449-1, 'SomeVarchar 449 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (450*2, 450+1, 450-1, 'SomeVarchar 450 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (451*2, 451+1, 451-1, 'SomeVarchar 451 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (452*2, 452+1, 452-1, 'SomeVarchar 452 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (453*2, 453+1, 453-1, 'SomeVarchar 453 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (454*2, 454+1, 454-1, 'SomeVarchar 454 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (455*2, 455+1, 455-1, 'SomeVarchar 455 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (456*2, 456+1, 456-1, 'SomeVarchar 456 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (457*2, 457+1, 457-1, 'SomeVarchar 457 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (458*2, 458+1, 458-1, 'SomeVarchar 458 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (459*2, 459+1, 459-1, 'SomeVarchar 459 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (460*2, 460+1, 460-1, 'SomeVarchar 460 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (461*2, 461+1, 461-1, 'SomeVarchar 461 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (462*2, 462+1, 462-1, 'SomeVarchar 462 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (463*2, 463+1, 463-1, 'SomeVarchar 463 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (464*2, 464+1, 464-1, 'SomeVarchar 464 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (465*2, 465+1, 465-1, 'SomeVarchar 465 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (466*2, 466+1, 466-1, 'SomeVarchar 466 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (467*2, 467+1, 467-1, 'SomeVarchar 467 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (468*2, 468+1, 468-1, 'SomeVarchar 468 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (469*2, 469+1, 469-1, 'SomeVarchar 469 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (470*2, 470+1, 470-1, 'SomeVarchar 470 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (471*2, 471+1, 471-1, 'SomeVarchar 471 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (472*2, 472+1, 472-1, 'SomeVarchar 472 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (473*2, 473+1, 473-1, 'SomeVarchar 473 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (474*2, 474+1, 474-1, 'SomeVarchar 474 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (475*2, 475+1, 475-1, 'SomeVarchar 475 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (476*2, 476+1, 476-1, 'SomeVarchar 476 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (477*2, 477+1, 477-1, 'SomeVarchar 477 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (478*2, 478+1, 478-1, 'SomeVarchar 478 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (479*2, 479+1, 479-1, 'SomeVarchar 479 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (480*2, 480+1, 480-1, 'SomeVarchar 480 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (481*2, 481+1, 481-1, 'SomeVarchar 481 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (482*2, 482+1, 482-1, 'SomeVarchar 482 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (483*2, 483+1, 483-1, 'SomeVarchar 483 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (484*2, 484+1, 484-1, 'SomeVarchar 484 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (485*2, 485+1, 485-1, 'SomeVarchar 485 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (486*2, 486+1, 486-1, 'SomeVarchar 486 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (487*2, 487+1, 487-1, 'SomeVarchar 487 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (488*2, 488+1, 488-1, 'SomeVarchar 488 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (489*2, 489+1, 489-1, 'SomeVarchar 489 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (490*2, 490+1, 490-1, 'SomeVarchar 490 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (491*2, 491+1, 491-1, 'SomeVarchar 491 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (492*2, 492+1, 492-1, 'SomeVarchar 492 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (493*2, 493+1, 493-1, 'SomeVarchar 493 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (494*2, 494+1, 494-1, 'SomeVarchar 494 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (495*2, 495+1, 495-1, 'SomeVarchar 495 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (496*2, 496+1, 496-1, 'SomeVarchar 496 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (497*2, 497+1, 497-1, 'SomeVarchar 497 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (498*2, 498+1, 498-1, 'SomeVarchar 498 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (499*2, 499+1, 499-1, 'SomeVarchar 499 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (500*2, 500+1, 500-1, 'SomeVarchar 500 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (501*2, 501+1, 501-1, 'SomeVarchar 501 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (502*2, 502+1, 502-1, 'SomeVarchar 502 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (503*2, 503+1, 503-1, 'SomeVarchar 503 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (504*2, 504+1, 504-1, 'SomeVarchar 504 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (505*2, 505+1, 505-1, 'SomeVarchar 505 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (506*2, 506+1, 506-1, 'SomeVarchar 506 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (507*2, 507+1, 507-1, 'SomeVarchar 507 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (508*2, 508+1, 508-1, 'SomeVarchar 508 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (509*2, 509+1, 509-1, 'SomeVarchar 509 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (510*2, 510+1, 510-1, 'SomeVarchar 510 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (511*2, 511+1, 511-1, 'SomeVarchar 511 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (512*2, 512+1, 512-1, 'SomeVarchar 512 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (513*2, 513+1, 513-1, 'SomeVarchar 513 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (514*2, 514+1, 514-1, 'SomeVarchar 514 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (515*2, 515+1, 515-1, 'SomeVarchar 515 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (516*2, 516+1, 516-1, 'SomeVarchar 516 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (517*2, 517+1, 517-1, 'SomeVarchar 517 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (518*2, 518+1, 518-1, 'SomeVarchar 518 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (519*2, 519+1, 519-1, 'SomeVarchar 519 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (520*2, 520+1, 520-1, 'SomeVarchar 520 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (521*2, 521+1, 521-1, 'SomeVarchar 521 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (522*2, 522+1, 522-1, 'SomeVarchar 522 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (523*2, 523+1, 523-1, 'SomeVarchar 523 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (524*2, 524+1, 524-1, 'SomeVarchar 524 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (525*2, 525+1, 525-1, 'SomeVarchar 525 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (526*2, 526+1, 526-1, 'SomeVarchar 526 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (527*2, 527+1, 527-1, 'SomeVarchar 527 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (528*2, 528+1, 528-1, 'SomeVarchar 528 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (529*2, 529+1, 529-1, 'SomeVarchar 529 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (530*2, 530+1, 530-1, 'SomeVarchar 530 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (531*2, 531+1, 531-1, 'SomeVarchar 531 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (532*2, 532+1, 532-1, 'SomeVarchar 532 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (533*2, 533+1, 533-1, 'SomeVarchar 533 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (534*2, 534+1, 534-1, 'SomeVarchar 534 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (535*2, 535+1, 535-1, 'SomeVarchar 535 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (536*2, 536+1, 536-1, 'SomeVarchar 536 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (537*2, 537+1, 537-1, 'SomeVarchar 537 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (538*2, 538+1, 538-1, 'SomeVarchar 538 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (539*2, 539+1, 539-1, 'SomeVarchar 539 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (540*2, 540+1, 540-1, 'SomeVarchar 540 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (541*2, 541+1, 541-1, 'SomeVarchar 541 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (542*2, 542+1, 542-1, 'SomeVarchar 542 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (543*2, 543+1, 543-1, 'SomeVarchar 543 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (544*2, 544+1, 544-1, 'SomeVarchar 544 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (545*2, 545+1, 545-1, 'SomeVarchar 545 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (546*2, 546+1, 546-1, 'SomeVarchar 546 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (547*2, 547+1, 547-1, 'SomeVarchar 547 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (548*2, 548+1, 548-1, 'SomeVarchar 548 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (549*2, 549+1, 549-1, 'SomeVarchar 549 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (550*2, 550+1, 550-1, 'SomeVarchar 550 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (551*2, 551+1, 551-1, 'SomeVarchar 551 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (552*2, 552+1, 552-1, 'SomeVarchar 552 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (553*2, 553+1, 553-1, 'SomeVarchar 553 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (554*2, 554+1, 554-1, 'SomeVarchar 554 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (555*2, 555+1, 555-1, 'SomeVarchar 555 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (556*2, 556+1, 556-1, 'SomeVarchar 556 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (557*2, 557+1, 557-1, 'SomeVarchar 557 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (558*2, 558+1, 558-1, 'SomeVarchar 558 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (559*2, 559+1, 559-1, 'SomeVarchar 559 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (560*2, 560+1, 560-1, 'SomeVarchar 560 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (561*2, 561+1, 561-1, 'SomeVarchar 561 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (562*2, 562+1, 562-1, 'SomeVarchar 562 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (563*2, 563+1, 563-1, 'SomeVarchar 563 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (564*2, 564+1, 564-1, 'SomeVarchar 564 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (565*2, 565+1, 565-1, 'SomeVarchar 565 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (566*2, 566+1, 566-1, 'SomeVarchar 566 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (567*2, 567+1, 567-1, 'SomeVarchar 567 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (568*2, 568+1, 568-1, 'SomeVarchar 568 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (569*2, 569+1, 569-1, 'SomeVarchar 569 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (570*2, 570+1, 570-1, 'SomeVarchar 570 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (571*2, 571+1, 571-1, 'SomeVarchar 571 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (572*2, 572+1, 572-1, 'SomeVarchar 572 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (573*2, 573+1, 573-1, 'SomeVarchar 573 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (574*2, 574+1, 574-1, 'SomeVarchar 574 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (575*2, 575+1, 575-1, 'SomeVarchar 575 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (576*2, 576+1, 576-1, 'SomeVarchar 576 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (577*2, 577+1, 577-1, 'SomeVarchar 577 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (578*2, 578+1, 578-1, 'SomeVarchar 578 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (579*2, 579+1, 579-1, 'SomeVarchar 579 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (580*2, 580+1, 580-1, 'SomeVarchar 580 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (581*2, 581+1, 581-1, 'SomeVarchar 581 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (582*2, 582+1, 582-1, 'SomeVarchar 582 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (583*2, 583+1, 583-1, 'SomeVarchar 583 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (584*2, 584+1, 584-1, 'SomeVarchar 584 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (585*2, 585+1, 585-1, 'SomeVarchar 585 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (586*2, 586+1, 586-1, 'SomeVarchar 586 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (587*2, 587+1, 587-1, 'SomeVarchar 587 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (588*2, 588+1, 588-1, 'SomeVarchar 588 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (589*2, 589+1, 589-1, 'SomeVarchar 589 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (590*2, 590+1, 590-1, 'SomeVarchar 590 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (591*2, 591+1, 591-1, 'SomeVarchar 591 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (592*2, 592+1, 592-1, 'SomeVarchar 592 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (593*2, 593+1, 593-1, 'SomeVarchar 593 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (594*2, 594+1, 594-1, 'SomeVarchar 594 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (595*2, 595+1, 595-1, 'SomeVarchar 595 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (596*2, 596+1, 596-1, 'SomeVarchar 596 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (597*2, 597+1, 597-1, 'SomeVarchar 597 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (598*2, 598+1, 598-1, 'SomeVarchar 598 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (599*2, 599+1, 599-1, 'SomeVarchar 599 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (600*2, 600+1, 600-1, 'SomeVarchar 600 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (601*2, 601+1, 601-1, 'SomeVarchar 601 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (602*2, 602+1, 602-1, 'SomeVarchar 602 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (603*2, 603+1, 603-1, 'SomeVarchar 603 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (604*2, 604+1, 604-1, 'SomeVarchar 604 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (605*2, 605+1, 605-1, 'SomeVarchar 605 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (606*2, 606+1, 606-1, 'SomeVarchar 606 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (607*2, 607+1, 607-1, 'SomeVarchar 607 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (608*2, 608+1, 608-1, 'SomeVarchar 608 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (609*2, 609+1, 609-1, 'SomeVarchar 609 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (610*2, 610+1, 610-1, 'SomeVarchar 610 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (611*2, 611+1, 611-1, 'SomeVarchar 611 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (612*2, 612+1, 612-1, 'SomeVarchar 612 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (613*2, 613+1, 613-1, 'SomeVarchar 613 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (614*2, 614+1, 614-1, 'SomeVarchar 614 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (615*2, 615+1, 615-1, 'SomeVarchar 615 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (616*2, 616+1, 616-1, 'SomeVarchar 616 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (617*2, 617+1, 617-1, 'SomeVarchar 617 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (618*2, 618+1, 618-1, 'SomeVarchar 618 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (619*2, 619+1, 619-1, 'SomeVarchar 619 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (620*2, 620+1, 620-1, 'SomeVarchar 620 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (621*2, 621+1, 621-1, 'SomeVarchar 621 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (622*2, 622+1, 622-1, 'SomeVarchar 622 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (623*2, 623+1, 623-1, 'SomeVarchar 623 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (624*2, 624+1, 624-1, 'SomeVarchar 624 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (625*2, 625+1, 625-1, 'SomeVarchar 625 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (626*2, 626+1, 626-1, 'SomeVarchar 626 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (627*2, 627+1, 627-1, 'SomeVarchar 627 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (628*2, 628+1, 628-1, 'SomeVarchar 628 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (629*2, 629+1, 629-1, 'SomeVarchar 629 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (630*2, 630+1, 630-1, 'SomeVarchar 630 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (631*2, 631+1, 631-1, 'SomeVarchar 631 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (632*2, 632+1, 632-1, 'SomeVarchar 632 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (633*2, 633+1, 633-1, 'SomeVarchar 633 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (634*2, 634+1, 634-1, 'SomeVarchar 634 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (635*2, 635+1, 635-1, 'SomeVarchar 635 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (636*2, 636+1, 636-1, 'SomeVarchar 636 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (637*2, 637+1, 637-1, 'SomeVarchar 637 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (638*2, 638+1, 638-1, 'SomeVarchar 638 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (639*2, 639+1, 639-1, 'SomeVarchar 639 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (640*2, 640+1, 640-1, 'SomeVarchar 640 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (641*2, 641+1, 641-1, 'SomeVarchar 641 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (642*2, 642+1, 642-1, 'SomeVarchar 642 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (643*2, 643+1, 643-1, 'SomeVarchar 643 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (644*2, 644+1, 644-1, 'SomeVarchar 644 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (645*2, 645+1, 645-1, 'SomeVarchar 645 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (646*2, 646+1, 646-1, 'SomeVarchar 646 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (647*2, 647+1, 647-1, 'SomeVarchar 647 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (648*2, 648+1, 648-1, 'SomeVarchar 648 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (649*2, 649+1, 649-1, 'SomeVarchar 649 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (650*2, 650+1, 650-1, 'SomeVarchar 650 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (651*2, 651+1, 651-1, 'SomeVarchar 651 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (652*2, 652+1, 652-1, 'SomeVarchar 652 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (653*2, 653+1, 653-1, 'SomeVarchar 653 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (654*2, 654+1, 654-1, 'SomeVarchar 654 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (655*2, 655+1, 655-1, 'SomeVarchar 655 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (656*2, 656+1, 656-1, 'SomeVarchar 656 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (657*2, 657+1, 657-1, 'SomeVarchar 657 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (658*2, 658+1, 658-1, 'SomeVarchar 658 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (659*2, 659+1, 659-1, 'SomeVarchar 659 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (660*2, 660+1, 660-1, 'SomeVarchar 660 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (661*2, 661+1, 661-1, 'SomeVarchar 661 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (662*2, 662+1, 662-1, 'SomeVarchar 662 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (663*2, 663+1, 663-1, 'SomeVarchar 663 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (664*2, 664+1, 664-1, 'SomeVarchar 664 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (665*2, 665+1, 665-1, 'SomeVarchar 665 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (666*2, 666+1, 666-1, 'SomeVarchar 666 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (667*2, 667+1, 667-1, 'SomeVarchar 667 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (668*2, 668+1, 668-1, 'SomeVarchar 668 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (669*2, 669+1, 669-1, 'SomeVarchar 669 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (670*2, 670+1, 670-1, 'SomeVarchar 670 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (671*2, 671+1, 671-1, 'SomeVarchar 671 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (672*2, 672+1, 672-1, 'SomeVarchar 672 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (673*2, 673+1, 673-1, 'SomeVarchar 673 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (674*2, 674+1, 674-1, 'SomeVarchar 674 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (675*2, 675+1, 675-1, 'SomeVarchar 675 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (676*2, 676+1, 676-1, 'SomeVarchar 676 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (677*2, 677+1, 677-1, 'SomeVarchar 677 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (678*2, 678+1, 678-1, 'SomeVarchar 678 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (679*2, 679+1, 679-1, 'SomeVarchar 679 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (680*2, 680+1, 680-1, 'SomeVarchar 680 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (681*2, 681+1, 681-1, 'SomeVarchar 681 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (682*2, 682+1, 682-1, 'SomeVarchar 682 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (683*2, 683+1, 683-1, 'SomeVarchar 683 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (684*2, 684+1, 684-1, 'SomeVarchar 684 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (685*2, 685+1, 685-1, 'SomeVarchar 685 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (686*2, 686+1, 686-1, 'SomeVarchar 686 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (687*2, 687+1, 687-1, 'SomeVarchar 687 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (688*2, 688+1, 688-1, 'SomeVarchar 688 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (689*2, 689+1, 689-1, 'SomeVarchar 689 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (690*2, 690+1, 690-1, 'SomeVarchar 690 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (691*2, 691+1, 691-1, 'SomeVarchar 691 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (692*2, 692+1, 692-1, 'SomeVarchar 692 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (693*2, 693+1, 693-1, 'SomeVarchar 693 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (694*2, 694+1, 694-1, 'SomeVarchar 694 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (695*2, 695+1, 695-1, 'SomeVarchar 695 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (696*2, 696+1, 696-1, 'SomeVarchar 696 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (697*2, 697+1, 697-1, 'SomeVarchar 697 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (698*2, 698+1, 698-1, 'SomeVarchar 698 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (699*2, 699+1, 699-1, 'SomeVarchar 699 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (700*2, 700+1, 700-1, 'SomeVarchar 700 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (701*2, 701+1, 701-1, 'SomeVarchar 701 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (702*2, 702+1, 702-1, 'SomeVarchar 702 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (703*2, 703+1, 703-1, 'SomeVarchar 703 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (704*2, 704+1, 704-1, 'SomeVarchar 704 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (705*2, 705+1, 705-1, 'SomeVarchar 705 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (706*2, 706+1, 706-1, 'SomeVarchar 706 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (707*2, 707+1, 707-1, 'SomeVarchar 707 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (708*2, 708+1, 708-1, 'SomeVarchar 708 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (709*2, 709+1, 709-1, 'SomeVarchar 709 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (710*2, 710+1, 710-1, 'SomeVarchar 710 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (711*2, 711+1, 711-1, 'SomeVarchar 711 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (712*2, 712+1, 712-1, 'SomeVarchar 712 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (713*2, 713+1, 713-1, 'SomeVarchar 713 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (714*2, 714+1, 714-1, 'SomeVarchar 714 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (715*2, 715+1, 715-1, 'SomeVarchar 715 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (716*2, 716+1, 716-1, 'SomeVarchar 716 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (717*2, 717+1, 717-1, 'SomeVarchar 717 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (718*2, 718+1, 718-1, 'SomeVarchar 718 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (719*2, 719+1, 719-1, 'SomeVarchar 719 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (720*2, 720+1, 720-1, 'SomeVarchar 720 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (721*2, 721+1, 721-1, 'SomeVarchar 721 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (722*2, 722+1, 722-1, 'SomeVarchar 722 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (723*2, 723+1, 723-1, 'SomeVarchar 723 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (724*2, 724+1, 724-1, 'SomeVarchar 724 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (725*2, 725+1, 725-1, 'SomeVarchar 725 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (726*2, 726+1, 726-1, 'SomeVarchar 726 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (727*2, 727+1, 727-1, 'SomeVarchar 727 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (728*2, 728+1, 728-1, 'SomeVarchar 728 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (729*2, 729+1, 729-1, 'SomeVarchar 729 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (730*2, 730+1, 730-1, 'SomeVarchar 730 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (731*2, 731+1, 731-1, 'SomeVarchar 731 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (732*2, 732+1, 732-1, 'SomeVarchar 732 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (733*2, 733+1, 733-1, 'SomeVarchar 733 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (734*2, 734+1, 734-1, 'SomeVarchar 734 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (735*2, 735+1, 735-1, 'SomeVarchar 735 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (736*2, 736+1, 736-1, 'SomeVarchar 736 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (737*2, 737+1, 737-1, 'SomeVarchar 737 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (738*2, 738+1, 738-1, 'SomeVarchar 738 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (739*2, 739+1, 739-1, 'SomeVarchar 739 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (740*2, 740+1, 740-1, 'SomeVarchar 740 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (741*2, 741+1, 741-1, 'SomeVarchar 741 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (742*2, 742+1, 742-1, 'SomeVarchar 742 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (743*2, 743+1, 743-1, 'SomeVarchar 743 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (744*2, 744+1, 744-1, 'SomeVarchar 744 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (745*2, 745+1, 745-1, 'SomeVarchar 745 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (746*2, 746+1, 746-1, 'SomeVarchar 746 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (747*2, 747+1, 747-1, 'SomeVarchar 747 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (748*2, 748+1, 748-1, 'SomeVarchar 748 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (749*2, 749+1, 749-1, 'SomeVarchar 749 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (750*2, 750+1, 750-1, 'SomeVarchar 750 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (751*2, 751+1, 751-1, 'SomeVarchar 751 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (752*2, 752+1, 752-1, 'SomeVarchar 752 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (753*2, 753+1, 753-1, 'SomeVarchar 753 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (754*2, 754+1, 754-1, 'SomeVarchar 754 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (755*2, 755+1, 755-1, 'SomeVarchar 755 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (756*2, 756+1, 756-1, 'SomeVarchar 756 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (757*2, 757+1, 757-1, 'SomeVarchar 757 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (758*2, 758+1, 758-1, 'SomeVarchar 758 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (759*2, 759+1, 759-1, 'SomeVarchar 759 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (760*2, 760+1, 760-1, 'SomeVarchar 760 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (761*2, 761+1, 761-1, 'SomeVarchar 761 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (762*2, 762+1, 762-1, 'SomeVarchar 762 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (763*2, 763+1, 763-1, 'SomeVarchar 763 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (764*2, 764+1, 764-1, 'SomeVarchar 764 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (765*2, 765+1, 765-1, 'SomeVarchar 765 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (766*2, 766+1, 766-1, 'SomeVarchar 766 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (767*2, 767+1, 767-1, 'SomeVarchar 767 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (768*2, 768+1, 768-1, 'SomeVarchar 768 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (769*2, 769+1, 769-1, 'SomeVarchar 769 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (770*2, 770+1, 770-1, 'SomeVarchar 770 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (771*2, 771+1, 771-1, 'SomeVarchar 771 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (772*2, 772+1, 772-1, 'SomeVarchar 772 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (773*2, 773+1, 773-1, 'SomeVarchar 773 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (774*2, 774+1, 774-1, 'SomeVarchar 774 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (775*2, 775+1, 775-1, 'SomeVarchar 775 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (776*2, 776+1, 776-1, 'SomeVarchar 776 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (777*2, 777+1, 777-1, 'SomeVarchar 777 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (778*2, 778+1, 778-1, 'SomeVarchar 778 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (779*2, 779+1, 779-1, 'SomeVarchar 779 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (780*2, 780+1, 780-1, 'SomeVarchar 780 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (781*2, 781+1, 781-1, 'SomeVarchar 781 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (782*2, 782+1, 782-1, 'SomeVarchar 782 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (783*2, 783+1, 783-1, 'SomeVarchar 783 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (784*2, 784+1, 784-1, 'SomeVarchar 784 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (785*2, 785+1, 785-1, 'SomeVarchar 785 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (786*2, 786+1, 786-1, 'SomeVarchar 786 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (787*2, 787+1, 787-1, 'SomeVarchar 787 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (788*2, 788+1, 788-1, 'SomeVarchar 788 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (789*2, 789+1, 789-1, 'SomeVarchar 789 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (790*2, 790+1, 790-1, 'SomeVarchar 790 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (791*2, 791+1, 791-1, 'SomeVarchar 791 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (792*2, 792+1, 792-1, 'SomeVarchar 792 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (793*2, 793+1, 793-1, 'SomeVarchar 793 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (794*2, 794+1, 794-1, 'SomeVarchar 794 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (795*2, 795+1, 795-1, 'SomeVarchar 795 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (796*2, 796+1, 796-1, 'SomeVarchar 796 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (797*2, 797+1, 797-1, 'SomeVarchar 797 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (798*2, 798+1, 798-1, 'SomeVarchar 798 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (799*2, 799+1, 799-1, 'SomeVarchar 799 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (800*2, 800+1, 800-1, 'SomeVarchar 800 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (801*2, 801+1, 801-1, 'SomeVarchar 801 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (802*2, 802+1, 802-1, 'SomeVarchar 802 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (803*2, 803+1, 803-1, 'SomeVarchar 803 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (804*2, 804+1, 804-1, 'SomeVarchar 804 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (805*2, 805+1, 805-1, 'SomeVarchar 805 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (806*2, 806+1, 806-1, 'SomeVarchar 806 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (807*2, 807+1, 807-1, 'SomeVarchar 807 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (808*2, 808+1, 808-1, 'SomeVarchar 808 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (809*2, 809+1, 809-1, 'SomeVarchar 809 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (810*2, 810+1, 810-1, 'SomeVarchar 810 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (811*2, 811+1, 811-1, 'SomeVarchar 811 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (812*2, 812+1, 812-1, 'SomeVarchar 812 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (813*2, 813+1, 813-1, 'SomeVarchar 813 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (814*2, 814+1, 814-1, 'SomeVarchar 814 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (815*2, 815+1, 815-1, 'SomeVarchar 815 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (816*2, 816+1, 816-1, 'SomeVarchar 816 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (817*2, 817+1, 817-1, 'SomeVarchar 817 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (818*2, 818+1, 818-1, 'SomeVarchar 818 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (819*2, 819+1, 819-1, 'SomeVarchar 819 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (820*2, 820+1, 820-1, 'SomeVarchar 820 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (821*2, 821+1, 821-1, 'SomeVarchar 821 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (822*2, 822+1, 822-1, 'SomeVarchar 822 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (823*2, 823+1, 823-1, 'SomeVarchar 823 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (824*2, 824+1, 824-1, 'SomeVarchar 824 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (825*2, 825+1, 825-1, 'SomeVarchar 825 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (826*2, 826+1, 826-1, 'SomeVarchar 826 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (827*2, 827+1, 827-1, 'SomeVarchar 827 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (828*2, 828+1, 828-1, 'SomeVarchar 828 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (829*2, 829+1, 829-1, 'SomeVarchar 829 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (830*2, 830+1, 830-1, 'SomeVarchar 830 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (831*2, 831+1, 831-1, 'SomeVarchar 831 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (832*2, 832+1, 832-1, 'SomeVarchar 832 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (833*2, 833+1, 833-1, 'SomeVarchar 833 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (834*2, 834+1, 834-1, 'SomeVarchar 834 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (835*2, 835+1, 835-1, 'SomeVarchar 835 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (836*2, 836+1, 836-1, 'SomeVarchar 836 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (837*2, 837+1, 837-1, 'SomeVarchar 837 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (838*2, 838+1, 838-1, 'SomeVarchar 838 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (839*2, 839+1, 839-1, 'SomeVarchar 839 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (840*2, 840+1, 840-1, 'SomeVarchar 840 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (841*2, 841+1, 841-1, 'SomeVarchar 841 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (842*2, 842+1, 842-1, 'SomeVarchar 842 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (843*2, 843+1, 843-1, 'SomeVarchar 843 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (844*2, 844+1, 844-1, 'SomeVarchar 844 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (845*2, 845+1, 845-1, 'SomeVarchar 845 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (846*2, 846+1, 846-1, 'SomeVarchar 846 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (847*2, 847+1, 847-1, 'SomeVarchar 847 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (848*2, 848+1, 848-1, 'SomeVarchar 848 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (849*2, 849+1, 849-1, 'SomeVarchar 849 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (850*2, 850+1, 850-1, 'SomeVarchar 850 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (851*2, 851+1, 851-1, 'SomeVarchar 851 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (852*2, 852+1, 852-1, 'SomeVarchar 852 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (853*2, 853+1, 853-1, 'SomeVarchar 853 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (854*2, 854+1, 854-1, 'SomeVarchar 854 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (855*2, 855+1, 855-1, 'SomeVarchar 855 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (856*2, 856+1, 856-1, 'SomeVarchar 856 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (857*2, 857+1, 857-1, 'SomeVarchar 857 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (858*2, 858+1, 858-1, 'SomeVarchar 858 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (859*2, 859+1, 859-1, 'SomeVarchar 859 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (860*2, 860+1, 860-1, 'SomeVarchar 860 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (861*2, 861+1, 861-1, 'SomeVarchar 861 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (862*2, 862+1, 862-1, 'SomeVarchar 862 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (863*2, 863+1, 863-1, 'SomeVarchar 863 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (864*2, 864+1, 864-1, 'SomeVarchar 864 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (865*2, 865+1, 865-1, 'SomeVarchar 865 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (866*2, 866+1, 866-1, 'SomeVarchar 866 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (867*2, 867+1, 867-1, 'SomeVarchar 867 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (868*2, 868+1, 868-1, 'SomeVarchar 868 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (869*2, 869+1, 869-1, 'SomeVarchar 869 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (870*2, 870+1, 870-1, 'SomeVarchar 870 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (871*2, 871+1, 871-1, 'SomeVarchar 871 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (872*2, 872+1, 872-1, 'SomeVarchar 872 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (873*2, 873+1, 873-1, 'SomeVarchar 873 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (874*2, 874+1, 874-1, 'SomeVarchar 874 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (875*2, 875+1, 875-1, 'SomeVarchar 875 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (876*2, 876+1, 876-1, 'SomeVarchar 876 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (877*2, 877+1, 877-1, 'SomeVarchar 877 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (878*2, 878+1, 878-1, 'SomeVarchar 878 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (879*2, 879+1, 879-1, 'SomeVarchar 879 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (880*2, 880+1, 880-1, 'SomeVarchar 880 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (881*2, 881+1, 881-1, 'SomeVarchar 881 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (882*2, 882+1, 882-1, 'SomeVarchar 882 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (883*2, 883+1, 883-1, 'SomeVarchar 883 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (884*2, 884+1, 884-1, 'SomeVarchar 884 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (885*2, 885+1, 885-1, 'SomeVarchar 885 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (886*2, 886+1, 886-1, 'SomeVarchar 886 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (887*2, 887+1, 887-1, 'SomeVarchar 887 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (888*2, 888+1, 888-1, 'SomeVarchar 888 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (889*2, 889+1, 889-1, 'SomeVarchar 889 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (890*2, 890+1, 890-1, 'SomeVarchar 890 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (891*2, 891+1, 891-1, 'SomeVarchar 891 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (892*2, 892+1, 892-1, 'SomeVarchar 892 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (893*2, 893+1, 893-1, 'SomeVarchar 893 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (894*2, 894+1, 894-1, 'SomeVarchar 894 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (895*2, 895+1, 895-1, 'SomeVarchar 895 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (896*2, 896+1, 896-1, 'SomeVarchar 896 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (897*2, 897+1, 897-1, 'SomeVarchar 897 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (898*2, 898+1, 898-1, 'SomeVarchar 898 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (899*2, 899+1, 899-1, 'SomeVarchar 899 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (900*2, 900+1, 900-1, 'SomeVarchar 900 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (901*2, 901+1, 901-1, 'SomeVarchar 901 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (902*2, 902+1, 902-1, 'SomeVarchar 902 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (903*2, 903+1, 903-1, 'SomeVarchar 903 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (904*2, 904+1, 904-1, 'SomeVarchar 904 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (905*2, 905+1, 905-1, 'SomeVarchar 905 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (906*2, 906+1, 906-1, 'SomeVarchar 906 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (907*2, 907+1, 907-1, 'SomeVarchar 907 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (908*2, 908+1, 908-1, 'SomeVarchar 908 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (909*2, 909+1, 909-1, 'SomeVarchar 909 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (910*2, 910+1, 910-1, 'SomeVarchar 910 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (911*2, 911+1, 911-1, 'SomeVarchar 911 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (912*2, 912+1, 912-1, 'SomeVarchar 912 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (913*2, 913+1, 913-1, 'SomeVarchar 913 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (914*2, 914+1, 914-1, 'SomeVarchar 914 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (915*2, 915+1, 915-1, 'SomeVarchar 915 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (916*2, 916+1, 916-1, 'SomeVarchar 916 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (917*2, 917+1, 917-1, 'SomeVarchar 917 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (918*2, 918+1, 918-1, 'SomeVarchar 918 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (919*2, 919+1, 919-1, 'SomeVarchar 919 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (920*2, 920+1, 920-1, 'SomeVarchar 920 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (921*2, 921+1, 921-1, 'SomeVarchar 921 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (922*2, 922+1, 922-1, 'SomeVarchar 922 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (923*2, 923+1, 923-1, 'SomeVarchar 923 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (924*2, 924+1, 924-1, 'SomeVarchar 924 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (925*2, 925+1, 925-1, 'SomeVarchar 925 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (926*2, 926+1, 926-1, 'SomeVarchar 926 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (927*2, 927+1, 927-1, 'SomeVarchar 927 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (928*2, 928+1, 928-1, 'SomeVarchar 928 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (929*2, 929+1, 929-1, 'SomeVarchar 929 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (930*2, 930+1, 930-1, 'SomeVarchar 930 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (931*2, 931+1, 931-1, 'SomeVarchar 931 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (932*2, 932+1, 932-1, 'SomeVarchar 932 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (933*2, 933+1, 933-1, 'SomeVarchar 933 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (934*2, 934+1, 934-1, 'SomeVarchar 934 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (935*2, 935+1, 935-1, 'SomeVarchar 935 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (936*2, 936+1, 936-1, 'SomeVarchar 936 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (937*2, 937+1, 937-1, 'SomeVarchar 937 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (938*2, 938+1, 938-1, 'SomeVarchar 938 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (939*2, 939+1, 939-1, 'SomeVarchar 939 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (940*2, 940+1, 940-1, 'SomeVarchar 940 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (941*2, 941+1, 941-1, 'SomeVarchar 941 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (942*2, 942+1, 942-1, 'SomeVarchar 942 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (943*2, 943+1, 943-1, 'SomeVarchar 943 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (944*2, 944+1, 944-1, 'SomeVarchar 944 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (945*2, 945+1, 945-1, 'SomeVarchar 945 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (946*2, 946+1, 946-1, 'SomeVarchar 946 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (947*2, 947+1, 947-1, 'SomeVarchar 947 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (948*2, 948+1, 948-1, 'SomeVarchar 948 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (949*2, 949+1, 949-1, 'SomeVarchar 949 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (950*2, 950+1, 950-1, 'SomeVarchar 950 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (951*2, 951+1, 951-1, 'SomeVarchar 951 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (952*2, 952+1, 952-1, 'SomeVarchar 952 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (953*2, 953+1, 953-1, 'SomeVarchar 953 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (954*2, 954+1, 954-1, 'SomeVarchar 954 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (955*2, 955+1, 955-1, 'SomeVarchar 955 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (956*2, 956+1, 956-1, 'SomeVarchar 956 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (957*2, 957+1, 957-1, 'SomeVarchar 957 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (958*2, 958+1, 958-1, 'SomeVarchar 958 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (959*2, 959+1, 959-1, 'SomeVarchar 959 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (960*2, 960+1, 960-1, 'SomeVarchar 960 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (961*2, 961+1, 961-1, 'SomeVarchar 961 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (962*2, 962+1, 962-1, 'SomeVarchar 962 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (963*2, 963+1, 963-1, 'SomeVarchar 963 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (964*2, 964+1, 964-1, 'SomeVarchar 964 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (965*2, 965+1, 965-1, 'SomeVarchar 965 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (966*2, 966+1, 966-1, 'SomeVarchar 966 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (967*2, 967+1, 967-1, 'SomeVarchar 967 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (968*2, 968+1, 968-1, 'SomeVarchar 968 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (969*2, 969+1, 969-1, 'SomeVarchar 969 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (970*2, 970+1, 970-1, 'SomeVarchar 970 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (971*2, 971+1, 971-1, 'SomeVarchar 971 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (972*2, 972+1, 972-1, 'SomeVarchar 972 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (973*2, 973+1, 973-1, 'SomeVarchar 973 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (974*2, 974+1, 974-1, 'SomeVarchar 974 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (975*2, 975+1, 975-1, 'SomeVarchar 975 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (976*2, 976+1, 976-1, 'SomeVarchar 976 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (977*2, 977+1, 977-1, 'SomeVarchar 977 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (978*2, 978+1, 978-1, 'SomeVarchar 978 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (979*2, 979+1, 979-1, 'SomeVarchar 979 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (980*2, 980+1, 980-1, 'SomeVarchar 980 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (981*2, 981+1, 981-1, 'SomeVarchar 981 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (982*2, 982+1, 982-1, 'SomeVarchar 982 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (983*2, 983+1, 983-1, 'SomeVarchar 983 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (984*2, 984+1, 984-1, 'SomeVarchar 984 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (985*2, 985+1, 985-1, 'SomeVarchar 985 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (986*2, 986+1, 986-1, 'SomeVarchar 986 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (987*2, 987+1, 987-1, 'SomeVarchar 987 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (988*2, 988+1, 988-1, 'SomeVarchar 988 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (989*2, 989+1, 989-1, 'SomeVarchar 989 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (990*2, 990+1, 990-1, 'SomeVarchar 990 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (991*2, 991+1, 991-1, 'SomeVarchar 991 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (992*2, 992+1, 992-1, 'SomeVarchar 992 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (993*2, 993+1, 993-1, 'SomeVarchar 993 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (994*2, 994+1, 994-1, 'SomeVarchar 994 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (995*2, 995+1, 995-1, 'SomeVarchar 995 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (996*2, 996+1, 996-1, 'SomeVarchar 996 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (997*2, 997+1, 997-1, 'SomeVarchar 997 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (998*2, 998+1, 998-1, 'SomeVarchar 998 for testing');
+INSERT INTO t3 (b, c, d, e) VALUES (999*2, 999+1, 999-1, 'SomeVarchar 999 for testing');
+#-------- Testing implicit ONLINE --------#
+ALTER TABLE t1 ADD INDEX ix_b (b);
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+DROP INDEX ix_b ON t1;
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+CREATE INDEX ix_c ON t1 (c);
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+DROP INDEX ix_c ON t1;
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+ALTER TABLE t3 ADD INDEX ix_b (b);
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+SELECT * from t3 where b > 555 ORDER BY a LIMIT 5;
+a b c d e
+279 556 279 277 SomeVarchar 278 for testing
+280 558 280 278 SomeVarchar 279 for testing
+281 560 281 279 SomeVarchar 280 for testing
+282 562 282 280 SomeVarchar 281 for testing
+283 564 283 281 SomeVarchar 282 for testing
+affected rows: 5
+DROP INDEX ix_b ON t3;
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+#-------- Testing implicit OFFLINE --------#
+ALTER TABLE t3 ADD INDEX ix_c (c);
+affected rows: 1000
+info: Records: 1000 Duplicates: 0 Warnings: 0
+DROP INDEX ix_c ON t3;
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+ALTER TABLE t3 ADD INDEX ix_cd (c, d);
+affected rows: 1000
+info: Records: 1000 Duplicates: 0 Warnings: 0
+DROP INDEX ix_cd ON t3;
+affected rows: 0
+info: Records: 0 Duplicates: 0 Warnings: 0
+#-------- Testing ONLINE keyword --------#
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b);
+ALTER ONLINE TABLE t1 DROP INDEX ix_b;
+ALTER ONLINE TABLE t1 ADD KEY ix_b (b);
+ALTER ONLINE TABLE t1 DROP KEY ix_b;
+CREATE ONLINE INDEX ix_c ON t1 (c);
+DROP ONLINE INDEX ix_c ON t1;
+ALTER ONLINE TABLE t3 ADD INDEX ix_b (b);
+SELECT * from t3 where b > 555 ORDER BY a LIMIT 5;
+a b c d e
+279 556 279 277 SomeVarchar 278 for testing
+280 558 280 278 SomeVarchar 279 for testing
+281 560 281 279 SomeVarchar 280 for testing
+282 562 282 280 SomeVarchar 281 for testing
+283 564 283 281 SomeVarchar 282 for testing
+ALTER ONLINE TABLE t3 DROP INDEX ix_b;
+ALTER ONLINE TABLE t3 ADD INDEX ix_c (c);
+ERROR 42000: This version of MySQL doesn't yet support 'ALTER ONLINE TABLE t3 ADD INDEX
ix_c (c)'
+ALTER ONLINE TABLE t3 ADD INDEX ix_d (d);
+ERROR 42000: This version of MySQL doesn't yet support 'ALTER ONLINE TABLE t3 ADD INDEX
ix_d (d)'
+#-------- Test: UNIQUE --------#
+ALTER ONLINE TABLE t2 ADD INDEX ix_unique_c (c);
+EXPLAIN SELECT * FROM t2 WHERE c < 25 AND c > 20 ORDER BY c;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t2 range ix_unique_c ix_unique_c 5 NULL 11 Using where; Using filesort
+SELECT * FROM t2 WHERE c < 25 AND c > 20 ORDER BY c;
+a b c d
+20 40 21 SomeString 20 for testing
+21 42 22 SomeString 21 for testing
+22 44 23 SomeString 22 for testing
+23 46 24 SomeString 23 for testing
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a NULL 16 NULL NULL BTREE
+t2 1 ix_unique_c 1 c NULL 16 NULL NULL YES BTREE
+DESCRIBE t2;
+Field Type Null Key Default Extra
+a int(11) NO PRI NULL
+b int(11) YES NULL
+c int(11) YES MUL NULL
+d varchar(65) YES NULL
+DROP ONLINE INDEX ix_unique_c ON t2;
+#-------- Test: DESC --------#
+ALTER ONLINE TABLE t3 ADD INDEX ix_desc_b (b DESC);
+ALTER ONLINE TABLE t3 ADD INDEX ix_asc_b (b ASC);
+SHOW INDEXES FROM t3;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t3 0 PRIMARY 1 a NULL 500 NULL NULL BTREE
+t3 1 ix_desc_b 1 b NULL 500 NULL NULL YES BTREE
+t3 1 ix_asc_b 1 b NULL 500 NULL NULL YES BTREE
+DROP ONLINE INDEX ix_desc_b ON t3;
+DROP ONLINE INDEX ix_asc_b ON t3;
+#-------- Test: KEY_BLOCK_SIZE --------#
+ALTER ONLINE TABLE t1 ADD INDEX ix_keyblock_b (b) KEY_BLOCK_SIZE = 0;
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 range ix_keyblock_b ix_keyblock_b 258 NULL 2 Using where; Using filesort
+SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+a b c d
+1 TestRow1 2 Char1
+10 TestRow10 20 Char10
+11 TestRow11 22 Char11
+12 TestRow12 24 Char12
+13 TestRow13 26 Char13
+14 TestRow14 28 Char14
+15 TestRow15 30 Char15
+16 TestRow16 32 Char16
+17 TestRow17 34 Char17
+18 TestRow18 36 Char18
+19 TestRow19 38 Char19
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 ix_keyblock_b 1 b NULL 10 NULL NULL YES BTREE
+ALTER ONLINE TABLE t1 DROP INDEX ix_keyblock_b;
+#-------- Test: COMMENT --------#
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b) COMMENT 'Test comment';
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 range ix_b ix_b 258 NULL 2 Using where; Using filesort
+SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+a b c d
+1 TestRow1 2 Char1
+10 TestRow10 20 Char10
+11 TestRow11 22 Char11
+12 TestRow12 24 Char12
+13 TestRow13 26 Char13
+14 TestRow14 28 Char14
+15 TestRow15 30 Char15
+16 TestRow16 32 Char16
+17 TestRow17 34 Char17
+18 TestRow18 36 Char18
+19 TestRow19 38 Char19
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 ix_b 1 b NULL 10 NULL NULL YES BTREE Test comment
+ALTER ONLINE TABLE t1 DROP INDEX ix_b;
+#-------- Test: Multiple columns --------#
+ALTER ONLINE TABLE t1 ADD INDEX index_multicol (b, c, d);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 index_multicol 1 b NULL 2 NULL NULL YES BTREE
+t1 1 index_multicol 2 c NULL 5 NULL NULL YES BTREE
+t1 1 index_multicol 3 d NULL 10 NULL NULL YES BTREE
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow3%' AND c = 6 ORDER BY b, c, d;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 range index_multicol index_multicol 263 NULL 2 Using where; Using filesort
+SELECT * FROM t1 WHERE b LIKE 'TestRow3%' AND c = 6 ORDER BY b, c, d;
+a b c d
+3 TestRow3 6 Char3
+DROP INDEX index_multicol ON t1;
+#-------- Test: Multiple ADD INDEX on same column --------#
+ALTER ONLINE TABLE t1 ADD INDEX index_1d (d);
+ALTER ONLINE TABLE t1 ADD INDEX index_2d (d);
+CREATE ONLINE INDEX index_3d ON t1 (d);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 index_1d 1 d NULL 10 NULL NULL YES BTREE
+t1 1 index_2d 1 d NULL 10 NULL NULL YES BTREE
+t1 1 index_3d 1 d NULL 10 NULL NULL YES BTREE
+DROP ONLINE INDEX index_1d ON t1;
+DROP ONLINE INDEX index_2d ON t1;
+DROP ONLINE INDEX index_3d ON t1;
+#-------- Test: Multiple ADD INDEX in a single statement --------#
+ALTER TABLE t1
+ADD INDEX index_varchar (b),
+ADD INDEX index_int (c);
+ALTER TABLE t3
+ADD INDEX index_int (b),
+ADD INDEX index_multi (b,e),
+ADD INDEX index_varchar (e);
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 index_varchar 1 b NULL 10 NULL NULL YES BTREE
+t1 1 index_int 1 c NULL 10 NULL NULL YES BTREE
+SHOW INDEXES FROM t3;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t3 0 PRIMARY 1 a NULL 500 NULL NULL BTREE
+t3 1 index_int 1 b NULL 500 NULL NULL YES BTREE
+t3 1 index_multi 1 b NULL 250 NULL NULL YES BTREE
+t3 1 index_multi 2 e NULL 500 NULL NULL YES BTREE
+t3 1 index_varchar 1 e NULL 500 NULL NULL YES BTREE
+#-------- Test: Multiple DROP INDEX in a single statement --------#
+ALTER TABLE t1
+DROP INDEX index_varchar,
+DROP INDEX index_int;
+ALTER TABLE t3
+DROP INDEX index_int,
+DROP INDEX index_multi,
+DROP INDEX index_varchar;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+SHOW INDEXES FROM t3;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t3 0 PRIMARY 1 a NULL 500 NULL NULL BTREE
+#-------- Test: Combined ADD/DROP INDEX in a single statement --------#
+ALTER TABLE t1 ADD INDEX index_int (c);
+ALTER TABLE t1 ADD INDEX index_char (d), DROP INDEX index_int;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+t1 1 index_char 1 d NULL 10 NULL NULL YES BTREE
+ALTER TABLE t1 DROP INDEX index_char;
+#-------- Test: ADD INDEX followed by some complex queries --------#
+ALTER TABLE t1 ADD INDEX ix_a (a);
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b);
+ALTER ONLINE TABLE t1 ADD INDEX ix_c (c);
+ALTER ONLINE TABLE t2
+ADD INDEX ix_b (b),
+ADD INDEX ix_d (d);
+ALTER ONLINE TABLE t3 ADD INDEX ix_b (b);
+EXPLAIN SELECT * FROM t1 WHERE a = 3 OR (c > 10 AND a < 15) ORDER BY a;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 range PRIMARY,ix_a,ix_c PRIMARY 4 NULL 20 Using where; Using filesort
+SELECT * FROM t1 WHERE a = 3 OR (c > 10 AND a < 15) ORDER BY a;
+a b c d
+3 TestRow3 6 Char3
+6 TestRow6 12 Char6
+7 TestRow7 14 Char7
+8 TestRow8 16 Char8
+9 TestRow9 18 Char9
+10 TestRow10 20 Char10
+11 TestRow11 22 Char11
+12 TestRow12 24 Char12
+13 TestRow13 26 Char13
+14 TestRow14 28 Char14
+EXPLAIN SELECT * FROM t1 WHERE a = 99 OR b LIKE 'TestRow7%';
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 index_merge PRIMARY,ix_a,ix_b PRIMARY,ix_b 4,258 NULL 3 Using
sort_union(PRIMARY,ix_b); Using where
+SELECT * FROM t1 WHERE a = 99 OR b LIKE 'TestRow7%';
+a b c d
+7 TestRow7 14 Char7
+EXPLAIN SELECT * FROM t1 WHERE (a = 10 OR b LIKE 'TestRow11') AND d LIKE 'Char%' ORDER BY
a;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 index_merge PRIMARY,ix_a,ix_b PRIMARY,ix_b 4,258 NULL 3 Using
sort_union(PRIMARY,ix_b); Using where; Using filesort
+SELECT * FROM t1 WHERE (a = 10 OR b LIKE 'TestRow11') AND d LIKE 'Char%' ORDER BY a;
+a b c d
+10 TestRow10 20 Char10
+11 TestRow11 22 Char11
+EXPLAIN SELECT * FROM t1, t2 WHERE (t1.a IN (1,2) OR t1.b LIKE 'TestRow1%') AND
t1.c=t2.c;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 index_merge PRIMARY,ix_a,ix_b,ix_c PRIMARY,ix_b 4,258 NULL 4 Using
sort_union(PRIMARY,ix_b); Using where
+1 SIMPLE t2 ALL NULL NULL NULL NULL 33 Using where; Using join buffer
+SELECT * FROM t1, t2 WHERE (t1.a IN (1,2) OR t1.b LIKE 'TestRow1%') AND t1.c=t2.c;
+a b c d a b c d
+1 TestRow1 2 Char1 1 2 2 SomeString 1 for testing
+2 TestRow2 4 Char2 3 6 4 SomeString 3 for testing
+10 TestRow10 20 Char10 19 38 20 SomeString 19 for testing
+11 TestRow11 22 Char11 21 42 22 SomeString 21 for testing
+12 TestRow12 24 Char12 23 46 24 SomeString 23 for testing
+13 TestRow13 26 Char13 25 50 26 SomeString 25 for testing
+14 TestRow14 28 Char14 27 54 28 SomeString 27 for testing
+15 TestRow15 30 Char15 29 58 30 SomeString 29 for testing
+16 TestRow16 32 Char16 31 62 32 SomeString 31 for testing
+EXPLAIN SELECT * FROM t1, t3 WHERE t3.b=2 AND (t1.c = t3.c OR t1.a=t3.d);
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t3 ref ix_b ix_b 5 const 100
+1 SIMPLE t1 ALL PRIMARY,ix_a,ix_c NULL NULL NULL 20 Range checked for each record (index
map: 0xB)
+SELECT * FROM t1, t3 WHERE t3.b=2 AND (t1.c = t3.c OR t1.a=t3.d);
+a b c d a b c d e
+0 TestRow0 0 Char0 2 2 2 0 SomeVarchar 1 for testing
+1 TestRow1 2 Char1 2 2 2 0 SomeVarchar 1 for testing
+ALTER ONLINE TABLE t1
+DROP INDEX ix_a,
+DROP INDEX ix_b,
+DROP INDEX ix_c;
+ALTER ONLINE TABLE t2
+DROP INDEX ix_b,
+DROP INDEX ix_d;
+ALTER ONLINE TABLE t3 DROP INDEX ix_b;
+SHOW INDEXES FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t1 0 PRIMARY 1 a NULL 10 NULL NULL BTREE
+SHOW INDEXES FROM t2;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t2 0 PRIMARY 1 a NULL 16 NULL NULL BTREE
+SHOW INDEXES FROM t3;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
+t3 0 PRIMARY 1 a NULL 500 NULL NULL BTREE
+DROP TABLE t1;
+DROP TABLE t2;
+DROP TABLE t3;
=== added file 'mysql-test/suite/falcon/t/falcon_index_datatypes.test'
--- a/mysql-test/suite/falcon/t/falcon_index_datatypes.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_index_datatypes.test 2008-09-04 18:38:48 +0000
@@ -0,0 +1,407 @@
+--source include/have_falcon.inc
+
+#
+# Test for ADD/DROP INDEX.
+#
+# ONLINE ADD/DROP is part of Worklog 4048, and is implicit.
+# Hence, this test will test ONLINE ADD/DROP INDEX if
+# it is supported by the engine. Otherwise, OFFLINE ADD/DROP
+# is used. See also falcon_online_index test.
+#
+# Note:
+# By using --enable_info command we can check if default
+# ALTER TABLE ... ADD INDEX is online or offline.
+# If ONLINE, affected rows is always 0.
+# If OFFLINE, and the table is non-empty, affected rows is > 0, since the
+# ALTER involved a table copy.
+#
+# This test is focusing on adding/dropping indexes to/from columns of various
+# data types.
+
+# ----------------------------------------------------- #
+# --- Initialisation --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+--enable_warnings
+
+##
+## Should test adding/dropping index for as many supported datatypes as
+## possible.
+##
+## Falcon does not support indexes on the types BLOB, MEDIUMBLOB, LONGBLOB
+## and TEXT. Falcon (supposedly) supports TINYBLOB indexes (because
+## TINYBLOB is mapped to VARCHAR), but this distinction is not visible from
+## the MySQL server.
+##
+## BIT type is handled differently than the rest, as it requires special
+## treatment in SELECTs for the output to be readable.
+##
+## Omitting synonym types. Using mostly default settings.
+##
+## Default CREATE clauses for TIMESTAMP columns are
+## "NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP".
+## To avoid having to filter out ever-changing timestamps, we are using
+## "NOT NULL DEFAULT 0" instead.
+##
+
+
+CREATE TABLE t1 (
+ a_int INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ a_tinyint TINYINT,
+ a_bigint BIGINT,
+ a_float FLOAT,
+ a_double DOUBLE,
+ a_decimal DECIMAL(10,2),
+ a_date DATE,
+ a_time TIME,
+ a_datetime DATETIME,
+ a_timestamp TIMESTAMP NOT NULL DEFAULT 0,
+ a_year YEAR,
+ a_char CHAR(10),
+ a_varchar VARCHAR(255),
+ a_binary BINARY(8),
+ a_varbinary VARBINARY(255),
+ a_enum ENUM('enumValueOne', 'enumValueTwo', 'enumValueThree')
+);
+
+SHOW CREATE TABLE t1;
+
+## BITs are special (binary), hence a separate table t2 so that we can do
+## simple SELECT * on t1.
+
+CREATE TABLE t2 (
+ a_int INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ a_bit BIT(8));
+
+SHOW CREATE TABLE t2;
+
+## Insert some example values. Should have 5 or more values to test LIMIT
+## with indexes. Values may start at either max or min, but are basically
+## randomly chosen (but sortable by humans).
+
+INSERT INTO t1 (
+ a_tinyint, a_bigint,
+ a_float, a_double, a_decimal, a_date,
+ a_time, a_datetime, a_timestamp, a_year,
+ a_char, a_varchar, a_binary, a_varbinary,
+ a_enum)
+ VALUES
+ (
+ 127, 9223372036854775807,
+ 999.99, 999.123456789, 111.99, '2008-07-09',
+ '11:30:00', '2008-07-09 11:30:00', '2008-07-09 11:30:00', '2008',
+ 'aTestChar', 'aTestVarChar', 'aTestBin', 'aTestVarBinary',
+ 'enumValueOne'
+ ),
+ (
+ 126, 9223372036854775806,
+ 998.88, 999.234567891, 112.00, '2008-07-10',
+ '12:30:10', '2008-07-10 12:30:10', '2008-07-10 12:30:10', '2009',
+ 'bTestChar', 'bTestVarChar', 'bTestBin', 'bTestVarBinary',
+ 'enumValueTwo'
+ ),
+ (
+ 125, 9223372036854775805,
+ 997.77, 999.345678912, 112.01, '2008-07-11',
+ '13:30:20', '2008-07-11 13:30:20', '2008-07-11 13:30:20', '2010',
+ 'cTestChar', 'cTestVarChar', 'cTestBin', 'cTestVarBinary',
+ 'enumValueThree'
+ ),
+ (
+ 124, 9223372036854775804,
+ 996.66, 999.456789123, 112.02, '2008-07-12',
+ '14:30:30', '2008-07-12 14:30:30', '2008-07-12 14:30:30', '2011',
+ 'dTestChar', 'dTestVarChar', 'dTestBin', 'dTestVarBinary',
+ 'enumValueOne'
+ ),
+ (
+ 123, 9223372036854775803,
+ 995.55, 999.567891234, 112.03, '2008-07-13',
+ '15:30:40', '2008-07-13 15:30:40', '2008-07-13 15:30:40', '2012',
+ 'eTestChar', 'eTestVarChar', 'eTestBin', 'eTestVarBinary',
+ 'enumValueTwo'
+ );
+
+INSERT INTO t2 (a_bit) VALUES (b'0'), (b'1'), (b'10'), (b'11'), (b'100');
+
+# ----------------------------------------------------- #
+# --- Test --- #
+# ----------------------------------------------------- #
+
+SELECT * FROM t1;
+SELECT a_int, BIN(a_bit+0) FROM t2;
+
+## Using the following procedure for each non-indexed data type/column:
+## 1. Add INDEX for the specific column
+## 2. Check index metadata (Falcon and server and user must agree)
+## 3. Insert new value in indexed column
+## 4. Update a value in indexed column
+## 4. Check that all values are still there
+## 5. Use a LIMIT query to excercise alternative index implementation
+## 6. Add additional index on the same column
+## 7. Drop newly added INDEX for the specified column
+## 8. Check index metadata (Falcon and server and user must agree)
+## 9. Check that the values are still there
+
+--echo #-------- Test: BIT --------#
+
+## BIT column, t2:
+ALTER TABLE t2 ADD INDEX index_bit (a_bit);
+SHOW INDEXES FROM t2;
+INSERT INTO t2 SET a_bit = b'11111';
+UPDATE t2 SET a_bit = b'101010' where a_int > b'101';
+SELECT a_int, BIN(a_bit+0) FROM t2;
+SELECT a_int, BIN(a_bit+0) FROM t2 WHERE a_bit > b'1' LIMIT 1;
+ALTER TABLE t2 DROP INDEX index_bit;
+SHOW INDEXES FROM t2;
+SELECT a_int, BIN(a_bit+0) FROM t2;
+
+--echo #-------- Test: TINYINT --------#
+
+ALTER TABLE t1 ADD INDEX index_tinyint (a_tinyint);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_tinyint = 99;
+UPDATE t1 SET a_tinyint = 88 where a_tinyint = 99;
+SELECT * FROM t1 ORDER BY a_tinyint;
+SELECT * FROM t1 WHERE a_tinyint > 1 LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_tinyint;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: BIGINT --------#
+
+ALTER TABLE t1 ADD INDEX index_bigint (a_bigint);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_bigint = 9223372036854775804;
+UPDATE t1 SET a_bigint = 911111111111111111 where a_bigint = 9223372036854775804;
+SELECT * FROM t1 ORDER BY a_bigint;
+SELECT * FROM t1 WHERE a_bigint > 1 LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_bigint;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: FLOAT --------#
+
+ALTER TABLE t1 ADD INDEX index_float (a_float);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_float = 994.44;
+UPDATE t1 SET a_float = 993.33 where a_float > 994 AND a_float < 994.5;
+SELECT * FROM t1 ORDER BY a_float;
+SELECT * FROM t1 WHERE a_float > 1 LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_float;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: DOUBLE --------#
+
+ALTER TABLE t1 ADD INDEX index_double (a_double);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_double = 999.678912345;
+UPDATE t1 SET a_double = 999.998877665 where a_double = 999.678912345;
+SELECT * FROM t1 ORDER BY a_double;
+SELECT * FROM t1 WHERE a_double > 1 LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_double;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: DECIMAL --------#
+
+ALTER TABLE t1 ADD INDEX index_decimal (a_decimal);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_decimal = 112.04;
+UPDATE t1 SET a_decimal = 112.05 where a_decimal = 112.04;
+SELECT * FROM t1 ORDER BY a_decimal;
+SELECT * FROM t1 WHERE a_decimal > 1 LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_decimal;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: DATE --------#
+
+ALTER TABLE t1 ADD INDEX index_date (a_date);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_date = '2008-07-14';
+UPDATE t1 SET a_date = '2008-08-14' where a_date = '2008-07-14';
+SELECT * FROM t1 ORDER BY a_date;
+SELECT * FROM t1 WHERE a_date > '2008-01-01' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_date;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: TIME --------#
+
+ALTER TABLE t1 ADD INDEX index_time (a_time);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_time = '16:30:50';
+UPDATE t1 SET a_time = '17:31:00' where a_time = '16:30:50';
+SELECT * FROM t1 ORDER BY a_time;
+SELECT * FROM t1 WHERE a_time > '11:00:00' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_time;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: DATETIME --------#
+
+ALTER TABLE t1 ADD INDEX index_datetime (a_datetime);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_datetime = '2008-07-14 16:30:50';
+UPDATE t1 SET a_datetime = '2008-08-14 17:31:00' where a_datetime = '2008-07-14
16:30:50';
+SELECT * FROM t1 ORDER BY a_datetime;
+SELECT * FROM t1 WHERE a_datetime > '2008-07-10 00:00:00' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_datetime;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: TIMESTAMP --------#
+
+ALTER TABLE t1 ADD INDEX index_timestamp (a_timestamp);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_timestamp = '2008-07-14 16:30:50';
+UPDATE t1 SET a_timestamp = '2008-08-14 19:20:21' where a_timestamp = '2008-07-14
16:30:50';
+SELECT * FROM t1 ORDER BY a_timestamp;
+SELECT * FROM t1 WHERE a_timestamp > '2008-07-10 00:00:00' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_timestamp;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: YEAR --------#
+
+ALTER TABLE t1 ADD INDEX index_year (a_year);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_year = '2013';
+UPDATE t1 SET a_year = '2020' where a_year LIKE '2013';
+SELECT * FROM t1 ORDER BY a_year;
+SELECT * FROM t1 WHERE a_year > '1999' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_year;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: CHAR --------#
+
+ALTER TABLE t1 ADD INDEX index_char (a_char);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_char = 'fTestChar';
+UPDATE t1 SET a_char = 'gTestChar' where a_char = 'fTestChar';
+SELECT * FROM t1 ORDER BY a_char;
+SELECT * FROM t1 WHERE a_char > 'afalcon' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_char;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: VARCHAR --------#
+
+ALTER TABLE t1 ADD INDEX index_varchar (a_varchar);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_varchar = 'fTestVarChar';
+UPDATE t1 SET a_varchar = 'gTestVarChar' where a_varchar = 'fTestVarChar';
+SELECT * FROM t1 ORDER BY a_varchar;
+SELECT * FROM t1 WHERE a_varchar > 'afalcon' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_varchar;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: BINARY --------#
+
+ALTER TABLE t1 ADD INDEX index_binary (a_binary);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_binary = 'fTestBin';
+UPDATE t1 SET a_binary = 'gTestBin' where a_binary = 'fTestBin';
+SELECT * FROM t1 ORDER BY a_binary;
+SELECT * FROM t1 WHERE a_binary > 'afalcon' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_binary;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: VARBINARY --------#
+
+ALTER TABLE t1 ADD INDEX index_varbinary (a_varbinary);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_varbinary = 'fTestVarBinary';
+UPDATE t1 SET a_varbinary = 'gTestVarBinary' where a_varbinary = 'fTestVarBinary';
+SELECT * FROM t1 ORDER BY a_varbinary;
+SELECT * FROM t1 WHERE a_varbinary > 'afalcon' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_varbinary;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: ENUM --------#
+
+ALTER TABLE t1 ADD INDEX index_enum (a_binary);
+SHOW INDEXES FROM t1;
+INSERT INTO t1 SET a_enum = 'enumValueThree';
+UPDATE t1 SET a_enum = 'enumValueOne' where a_enum = 'enumValueThree';
+SELECT * FROM t1 ORDER BY a_enum;
+SELECT * FROM t1 WHERE a_enum > 'afalcon' LIMIT 1;
+ALTER TABLE t1 DROP INDEX index_enum;
+SHOW INDEXES FROM t1;
+SELECT * FROM t1;
+
+--echo #-------- Test: Alternative CREATE INDEX --------#
+
+## Try adding all indexes once again using alternative syntax (CREATE...)
+CREATE INDEX index_int on t1 (a_int);
+CREATE INDEX index_bit on t2 (a_bit);
+CREATE INDEX index_tinyint on t1 (a_tinyint);
+CREATE INDEX index_bigint on t1 (a_bigint);
+CREATE INDEX index_float on t1 (a_float);
+CREATE INDEX index_double on t1 (a_double);
+CREATE INDEX index_decimal on t1 (a_decimal);
+CREATE INDEX index_date on t1 (a_date);
+CREATE INDEX index_datetime on t1 (a_datetime);
+CREATE INDEX index_timestamp on t1 (a_timestamp);
+CREATE INDEX index_year on t1 (a_year);
+CREATE INDEX index_char on t1 (a_char);
+CREATE INDEX index_varchar on t1 (a_varchar);
+CREATE INDEX index_binary on t1 (a_binary);
+CREATE INDEX index_varbinary on t1 (a_varbinary);
+CREATE INDEX index_enum on t1 (a_enum);
+
+
+SHOW INDEXES FROM t1;
+SELECT * FROM t1 ORDER BY a_int;
+
+SHOW INDEXES FROM t2;
+SELECT a_int, BIN(a_bit+0) FROM t2 ORDER BY a_int;
+
+## Try dropping all indexes using alternative syntax
+
+--echo #-------- Test: Alternative DROP INDEX --------#
+
+DROP INDEX index_int on t1;
+DROP INDEX index_bit on t2;
+DROP INDEX index_tinyint on t1;
+DROP INDEX index_bigint on t1;
+DROP INDEX index_float on t1;
+DROP INDEX index_double on t1;
+DROP INDEX index_decimal on t1;
+DROP INDEX index_date on t1;
+DROP INDEX index_datetime on t1;
+DROP INDEX index_timestamp on t1;
+DROP INDEX index_year on t1;
+DROP INDEX index_char on t1;
+DROP INDEX index_varchar on t1;
+DROP INDEX index_binary on t1;
+DROP INDEX index_varbinary on t1;
+DROP INDEX index_enum on t1;
+
+
+# ----------------------------------------------------- #
+# --- Check --- #
+# ----------------------------------------------------- #
+SHOW INDEXES FROM t1;
+SELECT * FROM t1 ORDER BY a_int;
+
+SHOW INDEXES FROM t2;
+SELECT a_int, BIN(a_bit+0) FROM t2 ORDER BY a_int;
+
+
+# ----------------------------------------------------- #
+# --- Final cleanup --- #
+# ----------------------------------------------------- #
+DROP TABLE t1;
+DROP TABLE t2;
=== added file 'mysql-test/suite/falcon/t/falcon_online_index.test'
--- a/mysql-test/suite/falcon/t/falcon_online_index.test 1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_online_index.test 2008-09-04 18:38:48 +0000
@@ -0,0 +1,304 @@
+--source include/have_falcon.inc
+
+#
+# Test for ONLINE ADD/DROP INDEX.
+# See also: falcon_index_datatypes
+#
+# ONLINE ADD/DROP was added to Falcon as part of
+# Worklog 4048 - "Falcon: On-line add attribute, Falcon handler part"
+# and is implicit for those statements where ONLINE functionality is supported
+# by the storage engine (and the server).
+#
+# This test is testing that:
+#
+# a) ONLINE is used for some selected ALTER TABLE ... ADD INDEX statements
+# where neither ONLINE nor OFFLINE is specified.
+# b) Alternative syntax works with the ONLINE keyword, for example
+# CREATE ONLINE INDEX
+# ALTER ONLINE TABLE ... ADD KEY
+# c) ONLINE ADD/DROP INDEX works where expected.
+# d) Statements using ONLINE keyword are rejected if the storage engine does
+# not support doing this online.
+#
+# ----------------------------------------------------- #
+# --- Initialisation --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+DROP TABLE IF EXISTS t2;
+DROP TABLE IF EXISTS t3;
+--enable_warnings
+
+CREATE TABLE t1 (
+ a int PRIMARY KEY,
+ b VARCHAR(255),
+ c int,
+ d CHAR(10)
+);
+
+# Populate t1, 20 rows
+let $i=20;
+let $r=0;
+while ($i < 20)
+{
+ eval INSERT INTO t1 VALUES ($r, 'TestRow$r', $r*2, 'Char$r');
+ dec $i;
+ inc $r;
+}
+
+CREATE TABLE t2 (
+ a int PRIMARY KEY,
+ b int,
+ c int,
+ d VARCHAR(65)
+);
+
+# Populate t2, 33 rows
+let $i=33;
+let $r=0;
+while ($i)
+{
+ eval INSERT INTO t2 VALUES ($r, $r*2, $r+1, 'SomeString $r for testing');
+ dec $i;
+ inc $r;
+}
+
+# Need this to test with default values, nullable, non-nullable columns...
+CREATE TABLE t3 (
+ a int PRIMARY KEY AUTO_INCREMENT,
+ b int DEFAULT 9999,
+ c int DEFAULT 8888 NOT NULL,
+ d int NOT NULL,
+ e VARCHAR(65)
+);
+
+# Populate t3, 1000 rows
+let $i=1000;
+let $r=0;
+while ($i)
+{
+ eval INSERT INTO t3 (b, c, d, e) VALUES ($r*2, $r+1, $r-1, 'SomeVarchar $r for
testing');
+ dec $i;
+ inc $r;
+}
+
+# ----------------------------------------------------- #
+# --- Test --- #
+# ----------------------------------------------------- #
+
+# Do implicit online checking by verifying the number of affected rows from
+# ALTER statement (0 if online, > 0 if offline), hence --enable_info.
+--enable_info
+
+--echo #-------- Testing implicit ONLINE --------#
+
+# Test that ALTER TABLE ADD INDEX is online for nullable column
+ALTER TABLE t1 ADD INDEX ix_b (b);
+DROP INDEX ix_b ON t1;
+
+# Test that CREATE INDEX is online for nullable column
+CREATE INDEX ix_c ON t1 (c);
+DROP INDEX ix_c ON t1;
+
+# Test that ALTER TABLE ADD INDEX is online for nullable column having default value
+ALTER TABLE t3 ADD INDEX ix_b (b);
+SELECT * from t3 where b > 555 ORDER BY a LIMIT 5;
+DROP INDEX ix_b ON t3;
+
+--echo #-------- Testing implicit OFFLINE --------#
+
+# Test that ALTER TABLE ADD INDEX is offline for non-nullable column having default value
+ALTER TABLE t3 ADD INDEX ix_c (c);
+DROP INDEX ix_c ON t3;
+
+# Test that ALTER TABLE ADD INDEX is offline for non-nullable columns
+ALTER TABLE t3 ADD INDEX ix_cd (c, d);
+DROP INDEX ix_cd ON t3;
+
+--disable_info
+
+
+# Test that ONLINE keyword is accepted (or not, depending on statement):
+
+--echo #-------- Testing ONLINE keyword --------#
+
+# Test ALTER ONLINE ADD/DROP INDEX
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b);
+ALTER ONLINE TABLE t1 DROP INDEX ix_b;
+
+# Test ALTER ONLINE ADD/DROP KEY
+ALTER ONLINE TABLE t1 ADD KEY ix_b (b);
+ALTER ONLINE TABLE t1 DROP KEY ix_b;
+
+# Test CREATE/DROP ONLINE INDEX
+CREATE ONLINE INDEX ix_c ON t1 (c);
+DROP ONLINE INDEX ix_c ON t1;
+
+# Test ALTER ... ADD ... with ONLINE for nullable column having default value
+ALTER ONLINE TABLE t3 ADD INDEX ix_b (b);
+SELECT * from t3 where b > 555 ORDER BY a LIMIT 5;
+ALTER ONLINE TABLE t3 DROP INDEX ix_b;
+
+# Test that ALTER ONLINE ... ADD INDEX fails with ONLINE for non-nullable column having
default value
+--error ER_NOT_SUPPORTED_YET
+ALTER ONLINE TABLE t3 ADD INDEX ix_c (c);
+
+# Test that ALTER ONLINE ... ADD INDEX fails with ONLINE for non-nullable columns
+--error ER_NOT_SUPPORTED_YET
+ALTER ONLINE TABLE t3 ADD INDEX ix_d (d);
+
+
+##
+## Testing some statement variations using ADD/DROP INDEX
+##
+
+--echo #-------- Test: UNIQUE --------#
+
+## Test adding UNIQUE index
+ALTER ONLINE TABLE t2 ADD INDEX ix_unique_c (c);
+EXPLAIN SELECT * FROM t2 WHERE c < 25 AND c > 20 ORDER BY c;
+SELECT * FROM t2 WHERE c < 25 AND c > 20 ORDER BY c;
+SHOW INDEXES FROM t2;
+DESCRIBE t2;
+DROP ONLINE INDEX ix_unique_c ON t2;
+
+--echo #-------- Test: DESC --------#
+
+## Test using DESC keyword (parsed but not used)
+## TODO: Check DESC; ASC
+ALTER ONLINE TABLE t3 ADD INDEX ix_desc_b (b DESC);
+ALTER ONLINE TABLE t3 ADD INDEX ix_asc_b (b ASC);
+SHOW INDEXES FROM t3;
+DROP ONLINE INDEX ix_desc_b ON t3;
+DROP ONLINE INDEX ix_asc_b ON t3;
+
+--echo #-------- Test: KEY_BLOCK_SIZE --------#
+
+## Test adding index and specifying KEY_BLOCK_SIZE
+## KEY _BLOCK_SIZE 0 indicates that the default should be used.
+ALTER ONLINE TABLE t1 ADD INDEX ix_keyblock_b (b) KEY_BLOCK_SIZE = 0;
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+SHOW INDEXES FROM t1;
+ALTER ONLINE TABLE t1 DROP INDEX ix_keyblock_b;
+
+--echo #-------- Test: COMMENT --------#
+
+## Test adding index and specifying a comment
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b) COMMENT 'Test comment';
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+SELECT * FROM t1 WHERE b LIKE 'TestRow1%' ORDER BY b;
+SHOW INDEXES FROM t1;
+ALTER ONLINE TABLE t1 DROP INDEX ix_b;
+
+--echo #-------- Test: Multiple columns --------#
+
+## Test ADD INDEX on multiple columns
+ALTER ONLINE TABLE t1 ADD INDEX index_multicol (b, c, d);
+SHOW INDEXES FROM t1;
+## Query using the two left-most keys
+EXPLAIN SELECT * FROM t1 WHERE b LIKE 'TestRow3%' AND c = 6 ORDER BY b, c, d;
+SELECT * FROM t1 WHERE b LIKE 'TestRow3%' AND c = 6 ORDER BY b, c, d;
+DROP INDEX index_multicol ON t1;
+
+--echo #-------- Test: Multiple ADD INDEX on same column --------#
+
+ALTER ONLINE TABLE t1 ADD INDEX index_1d (d);
+ALTER ONLINE TABLE t1 ADD INDEX index_2d (d);
+CREATE ONLINE INDEX index_3d ON t1 (d);
+SHOW INDEXES FROM t1;
+DROP ONLINE INDEX index_1d ON t1;
+DROP ONLINE INDEX index_2d ON t1;
+DROP ONLINE INDEX index_3d ON t1;
+
+--echo #-------- Test: Multiple ADD INDEX in a single statement --------#
+
+ALTER TABLE t1
+ ADD INDEX index_varchar (b),
+ ADD INDEX index_int (c);
+ALTER TABLE t3
+ ADD INDEX index_int (b),
+ ADD INDEX index_multi (b,e),
+ ADD INDEX index_varchar (e);
+SHOW INDEXES FROM t1;
+SHOW INDEXES FROM t3;
+
+--echo #-------- Test: Multiple DROP INDEX in a single statement --------#
+
+## Depends on indexes added in previous test segment.
+ALTER TABLE t1
+ DROP INDEX index_varchar,
+ DROP INDEX index_int;
+ALTER TABLE t3
+ DROP INDEX index_int,
+ DROP INDEX index_multi,
+ DROP INDEX index_varchar;
+SHOW INDEXES FROM t1;
+SHOW INDEXES FROM t3;
+
+--echo #-------- Test: Combined ADD/DROP INDEX in a single statement --------#
+
+ALTER TABLE t1 ADD INDEX index_int (c);
+ALTER TABLE t1 ADD INDEX index_char (d), DROP INDEX index_int;
+SHOW INDEXES FROM t1;
+ALTER TABLE t1 DROP INDEX index_char;
+
+--echo #-------- Test: ADD INDEX followed by some complex queries --------#
+
+# First index added offline (non-nullable column), others online.
+ALTER TABLE t1 ADD INDEX ix_a (a);
+ALTER ONLINE TABLE t1 ADD INDEX ix_b (b);
+ALTER ONLINE TABLE t1 ADD INDEX ix_c (c);
+
+ALTER ONLINE TABLE t2
+ ADD INDEX ix_b (b),
+ ADD INDEX ix_d (d);
+
+ALTER ONLINE TABLE t3 ADD INDEX ix_b (b);
+
+## Two keys, existing values
+EXPLAIN SELECT * FROM t1 WHERE a = 3 OR (c > 10 AND a < 15) ORDER BY a;
+SELECT * FROM t1 WHERE a = 3 OR (c > 10 AND a < 15) ORDER BY a;
+
+## Two keys, one non-existing and one existing value
+EXPLAIN SELECT * FROM t1 WHERE a = 99 OR b LIKE 'TestRow7%';
+SELECT * FROM t1 WHERE a = 99 OR b LIKE 'TestRow7%';
+
+## Two keys and a non-key
+EXPLAIN SELECT * FROM t1 WHERE (a = 10 OR b LIKE 'TestRow11') AND d LIKE 'Char%' ORDER BY
a;
+SELECT * FROM t1 WHERE (a = 10 OR b LIKE 'TestRow11') AND d LIKE 'Char%' ORDER BY a;
+
+## Two tables, keys in both, compare key to non-key
+EXPLAIN SELECT * FROM t1, t2 WHERE (t1.a IN (1,2) OR t1.b LIKE 'TestRow1%') AND
t1.c=t2.c;
+SELECT * FROM t1, t2 WHERE (t1.a IN (1,2) OR t1.b LIKE 'TestRow1%') AND t1.c=t2.c;
+EXPLAIN SELECT * FROM t1, t3 WHERE t3.b=2 AND (t1.c = t3.c OR t1.a=t3.d);
+SELECT * FROM t1, t3 WHERE t3.b=2 AND (t1.c = t3.c OR t1.a=t3.d);
+
+ALTER ONLINE TABLE t1
+ DROP INDEX ix_a,
+ DROP INDEX ix_b,
+ DROP INDEX ix_c;
+
+ALTER ONLINE TABLE t2
+ DROP INDEX ix_b,
+ DROP INDEX ix_d;
+
+ALTER ONLINE TABLE t3 DROP INDEX ix_b;
+
+
+# ----------------------------------------------------- #
+# --- Check --- #
+# ----------------------------------------------------- #
+SHOW INDEXES FROM t1;
+SHOW INDEXES FROM t2;
+SHOW INDEXES FROM t3;
+
+# ----------------------------------------------------- #
+# --- Final cleanup --- #
+# ----------------------------------------------------- #
+DROP TABLE t1;
+DROP TABLE t2;
+DROP TABLE t3;
| Thread | ||
|---|---|---|
| • bzr commit into mysql-6.0-falcon branch (john.embretsen:2812) WL#4048 | John H. Embretsen | 4 Sep |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 1.679 sec. using MySQL 5.1.14-beta-log