|
1
by brian
clean slate |
1 |
###################### mysql_comments.test ############################# |
2 |
# # |
|
3 |
# Testing of comments handling by the command line client (mysql) # |
|
4 |
# # |
|
5 |
# Creation: # |
|
6 |
# 2007-10-29 akopytov Implemented this test as a part of fixes for # |
|
7 |
# bug #26215 and bug #11230 # |
|
8 |
# # |
|
9 |
########################################################################
|
|
10 |
||
11 |
#
|
|
12 |
# Bug #11230: Keeping comments when storing stored procedures |
|
13 |
#
|
|
14 |
||
15 |
# See the content of mysql_comments.sql |
|
16 |
# Set the test database to a known state before running the tests. |
|
17 |
--disable_warnings
|
|
18 |
drop table if exists t1; |
|
19 |
drop function if exists foofct; |
|
20 |
drop procedure if exists empty; |
|
21 |
drop procedure if exists foosp; |
|
22 |
drop procedure if exists nicesp; |
|
23 |
drop trigger if exists t1_empty; |
|
24 |
drop trigger if exists t1_bi; |
|
25 |
--enable_warnings
|
|
26 |
||
27 |
# Test without comments |
|
28 |
--echo "Pass 1 : --disable-comments"
|
|
29 |
--exec $MYSQL --disable-comments test 2>&1 < "./t/mysql_comments.sql"
|
|
30 |
||
31 |
# Test with comments |
|
32 |
--echo "Pass 2 : --enable-comments"
|
|
33 |
--exec $MYSQL --enable-comments test 2>&1 < "./t/mysql_comments.sql"
|
|
34 |
||
35 |
--echo End of 5.0 tests
|