Bug In Showing The Records In Good Sequence

[jan marco alkema]

I have a table of 648000 records.

If I show the records with Open table (F12) and I use the mouse to scroll the records in the “right arrow down field=most right in the output window” to the bottom records. I see when I use the mouse:

Records in the output screen:

Id, postalcode

48, 1000ba

49, 1000ba

50, 1000bb

.

.

65509, 1617vr

65510, 1617vr

65511 1617vs

48, 1000ba

49, 1000ba

50, 1000bb

The Bug is that if there are more than (65535?, 16 bits?) records in the table. The first records seems to be put on output again, and not record id 65535,65536,65537,…

The bug does not appears when I use the or key for scrolling the records.

[peterlaursen]

We reproduced some/almost same problem if we show more than 65563 (not 65535) rows in a specific table.  

We are now trying to identify exactly what the problem is. I guess (only) that it is not related to 2^16/16bit integer resolution. Rather some internal pointer issue.

However we can only reproduce with the scrollbar – not the arrow-down icon below the scrollbar.

[navyashree.r]

Issue added here in our track system,

http://code.google.com/p/sqlyog/issues/detail?id=1234

Quote:

If I show the records with Open table (F12)

We use F11 to 'Open table' and not F12 which is used to Format SQL queries.

We are looking into this issue. Thanks for reporting.

Regards

Navya

[nithin]

Hello,

We are providing you a special build with this issue got fixed.

Your assumptions were correct that the scroll bar were able to handle 16 bits values only.

It was documented this:

“Note that the WM_VSCROLL message carries only 16 bits of scroll box position data. Thus, applications that rely solely on WM_VSCROLL (and WM_HSCROLL) for scroll position data have a practical maximum position value of 65,535.”

The fix is that now it can be processed 32 bit values, so your issue would be solved.

Please download, try it in your environment and lets know the status, so that we can include this fix into next public release

http://www.webyog.com/downloads/betas/not_released/SQLyog822.2Trial.exe

Thank you

Nithin

[navyashree.r]

Hi,

We have released SQLyog 8.22 with this fix, which is available publicly!

Please refer to:

http://www.webyog.com/blog/2010/01/29/sqlyog-mysql-gui-8-22-has-been-released/

Please verify whether this issue is fixed and update us the status.

Thank you.

Regards,

Navya

[jan marco alkema]

Hello Navya,

I test http://www.webyog.com/downloads/SQLyog822Trial.exe on Vista en the latest svn release on XP.

I don't seen the bug any more. Thank you, for solving it –)

Jan Marco

[Author]

Posts