Problem with Guids in MySQL Loader
Posted: Thu 03 Oct 2019 02:23
I have a MariaDB 10.3.14 table with a BINARY column into which a GUID is stored. I found that when I bulk loaded data into the table using MySqlLoader that I would get generated SQL syntax errors on some records but not others.
To look into this, I enabled logging in MariaDB and noticed that the INSERT statements were including the binary data directly into the INSERT statement, which of course caused syntax errors.
When I added a custom mapper and excluded the binary column, the tables loaded without error.
Shouldn't MySqlLoader encode binary literals -- perhaps as HEX?
Thanks
To look into this, I enabled logging in MariaDB and noticed that the INSERT statements were including the binary data directly into the INSERT statement, which of course caused syntax errors.
When I added a custom mapper and excluded the binary column, the tables loaded without error.
Shouldn't MySqlLoader encode binary literals -- perhaps as HEX?
Thanks