message: And now with some test cases
diff: @@ -6,16 +6,49 @@ query TTTTTTT
  SELECT * FROM information_schema_schemata();
  ----
  main main NULL NULL NULL NULL NULL
  +main temp NULL NULL NULL NULL NULL
  statement ok
  CREATE SCHEMA scheme;
  query I
  -SELECT COUNT(*) FROM information_schema_schemata() WHERE schema_name='main'
  +SELECT COUNT(*) FROM information_schema_schemata() WHERE schema_name='scheme'
  ----
  1
  +statement ok
  +CREATE TABLE scheme.integers (i INTEGER);
  +
  +query T
  +SELECT table_type FROM information_schema_tables() WHERE table_schema='scheme' AND table_name='integers'
  +----
  +BASE TABLE
  +
  +statement ok
  +CREATE TEMPORARY TABLE floats (f FLOAT);
  +
  +query T
  +SELECT table_type FROM information_schema_tables() WHERE table_schema='temp' AND table_name='floats'
  +----
  +LOCAL TEMPORARY
  +
  +statement ok
  +CREATE VIEW scheme.vintegers AS SELECT * FROM scheme.integers;
  +
  +query T
  +SELECT table_type FROM information_schema_tables() WHERE table_schema='scheme' AND table_name='vintegers'
  +----
  +VIEW
  +
  +statement ok
  +DROP SCHEMA scheme CASCADE;
  +
  query I
  SELECT COUNT(*) FROM information_schema_schemata() WHERE schema_name='scheme'
  ----
  -1
  +0
  +
  +query I
  +SELECT COUNT(*) FROM information_schema_tables() WHERE table_schema='scheme'
  +----
  +0
  