Zero and NULL MariaDB

12 views
Skip to first unread message

Pablo

unread,
Jul 11, 2019, 5:02:27 PM7/11/19
to doctri...@googlegroups.com
Hello everyone, we are migrating from server and we were forced to use MariaDB, our application uses DBAL and I came across the following problem:

An exception occurred while executing \'\\INSERT \\INTO fnc_conta (fnc_lancamento_cod, fnc_parcela_cod, fnc_conta_contabil_cod, fnc_conta_valor, fnc_conta_tipo, fnc_conta_selecao, fnc_conta_multiplicador, organogramaCod) VALUES(?, ?, ?, ?, ?, ?, ?, ?)\' with params [\"283979\", \"301932\", \"13\", 0, \"C\", \"Automatica\", null, \"4\"]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column \'fnc_conta_valor\' cannot be null


The column "fnc_conta_valor" is of type "decimal" with standard zero and not null

Is there any incompatibility between maria and dbAL, or any settings I should make to make it work?

I emphasize that using Mysql or INSERT work normally.

--
Pablo Vanni
(65) 9-9998-8480
Reply all
Reply to author
Forward
0 new messages