CARVIEW |
Select Language
HTTP/2 200
date: Thu, 31 Jul 2025 07:39:09 GMT
content-type: text/html; charset=utf-8
vary: X-PJAX, X-PJAX-Container, Turbo-Visit, Turbo-Frame, X-Requested-With,Accept-Encoding, Accept, X-Requested-With
etag: W/"55bc359d57d8a2b6a146bb792a184607"
cache-control: max-age=0, private, must-revalidate
strict-transport-security: max-age=31536000; includeSubdomains; preload
x-frame-options: deny
x-content-type-options: nosniff
x-xss-protection: 0
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'none'; base-uri 'self'; child-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/; connect-src 'self' uploads.github.com www.githubstatus.com collector.github.com raw.githubusercontent.com api.github.com github-cloud.s3.amazonaws.com github-production-repository-file-5c1aeb.s3.amazonaws.com github-production-upload-manifest-file-7fdce7.s3.amazonaws.com github-production-user-asset-6210df.s3.amazonaws.com *.rel.tunnels.api.visualstudio.com wss://*.rel.tunnels.api.visualstudio.com objects-origin.githubusercontent.com copilot-proxy.githubusercontent.com proxy.individual.githubcopilot.com proxy.business.githubcopilot.com proxy.enterprise.githubcopilot.com *.actions.githubusercontent.com wss://*.actions.githubusercontent.com productionresultssa0.blob.core.windows.net/ productionresultssa1.blob.core.windows.net/ productionresultssa2.blob.core.windows.net/ productionresultssa3.blob.core.windows.net/ productionresultssa4.blob.core.windows.net/ productionresultssa5.blob.core.windows.net/ productionresultssa6.blob.core.windows.net/ productionresultssa7.blob.core.windows.net/ productionresultssa8.blob.core.windows.net/ productionresultssa9.blob.core.windows.net/ productionresultssa10.blob.core.windows.net/ productionresultssa11.blob.core.windows.net/ productionresultssa12.blob.core.windows.net/ productionresultssa13.blob.core.windows.net/ productionresultssa14.blob.core.windows.net/ productionresultssa15.blob.core.windows.net/ productionresultssa16.blob.core.windows.net/ productionresultssa17.blob.core.windows.net/ productionresultssa18.blob.core.windows.net/ productionresultssa19.blob.core.windows.net/ github-production-repository-image-32fea6.s3.amazonaws.com github-production-release-asset-2e65be.s3.amazonaws.com insights.github.com wss://alive.github.com wss://alive-staging.github.com api.githubcopilot.com api.individual.githubcopilot.com api.business.githubcopilot.com api.enterprise.githubcopilot.com; font-src github.githubassets.com; form-action 'self' github.com gist.github.com copilot-workspace.githubnext.com objects-origin.githubusercontent.com; frame-ancestors 'none'; frame-src viewscreen.githubusercontent.com notebooks.githubusercontent.com; img-src 'self' data: blob: github.githubassets.com media.githubusercontent.com camo.githubusercontent.com identicons.github.com avatars.githubusercontent.com private-avatars.githubusercontent.com github-cloud.s3.amazonaws.com objects.githubusercontent.com release-assets.githubusercontent.com secured-user-images.githubusercontent.com/ user-images.githubusercontent.com/ private-user-images.githubusercontent.com opengraph.githubassets.com copilotprodattachments.blob.core.windows.net/github-production-copilot-attachments/ github-production-user-asset-6210df.s3.amazonaws.com customer-stories-feed.github.com spotlights-feed.github.com objects-origin.githubusercontent.com *.githubusercontent.com; manifest-src 'self'; media-src github.com user-images.githubusercontent.com/ secured-user-images.githubusercontent.com/ private-user-images.githubusercontent.com github-production-user-asset-6210df.s3.amazonaws.com gist.github.com; script-src github.githubassets.com; style-src 'unsafe-inline' github.githubassets.com; upgrade-insecure-requests; worker-src github.githubassets.com github.com/assets-cdn/worker/ github.com/assets/ gist.github.com/assets-cdn/worker/
server: github.com
content-encoding: gzip
accept-ranges: bytes
set-cookie: _gh_sess=P8S6FuvjjGRLrZ5wdmiYwlPBczOZnRwqWCjw6yr5yKjx676e8%2FSeet1cxMJDpHtmWDEgcjwFZmcl98loJlrgYtOJTmj4w9W46Yo2aWYvUzq46hoiF6ACnRruog9VIqbeDR76R3VorDN6005hJqPnN03vwHyzdlvQKQJP3ZlvcyJzFtujgk%2FBUdxzdREI3ERWRpSrwCZuLWrhUDqWdKJH6BpJrqdh%2FaM0SaYufStaxWaMIGSA4JnS6aHxWtfzk0kwu8ZzcR%2BeMGiVqOfMhrkIzw%3D%3D--dsHxj8borSpfCKkF--IH1Nz0YPNKYq7QuDdgCa8g%3D%3D; Path=/; HttpOnly; Secure; SameSite=Lax
set-cookie: _octo=GH1.1.151640281.1753947548; Path=/; Domain=github.com; Expires=Fri, 31 Jul 2026 07:39:08 GMT; Secure; SameSite=Lax
set-cookie: logged_in=no; Path=/; Domain=github.com; Expires=Fri, 31 Jul 2026 07:39:08 GMT; HttpOnly; Secure; SameSite=Lax
x-github-request-id: B7CC:144580:54E556:6A423F:688B1D9C
Releases ยท MarkMpn/Sql4Cds ยท GitHub
18 Jul 07:30
Loading
30 Apr 18:37
Loading
22 Feb 17:21
Loading
12 Dec 19:24
Loading
10 Dec 09:32
Loading
10 Nov 17:06
Loading
05 Nov 21:12
Loading
27 Aug 18:34
Loading
12 Jul 08:06
Loading
10 Jun 07:26
Loading
Skip to content
Navigation Menu
{{ message }}
-
-
Notifications
You must be signed in to change notification settings - Fork 26
Releases: MarkMpn/Sql4Cds
Releases ยท MarkMpn/Sql4Cds
v10.0.0
48d1806
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- 48d1806 Merge pull request #681 from MarkMpn/v9.6-fixes
- 0b7a276 Merge branch 'master' into v9.6-fixes
- 3f7d382 Updated release notes
- 627b683 Added option to add display name aliases [ #621 ]
- b414187 Updated package references
- e7a200d Possible fix for DML multithreading issues
- 1f48f71 Updated MSTest references
- 9849564 Removed reference to ScriptDom debugger
- 3790023 Fixed rounding errors with
datetime2
anddatetimeoffset
when changing scale - df4e1f9 Fixed conversion to
time
See More
- 82a1051 Do not spool OPENJSON results [ #682 ]
- 89c6983 Moved ScriptDom debugger to separate repo
- b7d08a7 Handle AND/OR within NOT [ #677 ]
- 6e29dda Removed commented code
- 92c4095 Load message and recycle bin metadata in background for smoother autocomplete
- 456cf55 Avoid conflicts between DISTINCT, TOP and aggregates [ #679 ]
- 509667a Fixed use of DISTINCT with subqueries [ #676 ]
- 08ff649 Binary data type conversions
- 2e46652 Expose versionnumber column using RowVersion from retrieved entity and convert to same binary format as used by SQL Server [ #678 ]
- 0f9ad09 Enabled use of CTEs in INSERT statements [ #596 ]
- edb5b82 Allow use of CTEs in DELETE and UPDATE statements
- 89c5801 Added ScriptDom serializers to solution
- aad8b02 Fixed use of null values in execution plan serializer
- 34f76c3 Fixed compile error
- 00c20e4 Allow targeting subqueries in UPDATE statements
- 077528f Added visualizer support for all new node types
- f745200 New debug visualiser for ScriptDom
- 093c049 Fixed stack overflow exception when using custom FetchXML datetime conditions
- b2d82ff Allow deleting from subquery
- f941baf Handle duplicated column names from TDS endpoint for DML operations [ #670 ]
- c05db00 Fixed inserting null literal values into temp tables
- f0c6bb5 Expose source table/column details for output columns
- 3975596 Fixed test
- d8ca9a7 Fixed inserting into principalobjectaccess [ #674 ]
- 7148aec Do not expose
name
andtype
virtual attributes if they already exist as physical attributes - e0bbb93 Handle duplicate connection error in same way as other duplicate key errors [ #672, #6 ]
- dbee262 Wildcard handling improvements
- 7ab7e35 Merge branch 'v9.6-fixes' of https://github.com/MarkMpn/Sql4Cds into v9.6-fixes
- 12b8abf Improved error handling for DROP TABLE IF EXISTS [ #664 ]
This list of changes was auto generated.
Assets 9
v9.6.1
bd263eb
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- bd263eb Merge pull request #669 from MarkMpn/v9.6-fixes
- bb7a225 Merge branch 'master' into v9.6-fixes
- 477c7b5 More changelog
- efaffa2 Updated change log
- 2d1cc3c Improved null handling when converting "not" conditions from FetchXML to SQL
- 4e9adaf Do not fold TOP clause to FetchXML for virtual tables [ #656 ]
- 878a3cc Merge pull request #667 from MarkMpn/v9.6-fixes
- 411786a Fixed cloning Concatenate nodes [ #665 ]
- 5b6792d Fixed retrieving activity and elastic table primary keys [ #662 ]
- faee73c Handle real attributes that have a "type" suffix from another attribute [ #661 ]
See More
- 0841f1e Fixed DML operations on listmember [ #655 ]
- a094ec6 Do not use TDS Endpoint for temporary tables [ #663 ]
- c4a5e79 Added support for more alphanumeric datetime formats [ #657 ]
- 9a4ea9b Check links to be added for IN/EXISTS predicates are valid before making other changes to the query [ #649 ]
- ff1e2a4 Fixed arithmetic overflow when adding large row count estimates in Concatenate node [ #651 ]
- d3aa29d Updated copyright notice
- d633e08 Do not attempt to restore connections using SDK login control [ #647 ]
- ae256ab Fixed label on checkbox to restore sessions with the original connection
- 344b781 Fixed showing the "Confirm close" dialog individually for each tab after already selecting "No" on the same dialog for bulk closing tabs
- 621bb67 Fixed inserting a primary key value from an existing lookup value [ #643 ]
- 9660f3f Always include audit.objectid when including audit.changedata to ensure all data is included [ #644, #646 ]
This list of changes was auto generated.
Assets 8
v9.6.0
9f4364e
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- 9f4364e Merge pull request #642 from MarkMpn/temp-tables
- 6368668 Merge branch 'master' into temp-tables
- aa850b2 Merge branch 'temp-tables' of https://github.com/MarkMpn/Sql4Cds into temp-tables
- b9e290f Updated release notes
- dd60c42 Merge pull request #640 from MarkMpn/temp-tables
- fcba919 Merge branch 'master' into temp-tables
- 8a80280 Implemented fast track optimisation for ROWS UNBOUNDED PRECEDING window functions
- 55df809 Added validation for duplicated parameters
- 94d8259 Extended validation of XPath expressions [ #636 ]
- 1d6ac25 Moved XML tests to separate file
See More
- 49cfaaf Merge pull request #639 from MarkMpn/temp-tables
- 224cfd5 Merge branch 'temp-tables' of https://github.com/MarkMpn/Sql4Cds into temp-tables
- 90d4f6c Do not duplicate required columns
- c938c7c Added error message
- f2d7493 Ensure an ORDER BY clause is present when using a ROWS/RANGE clause
- 63c24fd Ensure ranking functions have an ORDER BY clause
- 40623d4 STRING_AGG is not a valid window function
- 3a5650f Merge branch 'master' into temp-tables
- a8ce381 Updated changelog
- 3e0e8da Merge pull request #638 from MarkMpn/temp-tables
- a04474c Fixed use of aliases with temporary tables
- a6cf534 Merge pull request #637 from MarkMpn/window-functions
- 0fad68e Fixed use of multiple window functions
- e230069 Merge pull request #635 from MarkMpn/except-error
- bc91a94 Merge branch 'master' into except-error
- 524d08f Merge pull request #634 from MarkMpn/nested-loop-duplicate-key
- a51348c Fixed column selection for EXCEPT/INTERSECT
- 10357e1 Merge branch 'master' into nested-loop-duplicate-key
- 819bb61 Allow unpicking layered dictionaries to avoid duplication of parameters
- ad79f65 Fixed use of cloned connection in multi-threaded partitioned aggregate
- 480895b Merge pull request #631 from MarkMpn/saved-connection
- 24d7774 Fixed duplicate key error with nested loop parameters
- 953f36f Colourize icons in object explorer to match tab icons
- f728693 Show environment highlight in tab icon
- 523cc1a Added option to save connection details or not
- 598dea3 Save & restore connection for each tab [ #394 ]
- a1fe4ff Merge pull request #628 from MarkMpn/cursors
- 3d7f68a Merge branch 'cursors' of https://github.com/MarkMpn/Sql4Cds into cursors
- 747dafc Formatter refactoring
- 8a4d739 Merge branch 'master' into cursors
- 9c42859 Formatter improvement
- a392ada Merge pull request #627 from MarkMpn/cursors
- 4d83c42 Enforce forward_only cursors
- cf7b38a Allow using INSERT without explicit column listing with temp tables
- 37a5cdf Match line spacing in messages view to SSMS
- 74510a6 Separated fetch & population query column mappings
- b0b3dae Fixed time & execution count reporting in execution plan view for cursor queries
- 7f04243 Fixed selection of fallback icon in execution plan view
- 82f6e44 Allow using SqlNode as a data source
- e20edca Merged from master
- 2926c8c Merge pull request #625 from MarkMpn/temp-tables
- b451664 Added checks for unsupported column features
- ca0ca26 Merged from master
- f4a818d Merge pull request #623 from MarkMpn/window-functions
- e834c71 Merge branch 'master' into window-functions
- 31ca69c Removed test to check window functions are not supported
- fdd1803 Fixed stack overflow in recursive CTE
- 8a27bfa Merge pull request #624 from MarkMpn/security
- 9e2f919 Updated to .NET 8
- 8eccf2d Fixed security hotspots from SonarQube
- e3dd6df Merge branch 'master' into window-functions
- 11aac0b Use appropriate icon for window spool node
- 1042b34 Basic window aggregates
- bd83c6a Perf improvements
- e07f24c Show elapsed time in execution plan view
- c8246df Show window spool consumers as lazy spool for consistency with SQL Server
- 6537ee2 Added basic window aggregate support
- 3a4e599 Merge pull request #619 from KerryRJ/Fix-sequence-error
- f7231cf Fixed link to docs
- 9220b70 Exclude partitionid when searching for a primary key id
- f300c2c Added RANK and DENSE_RANK support
- db259d4 Handle all FETCH types
- 911796a Refactoring to simplify using Guid.TryParse
- a8ad801 Added test for standard fetch loop
- 84cf7dc Added FETCH INTO
- 3f4f5ea Execution plan view more in line with SSMS
- 643e43f Merged from window-functions
- 0051c82 Embed window function icons
- ec2a8f6 Execution plan view
- df93f55 Update @@FETCH_STATUS variable
- de0926c Raise correct errors when cursor is open/closed
- 15f84c4 Extended test
- 923122b Allow removing variable definition when deallocating cursor
- 8455297 Fixed handling FETCH query without INTO
- d8c9fc4 Fixed column name references
- f6f3e66 Use consistent exception handling
- e3a11da Keep the same node execution context across resultsets to keep local cursors alive
- 6bf6e91 Fixed temp table population
- 5363c02 Merge branch 'temp-tables' into cursors
- eabc571 Do not show DML confirmation messages for temp tables
- 43bedb4 Merge branch 'temp-tables' into cursors
- 69e4e2a Cursor implementation progress
- 31db506 Merge branch 'window-functions' into cursors
- b0226f9 Do not introduce redundant ComputeScalarNode when no window functions are present
- 8fbdc59 Fixed use of non-window functions
- d233573 Cursor framework
- ce41fd9 Use consistent method for reporting unsupported statements
- 9a43f47 Merged from window-functions
- c78370f Added basic ROW_NUMBER implementation
- 6f27d6d Fixed case-insensitive column name usage
- 39c406c Cursor progress
- 8e4392c Handle msdyn_emission.ownerid column as a string and not a GUID.
- dc34980 Merged temp table support
- 53a066a Improved execution plan visualisation
- 4acb450 Added DELETE and DROP TABLE support
- 2bcad3b UPDATE compatibility
- 7e6bad1 Temp table process - CREATE TABLE, INSERT, SELECT
- 7b684e2 More cursor validation & structure
- 55f9ef3 Merge remote-tracking branch 'origin/master' into cursors
- d07c134 Cursor option error checking
- 1a830cf Cursor basics
This list of changes was auto generated.
Assets 8
1 person reacted
v9.5.1
9b7fb17
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- 9b7fb17 Merge pull request #616 from MarkMpn/slow-conversion
- f17cc71 Merge branch 'master' into slow-conversion
- 9ffc8e6 Updated release notes
- 2d53621 Merge pull request #615 from MarkMpn/slow-conversion
- 70b6b38 Do not override Equals
- 5cb65f1 Fixed packaging ADS extension for .NET 8
- 11a48bc Performance improvements for queries with large number of filter conditions
- 30326e5 Merge pull request #613 from MarkMpn/in-variables
- e9bbba1 Fixed use of IN with a single variable
This list of changes was auto generated.
Assets 8
1 person reacted
v9.5.0
53287e4
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- 53287e4 Merge pull request #612 from MarkMpn/optionset
- 1b5e34f Merge branch 'master' into optionset
- 1b4d37b Merge branch 'optionset' of https://github.com/MarkMpn/Sql4Cds into optionset
- 70720bf Fixed SSMS21 artifact name
- 829ab26 Merge pull request #611 from MarkMpn/optionset
- a53c45b Merge branch 'master' into optionset
- b1979f0 Merge branch 'optionset' of https://github.com/MarkMpn/Sql4Cds into optionset
- e3dddbd Fixed signing script
- aee2c87 Merge pull request #610 from MarkMpn/optionset
- 59a9b7a Merge branch 'master' into optionset
See More
- e32dd3e Merge branch 'optionset' of https://github.com/MarkMpn/Sql4Cds into optionset
- 10f59c8 Fixed nuspec
- d6013a5 Merge pull request #609 from MarkMpn/optionset
- 466e5ac Merge branch 'master' into optionset
- d7e24f2 Fixed exposing optionset metadata and handle null values
- a6fde45 Merge pull request #606 from MarkMpn/ssms-21
- 9e65741 Merge branch 'master' into ssms-21
- 6b305de Autocomplete fixes for sprocs and sproc parameters
- 967f170 Fixed nuspec for .NET 8
- f5d8fe1 Fixed handling of anonymous columns in ADS results
- 535cbd1 Fixed autocomplete of functions that have a defined lookup type parameter
- 488d65e Merge branch 'ssms-21' of https://github.com/MarkMpn/Sql4Cds into ssms-21
- 442f2ee Updated changelog
- 3e6f6c6 Updated to .NET 8
- ec46b5e Merge pull request #602 from MarkMpn/ssms-21
- fa0dc95 Merge branch 'master' into ssms-21
- 4cd8042 Show close window confirmation even when session is remembered, except when closing entire plugin
- ea007ba Fixed ordering of parameters in generated TVF and sproc scripts [ #601 ]
- cceb741 Added sponsorship links
- ed7bbfb Improved handling of comments and whitespace [ #599, #600 ]
- 3ae08b5 Handle nested primary functions [ #598 ]
- ecb4f3d Avoid errors with cross-table column comparisons in nested link-entities [ #595 ]
- 7c3236f Allow querying the values from local optionsets via the metadata.optionsetvalue table
- 1a6beb2 Merge branch 'ssms-21' of https://github.com/MarkMpn/Sql4Cds into ssms-21
- fc2986c Expose optionset values via metadata.globaloptionsetvalue [ #543 ]
- 7253808 Lazy-load metadata of related columns when determining length of virtual __name attribute [ #593 ]
- 91403e4 Merge pull request #594 from MarkMpn/funding
- 56a72da Merge branch 'master' into funding
- 922581d Create FUNDING.yml
- 793c5fa Merge pull request #592 from MarkMpn/ssms-21
- d95044c Merge branch 'master' into ssms-21
- 12e3240 Use correct scale for Azure Data Studio results
- e3d814a Merge pull request #591 from MarkMpn/issue-templates
- d17c901 Merge branch 'master' into issue-templates
- 21a791e Merge pull request #590 from MarkMpn/ssms-21
- 26c6cc9 Update issue templates
- acd1aa7 Added INSERT/UPDATE/DELETE support for solutioncomponent
- 740d011 Merge pull request #586 from MarkMpn/ssms-21
- 3cc42d8 Updated PR build configuration
- d3fd5d6 Updated build configuration
- ff89d7c Updated version script
- 12e7e15 Merge remote-tracking branch 'origin/master' into ssms-21
- 6458e2a Merge pull request #585 from MarkMpn/large-inserts
- 7377792 Removed SSMS 18 & 19
- 0efc56e Refactored request retrying
- 8d7b4f6 Added initial SSMS 21 package
- 1be3e81 Improved stats feedback for large DML operations
- de62dc1 Merge remote-tracking branch 'origin/master' into large-inserts
- 3e90c84 Merge pull request #583 from MarkMpn/nested-loop-join-error
- bee1ac7 Merge branch 'master' into nested-loop-join-error
- 752db8e Added list of entities that RetrieveTotalRecordCount gives inaccurate results for
- 5762636 Fixed error when folding single-record joins to nested loop
- 2531aa1 More intuitive thread scaling & retries
- eca9902 Handle service protection limit reporting & cancellation for FetchXML and message execution
- 98290c2 Service protection limit reporting
- d4360d2 Merge remote-tracking branch 'origin/master' into large-inserts
- 3343c79 Fixed batch exception handling [ #575 ]
This list of changes was auto generated.
Assets 8
1 person reacted
v9.4.1
15d7236
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- 15d7236 Merge pull request #580 from MarkMpn/v9.4-fixes
- 99d1f36 Merge branch 'master' into v9.4-fixes
- 041befa Updated release notes
- 72d9a9b Merge pull request #579 from MarkMpn/case-insensitive
- 9c797c2 Fixed use of case-insensitive table names in INSERT statements
- d8105b1 Merge pull request #578 from MarkMpn/date-filter
- 0b08139 Merge branch 'master' into date-filter
- 69c51e1 Improved SQL -> FetchXML conversion of datetime filters [ #576 ]
- 0dcdf9b Merge pull request #577 from MarkMpn/fetchxml-alias
- 34d858e Include join alias when converting from Fetch XML to SQL
See More
- f5cb3cd Merge pull request #574 from MarkMpn/intellisense-comments
- ff6f01b Fixed intellisense with trailing comments [ #569 ]
This list of changes was auto generated.
Assets 10
1 person reacted
v9.4.0
c61a447
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- c61a447 Merge pull request #573 from MarkMpn/direct-updates
- c1e49d4 Merge branch 'master' into direct-updates
- 24eaf1c Merge branch 'direct-updates' of https://github.com/MarkMpn/Sql4Cds into direct-updates
- 5aa3f1a Added autocomplete information for DATETRUNC and CREATEELASTICLOOKUP functions
- b7eb797 Merge pull request #572 from MarkMpn/direct-updates
- 3530447 Merge branch 'master' into direct-updates
- 2952873 Updated release notes
- 2a79a08 Merge pull request #571 from MarkMpn/direct-updates
- 1107675 Merge remote-tracking branch 'origin/master' into direct-updates
- 6495afb Improved view of attribute accessors in execution plan property grid
See More
- 4c173ea Use the correct values for CURRENT_USER while impersonating
- 9dd470a Allow using eq-user condition for filtering primary key as well as lookup columns
- 164646b Refactored DML data type conversions
- 6779318 EntityReference type updates - support strongly typed EntityReference columns for simpler conversions
- 4175722 Do not leak parameter definitions out of subqueries
- 5026771 Added MINIMAL_UPDATES optimizer hint [ #249 ]
- 02122e5 Fixed implicit type conversion when combining non-numeric and numeric values in binary operations
- a4324e2 Merge pull request #563 from MarkMpn/alias-filter
- 7cba7c9 Fixed converting FetchXML to SQL that includes a filter on an aliased table
- be5c5b8 Fixed TDS compatibility
- 44ac5cd Merge pull request #560 from MarkMpn/direct-updates
- 1dc5bbf Fixed use of alias in subquery filters [ #558 ]
- 26994bc Merge pull request #557 from MarkMpn/direct-updates
- 82b6178 Refactored session variables
- 7c6a314 datetimeoffset conversion fixes
- 938d142 DATEDIFF tests & fixes
- 84960ce DATETRUNC tests & fixes
- 298fad0 DATEADD updates
- 8443ef9 DATEPART fixes with tests based on examples in docs
- 754b014 [small]datetime <-> numeric conversion improvements
- 3ec0019 DATEPART compartibility improvements
- 3ab7b8d Updated date/time data type parsing to respect SET DATEFORMAT
- 265291d Refactored folding IDs to constant scan for UPDATE and DELETE
- 384e94a Allow folding IN criteria using variables to FetchXML
- e9d5d20 Delete records by ID without reading them first [ #248 ]
- ddc9cf9 Merge pull request #554 from MarkMpn/polymorphic-activitypointer
- 171448a Merge branch 'master' into polymorphic-activitypointer
- 98d757e Support UPDATE & DELETE of activitypointer records, and principalobjectaccess records that reference an activitypointer [ #540 ]
- 1392c34 Merge pull request #549 from MarkMpn/v9.3-fixes
- 2317098 Initial work to extract activity type when revoking access
- 992352f Fixed error with scalar subqueries without alias
- 9b1790a Merge branch 'v9.3-fixes' of https://github.com/MarkMpn/Sql4Cds into v9.3-fixes
- 20104f9 Added manual retry logic for service protection limits [ #544 ]
- 0ea9df9 Standardised checking for missing records on UPDATE/DELETE
- 98707b0 Merge branch 'master' into v9.3-fixes
- 3324c5f Merge branch 'v9.3-fixes' of https://github.com/MarkMpn/Sql4Cds into v9.3-fixes
- 3aa9eec Fixed test for filter on outer join nested loop
- fd94f86 Do not fold join conditions from nested loop to outer source [ #548 ]
- 1028992 Do not fold full outer join to FetchXML/metadata queries
- 7c24e88 Use outer references when checking for not-null filters to apply to outer joins [ #547 ]
- 0619008 Fixed folding subquery alias to constant scan [ #546 ]
- f40e048 Do not attempt to use CreateMultiple or UpdateMultiple for virtual tables [ #541 ]
- 6a39195 Fixed swapping order of inputs on hash join [ #542 ]
- 8fd7519 Merge pull request #539 from MarkMpn/v9.3-fixes
- cbc2ab8 Merge branch 'master' into v9.3-fixes
- faeaef3 Added NEWID() function [ #537 ]
- 9e1ee13 Show confirmation message on bulk delete jobs [ #536 ]
- 754e24f Handle untyped entities and scalar collections in message responses, and entity types in message reuqests [ #369, #442, #494 ]
- 3f328f8 Do not fold filters on EntityKeyIndexStatus [ #534 ]
This list of changes was auto generated.
Assets 10
v9.3.0
d9eafb9
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
Changes:
- d9eafb9 Merge pull request #532 from MarkMpn/string_split
- d4eedef Merge branch 'master' into string_split
- bd04351 Improved error highlighting after internal rewriting
- 64b5b15 Merge pull request #531 from MarkMpn/string_split
- c6f5520 Updated changelog
- 4669171 Merge branch 'string_split' of https://github.com/MarkMpn/Sql4Cds into string_split
- ac8ca3c Fixed use of IS DISTINCT FROM in cross-column comparisons
- 7ce905b Fixed allowing implicit decimal conversions
- 86e688e Do not join FetchXML queries that use the same attribute aliases [ #522 ]
- 6946e70 Merge branch 'master' into string_split
See More
- bd1aea9 Do not require explicit conversion for different decimal types [ #527 ]
- baec2dc Highlight errors where the fragment was not in the original text
- e132d96 Highlight multiple errors in Azure Data Studio
- 5e4e148 Improved reporting of arithmetic overflow errors - highlight the source of the type conversion, not the definition of the type
- 43833d7 Decimal type conversion fixes
- 42bf1f6 Fixed re-inserting comments after formatting when using escaped identifiers [ #525 ]
- 02793eb Hide virtual attributes from solutioncomponent entity [ #524 ]
- c6efe10 Fixed use of DISTINCT with partylist attributes [ #528 ]
- 36d83ba Reuse same alias logic for FetchXmlScan and Select column mappings. [ #523 ]
- 1acc7fc Standardised checking for virtual attributes
- 744abce Expose multiple errors in the same exception
- a5820c2 Improved Copilot resiliency
- 29207c8 Improved injecting variable filter values via top-level nested loop
- 3efdbed Do not attempt to validate data types of variable filters
- fca61e1 Improved folding of sorts to aggregate FetchXML - restrictions on sorting on groupby columns and lookup columns
- 7ee3709 Show feedback when Copilot attempts to execute an invalid query
- 3aa4543 Inject dynamic filter values into FetchXML via nested loop
- f25a88e Improved moving filters to correct link-entity
- aedc881 Fixed converting datetime to number types
- da14b6a Do not apply eq-userid condition to non-lookup fields
- 384e577 Require more explicit permission to run queries from Copilot
- 63c13f9 Extended type checking for join comparisons [ #520 ]
- b2e246f Merge branch 'string_split' of https://github.com/MarkMpn/Sql4Cds into string_split
- da02945 Do not fold DISTINCT to queries including audit.objectid [ #519 ]
- 9a1bb1d Initial except/intersect work
- a1efc46 Added support for querying entity key metadata [ #409 ]
- 4cabe4b Re-added environment highlight label lost during previous merge
- faf54a0 Merge pull request #517 from MarkMpn/string_split
- a385447 Merge branch 'master' into string_split
- 336a47b Added string_split support [ #412 ]
- f3385dc Merge pull request #514 from MarkMpn/datepart
- 2cbb845 Only add not-null filter to hash join sources based on join type [ #516 ]
- 63d4fab Merge branch 'master' into datepart
- 538e508 Merge pull request #515 from MarkMpn/virtualentity
- c1f4f87 Allow grouping dates in either UTC or local time zone [ #512 ]
- 780259b Handle null primary keys from virtual entity providers [ #511 ]
This list of changes was auto generated.
Assets 10
2 people reacted
v9.2.0
3a106ae
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
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.
Assets 10
2 people reacted
v9.1.0
d4f1403
This commit was created on GitHub.com and signed with GitHubโs verified signature.
Compare
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.
Assets 10
Previous Next
You canโt perform that action at this time.