newvar=copyObject(var);

newvar->varno=newvar->varnoold=1;

newvar->varlevelsup=0;

attno=list_length(context->targetlist)+1;

tle=makeTargetEntry((Expr*)newvar,

DROP TABLE tx1;

DROP TABLE tx2;

DROP TABLE tx3;

--

-- Test handling of vars from correlated subqueries in quals from outer

-- security barrier views, per bug #13988

--

CREATE TABLE t1 (a int, b text, c int);

INSERT INTO t1 VALUES (1, 'one', 10);

CREATE TABLE t2 (cc int);

INSERT INTO t2 VALUES (10), (20);

CREATE VIEW v1 WITH (security_barrier = true) AS

SELECT * FROM t1 WHERE (a > 0)

WITH CHECK OPTION;

CREATE VIEW v2 WITH (security_barrier = true) AS

SELECT * FROM v1 WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.cc = v1.c)

WITH CHECK OPTION;

INSERT INTO v2 VALUES (2, 'two', 20); -- ok

INSERT INTO v2 VALUES (-2, 'minus two', 20); -- not allowed

ERROR: new row violates check option for view "v1"

DETAIL: Failing row contains (-2, minus two, 20).

INSERT INTO v2 VALUES (3, 'three', 30); -- not allowed

ERROR: new row violates check option for view "v2"

DETAIL: Failing row contains (3, three, 30).

UPDATE v2 SET b = 'ONE' WHERE a = 1; -- ok

UPDATE v2 SET a = -1 WHERE a = 1; -- not allowed

ERROR: new row violates check option for view "v1"

DETAIL: Failing row contains (-1, ONE, 10).

UPDATE v2 SET c = 30 WHERE a = 1; -- not allowed

ERROR: new row violates check option for view "v2"

DETAIL: Failing row contains (1, ONE, 30).

DELETE FROM v2 WHERE a = 2; -- ok

SELECT * FROM v2;

a | b | c

---+-----+----

1 | ONE | 10

(1 row)

DROP VIEW v2;

DROP VIEW v1;

DROP TABLE t2;

DROP TABLE t1;

DROPTABLE tx1;

DROPTABLE tx2;

DROPTABLE tx3;

CREATETABLEt1 (aint, btext, cint);

INSERT INTO t1VALUES (1,'one',10);

CREATETABLEt2 (ccint);

INSERT INTO t2VALUES (10), (20);

CREATEVIEWv1 WITH (security_barrier= true)AS

SELECT*FROM t1WHERE (a>0)

WITHCHECK OPTION;

CREATEVIEWv2 WITH (security_barrier= true)AS

SELECT*FROM v1WHERE EXISTS (SELECT1FROM t2WHEREt2.cc=v1.c)

WITHCHECK OPTION;

INSERT INTO v2VALUES (2,'two',20);-- ok

INSERT INTO v2VALUES (-2,'minus two',20);-- not allowed

INSERT INTO v2VALUES (3,'three',30);-- not allowed

UPDATE v2SET b='ONE'WHERE a=1;-- ok

UPDATE v2SET a=-1WHERE a=1;-- not allowed

UPDATE v2SET c=30WHERE a=1;-- not allowed

DELETEFROM v2WHERE a=2;-- ok

SELECT*FROM v2;

DROPVIEW v2;

DROPVIEW v1;

DROPTABLE t2;

DROPTABLE t1;