distal-attribute
distal-attribute
distal-attribute
distal-attribute

Export with JSON field seems to be buggy

kisb posted 1 year ago in Import/Export

dear all,

Im exporting my database with JSON field, the result:

INSERT INTO * VALUES (**, 1, [138, 100, 800, 419]));

but shouldn't it be look alike:

INSERT INTO * VALUES (**, 1, '[138, 100, 800, 419]'));

? At least, importing the first one causes syntax error

enduro44 posted 10 months ago

We are useing Export feature a lot in our projects. And I can confirm, that exporting tables with json field results in INSERT INTO * VALUES (**, 1, [138, 100, 800, 419])); Which results in syntax error. With this bug export feature is useless.

enduro44 posted 10 months ago

I'm using HeigiSQL 9.3.0.5104

ansgar posted 10 months ago

Yes, confirmed.

ansgar posted 10 months ago

Should be fixed in r5106

enduro44 posted 10 months ago

Thank you. I can confirm that problem is fixed in r5106.

globalassignmenthelp posted 9 months ago

aaa

Please login to leave a reply, or register at first.