2 ERROR 42000: Unknown database 'lpt1'
4 ERROR 42000: Unknown database 'com1'
6 ERROR 42000: Unknown database 'prn'
7 create table nu (a int);
9 drop table if exists t1;
10 CREATE TABLE t1 ( `ID` int(6) ) data directory 'c:/tmp/' index directory 'c:/tmp/' engine=MyISAM;
12 Warning 1618 <DATA DIRECTORY> option ignored
13 Warning 1618 <INDEX DIRECTORY> option ignored
15 CREATE TABLE t1 (a int, b int);
16 INSERT INTO t1 VALUES (1,1);
17 EXPLAIN SELECT * FROM t1 WHERE b = (SELECT max(2));
18 id select_type table type possible_keys key key_len ref rows Extra
19 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
20 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL No tables used
22 CREATE DATABASE `TESTDB`;
24 CREATE FUNCTION test_fn() RETURNS INTEGER
30 CREATE FUNCTION test_fn2() RETURNS INTEGER
36 DROP FUNCTION `TESTDB`.`test_fn`;
37 DROP FUNCTION `testdb`.`test_fn2`;
39 DROP DATABASE `TESTDB`;
41 drop procedure if exists proc_1;
42 create procedure proc_1() install plugin my_plug soname '\\root\\some_plugin.dll';
44 ERROR HY000: No paths allowed for shared library
46 ERROR HY000: No paths allowed for shared library
48 ERROR HY000: No paths allowed for shared library
49 drop procedure proc_1;
50 prepare abc from "install plugin my_plug soname '\\\\root\\\\some_plugin.dll'";
52 ERROR HY000: No paths allowed for shared library
54 ERROR HY000: No paths allowed for shared library
55 deallocate prepare abc;
57 # Bug#45498: Socket variable not available on Windows
59 SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
60 WHERE VARIABLE_NAME = 'socket';