check-from-v0.27.0-kafka-source.td 904 B

12345678910111213141516171819202122232425262728293031323334353637383940
  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. $ set schema={
  10. "type": "record",
  11. "name": "cpx",
  12. "fields": [
  13. {"name": "a", "type": "long"},
  14. {"name": "b", "type": "long"}
  15. ]
  16. }
  17. > SELECT * FROM kafka_source;
  18. a b
  19. ---
  20. 1 2
  21. 2 3
  22. $ kafka-ingest format=avro topic=upgrade-kafka-source-${arg.upgrade-from-version} schema=${schema} timestamp=1
  23. {"a": 10, "b": 20}
  24. {"a": 20, "b": 30}
  25. > SELECT * FROM kafka_source;
  26. a b
  27. ---
  28. 1 2
  29. 2 3
  30. 10 20
  31. 20 30
  32. $ set-from-sql var=expected-user
  33. SELECT user FROM linked_cluster_audit_event_user ORDER BY priority DESC LIMIT 1