diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-11-14 22:51:54 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-12-21 21:30:54 +0100 |
| commit | 0686c34d22a5cbf93015012eaf77a4a977b63afb (patch) | |
| tree | 3c95207d5e01a905f9e87820e6439fe6c6547653 /mysql-test/r/trigger.result | |
| parent | ad5db17e882fea36dcae6f6e61996b5f9bf28962 (diff) | |
| download | mariadb-git-0686c34d22a5cbf93015012eaf77a4a977b63afb.tar.gz | |
MDEV-8605 MariaDB not use DEFAULT value even when inserted NULL for NOT NULLABLE column
NOT NULL constraint must be checked *after* the BEFORE triggers.
That is for INSERT and UPDATE statements even NOT NULL fields
must be able to store a NULL temporarily at least while
BEFORE INSERT/UPDATE triggers are running.
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index c1780819c68..86219875bed 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -214,12 +214,14 @@ end if; end| insert into t3 values (1); insert into t1 values (4, "four", 1), (5, "five", 2); -ERROR 23000: Column 'id' cannot be null +Warnings: +Warning 1048 Column 'id' cannot be null select * from t1; id data fk 1 one NULL 2 two NULL 4 four 1 +0 five 2 select * from t2; event INSERT INTO t1 id=1 data='one' |