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