Tuesday, February 27, 2007

SQLyog annoyances.

  1. Do a query like "SELECT a.id, a.name, a.* FROM a"
  2. Swap from read only to edit mode
  3. Go through and set the a.name to NULL
  4. Move to the next row
Expected:
SQLyog does an update statement - UPDATE a SET name = NULL WHERE a.id = ?

Actual:
SQLyog does an update statement - UPDATE a SET id = ?, name = NULL, id=?, name="fish" WHERE a.id = ?


  1. Do a query like "SELECT a.id, a.name, a.* FROM a"
  2. Swap to edit mode
  3. Highlight a.id (so the cell has focus and is selected)
  4. Set a.name to NULL
Expected:
a.name becomes NULL
Actual:
a.name becomes the highlighted value

See this bug and that bug
Post a Comment