syntax error at or near "unsigned" (checked previously closed issues)

[mdhornet90]

Tried running the basic command from mysql to postgresql docker run --rm --name pgloader dimitri/pgloader:latest pgloader "mysql://remote.database1.com" "postgresql://remote.database2.com"

Versions:

• Mac OS 3.6.2, compiled with SBCL 2.0.11 (Homebrew) - Where bug was found
• Docker image, v3.6.3~devel

2021-04-04T21:30:47.462000Z ERROR Database error 42601: syntax error at or near "unsigned"
QUERY: CREATE TABLE foo.bar 
(
  ....
  message_length       int unsigned not null,
  ...
);
2021-04-04T21:30:47.670000Z FATAL Failed to create the schema, see above.

Couldn't compile from sources on mac:

me@My-MacBook-Pro website % brew install --HEAD pgloader
==> Cloning https://github.com/dimitri/pgloader.git
Updating /Users/me/Library/Caches/Homebrew/pgloader--git
==> Checking out branch master
Already on 'master'
Your branch is up to date with 'origin/master'.
HEAD is now at 3047c9a Typo fix in MS SQL documentation (#1242)
==> Patching
Error: Failure while executing; `patch -g 0 -f -p1` exited with 1. Here's the output:
can't find file to patch at input line 3
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|--- a/local-projects/cl-csv/parser.lisp
|+++ b/local-projects/cl-csv/parser.lisp
--------------------------
No file to patch.  Skipping patch.
1 out of 1 hunk ignored

[SachaMPS]

just install it via brew install pgloader

[mdhornet90]

That's where the issue was first noticed.

[SachaMPS]

I had the same troubles with the "--HEAD" flag. Without it, it installed fine

[mdhornet90]

It's not an issue of installation. Without using the --HEAD flag I was on version 3.6.2, which is where the error originally presented. Then any attempts at remediation via compiling from sources (--HEAD) yields a separate error.

[johndanek]

Can confirm this is happening to me too. Not sure how to get around it, especially considering all the closed issues that say this should be fixed.

MySQL Ver 8.0.25 for macos10.15 on x86_64 (Homebrew) PostgreSQL 13.3 in docker from the postgres image pgloader version "3.6.2" compiled with SBCL 2.0.11

[jondkinney]

I'm unable to install with the --HEAD flag as well. And 3.6.2 has this same unsigned error for me. I ended up editing the mysql dump file to remove unsigned from those int columns, but having to do that manually is not an ideal solution.