forked from alibaba/AliSQL
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathduckdb_proc.cc
More file actions
102 lines (80 loc) · 3.19 KB
/
duckdb_proc.cc
File metadata and controls
102 lines (80 loc) · 3.19 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
/*****************************************************************************
Copyright (c) 2025, Alibaba and/or its affiliates. All Rights Reserved.
This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License, version 2.0, as published by the
Free Software Foundation.
This program is also distributed with certain software (including but not
limited to OpenSSL) that is licensed under separate terms, as designated in a
particular file or component or in included license documentation. The authors
of MySQL hereby grant you an additional permission to link the program and
your derivative works with the separately licensed software that they have
included with MySQL.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the GNU General Public License, version 2.0,
for more details.
You should have received a copy of the GNU General Public License along with
this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*****************************************************************************/
#include "sql/duckdb/duckdb_proc.h"
#include "sql/auth/auth_acls.h"
#include "sql/duckdb/duckdb_query.h"
#include "sql/sql_lex.h"
#include "sql/sql_prepare.h"
#include "sql/strfunc.h"
#include "sql/protocol.h"
namespace myduck {
/** Uniform schema name for duckdb procedures */
const LEX_CSTRING DUCKDB_PROC_SCHEMA = {STRING_WITH_LEN("dbms_duckdb")};
/**
Singleton instance for begin_backup
*/
Proc *Duckdb_proc_query::instance() {
static Proc *proc = new Duckdb_proc_query();
return proc;
}
/**
Evoke the sql_cmd object for begin_backup() proc.
*/
Sql_cmd *Duckdb_proc_query::evoke_cmd(THD *thd,
mem_root_deque<Item *> *list) const {
return new (thd->mem_root) Sql_cmd_type(thd, list, this);
}
/**
Execute sql by duckdb
@param[in] THD Thread context
@retval true Failure
@retval false Success
*/
bool Sql_cmd_duckdb_query::pc_execute(THD *) {
DBUG_ENTER("Sql_cmd_duckdb_query::pc_execute");
DBUG_RETURN(false);
}
void Sql_cmd_duckdb_query::send_result(THD *thd, bool error) {
DBUG_ENTER("Sql_cmd_duckdb_query::send_result");
Protocol *protocol = thd->get_protocol();
if (error) {
assert(thd->is_error());
DBUG_VOID_RETURN;
}
/* Parse the input parameters */
String *input;
char buff[1024];
String str(buff, sizeof(buff), system_charset_info);
input = (*m_list)[0]->val_str(&str);
std::string sql(input->ptr(), input->length());
auto res = duckdb_query(thd, sql, false);
if (res->type == duckdb::QueryResultType::STREAM_RESULT) {
auto &stream_result = res->Cast<duckdb::StreamQueryResult>();
res = stream_result.Materialize();
}
std::string result = res->ToString();
if (m_proc->send_result_metadata(thd)) DBUG_VOID_RETURN;
protocol->start_row();
protocol->store_string(result.c_str(), result.length(), system_charset_info);
if (protocol->end_row()) DBUG_VOID_RETURN;
my_eof(thd);
DBUG_VOID_RETURN;
}
} // namespace myduck