summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysql_comments.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/mysql_comments.sql')
-rw-r--r--mysql-test/t/mysql_comments.sql218
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;