mwalker wrote:
mwalker wrote:
If it is legal, then perhaps DefaultDatabaseCollection's logic could be changed, such that it constructs the qualifier by concatenating the catalog + "." + schema name, rather than by using the StringHelper.qualifier() trick.
In fact, I made this code change, and it does now work as expected. I'd be happy to share it if you guys think it's worth fixing.
create a jira with a patch (not the whole file please ;) so we can see.
Quote:
Also took a quick look through the SQL92 specification, along with a trip to Mimer SQL validator, and it appears that dots in table names are technically legal.
it all depends on quoting I believe.
If your table got "." in them how do you distinguish SCH1.TAB1 from SCH1.TAB1 without quoting ?