system sh/stop_dnodes.sh system sh/deploy.sh -n dnode1 -i 1 system sh/cfg.sh -n dnode1 -c walLevel -v 1 system sh/exec.sh -n dnode1 -s start sleep 500 sql connect $dbPrefix = db $tbPrefix = ct $mtPrefix = st $quote = ' $tbNum = 2 $rowNum = 50 print =============== step1 create stable/table $i = 0 $db = $dbPrefix . $i $mt = $mtPrefix . $i sql drop database $db -x step1 step1: sql create database $db sql use $db sql create table $mt (ts timestamp, c1 int, c2 binary(10), c3 binary(30), c4 binary(40), c5 binary(50), c6 nchar(10), c7 nchar(20), c8 nchar(30), c9 nchar(40)) TAGS (tgcol int) $i = 0 while $i < $tbNum $tb = $tbPrefix . $i sql create table $tb using $mt tags( $i ) $x = 0 $z2 = $x . 2 $y2 = $quote . $z2 $y2 = $y2 . $quote $z3 = $x . 3 $y3 = $quote . $z3 $y3 = $y3 . $quote $z4 = $x . 4 $y4 = $quote . $z4 $y4 = $y4 . $quote $z5 = $x . 5 $y5 = $quote . $z5 $y5 = $y5 . $quote $z6 = $x . 6 $y6 = $quote . $z6 $y6 = $y6 . $quote $z7 = $x . 7 $y7 = $quote . $z7 $y7 = $y7 . $quote $z8 = $x . 8 $y8 = $quote . $z8 $y8 = $y8 . $quote $z9 = $x . 9 $y9 = $quote . $z9 $y9 = $y9 . $quote while $x < $rowNum $cc = $x * 60000 $ms = 1601481600000 + $cc sql insert into $tb values ($ms , $x , $y2 , $y3 , $y4 , $y5 , $y6 , $y7 , $y8 , $y9 ) $x = $x + 1 $z2 = $x . 2 $y2 = $quote . $z2 $y2 = $y2 . $quote $z3 = $x . 3 $y3 = $quote . $z3 $y3 = $y3 . $quote $z4 = $x . 4 $y4 = $quote . $z4 $y4 = $y4 . $quote $z5 = $x . 5 $y5 = $quote . $z5 $y5 = $y5 . $quote $z6 = $x . 6 $y6 = $quote . $z6 $y6 = $y6 . $quote $z7 = $x . 7 $y7 = $quote . $z7 $y7 = $y7 . $quote $z8 = $x . 8 $y8 = $quote . $z8 $y8 = $y8 . $quote $z9 = $x . 9 $y9 = $quote . $z9 $y9 = $y9 . $quote endw $i = $i + 1 endw print ================= step2 $i = 1 $tb = $tbPrefix . $i $stb = $mtPrefix . 0 print sql select concat(c2, c3, c4, c5) from $tb sql select concat(c2, c3, c4, c5) from $tb print $data00 if $data00 != 02030405 then return -1 endi print sql select concat_ws('data',c2,c3,c4,c5) from $tb sql select concat_ws('data',c2,c3,c4,c5) from $tb print $data00 if $data00 != 02data03data04data05 then return -1 endi print sql select concat(c6, c7, c8, c9) from $tb sql select concat(c6, c7, c8, c9) from $tb print $data00 if $data00 != 06070809 then return -1 endi print sql select concat_ws('data' ,c6,c7,c8,c9) from $tb sql select concat_ws('data' ,c6,c7,c8,c9) from $tb print $data00 if $data00 != 06data07data08data09 then return -1 endi print sql select length(concat(c2, c3, c4, c5)) from $tb sql select length(concat(c2, c3, c4, c5)) from $tb print $data00 if $data00 != 8 then return -1 endi print sql select char_length(concat(c2, c3, c4, c5)) from $tb sql select char_length(concat(c2, c3, c4, c5)) from $tb print $data00 if $data00 != 8 then return -1 endi print sql select length(concat_ws('data',c2,c3,c4,c5)) from $tb sql select length(concat_ws('data',c2,c3,c4,c5)) from $tb print $data00 if $data00 != 20 then return -1 endi print sql select char_length(concat_ws('data',c2,c3,c4,c5)) from $tb sql select char_length(concat_ws('data',c2,c3,c4,c5)) from $tb print $data00 if $data00 != 20 then return -1 endi print sql select length(concat(c6, c7, c8, c9)) from $tb sql select length(concat(c6, c7, c8, c9)) from $tb print $data00 if $data00 != 32 then return -1 endi print sql select char_length(concat(c6, c7, c8, c9)) from $tb sql select char_length(concat(c6, c7, c8, c9)) from $tb print $data00 if $data00 != 8 then return -1 endi print sql select length(concat_ws('data' ,c6,c7,c8,c9)) from $tb sql select length(concat_ws('data' ,c6,c7,c8,c9)) from $tb print $data00 if $data00 != 80 then return -1 endi print sql select char_length(concat_ws('data', c6,c7,c8,c9)) from $tb sql select char_length(concat_ws('data', c6, c7, c8, c9)) from $tb print $data00 if $data00 != 20 then return -1 endi print sql_error select concat(c1, c2, c3, c4, c5) from $tb sql_error select concat(c1, c2, c3, c4, c5) from $tb print sql_error select concat_ws('data',c1,c2,c3,c4,c5) from $tb sql_error select concat_ws('data',c1,c2,c3,c4,c5) from $tb print ===============> step 3 sql_error stable, group by, window sql_error select concat(c2) from $stb group by tbname; sql_error select concat(c2) from $stb group by tgcol; sql_error select concat(c2) from $stb group by c3; sql_error select concat(c2) from $stb interval(1m); sql_error select concat(c2) from $stb state_window(c7); sql_error select concat(c2) from $tb state_window(c7); sql_error select concat(c2) from $stb session(ts, 30s); sql_error select concat(c2) from $tb session(ts, 30s); sql_error select concat(c2) from $stb slimit 2; sql_error select concat(c2) from $stb interval(1m) slimit 2; sql_error select length(c2) from $stb group by tbname; sql_error select length(c2) from $stb group by tgcol; sql_error select length(c2) from $stb group by c3; sql_error select length(c2) from $stb interval(1m); sql_error select length(c2) from $stb state_window(c7); sql_error select length(c2) from $tb state_window(c7); sql_error select length(c2) from $stb session(ts, 30s); sql_error select length(c2) from $tb session(ts, 30s); sql_error select length(c2) from $stb slimit 2; sql_error select length(c2) from $stb interval(1m) slimit 2; sql_error select concat_ws(c2) from $stb group by tbname; sql_error select concat_ws(c2) from $stb group by tgcol; sql_error select concat_ws(c2) from $stb group by c3; sql_error select concat_ws(c2) from $stb interval(1m); sql_error select concat_ws(c2) from $stb state_window(c7); sql_error select concat_ws(c2) from $tb state_window(c7); sql_error select concat_ws(c2) from $stb session(ts, 30s); sql_error select concat_ws(c2) from $tb session(ts, 30s); sql_error select concat_ws(c2) from $stb slimit 2; sql_error select concat_ws(c2) from $stb interval(1m) slimit 2; print =============== trival test print execute sql select concat(c2,c3),concat(c2,c3,c4),concat(c2,c3,c4,c5) from ct1 sql select concat(c2,c3),concat(c2,c3,c4),concat(c2,c3,c4,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @0203@ then return -1 endi if $data01 != @020304@ then return -1 endi if $data02 != @02030405@ then return -1 endi print execute sql select concat(c2,'taos'),concat(c3,'taos'),concat(c4,'taos'),concat(c5,'taos') from ct1 sql select concat(c2,'taos'),concat(c3,'taos'),concat(c4,'taos'),concat(c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @02taos@ then return -1 endi if $data01 != @03taos@ then return -1 endi if $data02 != @04taos@ then return -1 endi if $data03 != @05taos@ then return -1 endi print execute sql select concat(c2,c3,'taos'),concat(c2,c4,'taos'),concat(c2,c5,'taos'),concat(c3,c4,'taos'),concat(c3,c5,'taos') from ct1 sql select concat(c2,c3,'taos'),concat(c2,c4,'taos'),concat(c2,c5,'taos'),concat(c3,c4,'taos'),concat(c3,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @0203taos@ then return -1 endi if $data01 != @0204taos@ then return -1 endi if $data02 != @0205taos@ then return -1 endi if $data03 != @0304taos@ then return -1 endi if $data04 != @0305taos@ then return -1 endi print execute sql select concat(c2,'taos',c3),concat(c2,'taos',c4),concat(c2,'taos',c5),concat(c3,'taos',c4),concat(c3,'taos',c5) from ct1 sql select concat(c2,'taos',c3),concat(c2,'taos',c4),concat(c2,'taos',c5),concat(c3,'taos',c4),concat(c3,'taos',c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @02taos03@ then return -1 endi if $data01 != @02taos04@ then return -1 endi if $data02 != @02taos05@ then return -1 endi if $data03 != @03taos04@ then return -1 endi if $data04 != @03taos05@ then return -1 endi print execute sql select concat('taos',c2,c3),concat('taos',c2,c4),concat('taos',c2,c5),concat('taos',c3,c4),concat('taos',c3,c5) from ct1 sql select concat('taos',c2,c3),concat('taos',c2,c4),concat('taos',c2,c5),concat('taos',c3,c4),concat('taos',c3,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @taos0203@ then return -1 endi if $data01 != @taos0204@ then return -1 endi if $data02 != @taos0205@ then return -1 endi if $data03 != @taos0304@ then return -1 endi if $data04 != @taos0305@ then return -1 endi print execute sql select concat(c2,c3,c4,c5),concat('taos',c2,c3,c4,c5),concat(c2,'taos',c3,c4,c5),concat(c2,c3,'taos',c4,c5),concat(c2,c3,c4,c5,'taos') from ct1 sql select concat(c2,c3,c4,c5),concat('taos',c2,c3,c4,c5),concat(c2,'taos',c3,c4,c5),concat(c2,c3,'taos',c4,c5),concat(c2,c3,c4,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @02030405@ then return -1 endi if $data01 != @taos02030405@ then return -1 endi if $data02 != @02taos030405@ then return -1 endi if $data03 != @0203taos0405@ then return -1 endi if $data04 != @02030405taos@ then return -1 endi print execute sql select concat(c6,c7),concat(c6,c7,c8),concat(c6,c7,c8,c9) from ct1 sql select concat(c6,c7),concat(c6,c7,c8),concat(c6,c7,c8,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @0607@ then return -1 endi if $data01 != @060708@ then return -1 endi if $data02 != @06070809@ then return -1 endi print execute sql select concat(c6,'taos'),concat(c7,'taos'),concat(c8,'taos'),concat(c9,'taos') from ct1 sql select concat(c6,'taos'),concat(c7,'taos'),concat(c8,'taos'),concat(c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @06taos@ then return -1 endi if $data01 != @07taos@ then return -1 endi if $data02 != @08taos@ then return -1 endi if $data03 != @09taos@ then return -1 endi print execute sql select concat(c6,c7,'taos'),concat(c6,c8,'taos'),concat(c6,c9,'taos'),concat(c7,c8,'taos'),concat(c7,c9,'taos') from ct1 sql select concat(c6,c7,'taos'),concat(c6,c8,'taos'),concat(c6,c9,'taos'),concat(c7,c8,'taos'),concat(c7,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @0607taos@ then return -1 endi if $data01 != @0608taos@ then return -1 endi if $data02 != @0609taos@ then return -1 endi if $data03 != @0708taos@ then return -1 endi if $data04 != @0709taos@ then return -1 endi print execute sql select concat(c6,'taos',c7),concat(c6,'taos',c8),concat(c6,'taos',c9),concat(c7,'taos',c8),concat(c7,'taos',c9) from ct1 sql select concat(c6,'taos',c7),concat(c6,'taos',c8),concat(c6,'taos',c9),concat(c7,'taos',c8),concat(c7,'taos',c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @06taos07@ then return -1 endi if $data01 != @06taos08@ then return -1 endi if $data02 != @06taos09@ then return -1 endi if $data03 != @07taos08@ then return -1 endi if $data04 != @07taos09@ then return -1 endi print execute sql select concat('taos',c6,c7),concat('taos',c6,c8),concat('taos',c6,c9),concat('taos',c7,c8),concat('taos',c7,c9) from ct1 sql select concat('taos',c6,c7),concat('taos',c6,c8),concat('taos',c6,c9),concat('taos',c7,c8),concat('taos',c7,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @taos0607@ then return -1 endi if $data01 != @taos0608@ then return -1 endi if $data02 != @taos0609@ then return -1 endi if $data03 != @taos0708@ then return -1 endi if $data04 != @taos0709@ then return -1 endi print execute sql select concat(c6,c7,c8,c9),concat('taos',c6,c7,c8,c9),concat(c6,'taos',c7,c8,c9),concat(c6,c7,'taos',c8,c9),concat(c6,c7,c8,c9,'taos') from ct1 sql select concat(c6,c7,c8,c9),concat('taos',c6,c7,c8,c9),concat(c6,'taos',c7,c8,c9),concat(c6,c7,'taos',c8,c9),concat(c6,c7,c8,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @06070809@ then return -1 endi if $data01 != @taos06070809@ then return -1 endi if $data02 != @06taos070809@ then return -1 endi if $data03 != @0607taos0809@ then return -1 endi if $data04 != @06070809taos@ then return -1 endi print execute sql select concat('data',c3),concat('data',c3,c4),concat('data',c3,c4,c5) from ct1 sql select concat('data',c3),concat('data',c3,c4),concat('data',c3,c4,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @data03@ then return -1 endi if $data01 != @data0304@ then return -1 endi if $data02 != @data030405@ then return -1 endi print execute sql select concat('data','taos'),concat(c3,'taos'),concat(c4,'taos'),concat(c5,'taos') from ct1 sql select concat('data','taos'),concat(c3,'taos'),concat(c4,'taos'),concat(c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datataos@ then return -1 endi if $data01 != @03taos@ then return -1 endi if $data02 != @04taos@ then return -1 endi if $data03 != @05taos@ then return -1 endi print execute sql select concat('data',c3,'taos'),concat('data',c4,'taos'),concat('data',c5,'taos'),concat(c3,c4,'taos'),concat(c3,c5,'taos') from ct1 sql select concat('data',c3,'taos'),concat('data',c4,'taos'),concat('data',c5,'taos'),concat(c3,c4,'taos'),concat(c3,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @data03taos@ then return -1 endi if $data01 != @data04taos@ then return -1 endi if $data02 != @data05taos@ then return -1 endi if $data03 != @0304taos@ then return -1 endi if $data04 != @0305taos@ then return -1 endi print execute sql select concat('data','taos',c3),concat('data','taos',c4),concat('data','taos',c5),concat(c3,'taos',c4),concat(c3,'taos',c5) from ct1 sql select concat('data','taos',c3),concat('data','taos',c4),concat('data','taos',c5),concat(c3,'taos',c4),concat(c3,'taos',c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @datataos03@ then return -1 endi if $data01 != @datataos04@ then return -1 endi if $data02 != @datataos05@ then return -1 endi if $data03 != @03taos04@ then return -1 endi if $data04 != @03taos05@ then return -1 endi print execute sql select concat('taos','data',c3),concat('taos','data',c4),concat('taos','data',c5),concat('taos',c3,c4),concat('taos',c3,c5) from ct1 sql select concat('taos','data',c3),concat('taos','data',c4),concat('taos','data',c5),concat('taos',c3,c4),concat('taos',c3,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosdata03@ then return -1 endi if $data01 != @taosdata04@ then return -1 endi if $data02 != @taosdata05@ then return -1 endi if $data03 != @taos0304@ then return -1 endi if $data04 != @taos0305@ then return -1 endi print execute sql select concat('data',c3,c4,c5),concat('taos','data',c3,c4,c5),concat('data','taos',c3,c4,c5),concat('data',c3,'taos',c4,c5),concat('data',c3,c4,c5,'taos') from ct1 sql select concat('data',c3,c4,c5),concat('taos','data',c3,c4,c5),concat('data','taos',c3,c4,c5),concat('data',c3,'taos',c4,c5),concat('data',c3,c4,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @data030405@ then return -1 endi if $data01 != @taosdata030405@ then return -1 endi if $data02 != @datataos030405@ then return -1 endi if $data03 != @data03taos0405@ then return -1 endi if $data04 != @data030405taos@ then return -1 endi print execute sql select concat('data',c7),concat('data',c7,c8),concat('data',c7,c8,c9) from ct1 sql select concat('data',c7),concat('data',c7,c8),concat('data',c7,c8,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @data07@ then return -1 endi if $data01 != @data0708@ then return -1 endi if $data02 != @data070809@ then return -1 endi print execute sql select concat('data','taos'),concat(c7,'taos'),concat(c8,'taos'),concat(c9,'taos') from ct1 sql select concat('data','taos'),concat(c7,'taos'),concat(c8,'taos'),concat(c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datataos@ then return -1 endi if $data01 != @07taos@ then return -1 endi if $data02 != @08taos@ then return -1 endi if $data03 != @09taos@ then return -1 endi print execute sql select concat('data',c7,'taos'),concat('data',c8,'taos'),concat('data',c9,'taos'),concat(c7,c8,'taos'),concat(c7,c9,'taos') from ct1 sql select concat('data',c7,'taos'),concat('data',c8,'taos'),concat('data',c9,'taos'),concat(c7,c8,'taos'),concat(c7,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @data07taos@ then return -1 endi if $data01 != @data08taos@ then return -1 endi if $data02 != @data09taos@ then return -1 endi if $data03 != @0708taos@ then return -1 endi if $data04 != @0709taos@ then return -1 endi print execute sql select concat('data','taos',c7),concat('data','taos',c8),concat('data','taos',c9),concat(c7,'taos',c8),concat(c7,'taos',c9) from ct1 sql select concat('data','taos',c7),concat('data','taos',c8),concat('data','taos',c9),concat(c7,'taos',c8),concat(c7,'taos',c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @datataos07@ then return -1 endi if $data01 != @datataos08@ then return -1 endi if $data02 != @datataos09@ then return -1 endi if $data03 != @07taos08@ then return -1 endi if $data04 != @07taos09@ then return -1 endi print execute sql select concat('taos','data',c7),concat('taos','data',c8),concat('taos','data',c9),concat('taos',c7,c8),concat('taos',c7,c9) from ct1 sql select concat('taos','data',c7),concat('taos','data',c8),concat('taos','data',c9),concat('taos',c7,c8),concat('taos',c7,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosdata07@ then return -1 endi if $data01 != @taosdata08@ then return -1 endi if $data02 != @taosdata09@ then return -1 endi if $data03 != @taos0708@ then return -1 endi if $data04 != @taos0709@ then return -1 endi print execute sql select concat('data',c7,c8,c9),concat('taos','data',c7,c8,c9),concat('data','taos',c7,c8,c9),concat('data',c7,'taos',c8,c9),concat('data',c7,c8,c9,'taos') from ct1 sql select concat('data',c7,c8,c9),concat('taos','data',c7,c8,c9),concat('data','taos',c7,c8,c9),concat('data',c7,'taos',c8,c9),concat('data',c7,c8,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @data070809@ then return -1 endi if $data01 != @taosdata070809@ then return -1 endi if $data02 != @datataos070809@ then return -1 endi if $data03 != @data07taos0809@ then return -1 endi if $data04 != @data070809taos@ then return -1 endi print execute sql select concat_ws('jeff',c2,c3),concat_ws('jeff',c2,c3,c4),concat_ws('jeff',c2,c3,c4,c5) from ct1 sql select concat_ws('jeff',c2,c3),concat_ws('jeff',c2,c3,c4),concat_ws('jeff',c2,c3,c4,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @02jeff03@ then return -1 endi if $data01 != @02jeff03jeff04@ then return -1 endi if $data02 != @02jeff03jeff04jeff05@ then return -1 endi print execute sql select concat_ws('jeff',c2,'taos'),concat_ws('jeff',c3,'taos'),concat_ws('jeff',c4,'taos'),concat_ws('jeff',c5,'taos') from ct1 sql select concat_ws('jeff',c2,'taos'),concat_ws('jeff',c3,'taos'),concat_ws('jeff',c4,'taos'),concat_ws('jeff',c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @02jefftaos@ then return -1 endi if $data01 != @03jefftaos@ then return -1 endi if $data02 != @04jefftaos@ then return -1 endi if $data03 != @05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff',c2,c3,'taos'),concat_ws('jeff',c2,c4,'taos'),concat_ws('jeff',c2,c5,'taos'),concat_ws('jeff',c3,c4,'taos'),concat_ws('jeff',c3,c5,'taos') from ct1 sql select concat_ws('jeff',c2,c3,'taos'),concat_ws('jeff',c2,c4,'taos'),concat_ws('jeff',c2,c5,'taos'),concat_ws('jeff',c3,c4,'taos'),concat_ws('jeff',c3,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @02jeff03jefftaos@ then return -1 endi if $data01 != @02jeff04jefftaos@ then return -1 endi if $data02 != @02jeff05jefftaos@ then return -1 endi if $data03 != @03jeff04jefftaos@ then return -1 endi if $data04 != @03jeff05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff',c2,'taos',c3),concat_ws('jeff',c2,'taos',c4),concat_ws('jeff',c2,'taos',c5),concat_ws('jeff',c3,'taos',c4),concat_ws('jeff',c3,'taos',c5) from ct1 sql select concat_ws('jeff',c2,'taos',c3),concat_ws('jeff',c2,'taos',c4),concat_ws('jeff',c2,'taos',c5),concat_ws('jeff',c3,'taos',c4),concat_ws('jeff',c3,'taos',c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @02jefftaosjeff03@ then return -1 endi if $data01 != @02jefftaosjeff04@ then return -1 endi if $data02 != @02jefftaosjeff05@ then return -1 endi if $data03 != @03jefftaosjeff04@ then return -1 endi if $data04 != @03jefftaosjeff05@ then return -1 endi print execute sql select concat_ws('jeff','taos',c2,c3),concat_ws('jeff','taos',c2,c4),concat_ws('jeff','taos',c2,c5),concat_ws('jeff','taos',c3,c4),concat_ws('jeff','taos',c3,c5) from ct1 sql select concat_ws('jeff','taos',c2,c3),concat_ws('jeff','taos',c2,c4),concat_ws('jeff','taos',c2,c5),concat_ws('jeff','taos',c3,c4),concat_ws('jeff','taos',c3,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosjeff02jeff03@ then return -1 endi if $data01 != @taosjeff02jeff04@ then return -1 endi if $data02 != @taosjeff02jeff05@ then return -1 endi if $data03 != @taosjeff03jeff04@ then return -1 endi if $data04 != @taosjeff03jeff05@ then return -1 endi print execute sql select concat_ws('jeff',c2,c3,c4,c5),concat_ws('jeff','taos',c2,c3,c4,c5),concat_ws('jeff',c2,'taos',c3,c4,c5),concat_ws('jeff',c2,c3,'taos',c4,c5),concat_ws('jeff',c2,c3,c4,c5,'taos') from ct1 sql select concat_ws('jeff',c2,c3,c4,c5),concat_ws('jeff','taos',c2,c3,c4,c5),concat_ws('jeff',c2,'taos',c3,c4,c5),concat_ws('jeff',c2,c3,'taos',c4,c5),concat_ws('jeff',c2,c3,c4,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @02jeff03jeff04jeff05@ then return -1 endi if $data01 != @taosjeff02jeff03jeff04jeff05@ then return -1 endi if $data02 != @02jefftaosjeff03jeff04jeff05@ then return -1 endi if $data03 != @02jeff03jefftaosjeff04jeff05@ then return -1 endi if $data04 != @02jeff03jeff04jeff05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff',c6,c7),concat_ws('jeff',c6,c7,c8),concat_ws('jeff',c6,c7,c8,c9) from ct1 sql select concat_ws('jeff',c6,c7),concat_ws('jeff',c6,c7,c8),concat_ws('jeff',c6,c7,c8,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @06jeff07@ then return -1 endi if $data01 != @06jeff07jeff08@ then return -1 endi if $data02 != @06jeff07jeff08jeff09@ then return -1 endi print execute sql select concat_ws('jeff',c6,'taos'),concat_ws('jeff',c7,'taos'),concat_ws('jeff',c8,'taos'),concat_ws('jeff',c9,'taos') from ct1 sql select concat_ws('jeff',c6,'taos'),concat_ws('jeff',c7,'taos'),concat_ws('jeff',c8,'taos'),concat_ws('jeff',c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @06jefftaos@ then return -1 endi if $data01 != @07jefftaos@ then return -1 endi if $data02 != @08jefftaos@ then return -1 endi if $data03 != @09jefftaos@ then return -1 endi print execute sql select concat_ws('jeff',c6,c7,'taos'),concat_ws('jeff',c6,c8,'taos'),concat_ws('jeff',c6,c9,'taos'),concat_ws('jeff',c7,c8,'taos'),concat_ws('jeff',c7,c9,'taos') from ct1 sql select concat_ws('jeff',c6,c7,'taos'),concat_ws('jeff',c6,c8,'taos'),concat_ws('jeff',c6,c9,'taos'),concat_ws('jeff',c7,c8,'taos'),concat_ws('jeff',c7,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @06jeff07jefftaos@ then return -1 endi if $data01 != @06jeff08jefftaos@ then return -1 endi if $data02 != @06jeff09jefftaos@ then return -1 endi if $data03 != @07jeff08jefftaos@ then return -1 endi if $data04 != @07jeff09jefftaos@ then return -1 endi print execute sql select concat_ws('jeff',c6,'taos',c7),concat_ws('jeff',c6,'taos',c8),concat_ws('jeff',c6,'taos',c9),concat_ws('jeff',c7,'taos',c8),concat_ws('jeff',c7,'taos',c9) from ct1 sql select concat_ws('jeff',c6,'taos',c7),concat_ws('jeff',c6,'taos',c8),concat_ws('jeff',c6,'taos',c9),concat_ws('jeff',c7,'taos',c8),concat_ws('jeff',c7,'taos',c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @06jefftaosjeff07@ then return -1 endi if $data01 != @06jefftaosjeff08@ then return -1 endi if $data02 != @06jefftaosjeff09@ then return -1 endi if $data03 != @07jefftaosjeff08@ then return -1 endi if $data04 != @07jefftaosjeff09@ then return -1 endi print execute sql select concat_ws('jeff','taos',c6,c7),concat_ws('jeff','taos',c6,c8),concat_ws('jeff','taos',c6,c9),concat_ws('jeff','taos',c7,c8),concat_ws('jeff','taos',c7,c9) from ct1 sql select concat_ws('jeff','taos',c6,c7),concat_ws('jeff','taos',c6,c8),concat_ws('jeff','taos',c6,c9),concat_ws('jeff','taos',c7,c8),concat_ws('jeff','taos',c7,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosjeff06jeff07@ then return -1 endi if $data01 != @taosjeff06jeff08@ then return -1 endi if $data02 != @taosjeff06jeff09@ then return -1 endi if $data03 != @taosjeff07jeff08@ then return -1 endi if $data04 != @taosjeff07jeff09@ then return -1 endi print execute sql select concat_ws('jeff',c6,c7,c8,c9),concat_ws('jeff','taos',c6,c7,c8,c9),concat_ws('jeff',c6,'taos',c7,c8,c9),concat_ws('jeff',c6,c7,'taos',c8,c9),concat_ws('jeff',c6,c7,c8,c9,'taos') from ct1 sql select concat_ws('jeff',c6,c7,c8,c9),concat_ws('jeff','taos',c6,c7,c8,c9),concat_ws('jeff',c6,'taos',c7,c8,c9),concat_ws('jeff',c6,c7,'taos',c8,c9),concat_ws('jeff',c6,c7,c8,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @06jeff07jeff08jeff09@ then return -1 endi if $data01 != @taosjeff06jeff07jeff08jeff09@ then return -1 endi if $data02 != @06jefftaosjeff07jeff08jeff09@ then return -1 endi if $data03 != @06jeff07jefftaosjeff08jeff09@ then return -1 endi if $data04 != @06jeff07jeff08jeff09jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data',c3),concat_ws('jeff','data',c3,c4),concat_ws('jeff','data',c3,c4,c5) from ct1 sql select concat_ws('jeff','data',c3),concat_ws('jeff','data',c3,c4),concat_ws('jeff','data',c3,c4,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff03@ then return -1 endi if $data01 != @datajeff03jeff04@ then return -1 endi if $data02 != @datajeff03jeff04jeff05@ then return -1 endi print execute sql select concat_ws('jeff','data','taos'),concat_ws('jeff',c3,'taos'),concat_ws('jeff',c4,'taos'),concat_ws('jeff',c5,'taos') from ct1 sql select concat_ws('jeff','data','taos'),concat_ws('jeff',c3,'taos'),concat_ws('jeff',c4,'taos'),concat_ws('jeff',c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajefftaos@ then return -1 endi if $data01 != @03jefftaos@ then return -1 endi if $data02 != @04jefftaos@ then return -1 endi if $data03 != @05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data',c3,'taos'),concat_ws('jeff','data',c4,'taos'),concat_ws('jeff','data',c5,'taos'),concat_ws('jeff',c3,c4,'taos'),concat_ws('jeff',c3,c5,'taos') from ct1 sql select concat_ws('jeff','data',c3,'taos'),concat_ws('jeff','data',c4,'taos'),concat_ws('jeff','data',c5,'taos'),concat_ws('jeff',c3,c4,'taos'),concat_ws('jeff',c3,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff03jefftaos@ then return -1 endi if $data01 != @datajeff04jefftaos@ then return -1 endi if $data02 != @datajeff05jefftaos@ then return -1 endi if $data03 != @03jeff04jefftaos@ then return -1 endi if $data04 != @03jeff05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data','taos',c3),concat_ws('jeff','data','taos',c4),concat_ws('jeff','data','taos',c5),concat_ws('jeff',c3,'taos',c4),concat_ws('jeff',c3,'taos',c5) from ct1 sql select concat_ws('jeff','data','taos',c3),concat_ws('jeff','data','taos',c4),concat_ws('jeff','data','taos',c5),concat_ws('jeff',c3,'taos',c4),concat_ws('jeff',c3,'taos',c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @datajefftaosjeff03@ then return -1 endi if $data01 != @datajefftaosjeff04@ then return -1 endi if $data02 != @datajefftaosjeff05@ then return -1 endi if $data03 != @03jefftaosjeff04@ then return -1 endi if $data04 != @03jefftaosjeff05@ then return -1 endi print execute sql select concat_ws('jeff','taos','data',c3),concat_ws('jeff','taos','data',c4),concat_ws('jeff','taos','data',c5),concat_ws('jeff','taos',c3,c4),concat_ws('jeff','taos',c3,c5) from ct1 sql select concat_ws('jeff','taos','data',c3),concat_ws('jeff','taos','data',c4),concat_ws('jeff','taos','data',c5),concat_ws('jeff','taos',c3,c4),concat_ws('jeff','taos',c3,c5) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosjeffdatajeff03@ then return -1 endi if $data01 != @taosjeffdatajeff04@ then return -1 endi if $data02 != @taosjeffdatajeff05@ then return -1 endi if $data03 != @taosjeff03jeff04@ then return -1 endi if $data04 != @taosjeff03jeff05@ then return -1 endi print execute sql select concat_ws('jeff','data',c3,c4,c5),concat_ws('jeff','taos','data',c3,c4,c5),concat_ws('jeff','data','taos',c3,c4,c5),concat_ws('jeff','data',c3,'taos',c4,c5),concat_ws('jeff','data',c3,c4,c5,'taos') from ct1 sql select concat_ws('jeff','data',c3,c4,c5),concat_ws('jeff','taos','data',c3,c4,c5),concat_ws('jeff','data','taos',c3,c4,c5),concat_ws('jeff','data',c3,'taos',c4,c5),concat_ws('jeff','data',c3,c4,c5,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff03jeff04jeff05@ then return -1 endi if $data01 != @taosjeffdatajeff03jeff04jeff05@ then return -1 endi if $data02 != @datajefftaosjeff03jeff04jeff05@ then return -1 endi if $data03 != @datajeff03jefftaosjeff04jeff05@ then return -1 endi if $data04 != @datajeff03jeff04jeff05jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data',c7),concat_ws('jeff','data',c7,c8),concat_ws('jeff','data',c7,c8,c9) from ct1 sql select concat_ws('jeff','data',c7),concat_ws('jeff','data',c7,c8),concat_ws('jeff','data',c7,c8,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff07@ then return -1 endi if $data01 != @datajeff07jeff08@ then return -1 endi if $data02 != @datajeff07jeff08jeff09@ then return -1 endi print execute sql select concat_ws('jeff','data','taos'),concat_ws('jeff',c7,'taos'),concat_ws('jeff',c8,'taos'),concat_ws('jeff',c9,'taos') from ct1 sql select concat_ws('jeff','data','taos'),concat_ws('jeff',c7,'taos'),concat_ws('jeff',c8,'taos'),concat_ws('jeff',c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajefftaos@ then return -1 endi if $data01 != @07jefftaos@ then return -1 endi if $data02 != @08jefftaos@ then return -1 endi if $data03 != @09jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data',c7,'taos'),concat_ws('jeff','data',c8,'taos'),concat_ws('jeff','data',c9,'taos'),concat_ws('jeff',c7,c8,'taos'),concat_ws('jeff',c7,c9,'taos') from ct1 sql select concat_ws('jeff','data',c7,'taos'),concat_ws('jeff','data',c8,'taos'),concat_ws('jeff','data',c9,'taos'),concat_ws('jeff',c7,c8,'taos'),concat_ws('jeff',c7,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff07jefftaos@ then return -1 endi if $data01 != @datajeff08jefftaos@ then return -1 endi if $data02 != @datajeff09jefftaos@ then return -1 endi if $data03 != @07jeff08jefftaos@ then return -1 endi if $data04 != @07jeff09jefftaos@ then return -1 endi print execute sql select concat_ws('jeff','data','taos',c7),concat_ws('jeff','data','taos',c8),concat_ws('jeff','data','taos',c9),concat_ws('jeff',c7,'taos',c8),concat_ws('jeff',c7,'taos',c9) from ct1 sql select concat_ws('jeff','data','taos',c7),concat_ws('jeff','data','taos',c8),concat_ws('jeff','data','taos',c9),concat_ws('jeff',c7,'taos',c8),concat_ws('jeff',c7,'taos',c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @datajefftaosjeff07@ then return -1 endi if $data01 != @datajefftaosjeff08@ then return -1 endi if $data02 != @datajefftaosjeff09@ then return -1 endi if $data03 != @07jefftaosjeff08@ then return -1 endi if $data04 != @07jefftaosjeff09@ then return -1 endi print execute sql select concat_ws('jeff','taos','data',c7),concat_ws('jeff','taos','data',c8),concat_ws('jeff','taos','data',c9),concat_ws('jeff','taos',c7,c8),concat_ws('jeff','taos',c7,c9) from ct1 sql select concat_ws('jeff','taos','data',c7),concat_ws('jeff','taos','data',c8),concat_ws('jeff','taos','data',c9),concat_ws('jeff','taos',c7,c8),concat_ws('jeff','taos',c7,c9) from ct1 if $rows != 50 then return -1 endi if $data00 != @taosjeffdatajeff07@ then return -1 endi if $data01 != @taosjeffdatajeff08@ then return -1 endi if $data02 != @taosjeffdatajeff09@ then return -1 endi if $data03 != @taosjeff07jeff08@ then return -1 endi if $data04 != @taosjeff07jeff09@ then return -1 endi print execute sql select concat_ws('jeff','data',c7,c8,c9),concat_ws('jeff','taos','data',c7,c8,c9),concat_ws('jeff','data','taos',c7,c8,c9),concat_ws('jeff','data',c7,'taos',c8,c9),concat_ws('jeff','data',c7,c8,c9,'taos') from ct1 sql select concat_ws('jeff','data',c7,c8,c9),concat_ws('jeff','taos','data',c7,c8,c9),concat_ws('jeff','data','taos',c7,c8,c9),concat_ws('jeff','data',c7,'taos',c8,c9),concat_ws('jeff','data',c7,c8,c9,'taos') from ct1 if $rows != 50 then return -1 endi if $data00 != @datajeff07jeff08jeff09@ then return -1 endi if $data01 != @taosjeffdatajeff07jeff08jeff09@ then return -1 endi if $data02 != @datajefftaosjeff07jeff08jeff09@ then return -1 endi if $data03 != @datajeff07jefftaosjeff08jeff09@ then return -1 endi if $data04 != @datajeff07jeff08jeff09jefftaos@ then return -1 endi print execute sql select length(concat(c2,c3)),length(concat(c2,c3,c4)),length(concat(c2,c3,c4,c5)) from ct1 sql select length(concat(c2,c3)),length(concat(c2,c3,c4)),length(concat(c2,c3,c4,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @4@ then return -1 endi if $data01 != @6@ then return -1 endi if $data02 != @8@ then return -1 endi print execute sql select length(concat(c2,'taos')),length(concat(c3,'taos')),length(concat(c4,'taos')),length(concat(c5,'taos')) from ct1 sql select length(concat(c2,'taos')),length(concat(c3,'taos')),length(concat(c4,'taos')),length(concat(c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @6@ then return -1 endi if $data01 != @6@ then return -1 endi if $data02 != @6@ then return -1 endi if $data03 != @6@ then return -1 endi print execute sql select length(concat(c2,c3,'taos')),length(concat(c2,c4,'taos')),length(concat(c2,c5,'taos')),length(concat(c3,c4,'taos')),length(concat(c3,c5,'taos')) from ct1 sql select length(concat(c2,c3,'taos')),length(concat(c2,c4,'taos')),length(concat(c2,c5,'taos')),length(concat(c3,c4,'taos')),length(concat(c3,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @8@ then return -1 endi if $data02 != @8@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat(c2,'taos',c3)),length(concat(c2,'taos',c4)),length(concat(c2,'taos',c5)),length(concat(c3,'taos',c4)),length(concat(c3,'taos',c5)) from ct1 sql select length(concat(c2,'taos',c3)),length(concat(c2,'taos',c4)),length(concat(c2,'taos',c5)),length(concat(c3,'taos',c4)),length(concat(c3,'taos',c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @8@ then return -1 endi if $data02 != @8@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat('taos',c2,c3)),length(concat('taos',c2,c4)),length(concat('taos',c2,c5)),length(concat('taos',c3,c4)),length(concat('taos',c3,c5)) from ct1 sql select length(concat('taos',c2,c3)),length(concat('taos',c2,c4)),length(concat('taos',c2,c5)),length(concat('taos',c3,c4)),length(concat('taos',c3,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @8@ then return -1 endi if $data02 != @8@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat(c2,c3,c4,c5)),length(concat('taos',c2,c3,c4,c5)),length(concat(c2,'taos',c3,c4,c5)),length(concat(c2,c3,'taos',c4,c5)),length(concat(c2,c3,c4,c5,'taos')) from ct1 sql select length(concat(c2,c3,c4,c5)),length(concat('taos',c2,c3,c4,c5)),length(concat(c2,'taos',c3,c4,c5)),length(concat(c2,c3,'taos',c4,c5)),length(concat(c2,c3,c4,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @12@ then return -1 endi if $data02 != @12@ then return -1 endi if $data03 != @12@ then return -1 endi if $data04 != @12@ then return -1 endi print execute sql select length(concat(c6,c7)),length(concat(c6,c7,c8)),length(concat(c6,c7,c8,c9)) from ct1 sql select length(concat(c6,c7)),length(concat(c6,c7,c8)),length(concat(c6,c7,c8,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @16@ then return -1 endi if $data01 != @24@ then return -1 endi if $data02 != @32@ then return -1 endi print execute sql select length(concat(c6,'taos')),length(concat(c7,'taos')),length(concat(c8,'taos')),length(concat(c9,'taos')) from ct1 sql select length(concat(c6,'taos')),length(concat(c7,'taos')),length(concat(c8,'taos')),length(concat(c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @24@ then return -1 endi if $data01 != @24@ then return -1 endi if $data02 != @24@ then return -1 endi if $data03 != @24@ then return -1 endi print execute sql select length(concat(c6,c7,'taos')),length(concat(c6,c8,'taos')),length(concat(c6,c9,'taos')),length(concat(c7,c8,'taos')),length(concat(c7,c9,'taos')) from ct1 sql select length(concat(c6,c7,'taos')),length(concat(c6,c8,'taos')),length(concat(c6,c9,'taos')),length(concat(c7,c8,'taos')),length(concat(c7,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @32@ then return -1 endi if $data01 != @32@ then return -1 endi if $data02 != @32@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat(c6,'taos',c7)),length(concat(c6,'taos',c8)),length(concat(c6,'taos',c9)),length(concat(c7,'taos',c8)),length(concat(c7,'taos',c9)) from ct1 sql select length(concat(c6,'taos',c7)),length(concat(c6,'taos',c8)),length(concat(c6,'taos',c9)),length(concat(c7,'taos',c8)),length(concat(c7,'taos',c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @32@ then return -1 endi if $data01 != @32@ then return -1 endi if $data02 != @32@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat('taos',c6,c7)),length(concat('taos',c6,c8)),length(concat('taos',c6,c9)),length(concat('taos',c7,c8)),length(concat('taos',c7,c9)) from ct1 sql select length(concat('taos',c6,c7)),length(concat('taos',c6,c8)),length(concat('taos',c6,c9)),length(concat('taos',c7,c8)),length(concat('taos',c7,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @32@ then return -1 endi if $data01 != @32@ then return -1 endi if $data02 != @32@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat(c6,c7,c8,c9)),length(concat('taos',c6,c7,c8,c9)),length(concat(c6,'taos',c7,c8,c9)),length(concat(c6,c7,'taos',c8,c9)),length(concat(c6,c7,c8,c9,'taos')) from ct1 sql select length(concat(c6,c7,c8,c9)),length(concat('taos',c6,c7,c8,c9)),length(concat(c6,'taos',c7,c8,c9)),length(concat(c6,c7,'taos',c8,c9)),length(concat(c6,c7,c8,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @32@ then return -1 endi if $data01 != @48@ then return -1 endi if $data02 != @48@ then return -1 endi if $data03 != @48@ then return -1 endi if $data04 != @48@ then return -1 endi print execute sql select length(concat('data',c3)),length(concat('data',c3,c4)),length(concat('data',c3,c4,c5)) from ct1 sql select length(concat('data',c3)),length(concat('data',c3,c4)),length(concat('data',c3,c4,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @6@ then return -1 endi if $data01 != @8@ then return -1 endi if $data02 != @10@ then return -1 endi print execute sql select length(concat('data','taos')),length(concat(c3,'taos')),length(concat(c4,'taos')),length(concat(c5,'taos')) from ct1 sql select length(concat('data','taos')),length(concat(c3,'taos')),length(concat(c4,'taos')),length(concat(c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @6@ then return -1 endi if $data02 != @6@ then return -1 endi if $data03 != @6@ then return -1 endi print execute sql select length(concat('data',c3,'taos')),length(concat('data',c4,'taos')),length(concat('data',c5,'taos')),length(concat(c3,c4,'taos')),length(concat(c3,c5,'taos')) from ct1 sql select length(concat('data',c3,'taos')),length(concat('data',c4,'taos')),length(concat('data',c5,'taos')),length(concat(c3,c4,'taos')),length(concat(c3,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @10@ then return -1 endi if $data02 != @10@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat('data','taos',c3)),length(concat('data','taos',c4)),length(concat('data','taos',c5)),length(concat(c3,'taos',c4)),length(concat(c3,'taos',c5)) from ct1 sql select length(concat('data','taos',c3)),length(concat('data','taos',c4)),length(concat('data','taos',c5)),length(concat(c3,'taos',c4)),length(concat(c3,'taos',c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @10@ then return -1 endi if $data02 != @10@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat('taos','data',c3)),length(concat('taos','data',c4)),length(concat('taos','data',c5)),length(concat('taos',c3,c4)),length(concat('taos',c3,c5)) from ct1 sql select length(concat('taos','data',c3)),length(concat('taos','data',c4)),length(concat('taos','data',c5)),length(concat('taos',c3,c4)),length(concat('taos',c3,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @10@ then return -1 endi if $data02 != @10@ then return -1 endi if $data03 != @8@ then return -1 endi if $data04 != @8@ then return -1 endi print execute sql select length(concat('data',c3,c4,c5)),length(concat('taos','data',c3,c4,c5)),length(concat('data','taos',c3,c4,c5)),length(concat('data',c3,'taos',c4,c5)),length(concat('data',c3,c4,c5,'taos')) from ct1 sql select length(concat('data',c3,c4,c5)),length(concat('taos','data',c3,c4,c5)),length(concat('data','taos',c3,c4,c5)),length(concat('data',c3,'taos',c4,c5)),length(concat('data',c3,c4,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @14@ then return -1 endi if $data02 != @14@ then return -1 endi if $data03 != @14@ then return -1 endi if $data04 != @14@ then return -1 endi print execute sql select length(concat('data',c7)),length(concat('data',c7,c8)),length(concat('data',c7,c8,c9)) from ct1 sql select length(concat('data',c7)),length(concat('data',c7,c8)),length(concat('data',c7,c8,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @24@ then return -1 endi if $data01 != @32@ then return -1 endi if $data02 != @40@ then return -1 endi print execute sql select length(concat('data','taos')),length(concat(c7,'taos')),length(concat(c8,'taos')),length(concat(c9,'taos')) from ct1 sql select length(concat('data','taos')),length(concat(c7,'taos')),length(concat(c8,'taos')),length(concat(c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @24@ then return -1 endi if $data02 != @24@ then return -1 endi if $data03 != @24@ then return -1 endi print execute sql select length(concat('data',c7,'taos')),length(concat('data',c8,'taos')),length(concat('data',c9,'taos')),length(concat(c7,c8,'taos')),length(concat(c7,c9,'taos')) from ct1 sql select length(concat('data',c7,'taos')),length(concat('data',c8,'taos')),length(concat('data',c9,'taos')),length(concat(c7,c8,'taos')),length(concat(c7,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @40@ then return -1 endi if $data02 != @40@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat('data','taos',c7)),length(concat('data','taos',c8)),length(concat('data','taos',c9)),length(concat(c7,'taos',c8)),length(concat(c7,'taos',c9)) from ct1 sql select length(concat('data','taos',c7)),length(concat('data','taos',c8)),length(concat('data','taos',c9)),length(concat(c7,'taos',c8)),length(concat(c7,'taos',c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @40@ then return -1 endi if $data02 != @40@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat('taos','data',c7)),length(concat('taos','data',c8)),length(concat('taos','data',c9)),length(concat('taos',c7,c8)),length(concat('taos',c7,c9)) from ct1 sql select length(concat('taos','data',c7)),length(concat('taos','data',c8)),length(concat('taos','data',c9)),length(concat('taos',c7,c8)),length(concat('taos',c7,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @40@ then return -1 endi if $data02 != @40@ then return -1 endi if $data03 != @32@ then return -1 endi if $data04 != @32@ then return -1 endi print execute sql select length(concat('data',c7,c8,c9)),length(concat('taos','data',c7,c8,c9)),length(concat('data','taos',c7,c8,c9)),length(concat('data',c7,'taos',c8,c9)),length(concat('data',c7,c8,c9,'taos')) from ct1 sql select length(concat('data',c7,c8,c9)),length(concat('taos','data',c7,c8,c9)),length(concat('data','taos',c7,c8,c9)),length(concat('data',c7,'taos',c8,c9)),length(concat('data',c7,c8,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @56@ then return -1 endi if $data02 != @56@ then return -1 endi if $data03 != @56@ then return -1 endi if $data04 != @56@ then return -1 endi print execute sql select length(concat_ws('jeff',c2,c3)),length(concat_ws('jeff',c2,c3,c4)),length(concat_ws('jeff',c2,c3,c4,c5)) from ct1 sql select length(concat_ws('jeff',c2,c3)),length(concat_ws('jeff',c2,c3,c4)),length(concat_ws('jeff',c2,c3,c4,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @8@ then return -1 endi if $data01 != @14@ then return -1 endi if $data02 != @20@ then return -1 endi print execute sql select length(concat_ws('jeff',c2,'taos')),length(concat_ws('jeff',c3,'taos')),length(concat_ws('jeff',c4,'taos')),length(concat_ws('jeff',c5,'taos')) from ct1 sql select length(concat_ws('jeff',c2,'taos')),length(concat_ws('jeff',c3,'taos')),length(concat_ws('jeff',c4,'taos')),length(concat_ws('jeff',c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @10@ then return -1 endi if $data02 != @10@ then return -1 endi if $data03 != @10@ then return -1 endi print execute sql select length(concat_ws('jeff',c2,c3,'taos')),length(concat_ws('jeff',c2,c4,'taos')),length(concat_ws('jeff',c2,c5,'taos')),length(concat_ws('jeff',c3,c4,'taos')),length(concat_ws('jeff',c3,c5,'taos')) from ct1 sql select length(concat_ws('jeff',c2,c3,'taos')),length(concat_ws('jeff',c2,c4,'taos')),length(concat_ws('jeff',c2,c5,'taos')),length(concat_ws('jeff',c3,c4,'taos')),length(concat_ws('jeff',c3,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @16@ then return -1 endi if $data01 != @16@ then return -1 endi if $data02 != @16@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff',c2,'taos',c3)),length(concat_ws('jeff',c2,'taos',c4)),length(concat_ws('jeff',c2,'taos',c5)),length(concat_ws('jeff',c3,'taos',c4)),length(concat_ws('jeff',c3,'taos',c5)) from ct1 sql select length(concat_ws('jeff',c2,'taos',c3)),length(concat_ws('jeff',c2,'taos',c4)),length(concat_ws('jeff',c2,'taos',c5)),length(concat_ws('jeff',c3,'taos',c4)),length(concat_ws('jeff',c3,'taos',c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @16@ then return -1 endi if $data01 != @16@ then return -1 endi if $data02 != @16@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff','taos',c2,c3)),length(concat_ws('jeff','taos',c2,c4)),length(concat_ws('jeff','taos',c2,c5)),length(concat_ws('jeff','taos',c3,c4)),length(concat_ws('jeff','taos',c3,c5)) from ct1 sql select length(concat_ws('jeff','taos',c2,c3)),length(concat_ws('jeff','taos',c2,c4)),length(concat_ws('jeff','taos',c2,c5)),length(concat_ws('jeff','taos',c3,c4)),length(concat_ws('jeff','taos',c3,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @16@ then return -1 endi if $data01 != @16@ then return -1 endi if $data02 != @16@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff',c2,c3,c4,c5)),length(concat_ws('jeff','taos',c2,c3,c4,c5)),length(concat_ws('jeff',c2,'taos',c3,c4,c5)),length(concat_ws('jeff',c2,c3,'taos',c4,c5)),length(concat_ws('jeff',c2,c3,c4,c5,'taos')) from ct1 sql select length(concat_ws('jeff',c2,c3,c4,c5)),length(concat_ws('jeff','taos',c2,c3,c4,c5)),length(concat_ws('jeff',c2,'taos',c3,c4,c5)),length(concat_ws('jeff',c2,c3,'taos',c4,c5)),length(concat_ws('jeff',c2,c3,c4,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @20@ then return -1 endi if $data01 != @28@ then return -1 endi if $data02 != @28@ then return -1 endi if $data03 != @28@ then return -1 endi if $data04 != @28@ then return -1 endi print execute sql select length(concat_ws('jeff',c6,c7)),length(concat_ws('jeff',c6,c7,c8)),length(concat_ws('jeff',c6,c7,c8,c9)) from ct1 sql select length(concat_ws('jeff',c6,c7)),length(concat_ws('jeff',c6,c7,c8)),length(concat_ws('jeff',c6,c7,c8,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @32@ then return -1 endi if $data01 != @56@ then return -1 endi if $data02 != @80@ then return -1 endi print execute sql select length(concat_ws('jeff',c6,'taos')),length(concat_ws('jeff',c7,'taos')),length(concat_ws('jeff',c8,'taos')),length(concat_ws('jeff',c9,'taos')) from ct1 sql select length(concat_ws('jeff',c6,'taos')),length(concat_ws('jeff',c7,'taos')),length(concat_ws('jeff',c8,'taos')),length(concat_ws('jeff',c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @40@ then return -1 endi if $data02 != @40@ then return -1 endi if $data03 != @40@ then return -1 endi print execute sql select length(concat_ws('jeff',c6,c7,'taos')),length(concat_ws('jeff',c6,c8,'taos')),length(concat_ws('jeff',c6,c9,'taos')),length(concat_ws('jeff',c7,c8,'taos')),length(concat_ws('jeff',c7,c9,'taos')) from ct1 sql select length(concat_ws('jeff',c6,c7,'taos')),length(concat_ws('jeff',c6,c8,'taos')),length(concat_ws('jeff',c6,c9,'taos')),length(concat_ws('jeff',c7,c8,'taos')),length(concat_ws('jeff',c7,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @64@ then return -1 endi if $data01 != @64@ then return -1 endi if $data02 != @64@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff',c6,'taos',c7)),length(concat_ws('jeff',c6,'taos',c8)),length(concat_ws('jeff',c6,'taos',c9)),length(concat_ws('jeff',c7,'taos',c8)),length(concat_ws('jeff',c7,'taos',c9)) from ct1 sql select length(concat_ws('jeff',c6,'taos',c7)),length(concat_ws('jeff',c6,'taos',c8)),length(concat_ws('jeff',c6,'taos',c9)),length(concat_ws('jeff',c7,'taos',c8)),length(concat_ws('jeff',c7,'taos',c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @64@ then return -1 endi if $data01 != @64@ then return -1 endi if $data02 != @64@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff','taos',c6,c7)),length(concat_ws('jeff','taos',c6,c8)),length(concat_ws('jeff','taos',c6,c9)),length(concat_ws('jeff','taos',c7,c8)),length(concat_ws('jeff','taos',c7,c9)) from ct1 sql select length(concat_ws('jeff','taos',c6,c7)),length(concat_ws('jeff','taos',c6,c8)),length(concat_ws('jeff','taos',c6,c9)),length(concat_ws('jeff','taos',c7,c8)),length(concat_ws('jeff','taos',c7,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @64@ then return -1 endi if $data01 != @64@ then return -1 endi if $data02 != @64@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff',c6,c7,c8,c9)),length(concat_ws('jeff','taos',c6,c7,c8,c9)),length(concat_ws('jeff',c6,'taos',c7,c8,c9)),length(concat_ws('jeff',c6,c7,'taos',c8,c9)),length(concat_ws('jeff',c6,c7,c8,c9,'taos')) from ct1 sql select length(concat_ws('jeff',c6,c7,c8,c9)),length(concat_ws('jeff','taos',c6,c7,c8,c9)),length(concat_ws('jeff',c6,'taos',c7,c8,c9)),length(concat_ws('jeff',c6,c7,'taos',c8,c9)),length(concat_ws('jeff',c6,c7,c8,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @80@ then return -1 endi if $data01 != @112@ then return -1 endi if $data02 != @112@ then return -1 endi if $data03 != @112@ then return -1 endi if $data04 != @112@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c3)),length(concat_ws('jeff','data',c3,c4)),length(concat_ws('jeff','data',c3,c4,c5)) from ct1 sql select length(concat_ws('jeff','data',c3)),length(concat_ws('jeff','data',c3,c4)),length(concat_ws('jeff','data',c3,c4,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @10@ then return -1 endi if $data01 != @16@ then return -1 endi if $data02 != @22@ then return -1 endi print execute sql select length(concat_ws('jeff','data','taos')),length(concat_ws('jeff',c3,'taos')),length(concat_ws('jeff',c4,'taos')),length(concat_ws('jeff',c5,'taos')) from ct1 sql select length(concat_ws('jeff','data','taos')),length(concat_ws('jeff',c3,'taos')),length(concat_ws('jeff',c4,'taos')),length(concat_ws('jeff',c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @12@ then return -1 endi if $data01 != @10@ then return -1 endi if $data02 != @10@ then return -1 endi if $data03 != @10@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c3,'taos')),length(concat_ws('jeff','data',c4,'taos')),length(concat_ws('jeff','data',c5,'taos')),length(concat_ws('jeff',c3,c4,'taos')),length(concat_ws('jeff',c3,c5,'taos')) from ct1 sql select length(concat_ws('jeff','data',c3,'taos')),length(concat_ws('jeff','data',c4,'taos')),length(concat_ws('jeff','data',c5,'taos')),length(concat_ws('jeff',c3,c4,'taos')),length(concat_ws('jeff',c3,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @18@ then return -1 endi if $data01 != @18@ then return -1 endi if $data02 != @18@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff','data','taos',c3)),length(concat_ws('jeff','data','taos',c4)),length(concat_ws('jeff','data','taos',c5)),length(concat_ws('jeff',c3,'taos',c4)),length(concat_ws('jeff',c3,'taos',c5)) from ct1 sql select length(concat_ws('jeff','data','taos',c3)),length(concat_ws('jeff','data','taos',c4)),length(concat_ws('jeff','data','taos',c5)),length(concat_ws('jeff',c3,'taos',c4)),length(concat_ws('jeff',c3,'taos',c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @18@ then return -1 endi if $data01 != @18@ then return -1 endi if $data02 != @18@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff','taos','data',c3)),length(concat_ws('jeff','taos','data',c4)),length(concat_ws('jeff','taos','data',c5)),length(concat_ws('jeff','taos',c3,c4)),length(concat_ws('jeff','taos',c3,c5)) from ct1 sql select length(concat_ws('jeff','taos','data',c3)),length(concat_ws('jeff','taos','data',c4)),length(concat_ws('jeff','taos','data',c5)),length(concat_ws('jeff','taos',c3,c4)),length(concat_ws('jeff','taos',c3,c5)) from ct1 if $rows != 50 then return -1 endi if $data00 != @18@ then return -1 endi if $data01 != @18@ then return -1 endi if $data02 != @18@ then return -1 endi if $data03 != @16@ then return -1 endi if $data04 != @16@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c3,c4,c5)),length(concat_ws('jeff','taos','data',c3,c4,c5)),length(concat_ws('jeff','data','taos',c3,c4,c5)),length(concat_ws('jeff','data',c3,'taos',c4,c5)),length(concat_ws('jeff','data',c3,c4,c5,'taos')) from ct1 sql select length(concat_ws('jeff','data',c3,c4,c5)),length(concat_ws('jeff','taos','data',c3,c4,c5)),length(concat_ws('jeff','data','taos',c3,c4,c5)),length(concat_ws('jeff','data',c3,'taos',c4,c5)),length(concat_ws('jeff','data',c3,c4,c5,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @22@ then return -1 endi if $data01 != @30@ then return -1 endi if $data02 != @30@ then return -1 endi if $data03 != @30@ then return -1 endi if $data04 != @30@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c7)),length(concat_ws('jeff','data',c7,c8)),length(concat_ws('jeff','data',c7,c8,c9)) from ct1 sql select length(concat_ws('jeff','data',c7)),length(concat_ws('jeff','data',c7,c8)),length(concat_ws('jeff','data',c7,c8,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @40@ then return -1 endi if $data01 != @64@ then return -1 endi if $data02 != @88@ then return -1 endi print execute sql select length(concat_ws('jeff','data','taos')),length(concat_ws('jeff',c7,'taos')),length(concat_ws('jeff',c8,'taos')),length(concat_ws('jeff',c9,'taos')) from ct1 sql select length(concat_ws('jeff','data','taos')),length(concat_ws('jeff',c7,'taos')),length(concat_ws('jeff',c8,'taos')),length(concat_ws('jeff',c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @12@ then return -1 endi if $data01 != @40@ then return -1 endi if $data02 != @40@ then return -1 endi if $data03 != @40@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c7,'taos')),length(concat_ws('jeff','data',c8,'taos')),length(concat_ws('jeff','data',c9,'taos')),length(concat_ws('jeff',c7,c8,'taos')),length(concat_ws('jeff',c7,c9,'taos')) from ct1 sql select length(concat_ws('jeff','data',c7,'taos')),length(concat_ws('jeff','data',c8,'taos')),length(concat_ws('jeff','data',c9,'taos')),length(concat_ws('jeff',c7,c8,'taos')),length(concat_ws('jeff',c7,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @72@ then return -1 endi if $data01 != @72@ then return -1 endi if $data02 != @72@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff','data','taos',c7)),length(concat_ws('jeff','data','taos',c8)),length(concat_ws('jeff','data','taos',c9)),length(concat_ws('jeff',c7,'taos',c8)),length(concat_ws('jeff',c7,'taos',c9)) from ct1 sql select length(concat_ws('jeff','data','taos',c7)),length(concat_ws('jeff','data','taos',c8)),length(concat_ws('jeff','data','taos',c9)),length(concat_ws('jeff',c7,'taos',c8)),length(concat_ws('jeff',c7,'taos',c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @72@ then return -1 endi if $data01 != @72@ then return -1 endi if $data02 != @72@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff','taos','data',c7)),length(concat_ws('jeff','taos','data',c8)),length(concat_ws('jeff','taos','data',c9)),length(concat_ws('jeff','taos',c7,c8)),length(concat_ws('jeff','taos',c7,c9)) from ct1 sql select length(concat_ws('jeff','taos','data',c7)),length(concat_ws('jeff','taos','data',c8)),length(concat_ws('jeff','taos','data',c9)),length(concat_ws('jeff','taos',c7,c8)),length(concat_ws('jeff','taos',c7,c9)) from ct1 if $rows != 50 then return -1 endi if $data00 != @72@ then return -1 endi if $data01 != @72@ then return -1 endi if $data02 != @72@ then return -1 endi if $data03 != @64@ then return -1 endi if $data04 != @64@ then return -1 endi print execute sql select length(concat_ws('jeff','data',c7,c8,c9)),length(concat_ws('jeff','taos','data',c7,c8,c9)),length(concat_ws('jeff','data','taos',c7,c8,c9)),length(concat_ws('jeff','data',c7,'taos',c8,c9)),length(concat_ws('jeff','data',c7,c8,c9,'taos')) from ct1 sql select length(concat_ws('jeff','data',c7,c8,c9)),length(concat_ws('jeff','taos','data',c7,c8,c9)),length(concat_ws('jeff','data','taos',c7,c8,c9)),length(concat_ws('jeff','data',c7,'taos',c8,c9)),length(concat_ws('jeff','data',c7,c8,c9,'taos')) from ct1 if $rows != 50 then return -1 endi if $data00 != @88@ then return -1 endi if $data01 != @120@ then return -1 endi if $data02 != @120@ then return -1 endi if $data03 != @120@ then return -1 endi if $data04 != @120@ then return -1 endi print =============== clear #sql drop database $db #sql show databases #if $rows != 0 then # return -1 #endi #system sh/exec.sh -n dnode1 -s stop -x SIGINT