Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4888

Support for SetQueryLimit

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Minor
    • 10.0
    • None
    • JDBC Connector
    • None

    Description

      OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL:
      SELECT
      g_1.ejer AS c_0
      FROM PUB.modpre AS g_1
      UNION ALL
      SELECT
      g_0.ejer AS c_0
      FROM PUB.modesp AS g_0
      FETCH NEXT 100 ROWS ONLY

      For the view:
      CREATE VIEW Modificaciones(
      ejercicio INTEGER
      )AS SELECT T.ejercicio
      FROM(
      SELECT M.ejercicio,
      FROM sipbas.modesp AS M
      UNION ALL
      SELECT M.ejercicio
      FROM sipbas.modpre AS M) AS T;

      It is necessary to be able to indicate SetQueryLimit in the same way as with SetQueryOrderBy.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            germantejero666 german tejero (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: