github-11563.td 671 B

123456789101112131415161718192021
  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. # Test that a distracted compute instance will not panic if asked to construct
  10. # an index for a now-invalid source.
  11. > CREATE MATERIALIZED VIEW test1 AS SELECT * FROM generate_series(1, 100000);
  12. > CREATE TABLE foo (a int);
  13. > CREATE INDEX baz ON foo (a);
  14. > DROP INDEX baz;
  15. > DROP TABLE foo;