Good to know, thanks.
I'll also talk to the Firebird core developers to address the problems
Firebird has with certain parenthesized select fragments (<qurey
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 on Monday.
Mark Rotteveel <m...@lawinegevaar.nl <mailto:m...@lawinegevaar.nl>>
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.visitQuerySpec(QuerySpec
querySpec) because the querySpec is not a root. Firebird doesn't
support
a parenthesized select in insert (yet).
What would be the best way to address this in the AstTranslator or
elsewhere? Overriding the entire visitQuerySpec(QuerySpec querySpec)
method could be brittle as significant changes would need to be
replicated to the Firebird-specific translator, and this only really
applies when processing a select in an insert statement (I think; there
are some other places where Firebird doesn't support parenthesized
selects where the standard does).
Mark
--
Mark Rotteveel
_______________________________________________
hibernate-dev mailing list -- hibernate-dev@lists.jboss.org
<mailto:hibernate-dev@lists.jboss.org>
To unsubscribe send an email to hibernate-dev-le...@lists.jboss.org
<mailto:hibernate-dev-le...@lists.jboss.org>
%(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
--
Mark Rotteveel
_______________________________________________
hibernate-dev mailing list -- hibernate-dev@lists.jboss.org
To unsubscribe send an email to hibernate-dev-le...@lists.jboss.org
%(web_page_url)slistinfo%(cgiext)s/%(_internal_name)s
