Error 3144: Cannot create a JSON value from a string with CHARACTER SET binary #86
Comments
|
Example value in the json type column that causes this: {"count": {"type": "other", "value": 1}} |
shuhaowu
added a commit
to shuhaowu/ghostferry
that referenced
this issue
Feb 16, 2019
JSON column was previously being recognized as a []byte array. This
causes the query generated to be something like `_binary'{"data": 1}'`.
However, JSON data are not binary, thus we get errors such as:
Error 3144: Cannot create a JSON value from a string with CHARACTER SET
binary error.
Fixing this requires us to pass the column types into the methods
actually escaping the values, as we cannot infer that something is a
JSON type from the Go type alone.
To do this the most generic way, I just pass down the table columns all
the way (in case we need something else from it in the future).
Fixes Shopify#86.
shuhaowu
added a commit
to shuhaowu/ghostferry
that referenced
this issue
Feb 16, 2019
JSON column was previously being recognized as a []byte array. This
causes the query generated to be something like `_binary'{"data": 1}'`.
However, JSON data are not binary, thus we get errors such as:
Error 3144: Cannot create a JSON value from a string with CHARACTER SET
binary error.
Fixing this requires us to pass the column types into the methods
actually escaping the values, as we cannot infer that something is a
JSON type from the Go type alone.
To do this the most generic way, I just pass down the table columns all
the way (in case we need something else from it in the future).
Fixes Shopify#86.
shuhaowu
added a commit
to shuhaowu/ghostferry
that referenced
this issue
Feb 19, 2019
JSON column was previously being recognized as a []byte array. This
causes the query generated to be something like `_binary'{"data": 1}'`.
However, JSON data are not binary, thus we get errors such as:
Error 3144: Cannot create a JSON value from a string with CHARACTER SET
binary error.
Fixing this requires us to pass the column types into the methods
actually escaping the values, as we cannot infer that something is a
JSON type from the Go type alone.
To do this the most generic way, I just pass down the table columns all
the way (in case we need something else from it in the future).
Fixes Shopify#86.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Moving a shop failed with
The text was updated successfully, but these errors were encountered: