← Back to team overview

maria-discuss team mailing list archive

Re: Reading a field's default value from a trigger


>From: maria-discuss-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx
[mailto:maria-discuss-bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx] On
Behalf Of Bruce Kirkpatrick
>Sent: Montag, 4. Februar 2013 20:32
>To: maria-discuss@xxxxxxxxxxxxxxxxxxx
>Subject: Re: [Maria-discuss] Reading a field's default value from a trigger

>For anyone encountering the "Field 'xxx' doesn't have a default value" when
running insert/update/replace statement on MariaDB, I found that this is
actually caused by the sql mode STRICT_TRANS_TABLES.  This also fixes when a
trigger updates the default value of the field.   I believe the default
options >for MariaDB windows installer cause this option to be enabled,
whereas I had previous never designed my application for the various modes

Hi Bruce,
sql_mode includes STRICT_TRANS_TABLES  is in MariaDB Windows installer,
since they are in MySQL Windows installer - in current 5.5 installer, and in
the past  ones as well.   One thing that changed in 5.5  (MySQL, and
MariaDB) as compared to earlier versions, is that default storage engine is
now transactional (Innodb/XtraDB).