[h2] Column not found when SELECTing from a recursive Common Table Expression (CTE)

Hello all, I'm new to the group so I apologize if this question has already been answered elsewhere. I'm just hoping someone has some ideas of what could be happening, as I'm running out of ideas. Let's suppose I'm retrieving some data from a table that has a parent/child reference. I'm using

Re: [h2] Column not found when SELECTing from a recursive Common Table Expression (CTE)

Greetings! While I am not a developer, but just an H2 user I would like to recommend to provide: 1) the DDL to create table_1 and table_2 and 2) some DML to fill it with data This way we can reproduce your samples easily, with different versions of H2. That said, the CTEs are still considered e

Re: [h2] Column not found when SELECTing from a recursive Common Table Expression (CTE)

Hi Andreas, Thanks for the quick reply. I think I may have already determined the cause of my stress. I am using H2 in conjunction with Jasper Reports. The report I am running against the database has several subreports, and some of the subreports were using the same name for the CTEs. So, I w

Re: [h2] Column not found when SELECTing from a recursive Common Table Expression (CTE)

Unfortunately CTE's in H2 are currently pretty bad, and nobody has felt sufficiently motivated to do the surgery that is necessary to accomodate them really well. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and