Exporting Data From Sqlyog On Vista

[McKenna]

I am having a problem with SQLyog on Vista. I have tried both the latest Community Edition Beta and the latest stable Community Edition (v5.29), both of which seem to exhibit the same strange behaviour. The problem occurred when I was selecting a single field from my database and using CONCAT to append a large string to the end of it. It seems that once horizontal scrolling is required to view a single field (it seems to be ok if more than one field is selected), the area where the results are displayed begins to flicker.

That in itself didn't seem to be a problem, but once I clicked on the results and chose 'Export As…', the pop up window didn't appear. I hit the alt key and it then appeared. Clicking the 'Change' button caused the program to freeze as did specifying an invalid location for Export and clicking the export button. When I specified a valid export location and hit export, SQLyog began to export the rows. In total I had just over 31,000 rows selected and when I checked on SQLyog, it had exported over 41,000 rows so I quit the program via Windows Task Manager. I inspected what it had exported and it seemed to have just exported the first two rows over and over.

I hope that I have explained that clearly enough, but if you need any more info from me just ask and I'll try and provide a better explanation.

[McKenna]

I just thought I'd add a sample SQL statement that causes this behaviour for me:

Code:

SELECT CONCAT('Hello', ', this is a really long string that is being added via concat to some other field to make SQLyog scroll and to demonstrate a possible bug. Once you select this string in SQLyog you should see some flickering in the Results viewpane')

If you execute the statement above in SQLyog you should see the behaviour described above.

[peterlaursen]

flickering issue confirmed.

the SELECT statement makes the data area flicker, and on my system CPU goes abot 50 % even when there is no activity!

[peterlaursen]

I am moving the post to the SQLyog category (you posted in MONyog category!)

[McKenna]

peterlaursen wrote on Apr 27 2007, 01:02 PM:

I am moving the post to the SQLyog category (you posted in MONyog category!)

Whoops, I obviously wasn't paying attention 😕

[Author]

Posts