apache / apache/geaflow

Fix mysql sink error when inserted value is null

Open
#176 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.