mirror of
https://github.com/MariaDB/server.git
synced 2025-10-20 06:32:11 +02:00
27 lines
839 B
Text
27 lines
839 B
Text
--source windows.inc
|
|
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
|
|
SET NAMES utf8;
|
|
|
|
#
|
|
#--echo Testing indexing on not indexable table type
|
|
#
|
|
--error ER_UNKNOWN_ERROR
|
|
CREATE TABLE t1 (i INT UNIQUE NOT NULL) ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xt1.xml' OPTION_LIST='xmlsup=domdoc,Rownode=N';
|
|
CREATE TABLE t1 (i INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xt1.xml' OPTION_LIST='xmlsup=domdoc,Rownode=N';
|
|
DESCRIBE t1;
|
|
# one could *add* an index to an existing table
|
|
--error ER_UNKNOWN_ERROR
|
|
ALTER TABLE t1 ADD UNIQUE(i);
|
|
--error ER_UNKNOWN_ERROR
|
|
CREATE UNIQUE INDEX i ON t1(i);
|
|
DESCRIBE t1;
|
|
INSERT INTO t1 VALUES(2),(5),(7);
|
|
SELECT * FROM t1 WHERE i = 5;
|
|
--error ER_CANT_DROP_FIELD_OR_KEY
|
|
ALTER TABLE t1 DROP INDEX i;
|
|
--error ER_CANT_DROP_FIELD_OR_KEY
|
|
DROP INDEX i ON t1;
|
|
DROP TABLE t1;
|
|
--remove_file $MYSQLD_DATADIR/test/xt1.xml
|