topic1.sim

system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1

system sh/cfg.sh -n dnode1 -c maxVgroupsPerDb -v 100
system sh/cfg.sh -n dnode1 -c partitions -v 4
system sh/exec.sh -n dnode1 -s start

sleep 2000
sql connect

print ====step1 create with default para
sql create topic t1;
sql use t1;

sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
if $data02 != 4 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 < 1 then 
  return -1
endi
#numofvgroups
if $data03 < 1 then 
  return -1
endi

sql show t1.vgroups;
if $rows < 1 then 
  return -1
endi

sql show t1.stables;
if $rows != 1 then 
  return -1
endi
if $data04 < 1 then 
  return -1
endi

sql show t1.tables;
if $rows < 1 then 
  return -1
endi

sql drop topic t1
sql show topics;
if $rows != 0 then 
  return -1
endi
sql show databases;
if $rows != 0 then 
  return -1
endi

sql_error use t1;
sql_error show t1.vgroups;
sql_error show t1.stables;
sql_error show t1.tables;

print ====step2 create with giving para
sql create topic t1 partitions 6;

sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
if $data02 != 6 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 != 6 then 
  return -1
endi
#numofvgroups
if $data03 != 6 then 
  return -1
endi

sql show t1.vgroups;
if $rows != 6 then 
  return -1
endi

sql show t1.stables;
if $rows != 1 then 
  return -1
endi
if $data00 != ps then 
  return -1
endi
if $data04 != 6 then 
  return -1
endi

sql show t1.tables;
if $rows != 6 then 
  return -1
endi

sql describe t1.ps;
if $data00 != off then 
  return -1
endi
if $data10 != ts then 
  return -1
endi
if $data20 != content then 
  return -1
endi
if $data30 != pid then 
  return -1
endi

sql describe t1.p1;
if $data00 != off then 
  return -1
endi
if $data10 != ts then 
  return -1
endi
if $data20 != content then 
  return -1
endi
if $data30 != pid then 
  return -1
endi

sql drop topic t1
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 0 then 
  return -1
endi

sql_error show t1.vgroups;
sql_error show t1.stables;
sql_error show t1.tables;

sql_error create topic t1 partitions -1;
#sql_error create topic t1 partitions 0;
sql_error create topic t1 partitions 10001;

print =============step3 create with db para
sql create topic db cache 2 blocks 4 days 10 keep 20 minRows 300 maxRows 400 ctime 120 precision 'ms' comp 2 wal 1 replica 1
sql show databases
if $data00 != db then 
  return -1
endi
if $data02 != 4 then 
  return -1
endi
if $data03 != 4 then 
  return -1
endi
if $data04 != 1 then 
  return -1
endi
if $data06 != 10 then 
  return -1
endi
if $data07 != 20,20,20 then 
  return -1
endi
if $data08 != 2 then 
  return -1
endi
if $data09 != 4 then 
  return -1
endi
sql drop topic db;

sql create topic db cache 2 blocks 4 days 10 keep 20 minRows 300 maxRows 400 ctime 120 precision 'ms' comp 2 wal 1 replica 1 partitions 7
sql show databases
if $data00 != db then 
  return -1
endi
if $data02 != 7 then 
  return -1
endi
if $data03 != 7 then 
  return -1
endi
if $data04 != 1 then 
  return -1
endi
if $data06 != 10 then 
  return -1
endi
if $data07 != 20,20,20 then 
  return -1
endi
if $data08 != 2 then 
  return -1
endi
if $data09 != 4 then 
  return -1
endi

sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != db then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != db then 
  return -1
endi
#tables
if $data02 != 7 then 
  return -1
endi
#numofvgroups
sql show db.vgroups;
if $rows != 7 then 
  return -1
endi
sql show db.stables;
if $rows != 1 then 
  return -1
endi
sql show db.tables;
if $rows != 7 then 
  return -1
endi

