00init.mql 586 B

1234567891011121314151617181920212223242526272829
  1. -- 18prepare 目录初始化:Prepare 语句测试
  2. create class if not exists /test/aaa/test_prepare (
  3. p_name varchar,
  4. p_text text,
  5. p_int int,
  6. p_bigint bigint,
  7. p_float float,
  8. p_double double,
  9. p_bool bool,
  10. p_ts timestamp,
  11. indexes(p_name, p_text, p_int, p_bigint, p_float, p_double, p_bool, p_ts),
  12. keys(p_name)
  13. ) with core=cassandraonly
  14. ;
  15. -- 先清表
  16. delete from /test/aaa/test_prepare with version
  17. /**
  18. onerror(continue,'not exist','not find','not found')
  19. **/
  20. ;
  21. -- 等待操作完成
  22. /**
  23. sleep(1s)
  24. **/
  25. ;