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

3 comments:

Reuben said...

Ahah. Awesome...
But is it good apart from that? We used to use MysqlQueryBrowser or whatever at work,.. it was okay. I think I had a few problems but can't remember quite.

hok

Anonymous said...

Now ...

why don't you go to the webyog forums at
http://www.webyog.com/forums
with comments or questions?

I am not able fully to understand you. You also do not tell what SQLyog version you are using.

recent versions (since 5.1) do distinguish between NULL and the string 'NULL". Please refer to:

http://www.webyog.com/faq/8_99_en.html

Please visit our Foums if this did not sort out things!


Regards

Peter Laursen
Webyog

Dan said...

Why not the forums?
I don't like to register - it's so annoying. Also, I don't need help; because this is a bug; and it's made me cranky.

Bug + registration = extreme unhappyness level; and bile doesn't tend to get things fixed.