Commitc1d59bd

committed

fix problems with DELETE USING mentioned in issue #111

1 parent200a391 commitc1d59bdCopy full SHA for c1d59bd

File tree

+17

-9

lines changed

+17

-9

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1740,6 +1740,20 @@ EXPLAIN (COSTS OFF) DELETE FROM test.range_rel r USING test.tmp t WHERE r.dt = '`
`1740`	`1740`	`(7 rows)`
`1741`	`1741`
`1742`	`1742`	`DELETE FROM test.range_rel r USING test.tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;`
	`1743`	`+EXPLAIN (COSTS OFF) DELETE FROM test.tmp t USING test.range_rel r WHERE r.dt = '2010-01-02' AND r.id = t.id;`
	`1744`	`+ QUERY PLAN`
	`1745`	`+--------------------------------------------------------------------------------------------------`
	`1746`	`+ Delete on tmp t`
	`1747`	`+ -> Hash Join`
	`1748`	`+ Hash Cond: (t.id = r.id)`
	`1749`	`+ -> Seq Scan on tmp t`
	`1750`	`+ -> Hash`
	`1751`	`+ -> Append`
	`1752`	`+ -> Index Scan using range_rel_1_pkey on range_rel_1 r`
	`1753`	`+ Filter: (dt = 'Sat Jan 02 00:00:00 2010'::timestamp without time zone)`
	`1754`	`+(8 rows)`
	`1755`	`+`
	`1756`	`+DELETE FROM test.tmp t USING test.range_rel r WHERE r.dt = '2010-01-02' AND r.id = t.id;`
`1743`	`1757`	`/* Create range partitions from whole range */`
`1744`	`1758`	`SELECT drop_partitions('test.range_rel');`
`1745`	`1759`	`NOTICE: 44 rows copied from test.range_rel_1`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -527,6 +527,9 @@ UPDATE test.range_rel r SET value = t.value FROM test.tmp t WHERE r.dt = '2010-0`
`527`	`527`	`EXPLAIN (COSTS OFF)DELETEFROMtest.range_rel r USINGtest.tmp tWHEREr.dt='2010-01-02'ANDr.id=t.id;`
`528`	`528`	`DELETEFROMtest.range_rel r USINGtest.tmp tWHEREr.dt='2010-01-02'ANDr.id=t.id;`
`529`	`529`
	`530`	`+EXPLAIN (COSTS OFF)DELETEFROMtest.tmp t USINGtest.range_rel rWHEREr.dt='2010-01-02'ANDr.id=t.id;`
	`531`	`+DELETEFROMtest.tmp t USINGtest.range_rel rWHEREr.dt='2010-01-02'ANDr.id=t.id;`
	`532`	`+`
`530`	`533`
`531`	`534`	`/* Create range partitions from whole range*/`
`532`	`535`	`SELECT drop_partitions('test.range_rel');`

Lines changed: 0 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -188,15 +188,6 @@ disable_standard_inheritance(Query *parse)`
`188`	`188`	`ListCell*lc;`
`189`	`189`	`Indexcurrent_rti;/* current range table entry index */`
`190`	`190`
`191`		`-/*`
`192`		`- * We can't handle non-SELECT queries unless`
`193`		`- * there's a pathman_expand_inherited_rtentry_hook()`
`194`		`- */`
`195`		`-#ifndefNATIVE_EXPAND_RTE_HOOK`
`196`		`-if (parse->commandType!=CMD_SELECT)`
`197`		`-return;`
`198`		`-#endif`
`199`		`-`
`200`	`191`	`/* Walk through RangeTblEntries list */`
`201`	`192`	`current_rti=0;`
`202`	`193`	`foreach (lc,parse->rtable)`

Comments

(0)