yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
main
doc-exports/docs/dataartsstudio/umn/dataartsstudio_03_0341.html
chenxiaoxiong f9e2808b7c DataArts UMN 20250810 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
Co-committed-by: chenxiaoxiong <chenxiaoxiong@huawei.com>
2025-09-02 10:44:13 +00:00

4.3 KiB
Raw Permalink Blame History

What Should I Do If invalid input syntax for integer: "true" Is Displayed During MySQL Database Migration?

Symptom

The MySQL database stores values 0 and 1, rather than true and false. However, true or false is read during MySQL database migration, and the following error information is displayed: Unable to execute the SQL statement. Cause: ERROR: invalid input syntax for integer: "true" Where: COPY sd_mask_ext, line 1, column mask_type.

Possible Cause

By default, tinyInt1isBit is set to true for MySQL databases. As a result, TINYINT(1) is processed as BIT (that is, Types.BOOLEAN), and 1 or 0 is read as true or false.

Solution

In the advanced attributes of the MySQL link, add either of the following parameters so that tables can be properly created at the destination:

  • Parameter tinyInt1isBit, with its value set to false
  • Parameter mysql.bool.type.transform, with its value set to false
    Figure 1 Adding link attributes
<script language="JavaScript"> </script>