forked from WesleyBlq/sql_parser
-
Notifications
You must be signed in to change notification settings - Fork 0
/
parser_test.cpp
104 lines (81 loc) · 3.52 KB
/
parser_test.cpp
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
#include <cstdlib>
#include <iostream>
#include <sstream>
#include <stdexcept>
#include <map>
#include <string>
#include <unistd.h>
#include <stdio.h>
#include <stdlib.h>
#include <cstdlib>
#include "parse_malloc.h"
#include "parse_node.h"
#include "utility.h"
#include "ob_define.h"
#include "ob_logical_plan.h"
#include "ob_select_stmt.h"
#include "ob_delete_stmt.h"
#include "ob_insert_stmt.h"
#include "ob_update_stmt.h"
#include "dml_build_plan.h"
#include "jd_exec_plan.h"
using namespace std;
using namespace oceanbase;
using namespace oceanbase::common;
using namespace oceanbase::sql;
int
sql_parser(string sql, string current_db_name)
{
int ret = 0;
QueryActuator *query_actuator = new QueryActuator(current_db_name);
if (OB_SUCCESS != (ret = query_actuator->generate_exec_plan(sql)))
{
fprintf(stderr, "generate_exec_plan: %s\n", query_actuator->get_result_plan().err_stat_.err_msg_);
ret = OB_ERR_GEN_PLAN;
return ret;
}
delete query_actuator;
}
int main(void)
{
string sql1 = "INSERT INTO persons (lastname, address) VALUES ('Wilson', 'Champs-Elysees')";
string sql2 = "SELECT * FROM persons";
string sql3 = "SELECT COUNT(lastname), address AS addr FROM persons WHERE id IN (select id from order_list) GROUP BY lastname";
string sql4 = "SELECT lastname, address FROM persons \
WHERE lastname='Bush' OR address='Adams' AND id = 10\
GROUP BY lastname HAVING(count(lastname) > 10) ORDER BY lastname desc limit 100, 10";
string sql7 = "select id,name FROM tt \
WHERE id=(select id from pp)";
string sql5 = "SELECT tt.id, tt.name, pp.age \
FROM tt \
JOIN pp \
ON tt.id = pp.id \
ORDER BY tt.name";
string sql6 = "select id, name, age from (select * from tt) ooxx where id > 50";
string sql9 = "SELECT id FROM tt WHERE name = 'Attendee' AND age = 10 AND (id = 147 OR id = 155)";
string sql10 = "UPDATE persons SET address = 'BEIJING' WHERE lastname = 'Wilson'";
string sql11 = "SELECT COUNT(lastname), address AS addr FROM persons";
string sql12 = "INSERT INTO persons VALUES ('Gates', 'Bill', 100), ('qinbo', 'qin', 101)";
string sql13 = "INSERT INTO persons (address, lastname) \
SELECT address,lastname FROM persons";
string sql14 = "DELETE FROM persons WHERE lastname > 'cao1' AND id = 10 AND (id = 15 OR id = 100)";
string sql15 = "SELECT COUNT(lastname), address AS addr FROM persons WHERE lastname > 'cao1' AND id = 10 AND (id = 15 OR id = 100)";
string sqls = "select t.id, s.lastname from persons t join persons s on t.id = s.id";
string sql_multi_table = "select * from tt AS ttt, pp WHERE tt.id > 10";
string sql_test1 = "SELECT id, name, age from tt where id = 147 OR id = 155";
string sql_test2 = "SELECT id from pp where id>5 AND id<20 AND (id = 6 OR id = 10) AND name = 'beijing'";
string sql_test3 = "SELECT id FROM pp";
string sql_test40 = "select max(id) as id, name, avg(age) as age from tt";
// UNION distinct SELECT id FROM tt
string sql_test5 = "SELECT MAX(id) from pp where id>5 AND id<20 AND (id = 6 OR id = 10) AND name = 'beijing' GROUP BY name Having SUM(age)>100 ORDER BY age";
string sql_test4 = "select max(id), name, avg(age) as cao from tt group by age HAVING cao>1 order by id LIMIT 10,100"; //
string sql_test6 = "select * from INformation_schema.tt"; //
//sql_parser(sql3, "qinbo");
//sql_parser(sql6);
//sql_parser(sql10);
sql_parser(sql_test6, "oxwf");
//sql_parser(sql14);
//sql_parser(sql9);
//sql_parser(sql8, "qinbo");
return 1;
}