windows.result 1.36 KB
Newer Older
1 2 3 4 5 6 7 8
use lpt1;
ERROR 42000: Unknown database 'lpt1'
use com1;
ERROR 42000: Unknown database 'com1'
use prn;
ERROR 42000: Unknown database 'prn'
create table nu (a int);
drop table nu;
9 10 11 12 13 14
drop table if exists t1;
CREATE TABLE t1 ( `ID` int(6) ) data directory 'c:/tmp/' index directory 'c:/tmp/' engine=MyISAM;
Warnings:
Warning	0	DATA DIRECTORY option ignored
Warning	0	INDEX DIRECTORY option ignored
drop table t1;
15 16 17 18 19 20 21 22 23 24 25 26 27 28
create procedure proc_1() install plugin my_plug soname '\\root\\some_plugin.dll';
call proc_1();
ERROR HY000: No paths allowed for shared library
call proc_1();
ERROR HY000: No paths allowed for shared library
call proc_1();
ERROR HY000: No paths allowed for shared library
drop procedure proc_1;
prepare abc from "install plugin my_plug soname '\\\\root\\\\some_plugin.dll'";
execute abc;
ERROR HY000: No paths allowed for shared library
execute abc;
ERROR HY000: No paths allowed for shared library
deallocate prepare abc;
29 30 31 32 33 34 35 36 37
CREATE TABLE t1 (
`pkid` int(11) NOT NULL AUTO_INCREMENT,
`SALES_DATE` date NOT NULL DEFAULT '0000-00-00',
KEY `pkid` (`pkid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (MONTH(SALES_DATE))
(
PARTITION p0 VALUES LESS THAN (2) ENGINE=INNODB
data DIRECTORY='c:/tmp/'
unknown's avatar
unknown committed
38
                index DIRECTORY = 'c:/tmp/',
39 40
PARTITION p1 VALUES LESS THAN (3) ENGINE=INNODB
data DIRECTORY='c:/tmp/'
unknown's avatar
unknown committed
41
                index DIRECTORY = 'c:/tmp/'
42
);
unknown's avatar
unknown committed
43
DROP TABLE t1;