Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

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

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

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 h2-

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Would you mind sharing your fix branch information? Thanks, Jason On Saturday, November 18, 2017 at 10:12:21 AM UTC-5 stu...@gmail.com wrote: > Noel, > > Yes - certainly the session locking (system or connection session) is one > issue I have been wrestling with - especially when the CTE per

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Encountering an error when creating a view of a CTE. Create view select 1 works, the CTE itself works, merging yields a Table T not found error. Did this ever make it in to 1.4.200? If not are there any WIP branches I should look at? -Jason On Saturday, November 18, 2017 at 2:20:48 PM UTC-5 No

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

On 18 November 2017 at 17:12, Stuart McMillan wrote: > Noel, > > Yes - certainly the session locking (system or connection session) is one > issue I have been wrestling with - especially when the CTE persistent views > have to join the parent views lifecycle - I did a hacky-fix which I am not >

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Noel, Yes - certainly the session locking (system or connection session) is one issue I have been wrestling with - especially when the CTE persistent views have to join the parent views lifecycle - I did a hacky-fix which I am not happy about to bypass that (and might not pass a code review). If

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Stuart, I have just pushed some meta-locking debug infrastructure. If you add the -Dh2.check2=true command line option when running H2, it will be turned on. The TestAll code also turns it on. The extra code fails nice and early when a single thread attempts to lock the meta info using two

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

I think, that CTE support for INSERT, UPDATE, DELETE would be great for the next 1.4.197 release. If it is ready now, could it be possible to merge it into next release? In other words it would be fine to have as much as finished and not wait for CTE in CREATE VIEW. Dne čtvrtek 16. listopadu 2

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

On 2017/11/16 3:29 PM, Stuart McMillan wrote: All except create view as are currently working on master branch. Create view as is taking much much longer than i thought, as cte are hard to persist between connections in current architectured form. Got any ideas for fixing that? Maybe we ne

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

All except create view as are currently working on master branch. Create view as is taking much much longer than i thought, as cte are hard to persist between connections in current architectured form. On Nov 16, 2017 6:58 AM, "Noel Grandin" wrote: > @stumc was working on such things, but he see

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

@stumc was working on such things, but he seems to have taken a break ?​ -- 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 h2-database+unsubscr...@googlegroups.com.

[h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Hello, is there any plan to enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS... SQL commands? It would be great to simplify these commands with CTE enabled compared to current very long joins. Regards, Stepan -- You received this mess