Releases: MarkMpn/Sql4Cds
Releases · MarkMpn/Sql4Cds
v9.2.0
Changes:
- 3a106ae Merge pull request #510 from MarkMpn/virtualentity
- 79b4af3 Merge branch 'virtualentity' of https://github.com/MarkMpn/Sql4Cds into virtualentity
- 10211a5 Removed duplicate dependency
- 9b964fb Merge branch 'master' into virtualentity
- 5fca49d Merge branch 'virtualentity' of https://github.com/MarkMpn/Sql4Cds into virtualentity
- 42aca9a Updated nuspec paths
- 21cd274 Merge pull request #509 from MarkMpn/virtualentity
- 8b4517f Merge branch 'master' into virtualentity
- 927035d Updated changelog
- 74f7ca8 Merge branch 'virtualentity' of https://github.com/MarkMpn/Sql4Cds into virtualentity
See More
- 79bf414 Handle virtual entity providers that don't respect filters
- 06de393 Merge pull request #507 from MarkMpn/virtualentity
- b02a56d Merge branch 'master' into virtualentity
- e56960e Removed System.Text.Json dependency
- 1a86ada Updated release notes and dependencies
- 5ce82df Merge branch 'virtualentity' of https://github.com/MarkMpn/Sql4Cds into virtualentity
- 4c6d313 Fixed generating error on invalid lookup/optionset comparison to string [ #506 ]
- 09bccb4 Merge pull request #505 from MarkMpn/virtualentity
- f7edef3 Merge branch 'master' into virtualentity
- f7668c0 Merge pull request #504 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.XTB/Azure.Identity-1.11.4
- d5cf5bd Use in-memory implementations for DISTINCT, OFFSET/FETCH, ORDER BY and TOP when working with virtual entity providers [ #503 ]
- 2b1a8a1 Bump Azure.Identity from 1.10.3 to 1.11.4 in /MarkMpn.Sql4Cds.XTB
- 15b2c89 Merge remote-tracking branch 'origin/master' into virtualentity
- 5354131 Merge pull request #502 from MarkMpn/copilot
- cc9bc71 Handle virtual entity providers returning values of different types than described by the metadata [ #152 ]
- 9a1bdd8 Simplified using OpenAI
- 71dd652 Improved copilot error handling
- 9fd57a2 Fixed use of OpenAI vs Azure OpenAI
- 9e74589 Keep focus in copilot
- 9868b63 Fixed showing/hiding copilot
- 972630c Settings form update
- 139359b Settings form update
- f1d5519 Delay-load message details
- fc041ab Added options to set up assistant for copilot
- 13d2e8c Hide the copilot panel if it is not configured
- b1d6087 Merged from master
- 6bcea62 Merge pull request #499 from MarkMpn/v9-fixes
- 6ae0116 Updated version number variable
- 14d5936 Updated CI build versioning to match release build
- 5a673d8 Include new dependencies in nuget package
- e58e826 Updated multitargeting
- 34d81ae Updated post-build events
- 97ee289 Updated gitversion task versions
- f138613 Use new gitversion task
- 5341e33 Updated build process
- 5acb9e0 Added using
- 8d93ccf Merge remote-tracking branch 'origin/master' into v9-fixes
- b7df402 Do not use attributes from semi-joins for custom paging. Fixes #498
- 69f2e02 Updated namespace
- 428f8e1 Added export handlers to ADS extension
- d2b663f Made entity references clickable links in Excel exports
- 50ade3c Refactored multi-targeting
- b029f12 Added initial export to CSV/Excel for XTB tool
- a57cf81 Improved error reporting when using wildcard instead of column name
- 680bb82 Improved error reporting for invalid operator types
- e0dd417 Improved error reporting on aggregate parameter counts
- 6008bb4 Fixed build error
- 8f8714d Improved error reporting when using SELECT * in scalar subquery
- b666450 Improved reporting of error when using SELECT * in scalar subquery
- 4328472 Fixed exposing collation of CAST/CONVERT to string
- 9ff0f41 Fixed incorrect type conversion errors when using specialized FetchXML comparison conditions
- 55ea349 Allow changing editor font and size [ #444 ]
- e1de76e Added keyboard shortcuts to switch and close tabs [ #457 ]
- a4bd989 Merge pull request #497 from MarkMpn/v9-fixes
- 1844287 Avoid folding aggregates on audit entity using inner joins [ #488 ]
- e1c416c Added more special cases for filtering specific attributes on audit entity
- 7067563 Clone metadata query to simplify logic of applying filters
- 845f623 Replace parameter values in metadata filters on each execution [ #495, #496 ]
- 9d81921 Fixed tests
- 539083d Updated tests with new not-null filters
- 868edb7 Merge remote-tracking branch 'origin/master' into v9-fixes
- d260783 Updated not-null test to use a nullable column - filter now gets removed otherwise
- 9ec8644 Identify tautological and contradictory filters
- 2b49000 Defined columns in outer joins are nullable
- 9a98441 Add not-null filters for hash join keys [ #491 ]
- bf94c01 Merge pull request #493 from fowl2/createdOnNull
- 1d39bf8 Fixed failing tests
- 0567793 Merge branch 'master' into createdOnNull
- bba57b5 Merge pull request #490 from MarkMpn/v9-fixes
- c8dde05 Merge branch 'v9-fixes' of https://github.com/MarkMpn/Sql4Cds into v9-fixes
- 8f11401 Updated tests
- a6db135 Copilot progress
- b434ab9 fix "Column 'createdon' does not allow DBNull.Value" [ #492 ]
- 843a670 Merged from v9-fixes
- 5424f8e Merge branch 'master' into v9-fixes
- d96542b Fixed cross-entity column comparisons using <> and IS NOT DISTINCT FROM [ #486 ]
- 43896c7 Initial copilot work
- 5c3f108 Added scripting of stored procedure execution
- 9bb1b0a Extract SQL error number from exception text
- da7a985 Added context menus for creating scripts to work with tables
- 00848b8 Use simplified metadata structure for autocomplete
- 566c9f1 Refactored getting list of available virtual attributes
- 3a71157 Fixed execution count for RAISERROR/THROW
- 426c682 Avoid using cross-table column comparisons on earlier versions (on-prem) [ #486 ]
This list of changes was auto generated.
v9.1.0
Changes:
- d4f1403 Merge pull request #483 from MarkMpn/v9-fixes
- 84a4bb1 Test fixes
- b9954e6 Merge remote-tracking branch 'origin/master' into v9-fixes
- d4b5c52 Include debugger visualizer in published build output
- a02e85c Collapse lambda invocations for more readable expressions
- ff17513 Allow deleting records from the bin schema by deleting the related record from the deleteditemreference table instead
- 514d4dd Do not allow joining between different FetchXML datasources, e.g. dbo and bin schemas
- 608094d Updated changelogs
- 01d92ff Convert SqlBoolean to bool and back for logical operators to avoid #484 in .NET Core
- 7138479 Fixed error message display
See More
- 0ddf1b7 Updated release notes
- 1d3558e Merge branch 'v9-fixes' of https://github.com/MarkMpn/Sql4Cds into v9-fixes
- d00a066 Use column ordering setting to also order TVF/sproc parameters [ #473 ]
- 869bb0e Added support for partitionid column in elastic lookup values [ #482 ]
- baf51f0 Added support for partitionid field as part of elastic lookup columns
- 532c569 Updated MaxLength handling
- 5ca3c92 Added recycle bin access via
bin
schema [ #471 ] - b240cbd Avoid useraworderby to fix paging issues
- 18199f9 Improved primary key calculation
- 63594b1 Updated test to expect more efficient sort folding around index spool
- 48970b0 Added test for #479
- 1b87eed Allow visualising more types
- bcdf02a Added property grid
- 58e6b0a Use updated debug visualiser system
- 13a5e3a Use spools for subqueries in join conditions
- 9d91698 Updated test
- 7702e46 Added not-null filter to index spool key fields
- bcfdaf0 Added debugger visualiser for execution plans
- 56dbf9f Join condition subquery progress
- ba73e5f Fold subqueries in join conditions to appropriate side of join
- 62cc0a0 Do not attempt to apply aliases to virtual columns [ #477 ]
- 2fcfa61 Subquery in join condition progress [ #476 ]
- 68cb0d6 Fixed error with joins in
[NOT] EXISTS
subqueries - bce25cd Updated test for custom paging fix
- ddb282f No need to do custom paging for TOP queries
- fa7b693 Enabled use of custom paging in DISTINCT queries [ #470 ]
- 5ec2bb2 Store all parameter values as INullable
- 72a28f8 Enable CUD operations on principalobjectaccess [ #423 ]
- f521c09 Added duplicate key error code mapping
- 0a2b862 Do not attempt to use DeleteMultiple except on elastic tables [ #469 ]
This list of changes was auto generated.
v9.0.1
Changes:
- d2b3862 Merge pull request #467 from MarkMpn/v9-fixes
- 63b467a Merge branch 'master' into v9-fixes
- 197d8b1 Updated release notes
- 37b04e4 Exclude audit.changedata from FetchXML filter [ #459 ]
- dc5ad56 Merge pull request #466 from MarkMpn/v9-fixes
- 7cf911b Updated JSON path tests
- ec0d9c0 Standardised exception on DML cancellation
- 9b83d46 Standardised exception on JSON path errors
- b355829 Fixed SSMS v20 build [ #465 ]
- c4671ee Update deletion count correctly [ #464 ]
See More
- 8bf0d19 Expose fragment details in error
- 52b6ac4 Report all internal errors with consistent error number
- 9be3726 Fixed NullReferenceException when retrieving results with an
IN
orEXISTS
FetchXML subquery - 357b839 Fixed NullReferenceException when an error is generated from TDS Endpoint
- 14a333d Handle converting query without CTE clause [ #462 ]
This list of changes was auto generated.
v9.0.0
Changes:
- 5a6d482 Merge pull request #461 from MarkMpn/executeas
- eef6d30 Merge branch 'master' into executeas
- a58505e Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- 3580673 Updated build script
- df68219 Merge pull request #460 from MarkMpn/executeas
- 926de53 Merge branch 'master' into executeas
- 5cd8fef Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- d70caba Updated dates
- faa9ed3 Merge pull request #458 from MarkMpn/executeas
- 203ebf0 Merge branch 'master' into executeas
See More
- 42a7f0f Do not attempt to fold IN/EXISTS queries to FetchXML for elastic or virtual tables
- b79d925 Merge pull request #455 from MarkMpn/executeas
- 3a96849 Made cached expressions collation sensitive
- 45ae277 Only apply truncation and collation conversion when necessary
- ac39dd0 Extra reflection helper
- 456a019 Improved handling of different parameter types for EXECUTE AS statement
- c691fcc Ensure impersonation was successful
- cee3566 Fixed infinite loop in TRY block
- b0fcb74 Extended validation of GROUP BY and EXECUTE AS expressions
- 87c7858 Merge pull request #454 from MarkMpn/executeas
- 0af0563 Fixed aggregate limit exception handling
- 748a3d0 Merge pull request #453 from MarkMpn/executeas
- 9a484e9 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- 8e6c7f5 Updated error handling on string truncation
- 052d59c Merge pull request #452 from MarkMpn/executeas
- 2f929fa Merge branch 'master' into executeas
- f07fed0 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- da4f63e Updated message formatting to match SSMS depending on severity
- 2a3bcbb Allow using RAISERROR with predefined error numbers
- 5c688bc Fixed constraint errors on system tables with null createdby attributes
- d019ee3 Merge pull request #451 from MarkMpn/executeas
- 3ba6987 Merge branch 'master' into executeas
- e65e592 Updated dependency version
- 260093d Merge pull request #450 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/tar-6.2.1
- c9d43f1 Bump tar from 6.1.11 to 6.2.1 in /AzureDataStudioExtension
- cd138d0 Merge pull request #448 from MarkMpn/executeas
- f7f9df9 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- d8d30e3 Include error number in telemetry
- 0c6c776 Improved div by zero handling
- f0c19e1 Merge branch 'master' into executeas
- 75ade8c Updated Microsoft.Data.SqlClient package
- f6d883a Improved error reporting with TDS endpoint
- 3f68f18 Merge pull request #437 from MarkMpn/dependabot/npm_and_yarn/AzureDataStudioExtension/es5-ext-0.10.64
- 4e6e7aa Refactored error message generation
- e3a8be0 Merge branch 'master' into dependabot/npm_and_yarn/AzureDataStudioExtension/es5-ext-0.10.64
- e88048c Merge pull request #418 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.Engine.NetCore/System.Data.SqlClient-4.8.6
- 4a86ce7 Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.Engine.NetCore/System.Data.SqlClient-4.8.6
- 3982f90 Merge pull request #415 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.SSMS.18/System.IdentityModel.Tokens.Jwt-6.34.0
- c72282e Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.SSMS.18/System.IdentityModel.Tokens.Jwt-6.34.0
- 4dd1842 Merge pull request #414 from MarkMpn/dependabot/nuget/MarkMpn.Sql4Cds.LanguageServer/System.IdentityModel.Tokens.Jwt-6.34.0
- 93ef7e6 Merge branch 'master' into dependabot/nuget/MarkMpn.Sql4Cds.LanguageServer/System.IdentityModel.Tokens.Jwt-6.34.0
- 7e0165b Merge pull request #445 from MarkMpn/executeas
- 73762d3 Updated build configuration
- 915e328 Updated release notes
- 43f57de Fixed infinite loop
- 6775930 Avoid pulling more columns than necessary for subqueries
- c04b36c Avoid overwriting output of joins with values from right source in semi joins
- 426c60e Fixed handling of multiple child record filters
- bc29237 Updated release notes
- 641349d Added SSMS 20 support
- 223ac8f Merge pull request #435 from MarkMpn/executeas
- 32d7117 Improved null handling for NOT LIKE predicate
- 1977f0b Updated test to use useraworderby attribute
- 73642dd Fixed sorting on picklist names
- a5f0f0a Fixed filtering on virtual attributes where there are multiple virtual attributes for the same underlying lookup [ #443 ]
- 24f6125 Support
- 2978607 Handle converting sort orders on lookup and optionset fields to sort by name or value according to fetch useraworderby attribute
- 2c3d5c9 Use "retained" instead of "archive" for fetch datasource
- eb838c8 Support converting from new related record FetchXml filters to SQL
- c93a0be Added support for converting in/exists/matchfirstrowusingcrossapply links, and cross-table column comparison queries to SQL
- e770ec0 Do not re-fold queries inside conditional blocks [ #441 ]
- 7473251 Added "any" and "not any" link entity types
- d9a4f49 Moved feature availability flags to DataSource
- 3e79868 Support cross-table column comparison
- cd0a7b5 Refactored
- 0dc6ef3 Use attribute
- eea7e76 Bump es5-ext from 0.10.62 to 0.10.64 in /AzureDataStudioExtension
- 53ea676 Merge branch 'executeas' of https://github.com/MarkMpn/Sql4Cds into executeas
- 067c485 Allow accessing catalog views using TDS Endpoint
- b499599 Merge pull request #433 from MarkMpn/executeas
- 2a58c1c Merge branch 'master' into executeas
- 9ee1297 Dapper compatibility
- e726127 TDS Endpoint doesn't support error handling functions or XML data type methods
- 3640602 Handle missing values in XML value method
- 3278cdb Bump System.Data.SqlClient in /MarkMpn.Sql4Cds.Engine.NetCore
- c6c6ae8 Merge pull request #430 from MarkMpn/executeas
- a62c677 Merged from master
- 7c11bef Improved query cancellation [ #63 ]
- d4717f0 Improved handling of errors from elastic tables
- 42df033 Expose warning on nested loops without join condition in execution plan view
- 6cb0700 Fold join condition on nested loop to the source nodes if it doesn't compare values between the two sources
- fb014aa Added support for rethrowing errors
- a19da3c Fixed using TOP 1 within IN clause [ #429 ]
- ff4310c Fixed NullReferenceException when folding nested loop with null outer references
- 04b968f Reduced query rewriting of select elements for improved performance
- 5968e34 Avoid creating Linq expressions where possible for improved performance
- d1f6217 Improved folding of multiple UNION statements
- b334568 Removed unnecessary usings
- edd5093 Avoid creating unnecessary lambda expressions
- 452d938 Avoid recalcu...
v8.0.0
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.
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.