On Tuesday, 4 December 2018 13:10:37 UTC, Noel Grandin wrote: > > you are missing a terminating $$, see examples here > > http://h2database.com/html/grammar.html#create_alias > > I guess that Spring is stripping it for some reason, you'd have to ask > them why. > > > If you refer to Christian's response at 1509 and my response you can see that H2 appears to interpret the semicolon associated with the Java return statement as the termination of the SQL command, even though it lies within the $$ ... $$ delimiters for the Java code. If I remove that semi colon, then the SQL is executed but fails due to a Java compilation error - because of a missing semicolon.
Perhaps that is a bug in H2? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
