Subject: "delimiter" fails when script invoked with "source"
>Description:
When "delimiter" is used to change the default delimiter in mysql,
its behaviour is different when it's invoked in batch mode (mysql < script_file)
or within the program, with the "source" command.
in this latter case, everything until the next occurrence of "delimiter"
in the script is apparently taken as the delimiter itself.
Bug confirmed in 5.0.7, 5.0.10, 5.0.11, 5.0.12 (Linux) and 5.0.2 (Windows)
>How-To-Repeat:
this script (test.mysql):
delimiter //
select now() //
delimiter ;
select version() ;
will execute correctly when launched by "mysql < test.mysql"
$ mysql -t < test.mysql
+---------------------+
| now() |
+---------------------+
| 2005-08-09 11:44:09 |
+---------------------+
+----------------------------------+
| version() |
+----------------------------------+
| 5.0.12-beta-nightly-20050806-log |
+----------------------------------+
But when invoked inside the monitor, things change:
mysql> source test.mysql
+----------------------------------+
| version() |
+----------------------------------+
| 5.0.12-beta-nightly-20050806-log |
+----------------------------------+
1 row in set (0.00 sec)
Empty set (0.01 sec)
mysql> select now();
-> //
-> \c
mysql> select now() //
-> ;
-> \q
Bye
>Fix:
No fix available
Bye
Silvano Mastice
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org
