Hello,

I have three databases 3.23.54 (production) & 4.0.18
and 4.1.3 as test servers.

I execute the following sqls:

>>>>>>>>>>>
create database testdb;

use testdb;

CREATE TABLE `test` (                                 
                      
        `example_col` varchar(100) default NULL       
                            
      ) TYPE=MyISAM;

create table `test_copy` type=MyISAM select
`example_col` from `test` where 1 = 0;>>>>>>>>>>>>>>

In 3.23.54, the example_col of test_copy gets
converted to char(100) whereas it remains same in i.e.
varchar (which I want) in 4.0.18 and 4.1.1.

Is it a known issue or it was a bug with 3.23.54 that
has been solved?

Regards,
Karam



                
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to