Datagrip generates a quoted 'NULL' - which is treated as text in mysql
For example, adding a row to a table in the GUI creates something like this:
INSERT INTO `myDatabase`.`Mytable` (`Col1`, `Col2`) VALUES (1234, 'NULL')
Running this in mysql, or even DataGrip;s own console inserts the string NULL, instead of <null>;
Older versions of DG we actually got a field too long in a five character field perhaps it tries to insert 'NULL' - including the single quotes!
Please sign in to leave a comment.
Could you specify your DG, MySQL & MySQL jdbc driver versions?
DataGrip is 2018.1.4
MySQL 5.5.53-log
Driver MySQLConnector/J/5.1.46
Hope that helps.
I can't reproduce the issue with DataGrip 2018.3.1. Could you try it out?
Looks good in this version, thank you.