The following bug has been logged on the website:
Bug reference: 15454
Logged by: Andrea Ferranti
Email address: andrea.ferranti@wolterskluwer.com
PostgreSQL version: 9.6.10
Operating system: Ubuntu 16
Description:
Dear all,
We have experienced a strange behaviour on PostgreSQL 9.6.10.
We have a series of query that move data from a table to another by using
the following logic.
create table A;
insert data into A from B;
drop B;
rename A to B;
in an operation we need to add a step to move some "remaining data" from A
to B by using the following logic:
INSERT INTO A SELECT X
FROM B DEST_TABLE JOIN (
SELECT CALC_METHOD AS S0, P_KEY AS S1, EXECUTION_NUMBER AS S2
FROM AW_001_000012_000001 SOURCE_TABLE)
SOURCE_TABLE
ON SOURCE_TABLE.S0 = DEST_TABLE.CALC_METHOD
AND SOURCE_TABLE.S1 = DEST_TABLE.KEY_DIM