sql use cdb; print "index tag test" sql select tbname,t1 from stba; if $rows != 10 then return -1 endi sql select tbname,t1 from stba where t1 > 2; if $rows != 7 then return -1 endi sql select tbname,t1 from stba where t1 >= 4; if $rows != 6 then return -1 endi sql select tbname,t1 from stba where t1 >= 3 and t1 <= 6; if $rows != 4 then return -1 endi sql select tbname,t1 from stba where t1 = 3; if $rows != 1 then return -1 endi sql select tbname,t1 from stba where t1 <> 6; if $rows != 9 then return -1 endi sql select tbname,t1 from stba where t1 < 6; if $rows != 6 then return -1 endi sql select tbname,t1 from stba where t1 < 6 and t1 >= 2; if $rows != 4 then return -1 endi sql select tbname,t1 from stba where t1 is null; sql select tbname,t1 from stba where t1 is not null; sql_error select tbname,t1 from stbb where t1 > true; sql select tbname,t1 from stbb where t1 = true; if $rows != 5 then return -1 endi sql select tbname,t1 from stbb where t1 <> true; if $rows != 5 then return -1 endi sql select tbname,t1 from stbb where t1 is null; sql select tbname,t1 from stbb where t1 is not null; sql select tbname,t1 from stbc; if $rows != 10 then return -1 endi sql select tbname,t1 from stbc where t1 > 2; if $rows != 7 then return -1 endi sql select tbname,t1 from stbc where t1 >= 4; if $rows != 6 then return -1 endi sql select tbname,t1 from stbc where t1 >= 3 and t1 <= 6; if $rows != 4 then return -1 endi sql select tbname,t1 from stbc where t1 = 3; if $rows != 1 then return -1 endi sql select tbname,t1 from stbc where t1 <> 6; if $rows != 9 then return -1 endi sql select tbname,t1 from stbc where t1 < 6; if $rows != 6 then return -1 endi sql select tbname,t1 from stbc where t1 < 6 and t1 >= 2; if $rows != 4 then return -1 endi sql select tbname,t1 from stbc where t1 is null; sql select tbname,t1 from stbc where t1 is not null; sql select tbname,t1 from stbd where t1 > '2222'; if $rows != 7 then return -1 endi sql select tbname,t1 from stbd where t1 >= '4444'; if $rows != 6 then return -1 endi sql select tbname,t1 from stbd where t1 >= '3333' and t1 <= '6666'; if $rows != 4 then return -1 endi sql select tbname,t1 from stbd where t1 = '3333'; if $rows != 1 then return -1 endi sql select tbname,t1 from stbd where t1 <> '6666'; if $rows != 9 then return -1 endi sql select tbname,t1 from stbd where t1 < '6666'; if $rows != 6 then return -1 endi sql select tbname,t1 from stbd where t1 < '6666' and t1 >= '2222'; if $rows != 4 then return -1 endi sql select tbname,t1 from stbd where t1 is null; sql select tbname,t1 from stbd where t1 is not null; sql select tbname,t1 from stbe where t1 > '2222'; if $rows != 7 then return -1 endi sql select tbname,t1 from stbe where t1 >= '4444'; if $rows != 6 then return -1 endi sql select tbname,t1 from stbe where t1 >= '3333' and t1 <= '6666'; if $rows != 4 then return -1 endi sql select tbname,t1 from stbe where t1 = '3333'; if $rows != 1 then return -1 endi sql select tbname,t1 from stbe where t1 <> '6666'; if $rows != 9 then return -1 endi sql select tbname,t1 from stbe where t1 < '6666'; if $rows != 6 then return -1 endi sql select tbname,t1 from stbe where t1 < '6666' and t1 >= '2222'; if $rows != 4 then return -1 endi sql select tbname,t1 from stbe where t1 is null; sql select tbname,t1 from stbe where t1 is not null; #system sh/exec.sh -n dnode1 -s stop -x SIGINT