Author: shawkins Date: 2012-08-30 14:09:32 -0400 (Thu, 30 Aug 2012) New Revision: 4384 Modified: trunk/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected trunk/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected trunk/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected Log: TEIID-2111 return params are now forced to be the first param (jdbc convention) Modified: trunk/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected =================================================================== --- trunk/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected 2012-08-30 18:08:53 UTC (rev 4383) +++ trunk/test-integration/common/src/test/resources/TestMMDatabaseMetaData/testGetProcedureColumns.expected 2012-08-30 18:09:32 UTC (rev 4384) @@ -50,12 +50,12 @@ QT_Ora9DS SYSADMIN logMsg context 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 3 NO logMsg QT_Ora9DS SYSADMIN logMsg msg 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 4 NO logMsg QT_Ora9DS SYSADMIN logMsg logged 5 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 1 NO logMsg -QT_Ora9DS SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO refreshMatView -QT_Ora9DS SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView -QT_Ora9DS SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView -QT_Ora9DS SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow -QT_Ora9DS SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow -QT_Ora9DS SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +QT_Ora9DS SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView +QT_Ora9DS SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow +QT_Ora9DS SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +QT_Ora9DS SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow QT_Ora9DS SYSADMIN setColumnStats tableName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO setColumnStats QT_Ora9DS SYSADMIN setColumnStats columnName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO setColumnStats QT_Ora9DS SYSADMIN setColumnStats distinctCount 1 4 integer 10 4 0 10 1 <null> <null> <null> <null> <null> 3 YES setColumnStats Modified: trunk/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected =================================================================== --- trunk/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected 2012-08-30 18:08:53 UTC (rev 4383) +++ trunk/test-integration/common/src/test/resources/TestPartsDatabaseMetadata/testProcedureColumns.expected 2012-08-30 18:09:32 UTC (rev 4384) @@ -9,12 +9,12 @@ PartsSupplier SYSADMIN logMsg context 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 3 NO logMsg PartsSupplier SYSADMIN logMsg msg 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 4 NO logMsg PartsSupplier SYSADMIN logMsg logged 5 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 1 NO logMsg -PartsSupplier SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO refreshMatView -PartsSupplier SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 2 NO refreshMatView -PartsSupplier SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView -PartsSupplier SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow -PartsSupplier SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow -PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +PartsSupplier SYSADMIN refreshMatView ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatView +PartsSupplier SYSADMIN refreshMatView Invalidate 1 -7 boolean 1 1 0 10 0 <null> <null> <null> <null> <null> 3 NO refreshMatView +PartsSupplier SYSADMIN refreshMatView RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatView +PartsSupplier SYSADMIN refreshMatViewRow ViewName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO refreshMatViewRow +PartsSupplier SYSADMIN refreshMatViewRow Key 1 2000 object 2147483647 2147483647 0 0 0 <null> <null> <null> <null> <null> 3 NO refreshMatViewRow +PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated 5 4 integer 10 4 0 10 0 <null> <null> <null> <null> <null> 1 NO refreshMatViewRow PartsSupplier SYSADMIN setColumnStats tableName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 1 NO setColumnStats PartsSupplier SYSADMIN setColumnStats columnName 1 12 string 4000 4000 0 0 0 <null> <null> <null> <null> <null> 2 NO setColumnStats PartsSupplier SYSADMIN setColumnStats distinctCount 1 4 integer 10 4 0 10 1 <null> <null> <null> <null> <null> 3 YES setColumnStats Modified: trunk/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected =================================================================== --- trunk/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected 2012-08-30 18:08:53 UTC (rev 4383) +++ trunk/test-integration/common/src/test/resources/TestSystemVirtualModel/testProcedureParams.expected 2012-08-30 18:09:32 UTC (rev 4384) @@ -1,15 +1,15 @@ string string string string string integer string boolean integer integer integer integer string string string integer VDBName SchemaName ProcedureName Name DataType Position Type Optional Precision TypeLength Scale Radix NullType UID Description OID -PartsSupplier SYSADMIN refreshMatView Invalidate boolean 2 In false 1 1 0 10 No Nulls tid:60b87e792634-09a20d5b-00000019 <null> 11 -PartsSupplier SYSADMIN refreshMatViewRow Key object 2 In false 0 2147483647 0 0 No Nulls tid:60b87e792634-0001263f-0000001d <null> 14 +PartsSupplier SYSADMIN refreshMatView Invalidate boolean 3 In false 1 1 0 10 No Nulls tid:60b87e792634-09a20d5b-0000001a <null> 12 +PartsSupplier SYSADMIN refreshMatViewRow Key object 3 In false 0 2147483647 0 0 No Nulls tid:60b87e792634-0001263f-0000001e <null> 15 PartsSupplier SYSADMIN setProperty Name string 3 In false 0 4000 0 0 No Nulls tid:60b87e792634-0024eeab-00000029 <null> 24 PartsSupplier SYSADMIN setProperty OldValue clob 1 ReturnValue false 0 2097152 0 0 No Nulls tid:60b87e792634-0f2c17aa-00000027 <null> 22 -PartsSupplier SYSADMIN refreshMatView RowsUpdated integer 3 ReturnValue false 10 4 0 10 No Nulls tid:60b87e792634-884f8882-0000001a <null> 12 -PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated integer 3 ReturnValue false 10 4 0 10 No Nulls tid:60b87e792634-884f8882-0000001e <null> 15 +PartsSupplier SYSADMIN refreshMatView RowsUpdated integer 1 ReturnValue false 10 4 0 10 No Nulls tid:60b87e792634-884f8882-00000018 <null> 10 +PartsSupplier SYSADMIN refreshMatViewRow RowsUpdated integer 1 ReturnValue false 10 4 0 10 No Nulls tid:60b87e792634-884f8882-0000001c <null> 13 PartsSupplier SYSADMIN setProperty UID string 2 In false 0 50 0 0 No Nulls tid:60b87e792634-00014830-00000028 <null> 23 PartsSupplier SYSADMIN setProperty Value clob 4 In false 0 2097152 0 0 Nullable tid:60b87e792634-04e9a151-0000002a <null> 25 -PartsSupplier SYSADMIN refreshMatView ViewName string 1 In false 0 4000 0 0 No Nulls tid:60b87e792634-4b1eb2f0-00000018 <null> 10 -PartsSupplier SYSADMIN refreshMatViewRow ViewName string 1 In false 0 4000 0 0 No Nulls tid:60b87e792634-4b1eb2f0-0000001c <null> 13 +PartsSupplier SYSADMIN refreshMatView ViewName string 2 In false 0 4000 0 0 No Nulls tid:60b87e792634-4b1eb2f0-00000019 <null> 11 +PartsSupplier SYSADMIN refreshMatViewRow ViewName string 2 In false 0 4000 0 0 No Nulls tid:60b87e792634-4b1eb2f0-0000001d <null> 14 PartsSupplier SYSADMIN setTableStats cardinality integer 2 In false 10 4 0 10 No Nulls tid:60b87e792634-3260ed8e-0000002d <null> 27 PartsSupplier SYSADMIN setColumnStats columnName string 2 In false 0 4000 0 0 No Nulls tid:60b87e792634-827e2701-00000021 <null> 17 PartsSupplier SYSADMIN isLoggable context string 3 In false 0 4000 0 0 No Nulls tid:60b87e792634-38b735af-00000011 <null> 5