1# Windows-specific tests 2--source include/windows.inc 3 4# 5# Bug 9148: Denial of service 6# 7--error 1049 8use lpt1; 9--error 1049 10use com1; 11--error 1049 12use prn; 13 14# 15# Bug #12325: Can't create table named 'nu' 16# 17create table nu (a int); 18drop table nu; 19 20# 21# Bug17489: ailed to put data file in custom directory use "data directory" option 22# 23--disable_warnings 24drop table if exists t1; 25--enable_warnings 26CREATE TABLE t1 ( `ID` int(6) ) data directory 'c:/tmp/' index directory 'c:/tmp/' engine=MyISAM; 27drop table t1; 28 29# End of 4.1 tests 30 31# 32# Bug #27811: The variable 'join_tab' is being used without being defined 33# 34CREATE TABLE t1 (a int, b int); INSERT INTO t1 VALUES (1,1); 35EXPLAIN SELECT * FROM t1 WHERE b = (SELECT max(2)); 36DROP TABLE t1; 37 38# 39# Bug #33813: Schema names are case-sensitive in DROP FUNCTION 40# 41 42CREATE DATABASE `TESTDB`; 43 44USE `TESTDB`; 45DELIMITER //; 46 47CREATE FUNCTION test_fn() RETURNS INTEGER 48BEGIN 49DECLARE rId bigint; 50RETURN rId; 51END 52// 53 54CREATE FUNCTION test_fn2() RETURNS INTEGER 55BEGIN 56DECLARE rId bigint; 57RETURN rId; 58END 59// 60 61DELIMITER ;// 62 63DROP FUNCTION `TESTDB`.`test_fn`; 64DROP FUNCTION `testdb`.`test_fn2`; 65 66USE test; 67DROP DATABASE `TESTDB`; 68 69--echo End of 5.0 tests. 70 71--disable_warnings 72drop procedure if exists proc_1; 73--enable_warnings 74# 75# Bug #20665: All commands supported in Stored Procedures should work in 76# Prepared Statements 77# 78 79create procedure proc_1() install plugin my_plug soname '\\root\\some_plugin.dll'; 80--error ER_UDF_NO_PATHS 81call proc_1(); 82--error ER_UDF_NO_PATHS 83call proc_1(); 84--error ER_UDF_NO_PATHS 85call proc_1(); 86drop procedure proc_1; 87 88prepare abc from "install plugin my_plug soname '\\\\root\\\\some_plugin.dll'"; 89--error ER_UDF_NO_PATHS 90execute abc; 91--error ER_UDF_NO_PATHS 92execute abc; 93deallocate prepare abc; 94 95--echo # 96--echo # Bug#45498: Socket variable not available on Windows 97--echo # 98 99SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 100 WHERE VARIABLE_NAME = 'socket'; 101 102--echo # 103--echo # Bug#16581605: REPLACE.EXE UTILITY IS BROKEN IN 5.5 104--echo # 105 106# Creating a temporary text file. 107--write_file $MYSQL_TMP_DIR/bug16581605.txt 108abc 109def 110EOF 111 112#REPLACE.EXE UTILITY will work fine after the fix. 113--exec $REPLACE abc xyz < $MYSQL_TMP_DIR/bug16581605.txt 114 115#Cleanup 116remove_file $MYSQL_TMP_DIR/bug16581605.txt; 117