sleep 3000 sql connect $dbPrefix = lr_db $tbPrefix = lr_tb $stbPrefix = lr_stb $tbNum = 8 $rowNum = 60 * 24 $totalNum = $tbNum * $rowNum $ts0 = 1537146000000 $delta = 60000 print ========== lastrow_query.sim $i = 0 $db = $dbPrefix . $i $stb = $stbPrefix . $i sql use $db ##### select lastrow from STable with two vnodes, timestamp decreases from tables in vnode0 to tables in vnode1 sql select last_row(*) from $stb if $rows != 1 then return -1 endi if $data00 != @18-09-25 09:00:00.000@ then return -1 endi if $data01 != 1439 then return -1 endi if $data02 != null then return -1 endi if $data03 != 1439.00000 then return -1 endi if $data04 != 1439.000000000 then return -1 endi if $data06 != 31 then return -1 endi if $data07 != 1 then return -1 endi if $data08 != BINARY then return -1 endi if $data09 != NCHAR then return -1 endi