diff options
Diffstat (limited to 'mysql-test/t/mysql_comments.sql')
-rw-r--r-- | mysql-test/t/mysql_comments.sql | 218 |
1 files changed, 0 insertions, 218 deletions
diff --git a/mysql-test/t/mysql_comments.sql b/mysql-test/t/mysql_comments.sql deleted file mode 100644 index 2497c35e465..00000000000 --- a/mysql-test/t/mysql_comments.sql +++ /dev/null @@ -1,218 +0,0 @@ -##============================================================================ -## Notes -##============================================================================ - -# Test case for Bug#11230 - -# The point of this test is to make sure that '#', '-- ' and '/* ... */' -# comments, as well as empty lines, are sent from the client to the server. -# This is to ensure better error reporting, and to keep comments in the code -# for stored procedures / functions / triggers (Bug#11230). -# As a result, be careful when editing comments in this script, they do -# matter. -# -# Also, note that this is a script for **mysql**, not mysqltest. -# This is critical, as the mysqltest client interprets comments differently. - -##============================================================================ -## Setup -##============================================================================ - -## See mysql_comments.test for initial cleanup - -# Test tables -# -# t1 is reused throughout the file, and dropped at the end. -# -drop table if exists t1; -create table t1 ( - id char(16) not null default '', - data int not null -); - -##============================================================================ -## Comments outside statements -##============================================================================ - -# Ignored 1a --- Ignored 1b -/* - Ignored 1c -*/ - -select 1; - -##============================================================================ -## Comments inside statements -##============================================================================ - -select # comment 1a -# comment 2a --- comment 2b -/* - comment 2c -*/ -2 -; # not strictly inside, but on same line -# ignored - -##============================================================================ -## Comments inside functions -##============================================================================ - -drop function if exists foofct ; - -create function foofct (x char(20)) -returns char(20) -/* not inside the body yet */ -return --- comment 1a -# comment 1b -/* comment 1c */ -x; # after body, on same line - -select foofct("call 1"); - -show create function foofct; -drop function foofct; - -delimiter | - -create function foofct(x char(20)) -returns char(20) -begin - -- comment 1a - # comment 1b - /* - comment 1c - */ - - -- empty line below - - -- empty line above - return x; -end| - -delimiter ; - -select foofct("call 2"); - -show create function foofct; -drop function foofct; - -##============================================================================ -## Comments inside stored procedures -##============================================================================ - -# Empty statement -drop procedure if exists empty; -create procedure empty() -begin -end; - -call empty(); -show create procedure empty; -drop procedure empty; - -drop procedure if exists foosp; - -## These comments are before the create, and will be lost -# Comment 1a --- Comment 1b -/* - Comment 1c - */ -create procedure foosp() -/* Comment not quiet in the body yet */ - insert into test.t1 -## These comments are part of the procedure body, and should be kept. -# Comment 2a --- Comment 2b -/* Comment 2c */ - -- empty line below - - -- empty line above - values ("foo", 42); # comment 3, still part of the body -## After the ';', therefore not part of the body -# comment 4a --- Comment 4b -/* - Comment 4c - */ - -call foosp(); -select * from t1; -delete from t1; -show create procedure foosp; -drop procedure foosp; - -drop procedure if exists nicesp; - -delimiter | - -create procedure nicesp(a int) -begin - -- declare some variables here - declare b int; - declare c float; - - -- do more stuff here - -- commented nicely and so on - - -- famous last words ... -end| - -delimiter ; - -show create procedure nicesp; -drop procedure nicesp; - -##============================================================================ -## Comments inside triggers -##============================================================================ - -drop trigger if exists t1_empty; - -create trigger t1_empty after delete on t1 -for each row -begin -end; - -show create trigger t1_empty; - -drop trigger if exists t1_bi; - -delimiter | - -create trigger t1_bi before insert on t1 -for each row -begin -# comment 1a --- comment 1b -/* - comment 1c -*/ - -- declare some variables here - declare b int; - declare c float; - - -- do more stuff here - -- commented nicely and so on - - -- famous last words ... - set NEW.data := 12; -end| - -delimiter ; - -show create trigger t1_bi; - -# also make sure the trigger still works -insert into t1(id) value ("trig"); -select * from t1; - -##============================================================================ -## Cleanup -##============================================================================ - -drop table t1; |