Page 1 of 1

MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Posted: Fri 19 Feb 2016 14:27
by lucascomparin
Hi,

i'm using

UniDac 6.0.1
MySQL 5.1.54 - 64bit

If I execute "SHOW ENGINE INNODB STATUS" from a TUniQuery, the "status" field appears truncated at 10 characters.

Is there a work-around?

Thanks

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Posted: Mon 22 Feb 2016 14:14
by ViktorV
This MyDAC behaviour is absolutely correct. MyDAC sets TField.Size based on the value returned by MySQL server for each column. While executing "SHOW ENGINE INNODB STATUS" MySQL returns the Status field size equal to 10.

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Posted: Tue 10 May 2016 10:09
by lucascomparin
I understand that this behaviour is correct.

I'm asking if there is a work-around for "reading" the INNO DB STATUS..

If I ask it with several MySQL GUI I can read it correcly.

Thanks

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Posted: Wed 11 May 2016 14:08
by ViktorV
We will try to avoid this behavior of MySQL server in the next version of MyDAC.