Hi! We have a small update for DataGrip 2017.1, with a few fixes that will be important for some of you:
DBE-4570 – Trigger editor works properly now.
DBE-4282 – Fixed bug with wrong column order in MySQL.
DBE-2338 – Introspection in Sybase became faster. Thanks to Ian Moult for offering a better query to run!
Stay tuned!
DataGrip team.
1. How to display the schedule MySql in Data Grip?
2. How create field ON Update in MySql?
3. Why copy data error “1: Data truncation: Out of range value for column ‘msisdn’ at row 1”. MSISDN (BIGINT) and data length 13 example 6281234556671
Thank you
1. There is no UI for this
2. Do you mean a trigger?
3. It’s a problem with your data, please describe in details and attach the screenshot.
ON UPDATE CURRENT_TIMESTAMP unable to display
If it shows null instead of zeroes (if it wasn’t updated at all), please configure it like it’s shown in our FAQ: https://confluence.jetbrains.com/display/DBE/FAQ
DS properties → Advanced → zeroDateTimeBahaviour
MySQL Table structure in the DDL statement ON UPDATE CURRENT_TIMESTAMP is not displayed.
sql:
modify_timetimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘modify_time’;but displayed:
modify_timetimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘modify_time’;Thank you
So where was the announcement (and release notes) for 2017.1.3?
There were just super-minor fixes: https://twitter.com/0xdbe/status/859706307074502657