-
Notifications
You must be signed in to change notification settings - Fork 453
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
List of improvements for Preview 2 #4494
Milestone
Comments
If someone tackles this one: only if its cardinality is known to be 0 or 1.
Same. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Below I will add list of issues and potential improvements, found in baselines from new parser feature that we should review and fix it it makes sense for next preview(s). Only one test per-issue mentioned as example usually.
SelectManyUpdateTests.Test1
: IN predicate optimization[x].[ParentID] IN (0, 0)
SelectManyUpdateTests.Test2
: False predicate minification1 = 0 AND a_Children_1.ParentID
= a_Children.ChildID`Issue461Tests.SelectToAnonymousTest2
: review current policy how to populate columns for select to avoid unnecessary transfersSELECT l.ParentID + 1, l.ParentID
UserTests.Issue4383Tests.Test
: duplicate columns in eager loadIssue3402Tests.ColumnOptimization
: avoid optimizedtrue
filter generationWHERE 1=1
Issue3148Tests.TestDefaultExpression_22
LEFT JOIN with false condition could be removedON 1=0
Issue0082Tests.Test1(SqlCe
unused OUTER APPLY should be removedOrmBattleTests.DateTimeTest
: predicate function optimization regressionSqlServerTests.TablesInScopeHintTest
: duplicate predicates in AND optimizationAnalyticTests.TestStdDev
and others : duplicate columnsAssociationTests.AssociationExpressionNullCount
: unused left join not removedConcatUnionTests.UnionGroupByTest2
: duplicate columnsThe text was updated successfully, but these errors were encountered: