invalid regex substitution for table names in get_tables
Status: Beta
Brought to you by:
georg_erlacher
In get_tables in sqlcockpit.pl there is a regex that should beautify table names:
foreach (@tables) { # beautify name s/(".+")(.+)/$2/g; s/^\.//g; }
This regex does not work if the prefix and the table names are quoted, e.g. "thisisa"."test".
As a result, the table name is wrong and loading an SQLite database fails.
Exclusing quotes between quotes does the trick (I think).
Just replace
s/(".+")(.+)/$2/g;
by
s/("[^"]+")(.+)/$2/g;