print ============== step name
sql_error alter database db name d1
sql_error alter database db name d2
sql_error alter topic db name d1
sql_error alter topic db name d2

print ============== step ntables
sql_error alter database db ntables -1
sql_error alter database db ntables 0
sql_error alter database db ntables 1
sql_error alter database db ntables 10
sql_error alter topic db ntables -1
sql_error alter topic db ntables 0
sql_error alter topic db ntables 1
sql_error alter topic db ntables 10

print ============== step vgroups
sql_error alter database db vgroups -1
sql_error alter database db vgroups 0
sql_error alter database db vgroups 1
sql_error alter database db vgroups 10
sql_error alter topic db vgroups -1
sql_error alter topic db vgroups 0
sql_error alter topic db vgroups 1
sql_error alter topic db vgroups 10

print ============== step replica
sql_error alter database db replica 2
sql_error alter database db replica 3
sql_error alter database db replica 0
sql_error alter topic db replica 2
sql_error alter topic db replica 3
sql_error alter topic db replica 0

sql alter database db replica 1
sql show databases
print replica $data4_db
if $data4_db != 1 then 
  return -1
endi

sql show topics
if $rows != 1 then 
  return -1
endi

print ============== step quorum
sql show databases
print quorum $data5_db
if $data5_db != 1 then 
  return -1
endi

sql_error alter topic db quorum 1
sql alter database db quorum 1
sql show databases
print quorum $data5_db
if $data5_db != 1 then 
  return -1
endi

sql_error alter database db quorum 2
sql_error alter database db quorum 3
sql_error alter topic db quorum 2
sql_error alter topic db quorum 3

sql_error alter database db quorum 0
sql_error alter database db quorum 4
sql_error alter database db quorum 5
sql_error alter database db quorum -1
sql_error alter topic db quorum 0
sql_error alter topic db quorum 4
sql_error alter topic db quorum 5
sql_error alter topic db quorum -1

print ============== step days
sql_error alter database db days 0
sql_error alter database db days 1
sql_error alter database db days 2
sql_error alter database db days 10
sql_error alter database db days 50
sql_error alter database db days 100
sql_error alter topic db days 0
sql_error alter topic db days 1
sql_error alter topic db days 2
sql_error alter topic db days 10
sql_error alter topic db days 50
sql_error alter topic db days 100

print ============== step keep
sql show databases
print keep $data7_db
if $data7_db != 20,20,20 then 
  return -1
endi

sql_error topic db keep 20
sql alter database db keep 20
sql show databases
print keep $data7_db
if $data7_db != 20,20,20 then
  return -1
endi

sql_error topic db keep 30
sql alter database db keep 30
sql show databases
print keep $data7_db
if $data7_db != 30,30,30 then
  return -1
endi

sql_error alter topic db keep 40
sql alter database db keep 40
sql show databases
print keep $data7_db
if $data7_db != 40,40,40 then
  return -1
endi

sql alter database db keep 40
sql alter database db keep 30
sql alter database db keep 20
sql_error alter database db keep 10.0
sql_error alter database db keep 9
sql_error alter database db keep 1
sql_error alter database db keep 0
sql_error alter database db keep -1
sql_error alter database db keep 365001

sql_error alter topic db keep 40
sql_error alter topic db keep 30
sql_error alter topic db keep 20
sql_error alter topic db keep 10
sql_error alter topic db keep 9
sql_error alter topic db keep 1
sql_error alter topic db keep 0
sql_error alter topic db keep -1
sql_error alter topic db keep 365001

print ============== step cache
sql_error alter database db cache 60
sql_error alter database db cache 50
sql_error alter database db cache 20
sql_error alter database db cache 3
sql_error alter database db cache 129
sql_error alter database db cache 300
sql_error alter database db cache 0
sql_error alter database db cache -1

sql_error alter topic db cache 60
sql_error alter topic db cache 50
sql_error alter topic db cache 20
sql_error alter topic db cache 3
sql_error alter topic db cache 129
sql_error alter topic db cache 300
sql_error alter topic db cache 0
sql_error alter topic db cache -1

