You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2016/10/31 20:42:29 UTC
[1/2] incubator-trafodion git commit: Regression testware change for
compGeneral/TEST042
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 6a130fc87 -> 07a77b8cd
Regression testware change for compGeneral/TEST042
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/4f90fd7c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/4f90fd7c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/4f90fd7c
Branch: refs/heads/master
Commit: 4f90fd7c9a7f4b6e11cbd71c4104dfe667cd6074
Parents: 2c3c7c5
Author: Suresh Subbiah <su...@apache.org>
Authored: Mon Oct 31 15:33:48 2016 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Mon Oct 31 15:33:48 2016 +0000
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED042 | 74 ++++++++-------------------
1 file changed, 21 insertions(+), 53 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/4f90fd7c/core/sql/regress/compGeneral/EXPECTED042
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED042 b/core/sql/regress/compGeneral/EXPECTED042
index f6c7543..28e96e3 100644
--- a/core/sql/regress/compGeneral/EXPECTED042
+++ b/core/sql/regress/compGeneral/EXPECTED042
@@ -1,9 +1,9 @@
>>showstats for table t042_orderline on ol_o_id detail;
Detailed Histogram data for Table TRAFODION.ORDERENTRY.T042_ORDERLINE
-Table ID: 4943375013317643387
+Table ID: 3259029604783386160
-Hist ID: 796718003
+Hist ID: 335115597
Column(s): OL_O_ID
Total Rows: 10
Total UEC: 4
@@ -1789,7 +1789,7 @@ HQC key=SELECT T . VARCHAR0_UNIQ AS T_VARCHAR0_UNIQ , T . CHAR2_2 AS T_CHAR2_2 ,
>>-- test compile time
>>
>>sh more /proc/loadavg | cut -d' ' -f 1-3 | sed -e 's/^/System load: /' >> LOG042;
-System load: 2.85 3.75 3.68
+System load: 1.49 2.62 3.49
>>sh grep "model name" /proc/cpuinfo | head -1 | cut -d '@' -f 2 | sed -e 's/^/CPU frequency: /' >> LOG042;
CPU frequency: model name : Intel Core Processor (Haswell)
>>set statistics on;
@@ -1797,10 +1797,10 @@ CPU frequency: model name : Intel Core Processor (Haswell)
--- SQL command prepared.
-Start Time 2016/10/19 02:41:10.451650
-End Time 2016/10/19 02:41:10.455362
-Elapsed Time 00:00:00.003712
-Compile Time 00:00:00.003712
+Start Time 2016/10/28 23:22:16.629785
+End Time 2016/10/28 23:22:16.633290
+Elapsed Time 00:00:00.003505
+Compile Time 00:00:00.003505
Execution Time 00:00:00.000000
@@ -1831,10 +1831,10 @@ HQC key=SELECT * FROM T042_ORDERLINE WHERE OL_O_ID = #NP# ;
--- SQL command prepared.
-Start Time 2016/10/19 02:41:10.663273
-End Time 2016/10/19 02:41:10.667240
-Elapsed Time 00:00:00.003967
-Compile Time 00:00:00.003967
+Start Time 2016/10/28 23:22:16.818294
+End Time 2016/10/28 23:22:16.820789
+Elapsed Time 00:00:00.002495
+Compile Time 00:00:00.002495
Execution Time 00:00:00.000000
@@ -1875,7 +1875,7 @@ NUM_ENTRIES TEXT_ENTRIES NUM_PLANS
NUM_ENTRIES TEXT_ENTRIES NUM_PLANS
----------- ------------ ----------
- 31 0 31
+ 23 0 23
2 0 2
--- 2 row(s) selected.
@@ -1888,7 +1888,7 @@ NUM_ENTRIES TEXT_ENTRIES NUM_PLANS
----------- ------------ ----------
65 10 65
- 31 0 31
+ 23 0 23
2 0 2
--- 3 row(s) selected.
@@ -1984,10 +1984,6 @@ NUM_HITS NUM_PARAMS
0 1
0 1
0 1
- 0 1
- 0 1
- 0 1
- 0 1
0 2
0 2
0 2
@@ -1999,10 +1995,6 @@ NUM_HITS NUM_PARAMS
0 5
1 1
1 1
- 1 1
- 1 1
- 1 1
- 1 1
1 2
1 2
1 3
@@ -2012,9 +2004,9 @@ NUM_HITS NUM_PARAMS
2 1
2 3
3 3
- 12 4
+ 9 4
---- 33 row(s) selected.
+--- 25 row(s) selected.
>>select num_hits, num_params from table(querycacheentries('ustats', 'local')) order by 1,2;
--- 0 row(s) selected.
@@ -2086,10 +2078,6 @@ NUM_HITS NUM_PARAMS
0 1
0 1
0 1
- 0 1
- 0 1
- 0 1
- 0 1
0 2
0 2
0 2
@@ -2113,10 +2101,6 @@ NUM_HITS NUM_PARAMS
1 1
1 1
1 1
- 1 1
- 1 1
- 1 1
- 1 1
1 2
1 2
1 2
@@ -2130,9 +2114,9 @@ NUM_HITS NUM_PARAMS
2 3
3 3
5 1
- 12 4
+ 9 4
---- 108 row(s) selected.
+--- 100 row(s) selected.
>>
>>
>>--Stats in Hybrid Query Cache
@@ -2149,7 +2133,7 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
---------- ---------- ---------------------- ----------------------
- 29 31 5 211
+ 23 23 5 211
2 2 5 211
--- 2 row(s) selected.
@@ -2162,7 +2146,7 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
---------- ---------- ---------------------- ----------------------
37 60 5 211
- 29 31 5 211
+ 23 23 5 211
2 2 5 211
--- 3 row(s) selected.
@@ -2254,14 +2238,6 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
208 0 5 0
222 0 3 1
222 1 3 1
- 270 0 1 0
- 270 1 1 0
- 282 0 1 0
- 282 1 1 0
- 308 0 1 10
- 308 0 1 10
- 308 1 1 10
- 308 1 1 10
314 0 3 1
314 0 3 1
314 2 1 0
@@ -2273,7 +2249,7 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
619 0 1 14
619 0 1 14
---- 33 row(s) selected.
+--- 25 row(s) selected.
>>select char_length(hkey), num_hits, num_PLiterals, num_NPLiterals from table(hybridquerycacheentries('ustats', 'local')) order by 1, 2, 3, 4;
--- 0 row(s) selected.
@@ -2357,14 +2333,6 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
208 0 5 0
222 0 3 1
222 1 3 1
- 270 0 1 0
- 270 1 1 0
- 282 0 1 0
- 282 1 1 0
- 308 0 1 10
- 308 0 1 10
- 308 1 1 10
- 308 1 1 10
314 0 3 1
314 0 3 1
314 2 1 0
@@ -2376,7 +2344,7 @@ NUM_HKEYS NUM_SKEYS NUM_MAX_VALUES_PER_KEY NUM_HASH_TABLE_BUCKETS
619 0 1 14
619 0 1 14
---- 93 row(s) selected.
+--- 85 row(s) selected.
>>
>>
>>-- virtual table ISP queries are not cacheable.
[2/2] incubator-trafodion git commit: Merge [TRAFODION-None] PR-804
Testware change for compGeneral/TEST042
Posted by su...@apache.org.
Merge [TRAFODION-None] PR-804 Testware change for compGeneral/TEST042
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/07a77b8c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/07a77b8c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/07a77b8c
Branch: refs/heads/master
Commit: 07a77b8cdb1733aa0c799a3ad04e316382fecc4c
Parents: 6a130fc 4f90fd7
Author: Suresh Subbiah <su...@apache.org>
Authored: Mon Oct 31 20:42:10 2016 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Mon Oct 31 20:42:10 2016 +0000
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED042 | 74 ++++++++-------------------
1 file changed, 21 insertions(+), 53 deletions(-)
----------------------------------------------------------------------