Releases: MarkMpn/Sql4Cds
Releases · MarkMpn/Sql4Cds
v7.0.3
Changes:
- 77a24ec Merge pull request #258 from MarkMpn/timeouts [ #254 ]
- 90b0bfc Merge branch 'master' into timeouts
- f4fd235 Possible fix for #254
- 3971589 Merge pull request #256 from MarkMpn/timeouts
- 58c7821 Handle more date/time types as parameters to FetchXML queries
- 37f386e Merged from master
- e6139be Updated release notes
- 859bd06 Downgraded target framework to 4.6.2
- 9370a34 Improved timeout, cancellation and exception handling
This list of changes was auto generated.
v7.0.2
Changes:
- 3776ed3 Merge pull request #252 from MarkMpn/notexists
- 1e3d4ef Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- 49c3285 Fixed SSMS build
- 9417077 Merge branch 'master' into notexists
- 8ee8a14 Updated release notes
- 98f2d13 Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- f112639 Check all attributes are available in message query before executing [ #250 ]
- fca1385 Do not use custom paging for aggregate queries [ #251 ]
This list of changes was auto generated.
v7.0.1
Changes:
- 36b2a9a Merge pull request #247 from MarkMpn/notexists
- 4bbdd56 Merge branch 'master' into notexists
- e21ff07 Updated release notes
- d108a37 Partitioned aggregate query fixes
- 0099042 Improved autocomplete suggestions for stored procedures
- 5ab2bfc Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- 21c6a6c Fixed exception in autocomplete after typing "SELECT"
This list of changes was auto generated.
v7.0.0
Changes:
- a606702 Merge pull request #243 from MarkMpn/notexists
- 884e9fd Merge branch 'master' into notexists
- 8c260c0 Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- d822e6e Fixed build error
- c2af2c5 Merge pull request #242 from MarkMpn/notexists
- 64218d4 Merge branch 'master' into notexists
- ca25e85 Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- 487c919 Fixed autocomplete list filtering for stored procedure names
- fbf1176 Merge pull request #240 from MarkMpn/notexists
- 0b38b5f Merge branch 'master' into notexists
See More
- 523a28c Merge branch 'notexists' of https://github.com/MarkMpn/Sql4Cds into notexists
- 36b83a4 Fixed conversion of managed property types
- 78c9cfb Updated release notes
- 7624ecc Merge pull request #239 from MarkMpn/notexists
- 85cc9c0 Merge branch 'master' into notexists
- a0e6334 Set maximum length of JSON_VALUE result
- 63bedb8 Use standard TSQL functions for working with JSON
- 3295d0b Fixed test
- 30f8b54 Added CHAR/ASCII/NCHAR/UNICODE/DATALENGTH functions
- d480597 Merge pull request #238 from MarkMpn/notexists
- e283698 Fixed error executing query with date grouping
- 61e7290 Use dategrouping for YEAR/MONTH/DAY functions as well as DATEPART
- 91ff3a8 Apply rewrites case-insensitively [ #237 ]
- 9973be9 Optimization for joins/filters on col1 = col2 where the value of col1 or col2 is already fixed by a WHERE clause [ #234 ]
- e7408b7 Updated tests for custom paging
- e8e6580 Use custom paging when using joins to child entities
- 2388033 Allow folding joins around filters
- 2992b0c Fold multiple Filter nodes into one
- a49ff58 Fixed error win MIN aggregate [ #233 ]
- b217b1f Retry failed RetrieveTotalRecordCountRequest as Fetch query [ #234 ]
- 42a5a23 Fixed error showing FetchXML for queries that require multiple FetchXML nodes
- ce45558 Handle implicit type conversions in index seek node [ #230 ]
- fd4ee34 Merge pull request #236 from MarkMpn/audit
- af6292e Updated test assembly selector
- e8ad01b Added details to test output
- db491b2 Autocomplete extensions for stored procedures
- d70063f Allow executing messages using CommandType.StoredProcedure commands
- 4441046 Do not use TDS Endpoint for executing messages
- a768640 Show sprocs in object explorer
- 4bd3112 Execute messages as stored procedures
- 6ce1f18 Expose TVFs in Object Explorer tree
- 2215770 Added icon for ExecuteMessageNode in query plan viewer
- 9ad1bcd Handle scalar subqueries as TVF parameters
- 7d91710 Tidying
- b043443 Improved autocomplete handling for TVFs
- 18c9f8a Count executing messages in same way as retrieve requests
- 9ec5e9e Convert all string values to the default collation settings
- 3a77c35 Improved handling of unknown or missing type information
- 97d77db Fixed use of correlated message execution in OUTER APPLY
- 978f080 Fixed tests
- b6b06be Use different icon for TVFs
- 64a89fe Expose message details to autocomplete
- 29c17c1 Initial work to call messages as table valued functions and make audit entries accessible with custom functions
This list of changes was auto generated.
v6.4.0
Changes:
- 2456b44 Merge pull request #229 from MarkMpn/string-lengths
- 5ef4374 Merge branch 'master' into string-lengths
- 9076212 Updated release notes
- dbe00b6 Fixed aggregate initial values [ #228 ]
- a45609f Handle missing metadata cache for versions < 8 [ #225 ]
- 59c361f Always spool nested loop joins
- c2f7e23 Fixed use of merge joins for semi joins not on primary key
- 0a26ee5 Added hint to bypass optimizer and view original query plan
- d353aa3 IN filtering improvements
- 2c06128 Fixed nested IN subqueries
See More
- 973214c Merge branch 'string-lengths' of https://github.com/MarkMpn/Sql4Cds into string-lengths
- ad1c0a8 Fixed type conversion in simple CASE expressions
This list of changes was auto generated.
v6.3.0
Changes:
- bf5e1df Merge pull request #222 from MarkMpn/string-lengths
- 200e39d Merge branch 'master' into string-lengths
- 2c55a76 Updated release notes
- acc61c9 Merge pull request #218 from MarkMpn/string-lengths
- ad1e614 Fixed mapping data to intersect tables [ #217 ]
- a8618bf Remove DML-only custom hints for TDS endpoint
- 7018523 Always use bulk delete for audit records
- 047bfa0 Improved performance of folding queries with many joins
- 419fc83 Fold cross-table filters to joins [ #210 ]
- 4cc341b Refactored filter folding
See More
- 42b9a9e Handle multiple table names in autocomplete
- 8c1f4e5 Show completed conditional nodes in execution plan
- a7aa25b Refactored row count estimations
- 09f2de4 Allow parallel DML options with more authentication types
- 48708c6 Validate query hint names [ #215 ]
- 2432cb2 Recalculate schema if requesting specific columns only [ #207 ]
- b4ea3e3 Simplified nested filters [ #208 ]
- 67a371e Clone expressions to avoid rewriting problems [ #214 ]
This list of changes was auto generated.
v6.2.1
v6.2.0
Changes:
- eed235c Merge pull request #205 from MarkMpn/string-lengths
- 9909209 Updated release notes
- 9113b04 Do not use bulk delete for queries that use variables.
- fbbcafc Fixed INSERT/UPDATE with null literal. Do not require setting polymorphic lookup type field when setting ID field to null literal. [ #122 ]
- 3fc1148 Null literal refactoring
- 977c6f5 Implemented WAITFOR statement
- ae8d8c8 Handle lookup attributes with no Targets [ #204 ]
- 7a8b7b3 Improved null literal handling
- bc25216 Metadata filter case sensitivity fix. [ #201 ]
- 5619d88 Fixed timing of SELECT queries [ #202 ]
See More
This list of changes was auto generated.
v6.1.0
Changes:
- 4492ed3 Merge pull request #199 from MarkMpn/string-lengths
- 813a7a4 Handle null hints in conditions
- 74dc43c Moved applying hints to individual node
- 6554ec7 Simplify long lists of attributes to single
- a2e0929 Improved metadata cache performance
- 131aedf Prevent query tab being closed while it is still running [ #198 ]
- 7a959f9 Merge pull request #197 from MarkMpn/string-lengths
- 6213107 Fixed tests
- 678e980 Added keyboard shortcuts
- 240e6c3 Fixed bulk delete
See More
- cc365c8 Improved max string length error reporting
- 43a70ea Improved max string length handling
- 4e2000a Fixed folding wildcard columns for table aliases with overlapping prefixes
- 8aac7c2 Fixed scale for money columns
- 59f5a25 Merge pull request #196 from MarkMpn/string-lengths
- 7b6a9ae Updated target framework for tests
- 18b0802 Open records in appropriate browser profile
- 5d540cf More data type conversion fixes
- 253a4bc Merge pull request #189 from MarkMpn/string-lengths
- 04d4bfc Handle Dataverse bug with aggregates on address fields [ #192 ]
- c4951bf Updated release notes
- 46ab731 Updated .NET Core package details
- 7653aa2 Precision & scale enhancements
- 7dfd6fb Fixed use of REVERT
- 9fb4a2e Fixed type conversions when using TDS Endpoint
- a28f498 Disable timeout in SSMS [ #190 ]
- 5502493 Execute SELECT commands directly in SSMS when possible
- 960a838 Updated tooltips
- 4bf541f Merge pull request #188 from MarkMpn/string-lengths
- aadeeb6 Updated release notes
- 5a35f2d Refactored data type code
- 48dae3c Improved IN query folding
- 04da9aa Precision, scale & length updates
- b13254f Keep track of string length through calculations
- 698d926 Test fixes
- 09efd99 Merged from master
- b0860c4 Merge pull request #185 from MarkMpn/distinct
- 6b4a2ba Merged from master
- 933bf83 Merge pull request #178 from MarkMpn/query-hints
- 326477d Fixed stop button and retrieval limit [ #180 ]
- 5727295 Fixed SELECT alias.* queries [ #183 ]
- fb709b8 Fixed distinct queries for virtual attributes [ #182 ]
- 6c3143a Reordered distinct processing [ #181 ]
- 34ce61b SSMS fix
- 55a318c Improved schema type information progress
- 684a974 Updated release notes
- f5d5ca3 Merge remote-tracking branch 'origin/master' into query-hints
- 67e0701 Removed settings option for enabling RetrieveTotalRecordCount
- 7866772 Use query hints
This list of changes was auto generated.
v6.0.1
Changes:
- e52ea4a Merge pull request #177 from MarkMpn/v6-fixes
- 7a846e3 Updated release notes
- fa2f39a Fixed #176
- ad7fb98 Corrected display of error location for partitioned aggregate queries
- 77e9ac6 Merge pull request #174 from MarkMpn/v6-fixes
- 9fe0cf5 Handle CrmServiceClient instances with null ConnectedOrgUniqueName
- f03b0db Added missing dependency to NuGet package
This list of changes was auto generated.