Forums » General Discussion

Thread: Two bugs in Synchronization Wizard, I think


Permlink Replies: 1 - Pages: 1 - Last Post: Oct 29, 2010 11:06 AM by: Mike The KID Threads: [ Previous | Next ]
MBarrett

Posts: 1
Registered: 10/24/10
Two bugs in Synchronization Wizard, I think
Posted: Oct 24, 2010 7:04 AM
  Click to reply to this thread Reply

I've seen two odd things in the output of the Sychronization Wizard:

1.  Any field defined as 'bit(1) not null default false' comes out with a '<ascii 0>' default, rather than 'false'; meaning there's an actual zero-value character inside the quotes, which causes most text editors to refuse to deal with it.

2.  The names of referenced tables in foreign-key reference always come out lowercase, whatever the table's case is in the schema.  In a MySQL configuration that cares about case this is obviously a problem.




Mike The KID


Posts: 14
Registered: 6/11/10
Re: Two bugs in Synchronization Wizard, I think
Posted: Oct 29, 2010 11:06 AM   in response to: MBarrett
  Click to reply to this thread Reply

I'd like to ditto these bugs. It's really annoying when doing a schema compare to edit the sql to remove default for BIT(1) from 'b'0'' to 0 or false



Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums