Bug #8653

violation while inserting record

Details

Submitted	2006-09-07 13:41 UTC
From	pascal at tweakers dot net
Status	Wont fix
Package	MDB2
PHP Version	5.1.5
OS	FC4
Roadmaps	(Not assigned)

Comments

[2006-09-07 13:41 UTC] pascal at tweakers dot net

Description:
------------
When insert a empty value in a NOT NULL field with a DEFAULT value i'm getting a violation that the field does not accept empty values.

The normal way should be that the default value should be inserted :) I guess MDB2 is missing a check for a default value.

Example: field int(11) NOT NULL Default: 0

If inserted value is empty it should insert the 0.

Now, the record won't be inserted. Manually checked with phpmyadmin.