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 <[email protected]> Authored: Mon Oct 31 15:33:48 2016 +0000 Committer: Suresh Subbiah <[email protected]> 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.
