CREATE TABLE x(a CHAR(8));
CREATE TABLE y(a CHAR(8));
CREATE VIEW z AS SELECT a FROM x UNION SELECT a FROM y;
INSERT INTO x VALUES('cat');
INSERT INTO y VALUES('dog');
SELECT a,testudf(a) from x;
SELECT a,testudf(a) from y;
SELECT a,testudf(a) from z;
SELECT a FROM x WHERE testudf(a)>2;
SELECT a FROM y WHERE testudf(a)>2;
SELECT a FROM z WHERE testudf(a)>2;
