Ahmet Gedemenli

a broken case related to this issue https://github.com/citusdata/citus/pull/6023#issuecomment-1170951156

Now we successfully detect and error out in both cases that are provided in the issue description + the other case linked in my previous comment. Fixed and tested in:...

Closed by: #6100 #6103 #6106 #6171 #6176

```sql create table table2 (id int primary key); select create_reference_table('table2'); alter table table2 add constraint self_fkey foreign key (id) references table2(id); insert into table2 values (1); create table table3 (id...

Thanks for the lock information! I still can't reproduce the issue and the best way to debug it is actually first reproducing it. Any detail that helps with the reproduction...

``` cur_ma_sublink = (SubLink *) lfirst(next_ma_cell); next_ma_cell = lnext(ma_sublinks, next_ma_cell); remaining_ma_columns = count_nonjunk_tlist_entries( ((Query *) cur_ma_sublink->subselect)->targetList); Assert(((Param *) expr)->paramid == ((cur_ma_sublink->subLinkId `ruleutils_13.c` `targetList`'s first element has `paramid=65538` whereas the second...

> `targetList`'s first element has `paramid=65538` whereas the second element has `paramid=65537` In the failing one, we assert that `paramid == (x

Postgres doesn't actually check this assertion. The function `get_update_query_targetlist_def` isn't called for the example you provided.

``` CREATE TABLE update_test ( a INT DEFAULT 10, b INT, c TEXT ); CREATE RULE rule1 AS ON INSERT TO update_test DO UPDATE update_test SET (b, a) = (...

Worked with @thanodnl and found that `varnullingrels` is causing the issue. Looking into bt, the last Citus function seems to be `BuildSelectStatementViaStdPlanner`, which is calling standard_planner(combineQuery, NULL, 0, NULL) Running...