Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#469 Line with spaces does not separate SQLs

All
closed
Colin Bell
Core (461)
5
2007-01-23
2006-12-18
tmuerell
No

I discovered, that multiple SQLs can be executed if an empty line with whitespaces is between them.

In my opinion that's not the expected behaviour, because the user cannot really recognize whitespaces in empty lines.

The source code searches for "\n\n". The attached patch is a possible solution. It uses the regular expression objects of Java to search for lines containing only whitespaces, i.e. "\n\s*\n". I do not consider my solution production ready, but it's a proof of concept to solve this issue.

Discussion

  • tmuerell
    tmuerell
    2006-12-18

    Emtpy lines patch

     
    Attachments
  • Gerd Wagner
    Gerd Wagner
    2007-01-23

    • status: open --> closed
     
  • Gerd Wagner
    Gerd Wagner
    2007-01-23

    Logged In: YES
    user_id=776065
    Originator: NO

    Fixed in CVS