Released: Apr 6, 2020

Actualizaciones en 2020.1

Características

Run configurations

• Configuration for running script files - Before, you could only run files one by one. This could be especially frustrating if the files included dependencies and the order was crucial. Now, you can run several files at once. Choosing to run multiple files creates the run configuration. In this configuration, you can reorder the files, add new ones, and run other programs or configurations before launch. Your run configuration will be saved automatically. If you...

Released: Mar 17, 2020

Actualizaciones en 2019.3.4

Características

• Added subquery folding feature.

Correcciones

• Can't Synchronize Schemas with latest Redshift drivers.
• CSV/TXT Import to MSSQL Database without importing an id value.
• "Preview update" does not work when table is not introspected.
• Fixed the false positive in the Unused expression inspection.
• Fixed the false positive in the Redundant COALESCE inspection.

Released: Feb 13, 2020

Actualizaciones en 2019.3.3

Correcciones

• The right schema is now used when adding a foreign key constraint to a table.
• Auto sync is working after a DROP followed by a CREATE statement.
• No more freezes in JOIN completion.
• [Oracle] The OracleSqlPlus dialect is back.
• [ClickHouse] Deleting rows works as expected.
• [BigQuery] Identifiers are quoted using back quotes.
• [BigQuery] LIMIT and OFFSET are generated when opening a table’s data.

Released: Jan 22, 2020

Actualizaciones en 2019.3.2

Características

• Added the concept of virtual foreign keys which help you:
  • Have proper completion when writing JOIN clauses.
  • Display relations in diagrams.
• Added stored procedure runner for MySQL.

Correcciones

• Aliases are no longer used when completing table names in DDL.
• Only trigger functions are offered in the corresponding completion list.
• The wildcard is now resolved inside row constructors.

Released: Dec 19, 2019

Actualizaciones en 2019.3.1

Características

• A new option lets you choose whether you want to use schema qualifications when using JOIN.
• The table filter is cleared when opening a table from the database explorer.
• Added new registry option to remove schema qualification when updating data.

Correcciones

• The correct schema is used when adding a foreign key.
• Fixed the bug with queries seeping into column names.
• Right-clicking on a column header shows the menu again.

Released: Dec 3, 2019

Actualizaciones en 2019.3

Características

MongoDB support

• Introspection - You can now observe collections and fields in the database explorer. It fetches the first 10 documents from each collection to get information about the fields. This can be customized via the JDBC parameter fetch_documents_for_metainfo which is available in the Advanced tab of the data source properties dialog.
• Query console - Run statements via Ctrl+Enter or by using the Run button on the toolbar. If you’re using the database support in any other...

Released: Sep 26, 2019

Actualizaciones en 2019.2.5

Características

• Improved H2 grammar support.
• Support for numbers at the beginning of table names re-added.

Correcciones

• [PostgreSQL] Procedure added back to the Generate menu.
• Fixed the bug importing data from CSV files that include an IDENTITY column.
• The Replace IN intention no longer corrupts code.

Released: Sep 12, 2019

Actualizaciones en 2019.2.4

Características

• Added Compare Content action to table context menu.
• UUIDs are now quoted when navigating to referenced rows.
• Full-text search results are now sorted alphabetically.
• DataGrip offers to introspect the schema if it’s used in the console.

Released: Aug 16, 2019

Actualizaciones en 2019.2.2

Características

• Added JOIN completion based on column names.
• Markdown data extractor is now bundled with DataGrip.
• Drag-and-drop of columns now adds commas.
• Breadcrumbs are now also shown for SQL.
• Improved support for partition tables in PostgreSQL . The key enhancement: partition tables are now displayed under the main one.

Correcciones

IDE general

• Performance improvements.
• The folder path became editable in SQL Dialects settings section.

Code generation

• Schema comparison: the same objects are...

Released: Aug 1, 2019

Actualizaciones en 2019.2.1

Correcciones

• No more high memory usage, leading to total freezes.
• Fixed problems with failed startup on Linux.