db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4230) DatabaseMetaData.getColumns() returns extra column from view with group by and expression in SELECT list
Date Fri, 22 May 2009 14:34:45 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12712109#action_12712109

Knut Anders Hatlen commented on DERBY-4230:

I don't think there is an issue for it. Now that SQL:2008 allows ORDER BY in subqueries, it's
more likely that we'll allow it for CREATE VIEW too (there's no issue for ORDER BY in subqueries
either, I think).

By the way, even without changing size() to visibleSize(), isn't the patch already assuming
that the generated columns are at the end? If one of the generated columns appear at an index
< visibleSize(), the corresponding colInfos[index] entry will be left blank, and when we
come to a generated column with index >= visibleSize(), colInfos[index] will throw ArrayIndexOutOfBoundsException.

> DatabaseMetaData.getColumns() returns extra column from view with group by and  expression
in SELECT list
> ---------------------------------------------------------------------------------------------------------
>                 Key: DERBY-4230
>                 URL: https://issues.apache.org/jira/browse/DERBY-4230
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions:
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>         Attachments: create.sql, DERBY-4230_diff.txt, DERBY-4230_preview_diff.txt, ViewTest.java
> DatabaseMetaData.getColumns() returns an extra column for a view with a group by and
an expression in the select list.  I will attach the reproduction. Run the script create.sql
and then the program ViewTest.
> This is a regression in version 10.3, It ran ok on latest on the 10.1 and 10.2 branches.
> The ResultSetMetaData appears to return the correct number of columns  when you select
from the view, but it would be nice to add a regression test for that too.
> See discussion on derby-dev.
> http://www.nabble.com/extra-column-in-DatabaseMetaData.getColumns()-with-group-by-in-view-td23545576.html

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message