However, I believe that the trigger should return an error to the client. INSERT INTO RawData (LineItemID, PreState,CtimeIn,CtimeOut,PostState,Name,Value) VALUES (NULL, '1','1131405338.64','1131405338.6416','','Enter','11')Īs a application developer, this problem can be fixed by correcting the trigger to be The second should demonstrate the problem.

Instead, I believe that this trigger should error out under such a condition and return an error to the client.Ĭreate the tables listed in description. When the row contains a null value, FieldNameValues becomes null itself. However, The trigger has some abnormal behavior when we insert a row into RawData that contains a null value. Also, the syntax is documented as GROUPCONCAT(DISTINCT expr), not GROUPCONCAT(DISTINCT(expr)), though the extra parentheses might just be ignored, as they don't really modify expr. Note: In CockroachDB v20.2 and earlier, for all values other than STRING . If you are using a really sad library to connect to MySQL, you may need to give the column an alias (. Normally, when you insert a row into rawData, you get a trigger that inserts a row into ReplicationLog with a fieldNamevalues looking something like this Concatenation between a non- NULL value and a NULL value results in a NULL value. Take this into account when you concatenate string literals with column values that may contain NULL: SELECT CONCAT ('AB', NULL, 'EF') - Result: NULL.

In addition, I have the following trigger that occurs after RawData inserts: TableName varchar(64) NOT NULL default '', PostState varchar(100) NOT NULL default '', PreState varchar(100) NOT NULL default '', LineItemID int(10) unsigned default NULL,ĬtimeIn varchar(100) NOT NULL default '',ĬtimeOut varchar(100) NOT NULL default '', ID int(10) unsigned NOT NULL auto_increment,

Mysql concat fails on null