This is an automated email from the ASF dual-hosted git repository.

kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git

commit 0059417a6d9c78078a5706b178a002eade9c0706
Author: zy-kkk <[email protected]>
AuthorDate: Tue Aug 29 21:47:50 2023 +0800

    [fix](odbc) fix odbc insert string data to sqlserve (#23364)
---
 be/src/exec/table_connector.cpp | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/be/src/exec/table_connector.cpp b/be/src/exec/table_connector.cpp
index 9eb1fface1..92bb774bde 100644
--- a/be/src/exec/table_connector.cpp
+++ b/be/src/exec/table_connector.cpp
@@ -251,7 +251,8 @@ Status TableConnector::convert_column_data(const 
vectorized::ColumnPtr& column_p
     case TYPE_STRING: {
         // for oracle/pg database string must be '
         if (table_type == TOdbcTableType::ORACLE || table_type == 
TOdbcTableType::POSTGRESQL ||
-            table_type == TOdbcTableType::SAP_HANA) {
+            table_type == TOdbcTableType::SAP_HANA || table_type == 
TOdbcTableType::MYSQL ||
+            table_type == TOdbcTableType::CLICKHOUSE || table_type == 
TOdbcTableType::SQLSERVER) {
             fmt::format_to(_insert_stmt_buffer, "'{}'", 
fmt::basic_string_view(item, size));
         } else {
             fmt::format_to(_insert_stmt_buffer, "\"{}\"", 
fmt::basic_string_view(item, size));


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to