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,
Andrew McIntyre wrote:
On 10/17/06, Oystein Grovlen - Sun Norway [EMAIL PROTECTED] wrote:
I find it strange that while SHOW INDEXES, SHOW PROCEDURES, and
SHOW SYNONYMS by default list all corresponding objects in the
database, SHOW TABLES and SHOW VIEWS by default only list the
corresponding
Øystein Grøvlen wrote:
I will file a bug report for the documentation tomorrow. The
documentation should proabably also say that system tables are only
displayed if a schema is specified.
Thinking about this for another few minutes, this still means that the
show commands
, this still means that the
show commands are not orthogonal since by default system procedures and
indexes on system tables are displayed, but not system tables. So I'll
ask again: What do people think about this.
So, I went and looked at the code after this came up yesterday and I
believe
I find it strange that while SHOW INDEXES, SHOW PROCEDURES, and
SHOW SYNONYMS by default list all corresponding objects in the
database, SHOW TABLES and SHOW VIEWS by default only list the
corresponding objects in the current schema. Would it not be better
if all commands behaved the same way?
I also find it a bit strange that SHOW VIEWS uses the heading
TABLE_NAME and not VIEW_NAME.
In a way, this is similar to DERBY-1072:
http://issues.apache.org/jira/browse/DERBY-1072
bryan
Andrew McIntyre wrote:
I also find it a bit strange that SHOW VIEWS uses the heading
TABLE_NAME and not VIEW_NAME.
These are the names of the columns returned from the ResultSet
retrieved from DatabaseMetadata.getTables(), and I believe those
column names are mandated by the JDBC spec.