odbtools/odbctest/mql/basic/10basic/41.insert.mql

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob, vtime)
 values ('1', '1', '1', 'x', 1, 1, 1.1234567890123456, 1.1234567890123457, true, ["a"], ["a"], {"a":1.1}, "hello", "1970-01-01 00:00:00.000001"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob, vtime)
 values ('1', '1', '1', 'a', 1, 1, 1.1234567890123456, 1.1234567890123457, true, ["a"], ["a"], {"a":1.1}, "hello", "0001-01-01 00:00:00.000000"   )
;

update /test/foo set vtime='0001-01-03 00:00:00.000000' where v_varchar='1'
;

update /test/foo set vtime=? where v_varchar='1'
/**
params('1900-12-31 23:59:59.000001')
**/
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('2', '2', '2', 'b', 2, 2, 2.1, 2.1, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('3', '2', '2', 'b', 2, 2, 2.2, 2.2, true, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('4', '3', '3', 'c', 3, 3, 3.1, 3.1, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('5', '3', '3', 'c', 3, 3, 3.2, 3.3, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('6', '3', '3', 'c', 3, 3, 3.3, 3.5, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;


insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('7', '4', '4', 'd', 4, 4, 3.1, 3.1, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('8', '4', '4', 'd', 4, 4, 3.2, 3.3, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('9', '4', '4', 'd', 4, 4, 3.3, 3.5, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;

insert into /test/foo (v_varchar, v_text, v_string, v_chars, v_int, v_bigint, v_float, v_double, v_bool, v_set, v_list, v_map, v_blob)
 values ('a', '4', '4', 'd', 4, 4, 3.4, 3.7, false, ["a"], ["a"], {"a":1.1}, "hello"  )
;


/**
sleep(2s)
**/
;

select * from /test/foo refresh
/**
output()
count(10)
**/
;

-- 这个如果有错，重启一下cassandra就好了
-- If error occurs with this, just restart Cassandra
select * from /test/foo where v_float >= 1.1 or v_float <= 1.1
/**
output()
count(10)
**/
;

select * from /test/foo where v_float=1.1234567890123457
/**
output()
count(1)
**/
;