Early Access Program News

DataGrip 2019.2 EAP 2

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.

Database tree

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.

DataGrip team.

image description

Discover more