Andrew McIntyre wrote: ...
But, that decision in the code means if you 'set schema sys' and then 'show tables' you get no output. That's bad behavior, in my opinion.
I agree. ...
I've attached a patch which changes the behavior to adjust the behavior of show tables to what you describe, and which also fixes the problem I just found described above. Try it out, and if you're satisfied with the behavior, I'll open a JIRA for tracking for release purposes and then commit to trunk and 10.2.
The code changes looks good. One question comes to mind when reading the javadoc for DataBaseMetaData.getTables(): Should we also list temporary tables?
-- Øystein