The following bug has been logged online:
Bug reference: 5203
Logged by: Marcel Wieland
Email address: marcel.wiel...@fondsnet.de
PostgreSQL version: 8.2
Operating system: Linux
Description: Rule affecting more than one row is only fired once,
when there is no reference to the row.
Details:
BEGIN;
-- Create testing Tables
CREATE TABLE footable (
name char
);
CREATE TABLE bartable (
foo char
);
-- Insert testing Values
INSERT INTO footable (name) VALUES('a'), ('b');
-- RULE without row-reference
CREATE OR REPLACE RULE foorule AS ON UPDATE TO footable DO
INSERT INTO bartable (foo) SELECT * FROM (SELECT 'a' UNION SELECT 'b')
AS x;
-- Query fires Rule
UPDATE footable SET name = name;
-- Result
SELECT * FROM bartable;
-- Reset
DELETE FROM bartable;
-- RULE with row-reference
CREATE OR REPLACE RULE foorule AS ON UPDATE TO footable DO
INSERT INTO bartable (foo) SELECT * FROM (SELECT 'a' UNION SELECT 'b')
AS x WHERE old.name = old.name;
-- Query fires Rule
UPDATE footable SET name = name;
-- Result
SELECT * FROM bartable;
-- Cleanup
DROP TABLE footable;
DROP TABLE bartable;
ROLLBACK;
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
