v7.6.1

Changes:

• 339cd16 Merge pull request #373 from MarkMpn/fixes
• 796cf45 Added check for outdated dependencies
• 93820d6 Updated changelog
• 080eb80 Avoid using custom paging for IN and EXISTS filters [ #366 ]
• c99e071 Avoid errors when viewing naive execution plan with DEBUG_BYPASS_OPTIMIZATION hint
• 9f3f173 Fixed use of partitioned aggregates within a loop [ #366 ]
• 74ed7bc Fixed left outer join in nested loop join when first record has no matching records from right source
• f02b924 Fixed incorrect row count estimates due to arithmetic overflow [ #366 ]
• 960fa2e Fixed use of LIKE with data with embedded returns [ #372 ]
• 819e315 Enable cloning all SQL fragment classes [ #365 ]

This list of changes was auto generated.

v7.6.0

Changes:

• 5cb3100 Merge pull request #363 from MarkMpn/fixes
• 02f602c Updated release notes
• cde652f Handle sorting oddities with elastic and audit table
• 7348919 Standardised version of ScriptDom parser
• 6e36143 Standardised version of ScriptDom parser
• 391c729 Updated release notes
• 443dad9 Use builtin method to validate identifier names
• dec133f Fixed exception when cancelling query
• 596db54 Fixed failing UPDATE tests
• 1160a6b Fixed NullReferenceException when filter is fully folded to LHS of a join [ #364 ]

See More

• bac4793 Added option to reset tool windows [ #362 ]
• 18dea57 Allow updating many-to-many intersect tables [ #361 ]
• 5c108c0 Fixed use of SELECT * in subquery
• bd6b480 Added test for #360
• bbc1370 Improved error formatting for missing data sources
• d427392 Removed unnecessary checks for joins that have already been folded to data source
• 79780db Preserve additional join criteria when folding joins to MetadataQueryNode [ #360 ]
• 7a50a3c Improved folding NOT EXISTS to FetchXML
• 53fefbf Ensure only minimal schema is exposed by FetchXmlScan nodes regardless of execution order [ #359 ]

This list of changes was auto generated.

v7.5.2

Changes:

• 9f577ba Merge pull request #358 from MarkMpn/fixes
• bb064a9 Updated release notes
• 17e6c62 Merge remote-tracking branch 'origin/master' into fixes
• 64fa325 Avoid repeated columns in alias nodes
• eb57c5d Improved display of column sets in properties window
• 72197fa Improved handling of alias names requiring escaping
• 9bd7005 Refactoring
• 00f63c2 Improved filter folding across joins
• 83a9afa Fixed order preservation of hash join [ #356 ]

This list of changes was auto generated.

v7.5.1

Changes:

• 0f48390 Merge pull request #354 from MarkMpn/fixes
• f1fbfaa Updated readme
• d516d6a Deleted old files
• 59ac83f Updated release notes
• 3ed7817 Merged from master
• c5b70f3 Do not fold joins on subqueries with reused aliases [ #350 ]
• 67a0e23 Merge pull request #344 from MarkMpn/retention
• 6bffaa5 Added changelog
• 6c48f99 Updated change log
• 4bddbab Fixed CROSS APPLY with UNION ALL and references in each child query to the same column in the outer query [ #348 ]

See More

• 8c644e1 Fixed custom paging with alias on primary key field [ #346 ]
• c3fe6d9 Avoid errors getting unknown tables when we already know the query is not TDS-compatible
• b9470c3 Return correct schema for global option set values [ #345 ]
• 0fce22c Autocomplete variable names in SELECT clause without FROM

This list of changes was auto generated.

v7.5.0

Changes:

• 1ddcc99 Merge pull request #342 from MarkMpn/retention
• 7ebe428 Updated release notes
• 67d2405 Avoid error when missing saved settings
• b3a3246 Can't use DISTINCT predicate or SQL_VARIANT_PROPERTY function in TDS Endpoint
• eabb8ee Ensure post-build events run only in debug builds
• 7feeca2 Improved error reporting on batch DML statements
• c43218f Keep line breaks and tabs in copied text data but replace with spaces for painting
• 2c4e6b5 Do not allow TDS Endpoint for @@ServerName
• d6701de Keep @@Version more consistent with SQL Server
• 946b2e4 Standardised copyright notices

See More

• 64ff050 Allow executing messages with OptionSetValue parameters
• b572fd1 Added option to use legacy SetState and Assign messages
• a314386 Fixed .NET Core build
• a494a04 Fixed uncorrelated TOP 1 scalar subquery
• 90c4ced Improved handling of floating windows
• 44594ea Added metadata for new properties
• 5b9be7c Load XTB assembly directly
• 048a00b Save dock layout
• 43fee7e Improved value returned for @@ServerName and SERVERPROPERTY('servername')
• fb00de5 Fixed returning schema for sql_variant values
• c2881aa Fixed error with rewriting nested loop joins if uncorrelated subquery result is used elsewhere other than the filte
• 166f51b Copy required files on debug builds
• 67083ac Improved autocomplete for variable names
• 8533b9f Added sql_variant support for SERVERPROPERTY function
• 628defe Expose @@Version and @@ServerName variables
• ff9e3df IS DISTINCT FROM improvements for column comparisons
• 8c5abc3 Support IS [NOT] DISTINCT FROM predicate
• 19312f5 Ensure subquery will only return 1 row before restructuring
• c1948fb Autocomplete collation names
• d008580 Use original logical name casing for FetchXML filters and sorts [ #337 ]
• 3b592ba Reorder uncorrelated subqueries for more efficient filtering [ #338 ]
• 742f07f Do not use merge join when data types do not have consistent sort orders
• b4f0d9a Handle nested IN & EXISTS subqueries
• 2b29bdc Limit data retrieved for scalar subqueries
• 610d2cf Do not use index spool for left side of nested loops, or where variable condition is from external parameter [ #338 ]
• 906d2f3 Do not attempt to convert ExecuteTransactionRequest to xxxMultiple requests [ #339 ]
• 852f964 More CROSS APPLY tweaks [ #330 ]
• e523e13 Cross apply progress [ #330 ]
• 9c2c9e3 Merge remote-tracking branch 'origin/master' into retention
• 06df106 Merge branch 'retention' of https://github.com/MarkMpn/Sql4Cds into retention
• 7f179d6 Updated minimum XTB version [ #334 ]
• e8cf5b6 Copy required files for debug
• 1ac4f46 Fixed JSON_VALUE getting a null literal [ #335 ]
• c0020a2 Fix getting values from a TVF with alias [ #330 ]
• 0ab6401 Fix cross-threading error with message box prompts

This list of changes was auto generated.

v7.4.0

Changes:

• e11c0c5 Merge pull request #333 from MarkMpn/retention
• ff138c3 Merge branch 'master' into retention
• 659a865 Merge branch 'retention' of https://github.com/MarkMpn/Sql4Cds into retention
• 8655739 Extended checking for archive-enabled tables
• b754fd2 Extended filtering for archive-enabled entities in Object Explorer
• 58b7e2f Merge pull request #332 from MarkMpn/retention
• 6c4927e Merge branch 'master' into retention
• c80d25d Updated nuspec for .NET 6
• 891c70d Merge pull request #328 from MarkMpn/retention
• 8bf8ab3 Disabled ICE validations for SSMS builds - failing on resource files for Microsoft.SqlServer.TransactSql.ScriptDom

See More

• e23d221 Fixed filtering metadata by attribute.sourcetype
• 7d80cf3 Handle executing queries in workbooks
• 9a10eb4 Updated assembly list
• a3f8f3a Updated namespaces
• 6de3673 Refactoring for dynamic loading
• afde4c4 Enable BypassCustomPluginExecution on bulk DML operations [ #329 ]
• 3281a7a Include dependent assemblies in NuGet package
• 86260d3 Updated xrmtb.XrmToolBox.Controls port to use metadata cache
• abf6f95 Removed need for ILMerge
• ba9ea8b Removed ADS test folder
• e7f907b Updated changelog and dependencies
• d45b49e Fixed System.Text.Json redirection
• 5b98ef9 Ensure table is added with correct schema name
• de3b756 Updated release notes
• 3bec8ab Merge remote-tracking branch 'origin/master' into retention
• d753599 Merge pull request #319 from MarkMpn/xml
• 0238220 Convert archive queries from FetchXML to SQL
• 0927b20 Added STRING_AGG to autocomplete
• 9102e2d Updated release notes
• f26347e Added support for STRING_AGG function and WITHIN GROUP clause
• 0abdb96 Cannot use FetchXML aggregation for MIN/MAX of primary key fields [ #327 ]
• d80c49a Check types for AVG and SUM aggregates
• c6d5b5b Avoid errors with un-aliased calculated columns in subqueries
• 6bd3763 Do not consider table names in subqueries as ambiguous for UPDATE/DELETE queries
• 98ec323 Fold sorts to outer source of nested loops [ #326 ]
• 6b719c7 Lift more filters directly to link-entity [ #323 ]
• 10b6c6f Added tests for improved filter lifting [ #323 ]
• 9eaa615 Fixed cross instance string comparisons [ #325 ]
• 52fe6d9 Improved error messages on invalid schemas for DML statements
• 7494563 Improved display of bool & DateTime data in ADS
• 275d4af Can't fold aggregates for archive tables
• 819d0dd Extended checking for achive tables in .NET Core
• 84e46b1 Can't fold filters on metadata.entity.isarchivalenabled
• b125b06 Expose archive tables in Object Explorer
• 48b4989 Expose archive tables in autocomplete
• 388c487 Implemented "Select Top 1000" menu option
• e30b086 Merge remote-tracking branch 'origin/master' into xml
• 4011539 Implemented many-to-many merge join variant
• 0b5ca50 Improved handling of left outer join with nested loop [ #322 ]
• e83ab4e Fixed nuget dependencies [ #317 ]
• 9e0b4e0 Do not fold filters through IndexSpool nodes [ #314 ]
• 0c27af7 Fixed null type conversion [ #314 ]
• 72e820f Retention progress
• da6c9f3 Convert outer join with non-null filter to inner join
• e895da9 Do not expose internal column names
• 38179f5 Removed unnecessary ComputeScalar nodes
• e04b549 Spool more correlated subqueries
• a8f237f Fixed error in STUFF function with out-of-range index
• 6d4da57 Allow finding variables within more complex nodes
• 506c6de Do not recurse through subqueries
• e5b51f2 Set parent correctly in XML query plan
• 8d73fd8 Fixed error extracting variables from nested loop with no join condition

This list of changes was auto generated.

v7.3.0

Changes:

• 5819139 Merge pull request #306 from MarkMpn/xml
• 0a27f59 Refactored MaxDOP calculations
• f9784f9 Added changelogs
• 71d1458 Fixed multithreading error in PartitionedAggregateNode [ #308 ]
• e2d8dce Avoid folding filters to outer-joined solution table [ #309 ]
• 3dde4c3 Use xxxMultiple requests for more tables, and improved partial success handling
• 5ac2926 Fixed merge errors
• f0e1cd4 Merge remote-tracking branch 'origin/master' into xml
• 6c39f1d New CONTINUE_ON_ERROR hint for DML operations [ #304 ]
• eb36afc Ignore errors due to deleted records during DELETE and UPDATE [ #304 ]

See More

• 2794e9f Allow copying headers with no data rows
• 41b96cd Disable copy with no data [ #305 ]
• 5a049a7 Standardised error for non-updateable partitionid column
• 3f0c10c Preserve session token between requests
• 0f90861 Extended plugin error information
• 19bf84e Option to bypass plugins for SELECT statements
• 26bf735 USe new partitionId parameter to improve filtering elastic tables by partition
• e818c42 Fixed setting parameter to string value
• 3d10ef7 Do not fold sorts to aggregate queries using elastic tables
• 7656cae Handle DELETE and UPDATE on partitioned elastic tables
• 61dfd19 Use Multiple operations for elastic tables
• 78a61d7 Do not fold joins to elastic tables
• a1edc27 Allow using aggregates for audit queries so long as we don't trigger paging
• 1c30432 Take lookup value names from EntityReference when not present in FormattedValues
• add9cb5 Apply redirect to System.Text.Json version to fix #294 (comment)
• 0ab83be Use Implicit collation label for ___name and ___type virtual columns
• 9d8bcea Fixed using HashJoin for values with different collations
• b855c3b Use CoercibleDefault collation label for metadata
• f1f4f30 Avoid errors filtering on outer-joined entity from audit
• bd62e4c Work around bug with TOP queries applied to a join on audit.callinguserid
• 65fa1b4 Switch from merge to hash join for TOP queries where the sorts could not be folded. Apply the TOP limit as a page size hint to the child side of the join where possible to reduce the amount of data retrieved.
• 4f900d8 Fixed adding attributes to audit query
• c900ca8 Avoid generating invalid link-entities for audit
• dae1e47 Check for duplicated table/alias names
• 41925c2 Added tests for #296
• 84890d4 Added icon for XML node
• c8c609f Fixed use of 0 as unlimited results
• 440f946 Do not use TDS Endpoint for FOR XML queries
• 38f478c Fixed displaying XML values in XTB
• ad6f639 Added STUFF function
• eb27aa3 Include XPath2 in ILMerge
• b31d297 Fixed use of FOR XML PATH with empty row element
• d1b5dd8 FOR XML PATH progress
• 37fb4c1 FOR XML progress
• 8d3cd82 Removed unnecessary using
• 09bf185 Added sql:variable function
• ebd236b Ensure columns referenced in sql:column XQuery method are included in query
• f785bf1 Refactoring
• 0053929 XML progress using XPath2 library
• ce81c87 Added Saxon packages for XQuery
• 213b3e9 Xml support progress

This list of changes was auto generated.

v7.2.2

Changes:

• 480a845 Merge pull request #293 from MarkMpn/fixes
• dd441e4 Updated changelog
• 95c7226 Clone BatchSize setting [ #291 ]

This list of changes was auto generated.

v7.2.1

Changes:

• 39af085 Merge pull request #289 from MarkMpn/build
• d07367b Handle empty column names from TDS Endpoint
• 25db7bd Copy collation from source string for LOWER & UPPER functions
• 7385232 Merge pull request #288 from MarkMpn/build
• 41c437f Updated build script
• 0357663 Merge pull request #287 from MarkMpn/collation
• 2952a50 package.json fixes
• 4a6a67a Added note for auto MaxDOP setting
• 40c0fcb Updated changelog
• 103f526 Mirrored autocomplete improvements to ADS

See More

• d021c08 Added more RuntimeIdentifiers
• aec213f Added RuntimeIdentifiers
• 3063451 Handle comments in Autocomplete
• 1b1bc83 Do not attempt to use JSON functions with TDS Endpoint
• 0f5834e Converted packages.config to PackageReference
• 1ea2dc0 Removed downgraded package
• c9fed26 Fixed failing tests
• 95fbbe8 Use recommended degrees of parallelism
• 79f493c Added confirmation prompts to ADS extension
• 157ad5a Allow setting batch size for DML queries via query hint [ #282 ]
• 3cfdd0b Fixed disconnect button [ #284 ]
• 113966d Allow ordering columns in original schema order instead of alphabetically
• 4b10345 Keep column ordering consistent
• 5e8ecd5 Handle executing the same command after changing database
• 3b3d5dc Prevent duplicating calculated columns when also using SELECT *
• 62cd068 Added collation functions
• be9c856 Added failing test for IN subquery
• 9077195 System function progress
• 60eac3e Fixed bugs with collation sensitive functions
• 863a201 Added UPPER and LOWER functions
• 4bcbf6d Implemented PATINDEX
• f75be04 Load collations from XTB
• 8dbb9f9 Made LIKE collation aware
• 320b458 Fixed collation for cast/convert
• 2fd2580 Collation progress
• bb25ed8 Removed test - https://github.com/MicrosoftDocs/sql-docs/issues/8123
• 079bce2 Apply explicit collation on all primary expression types
• 6b6da52 Refactoring
• 6fd54a9 Collation progress
• 48692a8 Collation progress
• 6d347ef Merge pull request #280 from MarkMpn/multithreading
• 076cbd5 Merge branch 'master' into multithreading
• b32d01b Added changelog
• f7fa918 Apply version numbering to .NET Core assemblies

This list of changes was auto generated.

v7.1.0

Changes:

• 0001db9 Merge pull request #277 from MarkMpn/multithreading
• 24c3c9c Added RuntimeIdentifiers
• 9f46622 Project build configuration
• d686da6 Define constant for all build configurations
• a139f70 Do not build SSMS integration in debug
• b6edc75 Added support for SSMS 19
• 4d0e249 Fixed synchronization errors
• 1f29273 Merge pull request #270 from MarkMpn/timeouts
• 9780b1f Merge branch 'master' into timeouts
• 0b2f744 Merge pull request #269 from MarkMpn/ads

See More

• ffb4504 Fixed autocomplete of column names in INSERT
• ad5309d Fixed autocomplete of column names in INSERT
• 77dd1ed Fixed use of Ctrl+K key combinations
• 452f3b1 Added autocomplete for optionset values
• e1023c7 Added autocomplete for optionset values
• 17fd271 Updated release notes
• a07a4ce Added Ctrl+K/Ctrl+C combination to comment and Ctrl+K/Ctrl+U to uncomment
• 598e49d Fixed retrieving large multi-select picklist names
• 2e9d009 Reuse single connection per query tab to preserve values of variables between commands
• a59e53d Ensure small result sets are displayed correctly
• aa34d7f Fixed error when running DML-only commands
• 49e30bb Only return actual execution plan when requested
• 5aa1ba9 Raised minimum XrmToolBox version
• 3c16f43 Updated release notes
• 123522a Improved display of state transitions in property grid
• 27d8812 Handle the same parameter being used in more than one FetchXML condition [ #272 ]
• b8b1107 Extended state transition handling
• c7a185c Fixed test
• 0a2be32 Merge remote-tracking branch 'origin/master' into timeouts
• b84041d Fixed tests
• c7bb9f6 Improved environment highlight display
• 4f9dcf7 Handle closing quotes
• 054ce1b Package release build of language server
• aae100c Tidying up
• f3cd813 Build script
• 9211018 Build script
• 6147ec8 Build script
• 943ee1b Build script
• 425530b Build script
• d019092 Use different version number pattern
• 81ba9d0 Build script updates
• 754d3e8 Added extension
• 4cfcef1 Improved dashboard data
• 6cd4182 Improved errors on invalid metadata
• 1796cd1 Improved dashboard data
• daa5d60 Support S2S auth
• cde9bf4 Added dependency to parse user name from OAuth token
• ecba776 Simplified metadata caching for autocomplete
• c25d414 Allow switching queries between connected instances
• 22ead58 Improved completion item icons
• 95b0331 Improved formatting of hover contents
• c4b9395 Use simpler names for multiple connections
• 84ba003 Ensure metadata cache loads in background
• 936d874 Fixed object explorer
• efcf10b Added persistent metadata cache
• 0acdd12 Highlight errors
• a979d2e Added version checker
• b9769d9 Fix error combining TOP with FetchXML page count settings
• 6812790 Refactored notifications
• 3dc6997 Refactoring
• 87597ca Fixed display of execution plan node cost
• a3bd10a Added signature help
• cf96161 Refactored to use VS LSP package
• a88c5d8 Removed unnecessary dependency
• 891cdaf Showplan simplification
• 9dbf522 Enable cross-instance queries
• 0fe4359 Fixed off-by-one error in hover handler
• ef355f8 Filled out metadata list
• 4ab91ea Updated icons for more execution plan nodes
• 4ae4474 Remove resultsets when closing query
• 9c93457 Handle connecting to on-prem instances
• 432c742 Intellisense hover handler
• 1387cd6 Added autocomplete
• f86fa71 Set the default application name
• cea6fa0 Set the application name
• 257771f Show FetchXML in query plan tooltips
• a292b43 Handle opening and closing documents
• 85d0528 Fixed errors accessing properties
• 8fbac67 Improved row count estimates
• d829b79 Do not use TDS Endpoint for PRINT or WAITFOR statements
• de9f73a Execution plan progress
• a855faa Accept configuration changes
• 87e4be8 Cache OAuth tokens
• 93e777b Handle disconnection and cancelling connection
• 7b5a3e4 Connection management, returning results from queries
• a3e9a22 Query execution poc
• 2b933c2 Added options to control FetchXML -> SQL conversion [ #261 ]
• bd23e7f Added default attribute list [ #261 ]
• 4438842 Added test for FORMAT function
• e4641bd Implemented FORMAT function [ #260 ]
• 2631b36 Initial language server work to support Azure Data Studio
• 207ed80 Added more save options [ #219 ]
• ed024c3 Added tab menu to close, copy filename etc. [ #187 ]
• 56e3484 Prompt if file is changed externally [ #184 ]
• fe09898 Added find & replace dialog [ #172 ]
• 61edcd7 Change status bar colour to match environment highlight
• 340d58e Merge pull request #259 from MarkMpn/timeouts
• 0d4d361 Merge branch 'master' into timeouts
• ba73f65 Merge branch 'timeouts' of https://github.com/MarkMpn/Sql4Cds into timeouts
• a914742 Updated release notes

This list of changes was auto generated.