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

    • High Value Fix, Patch Available, Release Note Needed
    • 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. create.sql
          0.3 kB
          Katherine Marsden
        2. DERBY-4230_diff.txt
          4 kB
          Katherine Marsden
        3. derby-4230_diff2.txt
          1 kB
          Katherine Marsden
        4. DERBY-4230_preview_diff.txt
          1.0 kB
          Katherine Marsden
        5. releaseNote.html
          4 kB
          Katherine Marsden
        6. ViewTest.java
          1 kB
          Katherine Marsden

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: