4paradigm / 4paradigm/OpenMLDB

During online export (SELECT INTO), when quote='#', # in the string will not be escaped

Open
#2,589 1 comment 0 reactions 1 assignee Claimed by @vagetablechicken View on GitHub
bug storage-engine
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Bug Description**
During online export, when quote='#', the # in the string will not be escaped, which will lead to inconsistency when the exported data is imported again

**Expected Behavior**
```
Original data:~!@$%^#&*()_+<
After export:#~!@$%^#&*()_+<#
Expected:#~!@$%^\#&*()_+<#
```
**Relation Case**
test_select_into_load_data.yaml id:0-1
**Steps to Reproduce**

1.
2.
3.
4.

Contributor guide

Open the contributing guide

Research direction

Look at the online export logic, likely in a file handling SELECT INTO with quote characters. The test case test_select_into_load_data.yaml id:0-1 is a starting point. Understand how escaping works when quote='#' and ensure # in string data is escaped. Verify by running the test after changes.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.