Thanks, I was able to find a work around and more clearly identify my issue. https://github.com/h2database/h2database/issues/3058 . Splitting the view into 3 layers made the parser happy. Layer 1 - create select * from x.y views in the default schema. Layer 2 the CTE, layer 3 create view x.c as select * from V_TMPCTE
I will add h2 to our CI pipeline to track when issue goes away. On Thursday, March 11, 2021 at 5:05:38 AM UTC-5 Noel Grandin wrote: > You can try the HEAD of the main git repo, but CTE's in H2 are a bit of a > hack and still have a lot of issues. > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b2257d0f-16a1-46f9-913c-697ac19e0a92n%40googlegroups.com.
