2
# Test default delimiter ;
3
select "Test default delimiter ;" as " ";
6
# Test delimiter without argument
7
select "Test delimiter without arg" as " ";
8
# Nothing should be displayed, error is returned
10
delimiter ; # Reset delimiter
13
select "Test delimiter :" as " ";
16
delimiter ; # Reset delimiter
19
select "Test delimiter :" as " ";
22
delimiter ; # Reset delimiter
25
select "Test delimiter :;" as " ";
28
delimiter ; # Reset delimiter
31
select "Test delimiter //" as " ";
34
delimiter ; # Reset delimiter
36
# Test delimiter 'MySQL'
37
select "Test delimiter MySQL" as " ";
40
delimiter ; # Reset delimiter
42
# Test delimiter 'delimiter'(should be allowed according to the code)
43
select "Test delimiter delimiter" as " ";
45
select * from t1 delimiter
46
delimiter ; # Reset delimiter
49
# Bug #11523: \d works differently than delimiter
51
source t/mysql_delimiter_source.sql
52
delimiter ; # Reset delimiter
55
# Bug #19799: delimiter command not working correctly when sourcing a sql file
56
# with Windows style line endings.
58
source t/mysql_delimiter_19799.sql
61
delimiter ; # Reset delimiter