SQLite Backup command has wrong Regular Expression

[Daniel Glaser]

Hi,

in version sqlite-jdbc-3.7.2 ExtendedCommand class line 61 in package org.sqlite, there is a problem with the regular expression when not supplying a database (default should be main). It assumes two whitespaces between "backup" and "to" if db is not given:

Pattern.compile("backup(\\s+(\"[^\"]*\"|'[^\']*\'|\\S+))?\\s+to\\s+(\"[^\"]*\"|'[^\']*\'|\\S+)");

Problem is here: "backup(___\\s___+(\"[^\"]*\"|'[^\']*\'|\\S+))?___\\s___+to\\s+(\"[^\"]*\"|'[^\']*\'|\\S+)"

One of the occurences should be optional (pull the second one into the second group and trim the result before quatation removal).

Cheers,
Daniel

[Grace B]

Created issue at https://bitbucket.org/xerial/sqlite-jdbc/issue/41 

[Grace B]

Nothing to fix here. 

Unless you can give an example that does not work.