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

Export with JSON field seems to be buggy

kisb posted 11 months 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 6 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 6 months ago

I'm using HeigiSQL 9.3.0.5104

ansgar posted 6 months ago

Yes, confirmed.

ansgar posted 6 months ago

Should be fixed in r5106

enduro44 posted 6 months ago

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

globalassignmenthelp posted 5 months ago

aaa

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