print ============== step blocks
sql show databases
print blocks $data9_db
if $data9_db != 4 then 
  return -1
endi

sql_error alter topic db blocks 10
sql alter database db blocks 10
sql show databases
print blocks $data9_db
if $data9_db != 10 then 
  return -1
endi

sql_error alter topic db blocks 20
sql alter database db blocks 20
sql show databases
print blocks $data9_db
if $data9_db != 20 then 
  return -1
endi

sql_error alter topic db blocks 20
sql alter database db blocks 30
sql show databases
print blocks $data9_db
if $data9_db != 30 then 
  return -1
endi

sql alter database db blocks 40
sql alter database db blocks 30
sql alter database db blocks 20
sql alter database db blocks 10
sql_error alter database db blocks 2
sql_error alter database db blocks 1
sql_error alter database db blocks 0
sql_error alter database db blocks -1
sql_error alter database db blocks 10001

sql_error alter topic db blocks 40
sql_error alter topic db blocks 30
sql_error alter topic db blocks 20
sql_error alter topic db blocks 10
sql_error alter topic db blocks 2
sql_error alter topic db blocks 1
sql_error alter topic db blocks 0
sql_error alter topic db blocks -1
sql_error alter topic db blocks 10001

print ============== step minrows
sql_error alter database db minrows 1
sql_error alter database db minrows 100
sql_error alter database db minrows 1000

sql_error alter topic db minrows 1
sql_error alter topic db minrows 100
sql_error alter topic db minrows 1000

print ============== step maxrows
sql_error alter database db maxrows 1
sql_error alter database db maxrows 100
sql_error alter database db maxrows 1000

sql_error alter topic db maxrows 1
sql_error alter topic db maxrows 100
sql_error alter topic db maxrows 1000

print ============== step wallevel
sql show databases
print wallevel $data12_db
if $data12_db != 1 then 
  return -1
endi

sql_error alter topic db wal 1
sql_error alter database db wal 1

sql_error alter database db wal 1
sql_error alter database db wal 2
sql_error alter database db wal 1
sql_error alter database db wal 2
sql_error alter database db wal 0
sql_error alter database db wal 3
sql_error alter database db wal 4
sql_error alter database db wal -1
sql_error alter database db wal 1000

sql_error alter topic db wal 1
sql_error alter topic db wal 2
sql_error alter topic db wal 1
sql_error alter topic db wal 2
sql_error alter topic db wal 0
sql_error alter topic db wal 3
sql_error alter topic db wal 4
sql_error alter topic db wal -1
sql_error alter topic db wal 1000

print ============== step fsync
sql_error alter database db fsync 0
sql_error alter database db fsync 1
sql_error alter database db fsync 3600
sql_error alter database db fsync 18000
sql_error alter database db fsync 180000
sql_error alter database db fsync 180001
sql_error alter database db fsync -1

sql_error alter topic db fsync 0
sql_error alter topic db fsync 1
sql_error alter topic db fsync 3600
sql_error alter topic db fsync 18000
sql_error alter topic db fsync 180000
sql_error alter topic db fsync 180001
sql_error alter topic db fsync -1

print ============== step comp
sql show databases
print comp $data14_db
if $data14_db != 2 then 
  return -1
endi

sql_error alter topic db comp 1
sql alter database db comp 1
sql show databases
print comp $data14_db
if $data14_db != 1 then 
  return -1
endi

sql_error alter topic db comp 2
sql alter database db comp 2
sql show databases
print comp $data14_db
if $data14_db != 2 then 
  return -1
endi

sql_error alter topic db comp 0
sql alter database db comp 0
sql show databases
print comp $data14_db
if $data14_db != 0 then 
  return -1
endi

sql_error alter database db comp 3
sql_error alter database db comp 4
sql_error alter database db comp 5
sql_error alter database db comp -1

