[Firebird-devel] Standard-compliance for query expressions

2021-03-06 Thread Mark Rotteveel
Today, a bug in a development version of Hibernate 6.0 reminded me of problem that Firebird has with query expressions, specifically with parentheses around selects. Specifically, SQL:2016 specifies the following: ``` ::= [ ] [ ] [ ] [ ] ::= | UNION [ ALL | DISTINCT ]

[Firebird-devel] [FB-Tracker] Created: (CORE-6505) ISQL is adding an unnecessary COMMIT WORK statement to the extracted metadata script before starting the Stored functions headers/bodies statements

2021-03-06 Thread Luciano Mendes (JIRA)
ISQL is adding an unnecessary COMMIT WORK statement to the extracted metadata script before starting the Stored functions headers/bodies statements ---

[Firebird-devel] Does deferred processing of DSQL_drop and DSQL_unprepare make sense?

2021-03-06 Thread Mark Rotteveel
Freeing the statement with DSQL_close, DSQL_drop or DSQL_unprepare is deferred (since the v11 protocol). As a result, the free is only sent when something else is subsequently sent over the connection. I wonder if this makes sense for DSQL_drop and DSQL_unprepare, because the end result is tha