Closed GoogleCodeExporter closed 9 years ago
Original comment by christia...@gmail.com
on 15 Dec 2009 at 5:28
One of the early guiding principles has been that you should be able to execute
a sql
migration using the native db command line tools. This makes it easier to
write
them, test them, and to know what's allowed in them. As a result, I'm
interested in
replicating the behavior of the most common databases. This will help me
decide
whether this should report an error or warning.
From the command line, MySQL executes all of the statements in a script, even
if the
last statement If a multi-statement script does _not_ have a delimiter. It
does so
silently. Naturally, only the last statement can get away without its
delimiter.
I'm going to check postgresql too before committing the fix. I'm leaning
towards just
accepting the script if it's missing the last deliminator, executing all of the
statements (including the last one), and report an info or warn level message
if it
happens.
Thanks!
Christian
Original comment by christia...@gmail.com
on 26 Dec 2009 at 5:36
Just deployed 0.9.9-SNAPSHOT which includes the fix for this... give it a whirl
and let
me know if it works as expected. Merry Christmas! :)
Original comment by christia...@gmail.com
on 26 Dec 2009 at 6:16
Thanks! I'll test it on my inputs early next week. I've had to put the
delimiters on
them to get them working but I'll take one off just to check.
Original comment by nik9...@gmail.com
on 26 Dec 2009 at 12:28
Original issue reported on code.google.com by
nik9...@gmail.com
on 23 Nov 2009 at 2:21Attachments: