> MySQL, correctly, says the default is NULL:
i was say erroneously, not correctly.
if you try this:
insert into bars set id=1 ;
select * from bars ;
you will see that the foo column is '', not NULL, suggesting the
default really is ''.
On Feb 21, 2007, at 11:44 AM, Ask Bjørn Hansen wrote:
>
> On Feb 21, 2007, at 10:00, John Siracusa wrote:
>
>> I'm going to release 0.761 shortly. If you have any outstanding bugs
>> not fixed in SVN or any other small suggestions, speak now...
>
> Maybe this is something, once again, that I am doing wrong - but I
> don't understand this:
>
> mysql 5.0.27 and DBD::mysql 3.0008:
>
> create table bars (id int unsigned not null primary key, foo varchar
> (255) not null) engine = InnoDB;
>
> gets me (with the auto loader):
>
> __PACKAGE__->meta->setup(
> table => 'bars',
>
> columns => [
> id => { type => 'integer', not_null => 1 },
> foo => { type => 'varchar', default => '', length => 255,
> not_null => 1 },
> ],
>
> primary_key_columns => [ 'id' ],
> );
>
> Note the "" default to "foo".
>
>
> mysql> show create table bars\G
> *************************** 1. row ***************************
> Table: bars
> Create Table: CREATE TABLE `bars` (
> `id` int(10) unsigned NOT NULL,
> `foo` varchar(255) NOT NULL,
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
>
> mysql> select * from information_schema.columns where table_schema =
> 'ntppool' and table_name = 'bars' and column_name = 'foo' \G
> *************************** 1. row ***************************
> TABLE_CATALOG: NULL
> TABLE_SCHEMA: ntppool
> TABLE_NAME: bars
> COLUMN_NAME: foo
> ORDINAL_POSITION: 2
> COLUMN_DEFAULT: NULL
> IS_NULLABLE: NO
> DATA_TYPE: varchar
> CHARACTER_MAXIMUM_LENGTH: 255
> CHARACTER_OCTET_LENGTH: 255
> NUMERIC_PRECISION: NULL
> NUMERIC_SCALE: NULL
> CHARACTER_SET_NAME: latin1
> COLLATION_NAME: latin1_swedish_ci
> COLUMN_TYPE: varchar(255)
> COLUMN_KEY:
> EXTRA:
> PRIVILEGES: select,insert,update,references
> COLUMN_COMMENT:
> 1 row in set (0.03 sec)
>
>
> - ask
>
> --
> http://develooper.com/ - http://askask.com/
>
>
>
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Rose-db-object mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/rose-db-object
---
michael reece :: software engineer :: [EMAIL PROTECTED]
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
