17:00 — Adding multi table queries with Simple DTs

17:21 — Two base table inside single DT queries

17:30 — Base tables inside DT which is inside another DT queries

I am trying this query on sqlfiddle and it does not let me update:

update (select * from (select * from t1, t2) dt1 where a>3 and c<10) dt2 
set a=0, c=2 where a>4;

ERROR:
Derived table 'dt2' is not updatable because the modification affects multiple base tables.

So, they do not allow updating multiple base table in one query. Will this be allowed in our patch?

I am still adding those queries in test file but if not needed we can simply remove them.

DISCUSS THIS ^^

17:41 — DT with single base table inside another DT + base table queries

17:54 — Adding above equivalent with non-updatable columns.

18:34 — Added above queries.

It is already 400 lines+ and I am trying to reduces line as much as possible by exceeding 80 chars rule.

18:38 — Break. Next I will be adding views with DTs.

19:25 — Back to work.

19:48 — Added multi table queries with views.

20:09 — Added queries with views containing two tables.

20:17 — Adding equivalent queries to cte_update.test;

20:47 — Adding Nested CTEs + Base table queries

21:24 — Adding non-updatable queries to CTE

21:48 — Adding nested queries with non-updatable columns