[jira] [Closed] (TRAFODION-169) LP Bug: 1272095 - [any N] does not have any effect on a particular query

["Atanu Mishra (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Atanu Mishra closed TRAFODION-169.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: Anoop Sharma)
    Fix Version/s: 1.0 (pre-incubation)

> LP Bug: 1272095 - [any N] does not have any effect on a particular query
> ------------------------------------------------------------------------
>
>                 Key: TRAFODION-169
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-169
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>            Reporter: Weishiun Tsai
>            Priority: Critical
>             Fix For: 1.0 (pre-incubation)
>
>
> With this particular query, [any N] does not have any effect. As shown in the following output, [any 1] still returns 4 rows, while [first 1] works fine and returns only 1 row.
> This is seen on the beta build trafodion-ci-release-trafodion_beta-20140117-v36857_release.tar installed on a workstation.
> >>create table t (large_int LARGEINT not null not droppable, pic_252 PIC X(246) not null not droppable, pic_1 PIC X not null not droppable, PRIMARY KEY (large_int DESC) not droppable);
> --- SQL operation complete.
> >>insert into t values (3000,'george','D'),(100,'carltons','E'),(1000,'harveys','B'),(300,'Q','X'),(2000,'alexander','B'),(400,'joseph','X'),(200,'squaw','X'),(4000,'valley','D');
> --- 8 row(s) inserted.
> >>select pic_1,large_int
> from t
> where large_int >= 100
> group by pic_1,large_int
> having large_int in (100,200,1000,2000)
> order by pic_1,large_int;+>+>+>+>+>
> PIC_1 LARGE_INT
> ----- --------------------
> B 1000
> B 2000
> E 100
> X 200
> --- 4 row(s) selected.
> >>select [any 1] pic_1,large_int
> from t
> where large_int >= 100
> group by pic_1,large_int
> having large_int in (100,200,1000,2000)
> order by pic_1,large_int;+>+>+>+>+>
> PIC_1 LARGE_INT
> ----- --------------------
> B 1000
> B 2000
> E 100
> X 200
> --- 4 row(s) selected.
> >>select [first 1] pic_1,large_int
> from t
> where large_int >= 100
> group by pic_1,large_int
> having large_int in (100,200,1000,2000)
> order by pic_1,large_int;+>+>+>+>+>
> PIC_1 LARGE_INT
> ----- --------------------
> B 1000
> --- 1 row(s) selected.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)