Derby
  1. Derby
  2. DERBY-4703

Make it possible for table functions to return BOOLEAN columns

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.6.1.0
    • Fix Version/s: 10.7.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      Right now a function cannot return a table with a BOOLEAN column.

        Issue Links

          Activity

          Hide
          Rick Hillegas added a comment -

          Attaching derby-4703-01-aa-booleanTableFunctionColumns.diff. This allows table functions to have BOOLEAN columns. The regression tests passed for me.

          Touches the following files:

          ---------------

          M java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj

          Allow BOOLEAN columns in table functions.

          ---------------

          M java/engine/org/apache/derby/iapi/types/TypeId.java
          M java/engine/org/apache/derby/catalog/types/TypeDescriptorImpl.java

          Adjust type information so that DatabaseMetaData.getFunctionColumns() returns information compatible with ResultSetMetaData.

          ---------------

          M java/testing/org/apache/derbyTesting/functionTests/tests/lang/TableFunctionTest.java

          Regression test.

          Show
          Rick Hillegas added a comment - Attaching derby-4703-01-aa-booleanTableFunctionColumns.diff. This allows table functions to have BOOLEAN columns. The regression tests passed for me. Touches the following files: --------------- M java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj Allow BOOLEAN columns in table functions. --------------- M java/engine/org/apache/derby/iapi/types/TypeId.java M java/engine/org/apache/derby/catalog/types/TypeDescriptorImpl.java Adjust type information so that DatabaseMetaData.getFunctionColumns() returns information compatible with ResultSetMetaData. --------------- M java/testing/org/apache/derbyTesting/functionTests/tests/lang/TableFunctionTest.java Regression test.
          Hide
          Rick Hillegas added a comment -

          Committed at subversion revision 955983.

          Show
          Rick Hillegas added a comment - Committed at subversion revision 955983.

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development