sql_error alter topic db comp 3
sql_error alter topic db comp 4
sql_error alter topic db comp 5
sql_error alter topic db comp -1

print ============== step precision
sql_error alter database db prec 'us'
sql_error alter topic db prec 'us'

print ============== step status
sql_error alter database db status 'delete'
sql_error alter topic db status 'delete'

print ============== step drop
sql drop database db
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 0 then 
  return -1
endi

print ============== step db1
sql create database d1
sql_error alter database d1 partitions 2
sql_error alter topic d1 partitions 2

sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql alter database d1 fsync 0
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql drop database d1
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 0 then 
  return -1
endi

print ============== step db2
sql create topic d1
sql show topics;
if $rows != 1 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql alter database d1 fsync 0
sql show topics;
if $rows != 1 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql drop database d1
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 0 then 
  return -1
endi

print ============== step db3
sql create topic d1
sql show topics;
if $rows != 1 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql alter topic d1 partitions 2
sql show topics;
if $rows != 1 then 
  return -1
endi

sql show databases;
if $rows != 1 then 
  return -1
endi

sql drop database d1
sql show topics;
if $rows != 0 then 
  return -1
endi

sql show databases;
if $rows != 0 then 
  return -1
endi

print ============== step partitions
sql create topic t1 partitions 5

sql_error alter database t1 partitions -1
sql_error alter database t1 partitions 0
sql_error alter database t1 partitions 1
sql_error alter database t1 partitions 2
sql_error alter database t1 partitions 3
sql_error alter database t1 partitions 100
sql_error alter database t1 partitions 1000
sql_error alter database t1 partitions 10000

sql_error alter topic t1 partitions -1
#sql_error alter topic t1 partitions 0
sql_error alter database t1 partitions 10000

sql alter topic t1 partitions 1
sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 != 1 then 
  return -1
endi

sql show t1.stables;
if $rows != 1 then 
  return -1
endi
sql show t1.tables;
if $rows != 1 then 
  return -1
endi

sql alter topic t1 partitions 2
sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 != 2 then 
  return -1
endi


sql show t1.stables;
if $rows != 1 then 
  return -1
endi
sql show t1.tables;
if $rows != 2 then 
  return -1
endi

sql alter topic t1 partitions 3
sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 != 3 then 
  return -1
endi

sql show t1.stables;
if $rows != 1 then 
  return -1
endi
sql show t1.tables;
if $rows != 3 then 
  return -1
endi

sql alter topic t1 partitions 10
sql show topics;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
sql show databases;
if $rows != 1 then 
  return -1
endi
if $data00 != t1 then 
  return -1
endi
#tables
if $data02 != 10 then 
  return -1
endi
#numofvgroups
sql show t1.vgroups;
if $rows != 10 then 
  return -1
endi
sql show t1.stables;
if $rows != 1 then 
  return -1
endi
sql show t1.tables;
if $rows != 10 then 
  return -1
endi

sql drop topic t1

print ============== create same name topic
sql create database d2
sql create topic t2

sql_error create topic d2
sql_error create topic if not exists d2
sql_error create topic t2
sql       create topic if not exists t2
sql_error create topic t2 partitions 5;
sql_error create topic t2 partitions 6;
sql_error create topic t2 partitions 3;

sql_error alter topic t3 partitions 1
sql_error alter topic d2 partitions 1
#sql_error alter topic t2 partitions 0
sql_error alter topic t2 partitions 10000

sql_error drop topic d2
sql_error drop topic d3
sql       drop database d2
sql       drop database t2

print ============== create partitons 0
sql create topic t2 partitions 0
sql show t2.stables;
if $rows != 0 then 
  return -1
endi
sql show t2.tables;
if $rows != 0 then 
  return -1
endi

sql drop topic t2
sql_error drop topic abc
sql drop topic if exists abc;

system sh/exec.sh -n dnode1 -s stop -x SIGINT