EVOLUTION-MANAGER

Edit File: xml_mdev5261.test

--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