forked from taosdata/TDengine
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbasic.sim
More file actions
125 lines (108 loc) · 2.92 KB
/
Copy pathbasic.sim
File metadata and controls
125 lines (108 loc) · 2.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
sql connect
sleep 3000
sql show databases
sql drop database $data00 -x e1
e1:
sql show databases
sql drop database $data00 -x e2
e2:
sql create database ibadb
sql use ibadb
sql create table tb(ts timestamp, i int)
print ================= step1
sql import into tb values(1564641710000, 10000)
sql select * from tb;
if $rows != 1 then
return -1
endi
print ================= step2
sql insert into tb values(1564641708000, 8000)
sql select * from tb;
if $rows != 2 then
return -1
endi
print ================= step3
sql insert into tb values(1564641720000, 20000)
sql select * from tb;
if $rows != 3 then
return -1
endi
print ================= step4
sql import into tb values(1564641708000, 8000)
sql import into tb values(1564641715000, 15000)
sql import into tb values(1564641730000, 30000)
sql select * from tb;
if $rows != 5 then
return -1
endi
print ================= step5
sql insert into tb values(1564641708000, 8000)
sql insert into tb values(1564641714000, 14000)
sql insert into tb values(1564641725000, 25000)
sql insert into tb values(1564641740000, 40000)
sql select * from tb;
if $rows != 8 then
return -1
endi
print ================= step6
sql import into tb values(1564641707000, 7000)
sql import into tb values(1564641712000, 12000)
sql import into tb values(1564641723000, 23000)
sql import into tb values(1564641734000, 34000)
sql import into tb values(1564641750000, 50000)
sql select * from tb;
if $rows != 13 then
return -1
endi
print ================= step7
sql import into tb values(1564641707001, 7001)
sql import into tb values(1564641712001, 12001)
sql import into tb values(1564641723001, 23001)
sql import into tb values(1564641734001, 34001)
sql import into tb values(1564641750001, 50001)
sql select * from tb;
if $rows != 18 then
return -1
endi
print ================= step8
sql insert into tb values(1564641708002, 8002)
sql insert into tb values(1564641714002, 14002)
sql insert into tb values(1564641725002, 25002)
sql insert into tb values(1564641900000, 200000)
sql select * from tb;
if $rows != 22 then
return -1
endi
print ================= step9 only insert last one
sql import into tb values(1564641705000, 5000)(1564641718000, 18000)(1564642400000, 700000)
sql select * from tb;
if $rows != 25 then
return -1
endi
print ================= step10
sql import into tb values(1564641705000, 5000)(1564641718000, 18000)(1564642400000, 70000)
sql select * from tb;
if $rows != 25 then
return -1
endi
print ================= step11
sql import into tb values(1564642400000, 700000)
sql select * from tb;
if $rows != 25 then
return -1
endi
print ================= step12
sql import into tb values(1564641709527, 9527)(1564641709527, 9528)
sql select * from tb;
print rows=> $rows
if $rows != 26 then
return -1
endi
print ================= step13
sql import into tb values(1564641709898, 9898)(1564641709897, 9897)
sql select * from tb;
print rows=> $rows
if $rows != 28 then
return -1
endi
sql drop database ibadb