Hi all,
Using "DELETE ... RETURNING *" against a remote partitioned table (parent) returns wrong results according attached test case.
I've tested it against all supported versions and got error just in 9.3, 9.4 and 9.5 version.
Attached ziped test case and results:
- fdw_test.sql (main test case script)
- fdw_test.expected.out (expected output)
- fdw_test.result-*.out (wrong results)
Some environment details:
fabrizio@macanudo:/tmp
$ uname -a
Linux macanudo 4.13.0-41-generic #46~16.04.1-Ubuntu SMP Thu May 3 10:06:43 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
fabrizio@macanudo:/tmp
$ gcc --version
gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609
Copyright (C) 2015 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL