Fix mysql sink error when inserted value is null
Open
- Dominant language
- Java
- Stars
- 808
- Forks
- 188
- Avg merge
- 3d 22h
- Merged PRs (30d)
- 2
Description
1. map null value to `null` but not `'null'` when generating sql.
2. optimize insert sql template from `INSERT INTO %s VALUES(%s)` to `INSERT INTO %s (%s) VALUES(%s)` to avoid enumerating all table columns.
3. [additional] remove tolowcase when checkFields method.
Contributor guide
Research direction
Start by locating the MySQL sink's SQL-generation and checkFields code; inspect how null values and columns are rendered. Verify that generated SQL uses SQL NULL rather than a quoted value, includes an explicit column list, and applies the requested case-handling change.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql, sql
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100