current_database.slt 633 B

12345678910111213141516171819202122232425262728293031
  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. mode cockroach
  10. query T
  11. SELECT current_database()
  12. ----
  13. materialize
  14. query T
  15. SELECT current_catalog() = current_database()
  16. ----
  17. true
  18. statement ok
  19. CREATE DATABASE otherdb
  20. statement ok
  21. SET database TO otherdb
  22. query T
  23. SELECT current_database()
  24. ----
  25. otherdb