11insert_data.mql 2.2 KB

123456789101112131415161718192021222324252627282930313233
  1. BEGIN BATCH
  2. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  3. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  4. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  5. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  6. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  7. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  8. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  9. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  10. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? );
  11. insert into /test/batch (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values (?, ?, ?, ?, ?, ?, ?, ? )
  12. END
  13. /**
  14. params("4006", "hello word 2003", 4006, 4006, 1.1, 1.1234567890123456, 1.123456, true,
  15. "40", "hello word 2003", 40, 40, 1.1, 1.1234567890123456, 1.123456, false,
  16. "400", "hello word 2003", 400, 400, 1.1, 1.1234567890123456, 1.123456, true,
  17. "74006", "hello word 2003", -4006, 4006, 1.1, 1.1234567890123456, 1.123456, false,
  18. "409", "hello word 2003", -40, 40, 1.1, 1.1234567890123456, 1.123456, true,
  19. "500", "hello word 2003", -400, 400, 1.1, 1.1234567890123456, 1.123456, false,
  20. "600", "hello word 2003", 370, 370, 1.1, 1.1234567890123456, 1.123456, true,
  21. "700", "hello word 2003", 580, 580, 1.1, 1.1234567890123456, 1.123456, true,
  22. "602", "hello word 2003", -370, -370, 1.1, 1.1234567890123456, 1.123456, true,
  23. "708", "hello word 2003", -580, -580, 1.1, 1.1234567890123456, 1.123456, true)
  24. **/
  25. ;
  26. /**
  27. sleep(10s)
  28. **/
  29. ;