[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

[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]

[Author]

Posts