Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1420

DatabaseMetaData.getschemas returns incorrect column order

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.3.0, 3.3.0, 4.2.1, 3.2.1
    • Labels:
      None
    • Environment:

      all OS

      Description

      DatabaseMetaData.getSchemas returns incorrect column order. According to java 6 api doc, getSchemas should return answer set columns in the following order:

      1.TABLE_SCHEM String => schema name
      2.TABLE_CATALOG String => catalog name

      The Phoenix JDBC driver returns these in reverse column order, i.e.
      1. TABLE_CATALOG
      2. TABLE_SCHEM

      Our experience with other JDBC drivers is that they return the data w/ TABLE_SCHEM being the first column.

        Attachments

        1. PHOENIX-1420.patch
          2 kB
          James R. Taylor

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sergiolob Sergio Lob
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: