-
Bug
-
Resolution: Fixed
-
P3
-
1.4.1
-
b91
-
generic
-
generic
-
Not verified
Need to further clarify how ORDINAL_POSITION is used when a result set is returned via getProcedureColumns
The ordering of columns returned by getProcedureColumns should match ODBC which is defined as
SQLProcedureColumns returns the results as a standard result set, ordered by PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, and COLUMN_TYPE. Column names are returned for each procedure in the following order: the name of the return value, the names of each parameter in the procedure invocation (in call order), and then the names of each column in the result set returned by the procedure (in column order).
Need to add see PROCEDURE_CAT as the first column in the order by clause
javadoc for getColumnPrivileges() and getTablePrivileges() GRANTOR column is missing the definition of its data type returned which is a String
The ordering of columns returned by getProcedureColumns should match ODBC which is defined as
SQLProcedureColumns returns the results as a standard result set, ordered by PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, and COLUMN_TYPE. Column names are returned for each procedure in the following order: the name of the return value, the names of each parameter in the procedure invocation (in call order), and then the names of each column in the result set returned by the procedure (in column order).
Need to add see PROCEDURE_CAT as the first column in the order by clause
javadoc for getColumnPrivileges() and getTablePrivileges() GRANTOR column is missing the definition of its data type returned which is a String