DROP DATABASE IF EXISTS test1;
CREATE DATABASE test1;

Testcase 3.3.1.31 - 3.3.1.37 New Implementation 
--------------------------------------------------------------------------------
USE test;
DROP DATABASE IF EXISTS test2;
DROP TABLE IF EXISTS t0,t1;
DROP VIEW  IF EXISTS t3,t4;
CREATE DATABASE test2;
CREATE TABLE test1.t0 (f1 VARCHAR(20));
CREATE TABLE test1.t1 (f1 VARCHAR(20));
CREATE TABLE test2.t0 (f1 VARCHAR(20));
CREATE TABLE test2.t1 (f1 VARCHAR(20));
CREATE VIEW  test1.t2 AS SELECT * FROM test1.t0;
CREATE VIEW  test1.t3 AS SELECT * FROM test2.t0;
CREATE VIEW  test2.t2 AS SELECT * FROM test2.t0;
CREATE VIEW  test2.t3 AS SELECT * FROM test1.t0;
INSERT INTO  test1.t0 VALUES('test1.t0');
INSERT INTO  test1.t1 VALUES('test1.t1');
INSERT INTO  test2.t0 VALUES('test2.t0');
INSERT INTO  test2.t1 VALUES('test2.t1');
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t3 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t3 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t2 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t0	test1.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t2 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t0	test1.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test2.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test1.t3 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test2.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test2.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test1.t2 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test1.t0
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test2.t1 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test2.t1	test1.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test2.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test2.t1
CREATE OR REPLACE VIEW test.v1 AS
SELECT ta.f1 AS col1,
tb.f1 AS col2
FROM test1.t1 ta, test1.t1 tb;
SELECT * FROM test.v1;
col1	col2
test1.t1	test1.t1
DROP VIEW  IF EXISTS v1;
DROP DATABASE IF EXISTS test1;
DROP DATABASE IF EXISTS test2;
DROP DATABASE IF EXISTS test3;