Calculate Optimal Datatypes Error

[Tim East]

With SQLyog Ultimate 8.2 (also in beta phase) the Calculate Optimal Datatypes is producing a dump and an exit from the program. I'm working on Windows XP (up to date) and I attach the dump. Similar dumps were produced by the beta version of 8.2.

I hope this may be of use.

All the best and congratulations on the product.

Tim

[peterlaursen]

Can you please attach such dump (zip please) ?  We have not encountered this problem.

[Mahesh]

As you have posted this topic in wrong product category, I have moved this topic in SQLyog's “Bugs and Features” section.

[Mahesh]

Also if you can give certain information mentioned below along with dump file will be helpful.

1) Whether program crashes with particular table while performing “Calculate Optimal Datatypes” ? If so execute the SQL queries mentioned below and paste the output:

i) SELECT COUNT(*) FROM `table_name`;

ii) SELECT * FROM `table_name` PROCEDURE ANALYSE(1, 10);

2) MySQL server version you are using?

3) Connection method used (Direct/HTTP/SSH)?

[Tim East]

Sorry, I thought I had attached the dump[attachment=1297:SQLyog.zip], but first time mistakes.

It doesn't depend on the table but seems to depend on size (the select count is 1815) but more on clicking in the html area or on the start/stop button. The calculation is made and returned but subsequent click crashes SQLyog.

Answer to ii)

Field_name;Min_value;Max_value;Min_length;Max_length;Empties_or_zeros;Nulls;Avg_value_or_avg_length;Std;Optimal_fieldtype

records.rec_art.art_no;10;ZOR0577;1;7;0;0;5.9383;N;VARCHAR(7) NOT NULL

records.rec_art.artist;29TH ST SAX QUARTET;ZORN JOHN;3;23;0;0;14.0193;N;VARCHAR(23) NOT NULL

MySQL server version – 5.1.30-community-log via TCP/IP

Connection method – Direct on localhost

Please ask for further data if necessary.

All the best

Tim

---

[ quote name='Mahesh' date='09 December 2009 – 06:25 AM' timestamp='1260336343' post='21534']

Also if you can give certain information mentioned below along with dump file will be helpful.

1) Whether program crashes with particular table while performing “Calculate Optimal Datatypes” ? If so execute the SQL queries mentioned below and paste the output:

i) SELECT COUNT(*) FROM `table_name`;

ii) SELECT * FROM `table_name` PROCEDURE ANALYSE(1, 10);

2) MySQL server version you are using?

3) Connection method used (Direct/HTTP/SSH)?

[/quote]

[nithin]

Hello,

We tried the case as you suggested(“subsequent click”) but not reproducible to us. I checked the code and found an issue at the same place where your crash dumps are pointing. So I fixed that and providing you a special binary. Can you download it and verify the fix with your environment and let's know the status?

http://webyog.com/downloads/betas/not_released/SQLyog821.1.exe

Thanks

Nithin

[Tim East]

I have done as requested and, my compliments, I can't crash it in my environment. As a result your patch does good work.

All the best

Tim

---

'nithin' wrote on '10:

Hello,

We tried the case as you suggested(“subsequent click”) but not reproducible to us. I checked the code and found an issue at the same place where your crash dumps are pointing. So I fixed that and providing you a special binary. Can you download it and verify the fix with your environment and let's know the status?

http://webyog.com/downloads/betas/not_released/SQLyog821.1.exe

Thanks

Nithin

[Khushboo]

Hi,

This fix is available publicly in SQLyog 8.21 Beta1.

Please refer to:

http://www.webyog.com/blog/2009/12/18/sqlyog-mysql-gui-8-21-beta-1-has-been-released/

Thank you.

Regards,

Khushboo

[Author]

Posts