byte-vector-to-hexstring don't strip leading "x" #1758

Activity

1. dimitri

   added a commit that references this issue on Jul 15, 2026

   fix(mysql): handle X-prefix in binary transforms; add binary-to-uuid …

   ...

   5ce3726
2. dimitri

   closed this as completedin #1761on Jul 15, 2026
3. dimitri commented on Jul 15, 2026

   

   dimitri

   on Jul 15, 2026

   Owner

   More actions

   PR #1761 adds two fixes for this:

   1. byte-vector-to-hexstring is fixed — it now strips the bare X prefix that MySQL binary columns produce, so the existing cast in the issue will work once the fix is in.

   2. New binary-to-uuid transform — produces the canonical hyphenated UUID format (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) directly, which is cleaner:

   CAST
     column users.uuid to uuid drop typemod using binary-to-uuid,

   Once the PR is merged, CI will automatically publish an updated pgloader.jar at:

   https://github.com/dimitri/pgloader/releases/download/v4-dev/pgloader.jar

   You can download and run it with:

   wget https://github.com/dimitri/pgloader/releases/download/v4-dev/pgloader.jar
   java -jar pgloader.jar your.load

   See install.rst for full installation details including the Java version requirement (17+).

   🚀React with 🚀1Reacted by Dmitry