15:15 — Applying changes by Igor to fix a failing test (refer failing test for this)

15:20 — Rebuilding the server.

It is working fine now :)

15:38 — Shifting test cases from 'derived_queries' to 'with_update'

16:13 — Shifted all 'CTE update' tests to with_update.test and with_update.result.

I have not shifted nested with elements test cases yet from derived_queries. They will be added after that functionality has been added to the server.

16:17 — Let's move on to Task #3: "Add update queries that contain combinations of updatable views/derived tables/cte (all of them in each queries)."

We do have cases where cte has view inside which has DT inside of it. Does test case like this count here?

Ask for clarification here

16:26 — Break

16:51 — Back to work.

Let's start with Task #4 then: "Add queries with non-updatable views/derived tables/cte."

Now question becomes, when is a DT not updatable?

• When DT is not mergeable.
  • No union — next_select()=0
  • No Group by
  • No having
  • No Distinct
  • No limit
• DT is mergeable but field is not updatable.

17:24 — Added non updatable queries to with_update.test

with_update.test is passing properly in mtr

17:29 — Going to add similar queries to derived_update.test

17:50 — Added non-updatable queries to derived_update.test

18:07 — Added more test cases to derived_update.test and updated derived_update.result