#7778: sqldump -- doesn't handle bit fields correctly (mysql)

SachinPrakash reported 2012-10-11T23:05:14Z · last modified 2012-10-15T21:08:45Z

sqldump -- doesn't handle bit fields correctly (mysql)

Dev	NielsGron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	App - FluidShell - Command
Version	12.0

In mysql DB, I have a bit field such as:

activity_type bit(31)

When I run sqldump, the insert stmts that are generated look like the below:

INSERT INTO activities(activity_id, description, visibility, object_id, creator_id, created_date, like_count, link, comment_count, activity_type)

VALUES('0A57E9BF-8719-D65D-A60B-D42CE0D651B7', NULL, 0, '7B8DD850-C255-5888-D5C9-FC846C3A3911', '7E903ACC-77CC-AEB4-EA62-9AC4B13EF0E2', '2012-02-21 01:35:33.0', 0, NULL, 0, 0000a404)

Notice the value in green. It's a hex value & for MySQL, it should be x'0000a404'

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

sqldump -- doesn't handle bit fields correctly (mysql)

Issue #7778

Completion

Search Tips

Aqua Data Studio / nhilam

Title

sqldump -- doesn't handle bit fields correctly (mysql)

Issue #7778

Completion