Unexpected update behaviour

[Victor Yegorov <vyegorov@xxxxxxxxx>]

Greetings.

I've hit a strange issue. This is a simplified setup.

First, run create.sql to get a couple of tables.

Then, run the update query.

Tested on 9.2.6 and 9.3.2.

Now:

- if I remove the UNION ALL part of the inner query, UPDATE works;

- if I move the `raw` subquery into the CTE, UPDATE works (but takes

  hours on my full data);

- if I convert this UPDATE into a SELECT, I get the row to be updated.

Could you kindly explain me why the query as it is updates no records?

--
Victor Y. Yegorov

Attachment: create.sql
Description: Binary data

Attachment: update.sql
Description: Binary data

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general