Spreadsheet / Table Control Copies Information Wrongly

[doconnor]

5.21

See http://clockwerx.blogspot.com/2007/02/sqlyog-annoyances.html

1. Do a query like “SELECT a.id, a.name, a.* FROM a”

2. Swap to edit mode on the table control

3. Highlight a.id (so the cell has focus and is selected)

4. Set a.name to NULL

Expected:

a.name becomes NULL, because that's what you just told it to do with a right click menu option

Actual:

a.name becomes the highlighted value – this is unexpected and wrong behaviour

SQL

[attachment=603:bug_01.PNG]

Resultset

[attachment=604:bug_02.PNG]

Highlight a field

[attachment=605:bug_03.PNG]

Then right click on another

[attachment=606:bug_04.PNG]

Set to NULL – data not saved, all looks good

[attachment=607:bug_05.PNG]

Move to another cell. Data saved. A 3 has come from nowhere.

[attachment=608:bug_06.PNG]

[peterlaursen]

a 3 has not come from nowhere. It came from the later (most rightly) of the two colums showing the same value.

A simpler example

CREATE TABLE `aaa` (

`a` int(10) default NULL,

`b` varchar(20) default NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

and now insert a few rows (1,a),(2,:cool:,(c,3)

and “select aaa.a, aaa.* from aaa;”

set the FIRST aaa.a column in the grid to NULL won't help. You will have to either use a query where the same row is only displayed once or edit the LAST of the aaa.a columns.

Did I understand everything correct?

[peterlaursen]

sorry for the smiley .. it should have been a 'b' and not 😎

[doconnor]

Please re-read the bug description, and in particular look at the last two images to see why is this an unexpected behaviour – the interface shows me one thing one moment, an iteraction I have with it changes the values to something I did not set the next.

[peterlaursen]

Please confirm if my test case is a description of the problem??

the same column is selected twice, right?

If not so then please explain more in details!

[peterlaursen]

OK we discussed!

Please confirm that this is the issue!

create table `aaa` (

`a` double ,

`b` varchar (20));

insert into `aaa` (`a`, `b`) values('1','ada');

insert into `aaa` (`a`, `b`) values('2','dad');

insert into `aaa` (`a`, `b`) values('3','pel');

1) higlight the '1' in 1st column and first row of the grid.

2) right-click on the 2nd column of 1st row of the grid (showing 'ada') and SET to NULL.

3) save by pressing 'arrow down' or save button.

SQLyog sends the SQL (refer to HISTORY):

“UPDATE `aaa` SET `a`='1',`b`='1' WHERE `a`='1' AND `b`='ada'”

and the cell that displayed 'ada before displas '1' and not '(NULL)'

Was that it? Correctly understood this time?

This is a bug, sure!

Your example displaying the same row more than once confused me.

Please also create a simple and complete test case (with CREATE statement(s) and data) like this when you report an issue.

Chances that everybody understands 'in first shot' is bigger then.

[Author]

Posts