Show Results in Text Fails

[caves]

Hi,

When I use show results in text it only shows the first row of the resultset, but it only happens when the last column of the resultset is an integer or a decimal. If it is a char, varchar, datetime, NULL works perfectly.

I'm using v4.01

This is an example:

CREATE TABLE `bdays` (

`name` varchar(15) NOT NULL default '',

`birthday` datetime default NOT NULL,

`age` int(3) default NOT NULL,

) TYPE=MyISAM

WORKS => select name, birthday from bdays

FAILS => select name, birthday, age from bdays

Thanks

[Ritesh]

We are proud to announce the release of SQLyog v4.02 BETA.

This release fixes the above bug.

You can download SQLyog v4.02 BETA from the following links:

Enterprise Edition: http://www.webyog.com/sqlyog/SQLyog402Ent.exe

FREE Edition: http://www.webyog.com/sqlyog/SQLyog402.exe

Can you confirm the bug-fix?

[Author]

Posts