You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/27 20:53:48 UTC
[jira] [Closed] (TRAFODION-1005) LP Bug: 1421374 - Hybrid Query
Cache: precision of real differs when HQC is ON and OFF.
[ 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)