[teiid-issues] [JBoss JIRA] Commented: (TEIID-1681) Limit not working as expected

[Gaurav Chaudhary (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616043#comment-12616043 ] 

Gaurav Chaudhary commented on TEIID-1681:
-----------------------------------------

ProjectNode
  + Output Columns:
    0: ID (long)
    1: ACCESS_MODE (string)
    2: USER_ID (string)
    3: CREATED_ON (string)
    4: NOTE (string)
    5: __objecttype__ (string)
  + Statistics:
    0: Node Output Rows: 2
    1: Node Process Time: 1
    2: Node Cumulative Process Time: 7060
    3: Node Cumulative Next Batch Process Time: 1
    4: Node Next Batch Calls: 2
    5: Node Blocks: 1
  + Cost Estimates:Estimated Node Cardinality: 50.0
  + Child 0:
    ProjectNode
      + Output Columns:
        0: ID (long)
        1: ACCESS_MODE (string)
        2: USER_ID (string)
        3: CREATED_ON (string)
        4: NOTE (string)
      + Statistics:
        0: Node Output Rows: 2
        1: Node Process Time: 0
        2: Node Cumulative Process Time: 7059
        3: Node Cumulative Next Batch Process Time: 0
        4: Node Next Batch Calls: 2
        5: Node Blocks: 1
      + Cost Estimates:Estimated Node Cardinality: 50.0
      + Child 0:
        ProjectNode
          + Output Columns:
            0: ID (long)
            1: ACCESS_MODE (string)
            2: USER_ID (string)
            3: CREATED_ON (string)
            4: NOTE (string)
          + Statistics:
            0: Node Output Rows: 2
            1: Node Process Time: 0
            2: Node Cumulative Process Time: 7059
            3: Node Cumulative Next Batch Process Time: 0
            4: Node Next Batch Calls: 2
            5: Node Blocks: 1
          + Cost Estimates:Estimated Node Cardinality: 50.0
          + Child 0:
            LimitNode
              + Output Columns:
                0: ID (long)
                1: ACCESS_MODE (string)
                2: USER_ID (string)
                3: CREATED_ON (string)
                4: NOTE (string)
              + Statistics:
                0: Node Output Rows: 2
                1: Node Process Time: 0
                2: Node Cumulative Process Time: 7059
                3: Node Cumulative Next Batch Process Time: 0
                4: Node Next Batch Calls: 2
                5: Node Blocks: 1
              + Cost Estimates:Estimated Node Cardinality: 50.0
              + Child 0:
                DependentProcedureAccessNode
                  + Output Columns:
                    0: ID (long)
                    1: NOTE (string)
                    2: USER_ID (string)
                    3: NOTES_TYPE (string)
                    4: ACCESS_MODE (string)
                    5: CREATED_ON (string)
                  + Statistics:
                    0: Node Output Rows: 2
                    1: Node Process Time: 7059
                    2: Node Cumulative Process Time: 7059
                    3: Node Cumulative Next Batch Process Time: 0
                    4: Node Next Batch Calls: 2
                    5: Node Blocks: 1
                  + Cost Estimates:Estimated Node Cardinality: -1.0
                  + Query:EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)
                  + Model Name:chorus_notes
              + Row Offset:null
              + Row Limit:50
          + Select Columns:
            0: ID
            1: ACCESS_MODE
            2: USER_ID
            3: CREATED_ON
            4: NOTE
      + Select Columns:
        0: X.ID
        1: X.ACCESS_MODE
        2: X.USER_ID
        3: X.CREATED_ON
        4: X.NOTE
  + Select Columns:
    0: CHORUS_NOTES.RETRIEVE_NOTES.ID
    1: CHORUS_NOTES.RETRIEVE_NOTES.ACCESS_MODE
    2: CHORUS_NOTES.RETRIEVE_NOTES.USER_ID
    3: CHORUS_NOTES.RETRIEVE_NOTES.CREATED_ON
    4: CHORUS_NOTES.RETRIEVE_NOTES.NOTE
    5: 'chorusdata.note' AS "__objecttype__"


> Limit not working as expected
> -----------------------------
>
>                 Key: TEIID-1681
>                 URL: https://issues.jboss.org/browse/TEIID-1681
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 7.3
>            Reporter: Gaurav Chaudhary
>            Assignee: Steven Hawkins
>              Labels: Limit
>
> select CHORUS_B."ID", CHORUS_B."ACCESS_MODE", CHORUS_B."USER_ID", CHORUS_B."CREATED_ON", CHORUS_B."NOTE",'chorusdata.note' as "__objecttype__" from 
> (select * from chorus_notes.RETRIEVE_NOTES where 
> OBJECT_PKEY = 
> xmlserialize(xmlelement("demodata.rule", XMLATTRIBUTES(cast('name 1' as String) as "name",cast('sysid 0' as String) as "system",cast('user 1000' as String) as "user")) as String)) as CHORUS_B     LIMIT 50
> This query is not returning correct results unless we remove Limit from this.
> If we include Limit over here, it interchanges the columns and returning incorrect data.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira