This queue is for tickets about the DBIx-RunSQL CPAN distribution.

Report information
The Basics
Id:
115442
Status:
resolved
Priority:
Low/Low
Queue:

People
Owner:
corion [...] cpan.org
Requestors:
niceperl [...] cpan.org
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
(no value)
Fixed in:
(no value)



Subject: parsing SQL bug
I have a very simple SQL file with 2 sentences: DROP TABLE IF EXISTS player1; DROP TABLE IF EXISTS player2; I got a MySQL error, but after some debugging tasks (using verbose_handler) I found the error. It was a blank space after the semicolon at first sentence. I have just removed it and it worked. But I think the regular expression used to parse the sentences (line 454): my @sql = split /;\r?\n/, $sql; should be some like this: my @sql = split /; *\r?\n/, $sql; you also may consider tabs
Fixed in 0.15, thanks for reporting!


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.