message: Adding export tests with different schemas
diff: @@ -105,6 +105,51 @@ SELECT * FROM "view ""." ORDER BY 1
  ----
  1
  +
  +statement ok
  +CREATE SCHEMA s1;
  +
  +statement ok
  +CREATE SCHEMA s2;
  +
  +
  +statement ok
  +CREATE TABLE table01(i INTEGER, j INTEGER)
  +
  +statement ok
  +CREATE TABLE s1.table01(i INTEGER, j INTEGER)
  +
  +statement ok
  +CREATE TABLE s2.table01(i INTEGER, j INTEGER)
  +
  +statement ok
  +INSERT INTO table01 VALUES (1, 1), (2, 2)
  +
  +statement ok
  +INSERT INTO s1.table01 VALUES (3, 3), (4, 4)
  +
  +statement ok
  +INSERT INTO s2.table01 VALUES (5, 5), (6, 6)
  +
  +
  +query II
  +SELECT * FROM table01 ORDER BY i;
  +----
  +1 1
  +2 2
  +
  +query II
  +SELECT * FROM s1.table01 ORDER BY i;
  +----
  +3 3
  +4 4
  +
  +query II
  +SELECT * FROM s2.table01 ORDER BY i;
  +----
  +5 5
  +6 6
  +
  # now export the db
  statement ok
  EXPORT DATABASE '__TEST_DIR__/export_test' (FORMAT CSV)
  @@ -172,6 +217,24 @@ SELECT * FROM "view ""." ORDER BY 1
  ----
  1
  +query II
  +SELECT * FROM table01 ORDER BY i;
  +----
  +1 1
  +2 2
  +
  +query II
  +SELECT * FROM s1.table01 ORDER BY i;
  +----
  +3 3
  +4 4
  +
  +query II
  +SELECT * FROM s2.table01 ORDER BY i;
  +----
  +5 5
  +6 6
  +
  # verify that constraints are still there
  statement error
  INSERT INTO integers VALUES (5, 6)
  