Re: [pgsql-advocacy] MySQLs' "FOREIGN KEYS¨

Rajesh Kumar Mallah wrote:

>
> MySQL does not thinks 0 to be a valid integer data .
> Although 0 is not present in master table
> it allows inserting in a referencing table
> as though 0 == NULL . This is really funny (dangerous)

What does it do if you have a NOT NULL constraint on the FK column and
insert 0?

Jan

>
>
> mysql> alter table slave add foreign key (id2) references master(id);
> Query OK, 6 rows affected (0.00 sec)
> Records: 6 Duplicates: 0 Warnings: 0
>
>
> mysql> select * from master;
> Empty set (0.00 sec)
>
> mysql>
>
>
> mysql> select * from slave;
> +------+
> | id2 |
> +------+
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> +------+
> 6 rows in set (0.00 sec)

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #