|
1
by brian
clean slate |
1 |
# Test default delimiter ; |
2 |
select "Test default delimiter ;" as " "; |
|
3 |
select * from t1; |
|
4 |
||
5 |
# Test delimiter without argument |
|
6 |
select "Test delimiter without arg" as " "; |
|
7 |
# Nothing should be displayed, error is returned |
|
8 |
delimiter
|
|
9 |
delimiter ; # Reset delimiter |
|
10 |
||
11 |
# Test delimiter : |
|
12 |
select "Test delimiter :" as " "; |
|
13 |
delimiter : |
|
14 |
select * from t1: |
|
15 |
delimiter ; # Reset delimiter |
|
16 |
||
17 |
# Test delimiter ':' |
|
18 |
select "Test delimiter :" as " "; |
|
19 |
delimiter ':' |
|
20 |
select * from t1: |
|
21 |
delimiter ; # Reset delimiter |
|
22 |
||
23 |
# Test delimiter :; |
|
24 |
select "Test delimiter :;" as " "; |
|
25 |
delimiter :; |
|
26 |
select * from t1 :; |
|
27 |
delimiter ; # Reset delimiter |
|
28 |
||
29 |
## Test delimiter // |
|
30 |
select "Test delimiter //" as " "; |
|
31 |
delimiter // |
|
32 |
select * from t1// |
|
33 |
delimiter ; # Reset delimiter |
|
34 |
||
35 |
# Test delimiter 'MySQL' |
|
36 |
select "Test delimiter MySQL" as " "; |
|
37 |
delimiter 'MySQL' |
|
38 |
select * from t1MySQL |
|
39 |
delimiter ; # Reset delimiter |
|
40 |
||
41 |
# Test delimiter 'delimiter'(should be allowed according to the code) |
|
42 |
select "Test delimiter delimiter" as " "; |
|
43 |
delimiter delimiter |
|
44 |
select * from t1 delimiter |
|
45 |
delimiter ; # Reset delimiter |
|
46 |
||
47 |
#
|
|
48 |
# Bug #11523: \d works differently than delimiter |
|
49 |
#
|
|
50 |
source t/mysql_delimiter_source.sql |
|
51 |
delimiter ; # Reset delimiter |
|
52 |
||
53 |
#
|
|
54 |
# Bug #19799: delimiter command not working correctly when sourcing a sql file |
|
55 |
# with Windows style line endings. |
|
56 |
#
|
|
57 |
source t/mysql_delimiter_19799.sql |
|
58 |
use test// |
|
59 |
show tables// |
|
60 |
delimiter ; # Reset delimiter |
|
61 |