mini-sql-engine/test.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
./run.sh "select * from table1 group by A;"

./run.sh "select A, max(B), A from table1 group by A;"

./run.sh "select A, max(B) from table1 group by B;"

./run.sh "select A, sum(B), avg(C), max(D), min(E), count(F)  from table1,table2,table3 group by A;"

./run.sh "select A, sum(B), avg(C), max(D), min(E), count(F)  from table1,table2,table3 group by A order by A desc;"

./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;"

./run.sh "select A, C, D  from table1,table2,table3 order by F desc;"

./run.sh "select * from table1 order by C;"

./run.sh "select * from table1 order by D;"

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

./run.sh "select * from table1,table4 order by D;"

./run.sh "select F from table1,table2 order by D;"

./run.sh "select max(A), E from table1,table2,table3;"

./run.sh "select max(A),min(F),sum(B),avg(C),count(D) from table1,table2,table3;"

./run.sh "select max(A),min(F),sum(B),avg(C),count(D) from table1,table2,table3 order by F;"