Crash After Editing Column Of Type Set

[jexxer]

First, i want to apologise if this has already been postet. The forum search gives me an error when searching for 'set'.

SQLyog Free 4.2RC2 crashes if i edit a value of the type 'set'. I can open the dropdown list that shows all available set-entries and i can select one entry of the list. in the moment when i click somewhere in another cell of the resulttable and the dropdown list closes SQLyog crashes with error:

Die Anweisung in “0x0042f3e5” verweist auf Speicher in “0x0000000c”. Der Vorgang “read” konnte nicht auf dem Speicher durchgeführt werden.

if you want me to run a debug version I'd be happy to help.

[peterlaursen]

it does not crash here, but it is not perfect either!

This table def. is used for the test

Code:

CREATE TABLE `tablename1` (                
             `id` bigint(20) NOT NULL auto_increment,  
             `t1` varchar(40) default NULL,            
             `s1` set('a','b','c') default 'a',        
             `s2` set('1','2','3') default NULL,      
             `e1` enum('red','blue') default NULL,    
             PRIMARY KEY  (`id`)                      
           ) ENGINE=MyISAM DEFAULT CHARSET=latin1  

1) first a cosmetic

pic2 shows that it displays only “ ( ” where it should display ” (NULL) “

2) and a more serious issue.

pic1 shows some garbage! There should be only two rows, and the 'a' on the last line should be in second row. A CSV-export drops

Code:

“1”,”t\t”,”a”,”2″,”blue”
“2”,””,\N,”1,2″,”red”

.. so the last 'a' does not seem to be in the database at all? I can shut down SQLyog and restart it and data are still displayed like in pic1. How could SQLyog enter dataa into a row without the PK-field having assigned a value?

and BTW: actually I have seen that before with some 4.2 release that some data from some rows get stored or displayed (?) wrong.

[peterlaursen]

@jexxer

BTW – a mysql full-text index only indexes character sequences of 4 or more characters! If it should go lower the index would take more space than the data!

[Ritesh]

jexxer wrote on Nov 2 2005, 02:53 PM:

First, i want to apologise if this has already been postet. The forum search gives me an error when searching for 'set'.

SQLyog Free 4.2RC2 crashes if i edit a value of the type 'set'. I can open the dropdown list that shows all available set-entries and i can select one entry of the list. in the moment when i click somewhere in another cell of the resulttable and the dropdown list closes SQLyog crashes with error:

Die Anweisung in “0x0042f3e5” verweist auf Speicher in “0x0000000c”. Der Vorgang “read” konnte nicht auf dem Speicher durchgeführt werden.

if you want me to run a debug version I'd be happy to help.

[post=”7794″]<{POST_SNAPBACK}>[/post]

Bug confirmed. This will be fixed in v4.2 FINAL.

This bug was introduced in v4.2 BETA 5. Thanks a lot. It will be our pleasure to give you a complimentary license of SQLyog Enterprise for all the trouble you have taken to report the bug.

Please send in registration name etc. to [email protected].

[Ritesh]

Quote:

so the last 'a' does not seem to be in the database at all? I can shut down SQLyog and restart it and data are still displayed like in pic1. How could SQLyog enter dataa into a row without the PK-field having assigned a value?

This is the correct behavior. * on the left hand of the row indicates that this is a new row and has not been inserted. The value a as shown in the screenshot is the default value for the column 😀

[jexxer]

WOW 😀

Thank you very much for this generous offer.

This is a huge surprise and i can't express how happy i am. Because I'm a Student and do not earn a lot with my little jobs this offer is a really big gift to me.

Again. Thank you very much Ritesh.

[Author]

Posts