ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: 'NULL'

[antongorodezkiy]

Hello friends,

I got the following error when trying set timestamp column (it's allows NULL) to NULL.

Potentially unhandled rejection [1] Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: 'NULL' for column 'added_to_queue_at' at row 1

When trying to call the following code:

model.added_to_queue_at = null;
model.save();

The following code isn't work either:

model.added_to_queue_at = undefined;
model.save();

Schema:

let Word = Schema.define('Word', {
  id:                { type: Number },
  added_to_queue_at: { type: Date, dataType: 'timestamp', allowNull: true, null: true, default: () => { return null;} }
}, {
  table: 'word'
});

In the current version of node-mysql it works fine with undefined:

connection.query('UPDATE `words` SET `added_to_queue_at` = ? WHERE id = ?', [
  undefined,
  18
], function(err, results) {
  console.error(err);
  console.log(results);
});

[antongorodezkiy]

For now I'm using the following workaround:

Word.update({
  where: {
    id: word.id
  },
  update: {
    added_to_queue_at: undefined
  }
});