Inconsistent Behaviour When Editing Blob Field

[larsen]

Steps to reproduce:

– Have a blob field that is set to NULL

– Open register tab “Table Data”

– Use the cursor keys to navigate to the blob field (it should read “(NULL)”)

– Press Space

–> The checkbox “Set Null” is not checked

– Click on “ok”

–> The field still reads “(NULL)” but should be empty instead

– Now, use the mouse to click on the blob field

–> The checkbox is checked

Version is 9.10

Cheers

Lars

[peterlaursen]

This is not a bug. It is per design and in order to make it possible for user to insert into the BLOB-editor without using the mouse. A favour we did users that prefer not to use mouse.

SQLyog 8.05 release notes:

“In DATA and RESULT tab you can now open the BLOB VIEWER for BLOB and TEXT types with any keyboard keystroke (like SPACEBAR). The ‘NOT NULL’ checkbox will then automatically uncheck (if checked) and BLOB VIEWER window is ready for input from the keyboard without any mouse action”

[Author]

Posts