check-from-v0.27.0-database-schema.td 777 B

123456789101112131415161718192021222324252627282930
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. > SHOW DATABASES;
  10. materialize ""
  11. "some database" ""
  12. > SHOW SCHEMAS FROM "some database";
  13. public ""
  14. "some schema" ""
  15. information_schema ""
  16. mz_catalog ""
  17. mz_catalog_unstable ""
  18. mz_unsafe ""
  19. mz_internal ""
  20. mz_introspection ""
  21. pg_catalog ""
  22. > SELECT * FROM "some database"."some schema".t1;
  23. > DROP DATABASE "some database";
  24. ! SELECT * FROM "some database"."some schema".t1;
  25. contains:unknown database