mini-sql-engine/test_2.sh at main · mayankmusaddi/mini-sql-engine · GitHub

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
./run.sh "select * from table1;"

./run.sh "select * from table1, table2;"

./run.sh "select A, B from table1, table2;"

./run.sh "select B, D2 from table1, table2;"

./run.sh "select distinct B from table1;"

./run.sh "select A, B2 from table1, table2 where A > 900 AND D2 < 200;"

./run.sh "select * from table1, table2 where B > D2;"

./run.sh "select A, B, D2 from table1, table2 where B = D2;"

./run.sh "select A, B, C from table1, table2;"

./run.sh "select distinct A, D2 from table1, table2;"

./run.sh "select distinct A, B2 from table1, table2;"

./run.sh "Select max(A) from table1, table2 where A = D2;"

./run.sh "select A, B2 from table1, table2 where A > 900 AND B2 < 100;"

./run.sh "select A, B2 from table1, table2 where A > 900 AND B2 = 311;"

./run.sh "Select B,B2 from table1,table2 where B=B2;"

./run.sh "Select B, B2 from table1, table2 where A > 0 and B = B2;"

./run.sh "Slect B, B2 from table1, table2 where A > 0 and B = B2;"

./run.sh "Select B, B2 table1, table2 where A > 0 and B = B2;"

./run.sh "Select"

./run.sh "Select B, B2 from table1, table2 where A > 0 and B = B2"

./run.sh "Select B, B2 from table1, table2 where A > 0 xor B = B2;"

./run.sh "Select B, B2 from table1, table2 where A > 0 and B = B2;"

./run.sh "Select B, B2 from table1, table2 wherre A > 0 and B = B2;"

./run.sh "B, B2 from table1, table2 where A > 0 and B = B2;"

./run.sh "from table1, table2 where A & 0 and B = B2;"


# ./run.sh "select distinct max(A), sum(B), D from table1,table2,table3 group by D order by D desc"
# ./run.sh "select A,D from table1,table2,table3 order by F desc"