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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.2.1
• Fix Version/s: 10.3.3.1, 10.4.2.1, 10.5.2.0, 10.6.1.0
• Component/s: JDBC
• Issue & fix info: High Value Fix, Patch Available, Release Note Needed
• Bug behavior facts: Regression
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 14/May/09 20:16
• Updated: 16/Jul/09 21:24
• Resolved: 30/May/09 14:01

Description

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

Issue Links

• is related to: DERBY-681 Eliminate the parser's rewriting of the abstract syntax tree for queries with GROUP BY and/or HAVING clauses