Bug: Cannot Update A Field With Text "default".

[Richard B]

I was just trying to update a field and wanted to put the word “Default” (without quotes). However it is just inserting a blank.

When I view the history I see this:

/*[2:02:53 p.m.][ 0 ms]*/ UPDATE `testdb`.`testtable` SET `title`='' WHERE `id`='1';

If I instead insert the text “Default ” (with the extra space and without quotes) then it works correctly and the history is shown below:

/*[2:04:19 p.m.][ 0 ms]*/ UPDATE `testdb`.`testtable` SET `title`='Default ' WHERE `id`='1';

I noticed this bug in an earlier version and have now update to 8.2 RC2 Community Edition but the problem still occurs.

I expect it is something due to the mysql keyword DEFAULT.

If I enter it manually into the query window: UPDATE `testdb`.`testtable` SET `title`='Default' WHERE `id`='1';

it updates correctly, so I am sure this is an SQLYog bug.

Thanks,

Richard

[Khushboo]

Hi Richard,

This is not a bug.

In Tools–>preferences–>others, there is a option called “smart keyword handling” if you enable that option even if you enter a string `default`, it will take default value of that column.

Uncheck that option and then try your case, it will work.

And also please refer this:

http://www.webyog.com/faq/8_99_en.html?highlight=smart%20keyword

Regards,

Khushboo

[Author]

Posts