You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:19:23 UTC
[jira] [Created] (TRAFODION-1005) LP Bug: 1421374 - Hybrid Query
Cache: precision of real differs when HQC is ON and OFF.
Alice Chen created TRAFODION-1005:
-------------------------------------
Summary: LP Bug: 1421374 - Hybrid Query Cache: precision of real differs when HQC is ON and OFF.
Key: TRAFODION-1005
URL: https://issues.apache.org/jira/browse/TRAFODION-1005
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Julie Thai
Assignee: Howard Qin
Priority: Blocker
Fix For: 1.1 (pre-incubation)
Failing testcase is arkcase/arkt0102/test003.
In TRAF r1.0.0 (HQC off), the following query in trafci, returns:
SQL>select * from p9tab;
C1 C2 C3 C4 C5
------------------------ ------------------------ ------------------------ --------------- ------------------------
NULL NULL NULL NULL 0.0
61.0 52.0 43.0 4.123457 5.12345678901
101.0 102.0 103.0 14.0 15.0
2.0 333.333 40000.0 0.4 100.0
10.0 100.0 1000.0 10000.0 100000.0
21.0 210.0 2100.0 21000.0 210000.0
55.0 550.0 5500.0 55000.0 550000.0
80.0 800.0 8000.0 80000.0 800000.0
--- 8 row(s) selected.
Yet with HQC=ON, this query’s result set diffs. The result set with HQC=ON is:
SQL>select * from p9tab;
C1 C2 C3 C4 C5
------------------------ ------------------------ ------------------------ --------------- ------------------------
NULL NULL NULL NULL 0.0
61.0 52.0 43.0 4.1234565 5.12345678901
101.0 102.0 103.0 14.0 15.0
2.0 333.333 40000.0 0.4 100.0
10.0 100.0 1000.0 10000.0 100000.0
21.0 210.0 2100.0 21000.0 210000.0
55.0 550.0 5500.0 55000.0 550000.0
80.0 800.0 8000.0 80000.0 800000.0
--- 8 row(s) selected.
To reproduce, in trafci:
1. specify CQD HYBRID_QUERY_CACHE '[OFF|ON]';
2. obey repo.sql (see attached file)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)