summaryrefslogtreecommitdiff
path: root/mysql-test/t/parser_not_embedded.test
diff options
context:
space:
mode:
authorChad MILLER <chad@mysql.com>2009-04-17 16:00:53 -0400
committerChad MILLER <chad@mysql.com>2009-04-17 16:00:53 -0400
commit04d83cc85c42ecb7c03cb139bee6b23e8881466e (patch)
tree26a59da68994ddd577577a59c944a9d0a8bb1e00 /mysql-test/t/parser_not_embedded.test
parentb27261a6f710850636ccac4616e2cbd15bc55442 (diff)
downloadmariadb-git-04d83cc85c42ecb7c03cb139bee6b23e8881466e.tar.gz
Move test for bug 39559, which uses command-line mysql client
to separate test file that doesn't permit mysqld embedded in mysqltest. Also, fix different comment handling in a incorrect new-to-5.1 test.
Diffstat (limited to 'mysql-test/t/parser_not_embedded.test')
-rw-r--r--mysql-test/t/parser_not_embedded.test26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/parser_not_embedded.test b/mysql-test/t/parser_not_embedded.test
new file mode 100644
index 00000000000..8ebeb9a8301
--- /dev/null
+++ b/mysql-test/t/parser_not_embedded.test
@@ -0,0 +1,26 @@
+--source include/not_embedded.inc
+
+###########################################################################
+--echo #
+--echo # Bug#39559: dump of stored procedures / functions with C-style
+--echo # comment can't be read back
+--echo #
+
+--write_file $MYSQLTEST_VARDIR/tmp/bug39559.sql
+select 2 as expected, /*!01000/**/*/ 2 as result;
+select 1 as expected, /*!99998/**/*/ 1 as result;
+select 3 as expected, /*!01000 1 + */ 2 as result;
+select 2 as expected, /*!99990 1 + */ 2 as result;
+select 7 as expected, /*!01000 1 + /* 8 + */ 2 + */ 4 as result;
+select 8 as expected, /*!99998 1 + /* 2 + */ 4 + */ 8 as result;
+select 7 as expected, /*!01000 1 + /*!01000 8 + */ 2 + */ 4 as result;
+select 7 as expected, /*!01000 1 + /*!99998 8 + */ 2 + */ 4 as result;
+select 4 as expected, /*!99998 1 + /*!99998 8 + */ 2 + */ 4 as result;
+select 4 as expected, /*!99998 1 + /*!01000 8 + */ 2 + */ 4 as result;
+select 7 as expected, /*!01000 1 + /*!01000 8 + /*!01000 error */ 16 + */ 2 + */ 4 as result;
+select 4 as expected, /* 1 + /*!01000 8 + */ 2 + */ 4;
+EOF
+
+--exec $MYSQL --comment --force --table test <$MYSQLTEST_VARDIR/tmp/bug39559.sql
+--remove_file $MYSQLTEST_VARDIR/tmp/bug39559.sql
+