Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4230

DatabaseMetaData.getColumns() returns extra column from view with group by and expression in SELECT list

    XMLWordPrintableJSON

    Details

    • Issue & fix info:
      High Value Fix, Patch Available, Release Note Needed
    • Bug behavior facts:
      Regression

      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

        Attachments

        1. ViewTest.java
          1 kB
          Katherine Marsden
        2. releaseNote.html
          4 kB
          Katherine Marsden
        3. DERBY-4230_preview_diff.txt
          1.0 kB
          Katherine Marsden
        4. derby-4230_diff2.txt
          1 kB
          Katherine Marsden
        5. DERBY-4230_diff.txt
          4 kB
          Katherine Marsden
        6. create.sql
          0.3 kB
          Katherine Marsden

          Issue Links

            Activity

              People

              • Assignee:
                kmarsden Katherine Marsden
                Reporter:
                kmarsden Katherine Marsden
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: