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
Show replies by date