mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-07-16 16:28:15 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/engines/funcs/r/ix_unique_lob.result
Omer BarNir c92b9b7315 Test suites for engine testing, moved from test-extra so will be available 
for general use.


mysql-test/Makefile.am:
  Adding directories of additional test suites
mysql-test/mysql-stress-test.pl:
  Adding check for additional errors checking during test run
2010-03-17 23:42:07 -07:00

225 lines
4.8 KiB
Text
Raw Permalink Blame History

DROP TABLE IF EXISTS t4;
CREATE TABLE t4(c1 TINYBLOB NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 BLOB NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMBLOB NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 LONGBLOB NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 TINYTEXT NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 TEXT NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 MEDIUMTEXT NULL);
CREATE UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
CREATE TABLE t4(c1 LONGTEXT NULL);
CREATE UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE 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 UNIQUE 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,
UNIQUE KEY `i1` (`c1`(100))
) ENGINE=ENGINE DEFAULT CHARSET=latin1
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
Reference in a new issue View git blame Copy permalink