diff options
Diffstat (limited to 'mysql-test/main/myisam_debug_keys.result')
| -rw-r--r-- | mysql-test/main/myisam_debug_keys.result | 4924 |
1 files changed, 4924 insertions, 0 deletions
diff --git a/mysql-test/main/myisam_debug_keys.result b/mysql-test/main/myisam_debug_keys.result new file mode 100644 index 00000000000..e4cff16797b --- /dev/null +++ b/mysql-test/main/myisam_debug_keys.result @@ -0,0 +1,4924 @@ +# +# MDEV-29672 Add MTR tests covering key and key segment flags and types +# +SET debug_dbug='+d,key'; +CREATE TABLE types ( +id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, +type TEXT NOT NULL, +prefix_length INT NOT NULL +); +Warnings: +Note 1105 DBUG: prep_create_table: name=`PRIMARY` flags=00000001 (HA_NOSAME) +Note 1105 DBUG: ha_myisam::create: name=`PRIMARY` flags=00000011 (HA_AUTO_KEY|HA_NOSAME) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +INSERT INTO types (type, prefix_length) VALUES +('INT', 0), +('BIGINT', 0), +('DOUBLE', 0), +('DECIMAL(20,10)', 0), +('CHAR(4)', 0), +('CHAR(10)', 0), +('VARCHAR(4)', 0), +('VARCHAR(6)', 0), +('VARCHAR(8)', 0), +('VARCHAR(12)', 0), +('VARCHAR(16)', 0), +('VARCHAR(100)', 0), +('TEXT', 4), +('TEXT', 6), +('TEXT', 8), +('TEXT', 12), +('TEXT', 16), +('TEXT', 100); +BEGIN NOT ATOMIC +DECLARE create2_template TEXT +DEFAULT 'CREATE TABLE t1 (a TYPE1 NOT NULL, b TYPE2 NOT NULL, KEY(SEG1,SEG2))'; +DECLARE cur2 CURSOR FOR +SELECT t1.type AS type1, +t2.type AS type2, +t1.prefix_length AS prefix_length1, +t2.prefix_length AS prefix_length2 +FROM types AS t1, types AS t2 +ORDER BY t1.id, t2.id; +FOR rec IN cur2 DO +BEGIN +DECLARE tabledef TEXT DEFAULT REPLACE(create2_template,'TYPE1', rec.type1); +SET tabledef=REPLACE(tabledef, 'TYPE2', rec.type2); +SET tabledef=REPLACE(tabledef, 'SEG1', +IF(rec.prefix_length1, +CONCAT('a(',rec.prefix_length1,')'), 'a')); +SET tabledef=REPLACE(tabledef, 'SEG2', +IF(rec.prefix_length2, +CONCAT('b(',rec.prefix_length2,')'), 'b')); +SELECT tabledef AS ``; +EXECUTE IMMEDIATE tabledef; +SHOW WARNINGS; +SHOW CREATE TABLE t1; +DROP TABLE t1; +END; +END FOR; +END; +$$ + +CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a INT NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=4 LONG_INT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a BIGINT NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=10 LONGLONG +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DOUBLE NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=6 DOUBLE +Note 1105 DBUG: seg[0].flag=00000800 (HA_CAN_MEMCMP) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` double NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a DECIMAL(20,10) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=2 BINARY +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` decimal(20,10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000000 +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a CHAR(10) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: seg[0].type=1 TEXT +Note 1105 DBUG: seg[0].flag=00000001 (HA_SPACE_PACK) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` char(10) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(4) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(4) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000000 +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000002 (HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(6) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(6) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(8) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(8) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(12) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(12) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(16) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(16) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b INT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b BIGINT NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b DOUBLE NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b CHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b CHAR(10) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(4) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(6) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00000028 (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(8) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(12) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(16) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b VARCHAR(100) NOT NULL, KEY(a,b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0000002A (HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`,`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a VARCHAR(100) NOT NULL, b TEXT NOT NULL, KEY(a,b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=15 VARTEXT1 +Note 1105 DBUG: seg[0].flag=00000008 (HA_VAR_LENGTH_PART) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`,`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(4),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(4),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(4),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(4),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(6),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(6),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010000 (HA_KEY_HAS_PART_KEY_SEG) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000000 +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(6),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010002 (HA_KEY_HAS_PART_KEY_SEG|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(6),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(8),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(8),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(8),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(8),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(12),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(12),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(12),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(12),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(16),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(16),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(16),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(16),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b INT NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=4 LONG_INT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` int(11) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b BIGINT NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=10 LONGLONG +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` bigint(20) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DOUBLE NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=6 DOUBLE +Note 1105 DBUG: seg[1].flag=00000800 (HA_CAN_MEMCMP) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` double NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b DECIMAL(20,10) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=2 BINARY +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` decimal(20,10) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(4) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000000 +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(4) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b CHAR(10) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=1 TEXT +Note 1105 DBUG: seg[1].flag=00000001 (HA_SPACE_PACK) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` char(10) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(4) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(4) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(6) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(6) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(8) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(8) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(12) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(12) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(16) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(16) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b VARCHAR(100) NOT NULL, KEY(a(100),b)) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=15 VARTEXT1 +Note 1105 DBUG: seg[1].flag=00000008 (HA_VAR_LENGTH_PART) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` varchar(100) NOT NULL, + KEY `a` (`a`(100),`b`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(4))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(4)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(6))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=00010028 (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(6)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(8))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(8)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(12))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(12)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(16))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(16)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + +CREATE TABLE t1 (a TEXT NOT NULL, b TEXT NOT NULL, KEY(a(100),b(100))) +Level Code Message +Note 1105 DBUG: prep_create_table: name=`a` flags=0001002A (HA_KEY_HAS_PART_KEY_SEG|HA_BINARY_PACK_KEY|HA_VAR_LENGTH_KEY|HA_PACK_KEY) +Note 1105 DBUG: ha_myisam::create: name=`a` flags=00000020 (HA_BINARY_PACK_KEY) +Note 1105 DBUG: seg[0].type=17 VARTEXT2 +Note 1105 DBUG: seg[0].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Note 1105 DBUG: seg[1].type=17 VARTEXT2 +Note 1105 DBUG: seg[1].flag=00000024 (HA_BLOB_PART|HA_PART_KEY_SEG) +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text NOT NULL, + `b` text NOT NULL, + KEY `a` (`a`(100),`b`(100)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +DROP TABLE types; +SET debug_dbug=''; |