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)