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!

 

 

1
4 comments

Could you specify your DG, MySQL & MySQL jdbc driver versions?

0
Avatar
Permanently deleted user

DataGrip is 2018.1.4

MySQL 5.5.53-log

Driver MySQLConnector/J/5.1.46

 

Hope that helps.

0

I can't reproduce the issue with DataGrip 2018.3.1. Could you try it out?

0
Avatar
Permanently deleted user

Looks good in this version, thank you.

0

Please sign in to leave a comment.