{"id":186467,"date":"2021-09-30T14:27:49","date_gmt":"2021-09-30T13:27:49","guid":{"rendered":"https:\/\/blog.jetbrains.com\/?post_type=datagrip&#038;p=186467"},"modified":"2021-10-12T09:21:06","modified_gmt":"2021-10-12T08:21:06","slug":"datagrip-2021-2-3","status":"publish","type":"datagrip","link":"https:\/\/blog.jetbrains.com\/en\/datagrip\/2021\/09\/30\/datagrip-2021-2-3","title":{"rendered":"DataGrip 2021.2.3"},"content":{"rendered":"\n<p>The third minor update for <a href=\"https:\/\/www.jetbrains.com\/datagrip\/download\/\" class=\"ek-link\" target=\"_blank\" rel=\"noopener\">2021.2<\/a> introduces some important improvements and fixes.<\/p>\n\n\n\n<p><strong>Improvements<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-14044\" target=\"_blank\" rel=\"noopener\">DBE-14044<\/a>: <em>Test Connection<\/em> shows a warning if the <em>keep-alive<\/em> query has one or more errors.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1483\" height=\"457\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2021\/09\/image-32.png\" alt=\"\" class=\"wp-image-186468\"\/><\/figure>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-10341\" target=\"_blank\" rel=\"noopener\">DBE-10341<\/a>: We\u2019ve added the <em>Choose schema<\/em> action as the default intention action for the <em>Unresolved reference<\/em> inspection.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"920\" height=\"574\" src=\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2021\/09\/image-33.png\" alt=\"\" class=\"wp-image-186479\"\/><\/figure>\n\n\n\n<p><strong>Fixes<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-4212\" target=\"_blank\" rel=\"noopener\">DBE-4212<\/a>:&nbsp; [PostgreSQL] The problem with processing plv8 scripts has been fixed.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-13878\" target=\"_blank\" rel=\"noopener\">DBE-13878<\/a>: [PostgreSQL] The <em>Column is invalid in the select list <\/em>warning is no longer falsely triggered.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-5229\" target=\"_blank\" rel=\"noopener\">DBE-5229<\/a>: [MySQL] The <em>Ambiguous column reference <\/em>warning in a <em>HAVING<\/em> clause is no longer falsely triggered.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-12475\" target=\"_blank\" rel=\"noopener\">DBE-12475<\/a>: [MySQL] Aliases in INSERT statements are supported.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-12430\" target=\"_blank\" rel=\"noopener\">DBE-12430<\/a>: [SQLite] <em>UPDATE FROM<\/em> is supported.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtrack.jetbrains.com\/issue\/DBE-12404\" target=\"_blank\" rel=\"noopener\">DBE-12404<\/a>: [Db2] We\u2019ve fixed the bug that prevented introspection while data was being retrieved for users.<\/p>\n","protected":false},"author":395,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","categories":[3829,89],"tags":[6569,1334],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/186467"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/types\/datagrip"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/users\/395"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/comments?post=186467"}],"version-history":[{"count":4,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/186467\/revisions"}],"predecessor-version":[{"id":191348,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/datagrip\/186467\/revisions\/191348"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/media?parent=186467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/categories?post=186467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/tags?post=186467"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/en\/wp-json\/wp\/v2\/cross-post-tag?post=186467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}