Hello! This is another minor update for 2018.1. Here is the list of important bug-fixes:
Oracle
DBE-3195 — Auto-completion for object types
DBE-5340 — Compiling PL/SQL code works OK
Support for:
DBE-2581 — Conditional compilation flags
DBE-6027 — SET statements with multiple clauses
DBE-6196 — INSERT ALL
DBE-6378 — JSON keyword
PostgreSQL
DBE-6301 — The bug with creating foreign keys between tables is fixed
DBE-6391 — Fields are resolved in LOOP cycle
Redshift
DBE-6336 — MAXFILESIZE support for UNLOAD
Sql Server
DBE-6325, DBE-6370 — Columns for OUTPUT are resolved
DBE-6354 — Support for ORDER BY in subqueries
H2
DBE-6367 — CTE support
DBE-6368 — DROP CASCADE support
DataGrip team
Hey guys, when viewing DDL at least in SQL Server dialect can we have it auto refresh when you click the DDL view button. There are times were I do a double take and then remember to hit the sync/refresh button. Also the matching “if” with no begin keyword causes other ifs to mismatch in highlight; granted the code could be written better…
1. Probably you are talking about https://youtrack.jetbrains.com/issue/DBE-6185
2. Can you share an example?
We’ve reproduced. We’re fixing it now.
Is there a timeframe for support of Microsoft LocalDB 2017?
What is special about 2017? DataGrip can connect to Local DB.
@maksim, could you pm me your email? There is an issue with the DataGrip application and how the auto-sync function interacts with Redshift. I would like to discuss this issue and possibly have a fix in DataGrip introduced in the next version.
My e-mail is maxim.sobolevskiy@jetbrains.com
We see the same request from you in our zendesk. What way is convenient for you to communicate? I think for us it’s email, so I will appreciate if you drop me a line.