[
https://issues.apache.org/jira/browse/TRAFODION-1005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-1005.
-------------------------------------
> 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)
