MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lucascomparin
Posts: 2
Joined: Fri 19 Feb 2016 14:01

MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Post by lucascomparin » Fri 19 Feb 2016 14:27

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Post by ViktorV » Mon 22 Feb 2016 14:14

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.

lucascomparin
Posts: 2
Joined: Fri 19 Feb 2016 14:01

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Post by lucascomparin » Tue 10 May 2016 10:09

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MYSQL - SHOW ENGINE INNODB STATUS TRUNCATED

Post by ViktorV » Wed 11 May 2016 14:08

We will try to avoid this behavior of MySQL server in the next version of MyDAC.

Post Reply