4paradigm / 4paradigm/OpenMLDB
During online export (SELECT INTO), when quote='#', # in the string will not be escaped
- 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
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