cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 15064] New: - [PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported
Date Wed, 04 Dec 2002 13:29:38 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064

[PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported

           Summary: [PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer
                    supported
           Product: Cocoon 2
           Version: Current CVS
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: general components
        AssignedTo: cocoon-dev@xml.apache.org
        ReportedBy: michael.enke@wincor-nixdorf.com


since postgresql 7.3, the syntax "LIMIT x,y" has changed to "LIMIT x OFFSET y"
This must be reflected in EsqlQuery.java
This works also for pre 7.3 postgres (I have 7.2.3) but I don't know since when.

EsqlQuery.java simplifies to:

      case EsqlConnection.LIMIT_METHOD_POSTGRESQL:
        if (maxRows > -1) query = query + " LIMIT "  + maxRows;
        if (skipRows > 0) query = query + " OFFSET " + skipRows;
      case EsqlConnection.LIMIT_METHOD_MYSQL: ...

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message