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