[jira] [Created] (TRAFODION-595) LP Bug: 1364928 - WHERE on ROWNUM not working

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-595:
------------------------------------

             Summary: LP Bug: 1364928 - WHERE on ROWNUM not working
                 Key: TRAFODION-595
                 URL: https://issues.apache.org/jira/browse/TRAFODION-595
             Project: Apache Trafodion
          Issue Type: Wish
          Components: sql-exe
            Reporter: Holm Steinland
            Assignee: Anoop Sharma
            Priority: Minor


Our case: We have a table COUNTRY with all entries for the world.
doing an 
         select count(*) from country;
gives back the correct count on the table.

Doing an select like
         select rownum, * from country where rownum <= 50;
gives back the expected first 50 rows of the table.

Doing an COUNT of the same
       select count(*) from country where rownum <= 50;
gives however the total rows of the table like it ignore the "ROWNUM" restriction. 
Expected result would be 50.



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