[jira] [Comment Edited] (CALCITE-1265) Implement offset/fetch in JdbcSort

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16336696#comment-16336696 ] 

Julian Hyde edited comment on CALCITE-1265 at 1/24/18 1:04 AM:
---------------------------------------------------------------

I am working on this feature now. In {{SqlDialect}}, I am adding a new method {{unparseOffsetFetch}} and deprecating {{supportsOffsetFetch}}, so each dialect has total control of the syntax it generates.


was (Author: julianhyde):
I am working on this feature now. In {{SqlDialect}}, I am adding a new method {{unparseUnparseOffsetFetch}} and deprecating {{supportsOffsetFetch}}, so each dialect has total control of the syntax it generates.

> Implement offset/fetch in JdbcSort
> ----------------------------------
>
>                 Key: CALCITE-1265
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1265
>             Project: Calcite
>          Issue Type: Improvement
>          Components: jdbc-adapter
>            Reporter: Jordan Halterman
>            Assignee: Julian Hyde
>            Priority: Major
>
> In {{JdbcSort}}, support for offset/fetch is currently disabled. This seems like it may have simply been a result of a lack of support in {{RelToSqlConverter}} at the time that commit was made. Since {{RelToSqlConverter}} got support for offset/fetch in sorts recently, this should be implemented in {{JdbcSort}} as well.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)