mirror of
https://github.com/MariaDB/server.git
synced 2025-07-30 07:00:51 +02:00
1d2fa98260
-12d75e6121- new thread stack size -99e48cb1d9- warning text changed -6c173324ff- default values for BLOBs -c87e002bbb- don't return a negative zero
225 lines
4.6 KiB
Text
225 lines
4.6 KiB
Text
DROP TABLE IF EXISTS t4;
|
|
CREATE TABLE t4(c1 TINYBLOB NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` tinyblob DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 BLOB NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` blob DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 MEDIUMBLOB NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` mediumblob DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 LONGBLOB NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` longblob DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 TINYTEXT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` tinytext DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 TEXT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` text DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 MEDIUMTEXT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` mediumtext DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 LONGTEXT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` longtext DEFAULT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 TINYBLOB NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` tinyblob NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 BLOB NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` blob NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 MEDIUMBLOB NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` mediumblob NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 LONGBLOB NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` longblob NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 TINYTEXT NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` tinytext NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 TEXT NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` text NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 MEDIUMTEXT NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` mediumtext NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
CREATE TABLE t4(c1 LONGTEXT NOT NULL);
|
|
CREATE INDEX i1 ON t4(c1(100));
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t4
|
|
SHOW CREATE TABLE t4;
|
|
Table Create Table
|
|
t4 CREATE TABLE `t4` (
|
|
`c1` longtext NOT NULL,
|
|
KEY `i1` (`c1`(100))
|
|
) ENGINE=ENGINE DEFAULT CHARSET=latin1
|
|
DROP TABLE t4;
|
|
SHOW TABLES;
|
|
Tables_in_test
|