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
64 # Bug #36244: MySQL CLI doesn't recognize standalone -- as comment
65 # before DELIMITER statement