Hello! Please welcome the newest build of our DataGrip 2019.2 EAP.
The Full-text Search dialog has a nice new look.
The whole mechanism has had several improvements made to it:
– In PostgreSQL, MySQL, and MariaDB you can now switch it to only search in columns that are indexed. To use this mode, choose ‘Only columns with full-text search indexes’ in Search in the drop-down menu.
The query in PostgreSQL will be:
where col @@ plainto_tsquery('query')
The query in MySQL and mariaDB will be:
where match(col) against ('query' in natural language mode)
– The search looks in columns which don’t support the LIKE operator, for instance, columns of JSON type. Values in these columns are converted to string type beforehand.
– In Cassandra, DataGrip creates several queries for one table, because the OR condition isn’t supported by the database.
Drag-and-drop now works for creating groups in the database explorer.
If you want to create a new group, just drag-and-drop one data source onto the other.
If you want to place the data source into an existing group, drag-and-drop it there.
Working with queries
Before, when working in the read-only mode we had some inconsistency: if a user wanted to run an update query from the read-only mode, we turned off only the IDE-level mode, but not the JDBC one (DBE-8145). Now though, we turn off both so you can run the query if you really need to.
A new action is available: Select current statement. You can get to it from Find Action (Ctrl/Cmd+Shift+A) or assign it a shortcut of its own.
New combined items are now in code completion: IS NULL and IS NOT NULL.
And we’ve added another intention action: now you can convert GROUP BY to DISTINCT if all the columns of a SELECT clause are presented in a GROUP BY clause.
That’s all for this new EAP! Stay tuned for the next EAP release coming your way; 2019.2 is going to be cool.