Hi all, I've got a very strange issue when i try to update a MySql database table with phpStorm (the problem happens only when i change the values with the in-built table layout and not if i run a textual query).
This is the test table i create (note the "deleted_at" colum that is in the FIRST position in the DDL):
and this in the sample data:
I can insert new rows but whe i try to update a row (for example to put "z" in the "data3" field I get this error with no explanation:
If I create a new row and fill the "deleted_at" before the commit of the new row then i can update the row, but if i leave the field at null then i get the error.
The strange thing it's that if i create the same table putting the "deleted_at" after the other colums the issue never appear:
with the DDL above everything works fine and I can update the rows
I'm missing something or it's a bug?
thanks in advance, Mattia