Good to know, thanks.
I'll also talk to the Firebird core developers to address the problems
Firebird has with certain parenthesized select fragments (expression body> compared to the SQL standard.
Mark
On 06-03-2021 12:23, Christian Beikov wrote:
That's a bug. It should be a root. I'll fix
That's a bug. It should be a root. I'll fix that on Monday.
Mark Rotteveel schrieb am Sa., 6. März 2021, 11:01:
> For an INSERT ... SELECT, Hibernate (in wip/6.0) will generate a SQL
> statement with parentheses around the select statement.
>
> This happens in AbstractSqlAstTranslator.visitQuery
For an INSERT ... SELECT, Hibernate (in wip/6.0) will generate a SQL
statement with parentheses around the select statement.
This happens in AbstractSqlAstTranslator.visitQuerySpec(QuerySpec
querySpec) because the querySpec is not a root. Firebird doesn't support
a parenthesized select in inse
I was doing some testing Firebird against wip/6.0 and I tripped over the
fact the list of keywords in AnsiSqlKeywords.java (introduced for
https://hibernate.atlassian.net/browse/HHH-9768) is incomplete.
For example, the keyword POSITION is missing from the list, while it is
listed in SQL:2003
