[jira] Commented: (DERBY-4230) DatabaseMetaData.getColumns() returns extra column from view with group by and expression in SELECT list

["Kathey Marsden (JIRA)" <ji...@apache.org>]

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

Kathey Marsden commented on DERBY-4230:
---------------------------------------

One thing to note that the problem seems to occur on view creation, so  SYS.SYSCOLUMS is incorrect.  This means 
1) If the view  was originally created with version 10.2 or lower, the bug won't manifest itself after soft or hard upgrade to 10.3 or higher.
2) I think when we fix this issue, users who created their views with 10.3 or higher will have to drop and recreate the view to see the fix.


> 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: 10.3.2.1
>            Reporter: Kathey Marsden
>         Attachments: create.sql, 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.