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