00init.mql 648 B

12345678910111213141516171819202122232425
  1. -- 22syntax 目录初始化:语法扩展测试
  2. create class if not exists /test/aaa/test_syntax (
  3. s_name varchar,
  4. s_Value int,
  5. s_data text,
  6. S_EXTRA text,
  7. indexes(s_name, s_Value, S_EXTRA),
  8. keys(s_name)
  9. ) with nickname='syntax_test', core=cassandraonly
  10. ;
  11. -- 插入语法测试数据
  12. insert into /test/aaa/test_syntax (s_name, s_Value, s_data, S_EXTRA) values ('syntax_001', 100, 'relaxed syntax data', 'extra data')
  13. ;
  14. insert into /test/aaa/test_syntax (s_name, s_Value, s_data, S_EXTRA) values ('syntax_002', 200, 'case sensitive data', 'CASE test')
  15. ;
  16. -- 等待数据写入完成
  17. /**
  18. sleep(1s)
  19. **/
  20. ;