apache/seatunnel

[Feature][MySQL] Regarding the data processing of bit(1), it is hoped that a configuration item will be added to determine whether to convert it to a boolean value or an int.

Open

#9875 opened on Sep 18, 2025

View on GitHub
 (6 comments) (0 reactions) (1 assignee)Java (6,897 stars) (1,432 forks)batch import
help wanted

Description

Search before asking

  • I had searched in the feature and found no similar feature requirement.

Description

Currently, in practical scenarios, there are cases where it is necessary to convert bit(1) data in MySQL to int. However, in the latest version 2.3.12, this data type can only be converted to boolean by default, which causes errors when writing data to the target database. Therefore, it is necessary to add a configuration item to determine whether to convert the data to int or boolean.

Now I have modified the source code, and only adjusted it to int to meet my own needs.

Usage Scenario

To address various data processing scenarios

Related issues

No response

Are you willing to submit a PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Contributor guide

Tech stack
java
Domain
backenddatadatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Java programmingMySQL basicsSeaTunnel connector development
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70
Research direction
The bit(1) conversion logic is likely in the MySQL dialect or JDBC connector source code under 'seatunnel connectors v2/connector jdbc'. Examine the existing converter for BIT type to understand where the boolean conversion happens. Then add a new configuration property (e.g., 'bit mode') to toggle between boolean and integer conversion. Review existing connector configuration patterns in the same module for consistency.