Skip to content

v8.0.0

Compare
Choose a tag to compare
@MarkMpn MarkMpn released this 25 Nov 15:09
f13f2f8

Changes:

  • f13f2f8 Merge pull request #398 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/decode-uri-component-0.2.2
  • afff0ab Bump decode-uri-component in /AzureDataStudioExtension
  • ff1c7c5 Merge pull request #397 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/semver-5.7.2
  • 490ecaa Bump semver from 5.7.1 to 5.7.2 in /AzureDataStudioExtension
  • 1c9cd85 Merge pull request #396 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/glob-parent-5.1.2
  • e1225ba Bump glob-parent from 3.1.0 to 5.1.2 in /AzureDataStudioExtension
  • e78ec1a Merge pull request #383 from MarkMpn/cte
  • c0404f0 Give direct link to new download file
  • f9293e5 Use https instead of ssh for github
  • bc70b33 Give direct link to new download file
See More
  • 51aa85a Removed npm package lock file - install packages with yarn
  • 09a2ac0 Updated node
  • 55f2938 Simplified comment reformatting logic
  • 79462c3 Added option to copy URL to record
  • 8077808 Updated dependencies
  • d70055d Updated release notes
  • 4546d39 Updated dependencies
  • f6ec7cc Fixed errors with CTE rewrites using alises in recursive references and unnecessary quotes in column references
  • f7cd407 Preserve comments during formatting [ #393 ]
  • e955970 Added "Yes To All" option for DML confirmation dialogs
  • e04bf75 Fix partitioned aggregate error handling for dense data [ #387 ]
  • 595fcd4 Improved handling of ambiguous column names from un-aliased TVFs
  • 7d14f8e Find & Replace improvements
  • 7d52cc7 Made OPENJSON handling of scalar values consistent with SQL Server
  • 9670131 Made TVF display consistent in execution plan
  • 6497d27 Added new files to project
  • a336ee4 Added JSON_QUERY and ISJSON methods
  • 0056a42 Added filter StartupExpression for more efficient filtering of CROSS APPLY queries
  • 2535ab6 Fixed use of SELECT * within CTEs
  • f3bd7f6 Fixed column name escaping
  • 7c52cb2 Offer literal value suggestions for entityname attributes
  • 3894c6b Handle setting polymorphic lookup fields using TDS Endpoint
  • 588d0b1 Fixed use of OPENJSON in CROSS APPLY
  • c7c5b81 Handle subquery alias as source for defined values in join
  • 4c077ca Updated expected whitespace
  • 3f87b05 Use System.Text.Json instead of Newtonsoft
  • ccf8cec Added OPENJSON support using explicit schema
  • 00d3d72 Added OPENJSON support using default schema [ #340 ]
  • 915ee7c Add log message indicating IGNORE_DUP_KEY is implicit for listmember inserts
  • 583d987 Apply naming convention
  • 18f7f91 Avoid additional RetrieveVersionRequest where possible
  • 49d0694 Added IGNORE_DUP_KEY query hint for insert commands
  • ee540f9 Refactored outputting log messages from DML nodes
  • a6b0237 Clearer progress messages for multi-threaded DML operations
  • d4c8592 Remove data source from list when final use is disconnected
  • cab37bd Show plugin error details in Azure Data Studio messages
  • 1ed3d60 Fixed error showing execution plan with calculated columns
  • 749b9e5 Do not fold NOT IN queries using an inner join to a left outer join [ #382 ]
  • 624e423 Show plugin log more reliably
  • 57af6c5 Avoid folding filters to tables in subqueries if the same alias exists in the outer query
  • 604586c Switch FetchXML sort to custom sorting after adding joins that require custom paging
  • 1770472 Reduce custom sorts on merge joins
  • 1ca1381 Do not re-fold filter source immediately
  • 45f89f1 Fold "under" and "above" filters to FetchXML
  • 0237775 Fixed row count estimate overflow
  • 6de3297 Handle time zone mismatch for starting bulk delete jobs [ #380 ]
  • add2b61 Added tests for folding CTEs to hierarchical FetchXML conditions
  • 7dee5fb Fixed test
  • 1a1c177 Improved FetchXML to SQL conversion for hierarchical filters
  • 9aaad16 Added missing files to NuGet package [ #377 ]
  • 10aa0fb Support disconnect message from object explorer
  • 17c2a73 Use standard Index Spool icon for custom Adaptive Index Spool node
  • 9ae6aa7 Allow using columns from outer queries in joins [ #376 ]
  • 9f4349b Check for multi-currency issues when aggregating non-base currency fields
  • 06dac7b Allow rewriting CTEs used in subqueries
  • a74a25b Improved folding CTE to FetchXML
  • 41a0e3e Initial work on folding CTEs to FetchXML
  • beff093 Spool large recursive queries
  • 740580a Merged from master
  • 9520643 Fixed nested loop left outer join with no records returned from inner source
  • 8673a6a Merged from master
  • 38fa3f1 Extended tests
  • 203ac33 Fixed column renaming
  • 165577d Use producer node as source
  • efec67c Preserve WithStack property while cloning
  • 07021a7 Keep aliases case insensitive
  • 55acc58 Allow cloning joins
  • d2e072f Recursion progress
  • ca8c03f Merge remote-tracking branch 'origin/master' into cte
  • e43617f Clone spool producer/consumer nodes
  • 2fe11e9 Progress
  • 95226dd Use MAXRECURSION hint
  • b2382e7 Merge remote-tracking branch 'origin/master' into cte
  • 180694d Build basic structure of recursive CTE plan
  • 8e31b54 Added tests for calculated columns within CTE
  • 9e4616a Tests for column aliases
  • fb67a7e Validate CTEs before trying to convert them
  • f0a8915 Updated error messages to match SQL Server
  • b588229 Fixed UNION with wildcard columns
  • 9137321 More simple tests
  • c07a8cc Allow using TDS Endpoint for non-recursive CTEs
  • f450304 Initial basic CTE implementation

This list of changes was auto generated.