[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-293) Seperating InterBase and Firebird dialects

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Reha CENANI
    Created: Wed, 27 Aug 2003 2:45 AM
       Body:
Regarding the select limit issues, please find below the explanations from their documentations.

*** For Firebird: ***
SELECT [FIRST (<integer expr m>)] [SKIP (<integer expr n>)] ...

Retrieves the first m rows of the selected output set. The optional SKIP clause will cause the first n rows to be discarded and return an output set of m rows starting at n + 1. In the simplest form, m and n are integers but any Firebird expression that evaluates to an integer is valid. Parentheses are required for expression arguments and optional otherwise.

bindLimitParametersFirst() --> true
bindLimitParametersInReverseOrder() --> true


*** For InterBase: ***
SELECT ... [ROWS <value> [TO <upper_value>] [BY <step_value>] [PERCENT] [WITH TIES]]

* <value> is the total number of rows to return if used by itself
* <value> is the starting row number to return if used with TO
* <value> is the percent if used with PERCENT
* <upper_value> is the last row or highest percent to return
* If <step_value> = n, returns every n'th row, or n percent rows
* PERCENT causes all previous ROWS values to be interpreted as percents
* WITH TIES returns additional duplicate rows when the last value in the ordered sequence is the same as values in subsequent rows of the result set; must be used in conjunction with ORDER BY

bindLimitParametersFirst() --> false
bindLimitParametersInReverseOrder() --> false


---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-293


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-293
    Summary: Seperating InterBase and Firebird dialects
       Type: Improvement

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: Reha CENANI

    Created: Tue, 26 Aug 2003 6:46 AM
    Updated: Tue, 26 Aug 2003 6:46 AM

Description:
At the begining, opensource Firebird (or FirebirdSQL) was based on the same source code of commercial InterBase. But during past three years, lots of improvements are done to the Firebird. Recent versions of these DBMSs have different features and statement syntaxes. 

For example, their select offset/limit statement syntaxes are not compatible. Hibernate's recent InterbaseDialect select limit/offset feature is based on the Firebird's select statement syntax.

So, in order to prevent incompabilities and confussion, in addition to the InterbaseDialect, adding a new FirebirdDialect and seperating Firebird and InterBase features will be very helpfull.





---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira