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

Support for SetQueryLimit

XMLWordPrintable

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

      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.

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

                Created:
                Updated:
                Resolved: