mysql默认支持触发器,MySQL触发器不知道默认值

I use this trigger

delimiter ||

create TRIGGER column_a_to_default

BEFORE INSERT ON `property`

FOR EACH ROW

BEGIN

IF NEW.primary_image = '' THEN

SET NEW.primary_image = default(NEW.primary_image);

END IF;

END;

||

delimiter ;

If I insert into the table the trigger throws an error:

Field 'primary_image' doesn't have a default value.

But it does!

What is wrong here? It seems like the trigger isn't aware of default values!

EDIT

Table Create script

CREATE TABLE IF NOT EXISTS `property` (

`id` varchar(10) NOT NULL,

`images` text NOT NULL,

`primary_image` varchar(100) NOT NULL DEFAULT '../no-image.png',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

解决方案

Doesn't default(property.primary_image) work?

(Getting the default of the Real table, not the NEW holding-table)