slimit1.sim

system sh/stop_dnodes.sh
system sh/ip.sh -i 1 -s up
system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
system sh/cfg.sh -n dnode1 -c commitLog -v 0
system sh/cfg.sh -n dnode1 -c sessionsPerVnode -v 2
system sh/cfg.sh -n dnode1 -c numOfTotalVnodes -v 10
system sh/exec.sh -n dnode1 -s start
sleep 3000
sql connect

$dbPrefix = slm_alt_tg_db

print ========== slimit_alter_tag.sim
# make sure the data in each table crosses a file block boundary
$rowNum = 300
$ts0 = 1537146000000
$delta = 600000
$db = $dbPrefix

sql drop database if exists $db
sql create database $db rows 200
sql use $db

sql create table stb (ts timestamp, c1 int, c2 bigint, c3 double) tags(t1 int, t2 int)
# If grouped by t2, some groups should have tables from different vnodes
sql create table tb0 using stb tags (0, 0)
sql create table tb1 using stb tags (1, 0)
sql create table tb2 using stb tags (2, 0)
sql create table tb3 using stb tags (3, 1)
sql create table tb4 using stb tags (4, 1)
sql create table tb5 using stb tags (5, 1)
sql create table tb6 using stb tags (6, 2)
sql create table tb7 using stb tags (7, 2)
sql create table tb8 using stb tags (8, 2)
# tb9 is intentionally set the same tags with tb8
sql create table tb9 using stb tags (8, 2)

$i = 0
$tbNum = 10
while $i < $tbNum
  $tb = tb . $i
  $x = 0
  while $x < $rowNum
    $xs = $x * $delta
    $ts = $ts0 + $xs
    $c1 = $x * 10
    $c1 = $c1 + $i
    sql insert into $tb values ( $ts , $c1 , $c1 , $c1 )
    $x = $x + 1
  endw
  $i = $i + 1
endw

print ================== tables and data created
  
run lite/parser/slimit1_query.sim

print ================== restart server to commit data into disk
system sh/exec.sh -n dnode1 -s stop -x SIGINT
sleep 3000
system sh/exec.sh -n dnode1 -s start
print ================== server restart completed
sql connect
sleep 3000

run lite/parser/slimit1_query.sim