Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Bad SQL rendered for FOR UPDATE clause in Firebird #3186

Closed
lukaseder opened this issue Apr 14, 2014 · 0 comments
Closed

Bad SQL rendered for FOR UPDATE clause in Firebird #3186

lukaseder opened this issue Apr 14, 2014 · 0 comments
Labels
C: DB: Firebird C: Functionality P: High R: Fixed T: Defect
Milestone
Version 3.4.0

Comments

@lukaseder
Copy link
Member

Apparently, Firebird's understanding of FOR UPDATE is not the same as everyone else's, and we should thus render different SQL

See also:
https://groups.google.com/forum/#!topic/jooq-user/pSZH0c_x6Xk
@lukaseder lukaseder added this to the Version 3.4.0 milestone Apr 14, 2014
lukaseder added a commit that referenced this issue Apr 29, 2014
@lukaseder
[#3186] Bad SQL rendered for FOR UPDATE clause in Firebird
a02e496
lukaseder added a commit that referenced this issue Jul 14, 2014
@lukaseder
Version 3.3.3 - July 14, 2014
772841f 
================================================================================

This is a patch release with some useful fixes for the 3.3 branch

Bug fixes
---------
#2335 - SQL syntax error when projecting two columns of the same name along with
        a LIMIT clause in Oracle
#2646 - SQL Server error "The text, ntext, and image data types cannot be
        compared or sorted" when using LIMIT with a SELECT [text, image]
        statement
#2700 - DAO.insert() and other DAO operations do not respect DEFAULT values
#3186 - Bad SQL rendered for FOR UPDATE clause in Firebird
#3191 - ResultQuery.keepStatement(true) doesn't work correctly with
        DataSourceConnectionProvider
#3195 - IN predicate with subquery cannot have LIMIT .. OFFSET clause in Oracle
#3200 - Converter does not work when loading CSV files
#3226 - DefaultConnectionProvider shouldn't use DSL class for DEBUG logging
#3234 - Connection Leak With BatchCRUD operations
#3241 - Cursor.iterator() does not correctly implement Iterator.next() contract
        with respect to NoSuchElementException
#3244 - InsertQuery.setDefaultValues() is not supported by the ACCESS dialect
#3267 - Misleading DSLContext#batch Javadoc. It should be clear that an
        additional call to execute() is needed.
#3277 - SQLite DECIMAL(p, s) types are not correctly recognised
#3282 - inputSchema / outputSchema codegen configuration has no effect in
        Oracle, if inputSchema is lower-cased
#3294 - DSLContext.renderNamedParameters() doesn't replace ?, ? by :1, :2 in
        plain SQL QueryParts
#3309 - Don't use "deploy" as Maven <defaultGoal/>
#3328 - Re-create old DefaultConfiguration constructors for backwards-
        compatibility
#3333 - maven-compiler-plugin configuration in jooq-parent pom file uses the
        deprecated compilerArguments parameter
#3342 - Cannot INSERT into tables with Firebird BLOB types
#3347 - Field.in(T...) should defend against Collection arguments
#3382 - NOT NULL constraints and type information are incorrectly generated when
        using Firebird DOMAINs for data types
#3388 - Replace SQL Server's ROW_NUMBER() OVER(ORDER BY @@Version) by ORDER BY
        (SELECT 0)
lukaseder added a commit that referenced this issue Jul 15, 2014
@lukaseder
Version 3.2.6 - July 15, 2014
54ce413 
================================================================================

This is a patch release with some useful fixes for the 2.6 branch

Bug fixes
---------
#2335 - SQL syntax error when projecting two columns of the same name along with
        a LIMIT clause in Oracle
#2646 - SQL Server error "The text, ntext, and image data types cannot be
        compared or sorted" when using LIMIT with a SELECT [text, image]
        statement
#2700 - DAO.insert() and other DAO operations do not respect DEFAULT values
#3186 - Bad SQL rendered for FOR UPDATE clause in Firebird
#3191 - ResultQuery.keepStatement(true) doesn't work correctly with
        DataSourceConnectionProvider
#3195 - IN predicate with subquery cannot have LIMIT .. OFFSET clause in Oracle
#3200 - Converter does not work when loading CSV files
#3226 - DefaultConnectionProvider shouldn't use DSL class for DEBUG logging
#3234 - Connection Leak With BatchCRUD operations
#3241 - Cursor.iterator() does not correctly implement Iterator.next() contract
        with respect to NoSuchElementException
#3267 - Misleading DSLContext#batch Javadoc. It should be clear that an
        additional call to execute() is needed.
#3277 - SQLite DECIMAL(p, s) types are not correctly recognised
#3282 - inputSchema / outputSchema codegen configuration has no effect in
        Oracle, if inputSchema is lower-cased
#3294 - DSLContext.renderNamedParameters() doesn't replace ?, ? by :1, :2 in
        plain SQL QueryParts
#3309 - Don't use "deploy" as Maven <defaultGoal/>
#3328 - Re-create old DefaultConfiguration constructors for backwards-
        compatibility
#3333 - maven-compiler-plugin configuration in jooq-parent pom file uses the
        deprecated compilerArguments parameter
#3342 - Cannot INSERT into tables with Firebird BLOB types
#3347 - Field.in(T...) should defend against Collection arguments
#3382 - NOT NULL constraints and type information are incorrectly generated when
        using Firebird DOMAINs for data types
#3388 - Replace SQL Server's ROW_NUMBER() OVER(ORDER BY @@Version) by ORDER BY
        (SELECT 0)
@lukaseder lukaseder mentioned this issue May 11, 2022
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C: DB: Firebird C: Functionality P: High R: Fixed T: Defect
Projects
None yet
Milestone
Version 3.4.0
Development

No branches or pull requests
1 participant
@lukaseder