[JBoss JIRA] (TEIID-3815) Oracle translator - OFFSET function does not work - teiid-issues

Thursday, 9 June 2016

     [
https://issues.jboss.org/browse/TEIID-3815?page=com.atlassian.jira.plugin...
]

Juraj Duráni reopened TEIID-3815:
---------------------------------

The Teiid still returns no row.

...
From the log: {code:plain}
15:19:50,124 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Processing NEW request: SELECT g_0.INTKEY AS c_0 FROM Source.SMALLA
AS g_0 ORDER BY c_0 OFFSET 45 ROWS
15:19:50,125 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Obtained execution
15:19:50,125 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78) Source-specific
command: SELECT c_0 FROM (SELECT g_0."INTKEY" AS c_0 FROM
"DV"."SMALLA" g_0 ORDER BY c_0) WHERE ROWNUM > 45
15:19:50,269 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Executed command
15:19:50,270 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Processing MORE request
15:19:50,270 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Getting results from connector
15:19:50,270 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue78)
VAmB/CPZtJOo.12.0.13 Obtained last batch, total row count: 0
{code}

...
 Oracle translator - OFFSET function does not work
 -------------------------------------------------

                 Key: TEIID-3815
                 URL: https://issues.jboss.org/browse/TEIID-3815
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.7.2.6_2
            Reporter: Juraj Duráni
            Assignee: Steven Hawkins
             Fix For: 8.12.2, 8.13

 Oracle translator translates OFFSET function as:
 {code:sql}
 SELECT c_0 FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (***Query***)
VIEW_FOR_LIMIT WHERE ROWNUM <= -2147483604) WHERE ROWNUM_ > 45
 {code}
 This always returns an empty result because of *ROWNUM <= -2147483604*.
 Example:
 Query:
 {code:sql}
 SELECT INTKEY FROM bqt1.smalla ORDER BY INTKEY OFFSET 45 ROWS
 {code}
 Source-specific command:
 {code:sql}
 SELECT c_0 FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (SELECT
trunc(g_0."INTKEY") AS c_0 FROM "DV"."SMALLA" g_0 ORDER BY
c_0) VIEW_FOR_LIMIT WHERE ROWNUM <= -2147483604) WHERE ROWNUM_ > 45
 {code} 

--
This message was sent by Atlassian JIRA
(v6.4.11#64026)

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

[JBoss JIRA] (TEIID-3815) Oracle translator - OFFSET function does not work