Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Query: Task List #14630

Closed
15 of 22 tasks
smitpatel opened this issue Feb 7, 2019 · 1 comment
Closed
15 of 22 tasks

Query: Task List #14630

smitpatel opened this issue Feb 7, 2019 · 1 comment
Assignees
@smitpatel @roji
Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Milestone
3.0.0

Comments

@smitpatel
Copy link
Contributor

smitpatel commented Feb 7, 2019 •
edited
Loading

To re-implement parts

  • 1. Null semantics before second level cache
  • 2. Parameter nullability based SQL reduction
  • 3. Removal of redundant explicit cast to same type
  • 4. Value to search condition transformation and vice-versa
  • 5. is operator optimization to discriminator
  • 6. Nav Expansion
  • 7. == between anon types in where should get de-constructed? (Query: Anonymous type to constant comparison should be server eval'ed #14672 )
  • 8. Parameter being null converted to IS NULL
  • 9. Eliminate InvocationExpression when lambda expression. Like this
  • 10. Cross Join
  • 11. Join
    - [ ] 12. EntityEqualityRewrite Query: Rewrite Entity Equality #15588"
  • 13. Subquery pushdown
  • 14. Subquery lifting
  • 15. Reduce constant based comparison/conditionals in SQL tree
  • 16. Subquery InExpression
  • 17. Tracking behavior
  • 18. DbFunction support
  • 19. Include
  • 20. Owned entities support
  • 21. Discriminator/Inheritance support
  • 22. Async query support
  • 23. Concurrency detection
  • [ ] 24. Verify Exceptions QueryRewrite: materializer doesn't intercept reader exceptions #15751
@smitpatel smitpatel added this to the 3.0.0 milestone Feb 7, 2019
smitpatel added a commit that referenced this issue Apr 30, 2019
@smitpatel
New Query pipeline
beeb7bc 
What works:
Non-collection queries
Sync/Async
InMemory/Sqlite/SqlServer
Method/Member translators
Spatial

What does not work:
Cosmos provider - Tests are skipped in normal run so will fix later
Collection queries - Includes/Correlated Subquery is not implemented yet
Subquery lifting - Was dependent on nav rewrite
A lot of small optimizations in expression tree/generated Sql
Null semantics
TPH
Broader list at #14630

Notes:
Old files are not deleted yet. (keeping them for reference for now)
Still target NS2.0
Class names/namespaces are not final.
Doc comments missing
@smitpatel smitpatel mentioned this issue Apr 30, 2019
Merged
smitpatel added a commit that referenced this issue Apr 30, 2019
@smitpatel
New Query pipeline
acc325b 
What works:
Non-collection queries
Sync/Async
InMemory/Sqlite/SqlServer
Method/Member translators
Spatial

What does not work:
Cosmos provider - Tests are skipped in normal run so will fix later
Collection queries - Includes/Correlated Subquery is not implemented yet
Subquery lifting - Was dependent on nav rewrite
A lot of small optimizations in expression tree/generated Sql
Null semantics
TPH
Broader list at #14630

Notes:
Old files are not deleted yet. (keeping them for reference for now)
Still target NS2.0
Class names/namespaces are not final.
Doc comments missing
smitpatel added a commit that referenced this issue Apr 30, 2019
@smitpatel
New Query pipeline
0d359bb 
What works:
Non-collection queries
Sync/Async
InMemory/Sqlite/SqlServer
Method/Member translators
Spatial

What does not work:
Cosmos provider - Tests are skipped in normal run so will fix later
Collection queries - Includes/Correlated Subquery is not implemented yet
Subquery lifting - Was dependent on nav rewrite
A lot of small optimizations in expression tree/generated Sql
Null semantics
TPH
Broader list at #14630

Notes:
Old files are not deleted yet. (keeping them for reference for now)
Still target NS2.0
Class names/namespaces are not final.
Doc comments missing
smitpatel added a commit that referenced this issue May 2, 2019
@smitpatel
New Query pipeline
4fdbdd5 
What works:
Non-collection queries
Sync/Async
InMemory/Sqlite/SqlServer
Method/Member translators
Spatial

What does not work:
Cosmos provider - Tests are skipped in normal run so will fix later
Collection queries - Includes/Correlated Subquery is not implemented yet
Subquery lifting - Was dependent on nav rewrite
A lot of small optimizations in expression tree/generated Sql
Null semantics
TPH
Broader list at #14630

Notes:
Old files are not deleted yet. (keeping them for reference for now)
Still target NS2.0
Class names/namespaces are not final.
Doc comments missing
smitpatel added a commit that referenced this issue May 2, 2019
@smitpatel
New Query Pipeline (#14455)
b69900c 
* New Query pipeline

What works:
Non-collection queries
Sync/Async
InMemory/Sqlite/SqlServer
Method/Member translators
Spatial

What does not work:
Cosmos provider - Tests are skipped in normal run so will fix later
Collection queries - Includes/Correlated Subquery is not implemented yet
Subquery lifting - Was dependent on nav rewrite
A lot of small optimizations in expression tree/generated Sql
Null semantics
TPH
Broader list at #14630

Notes:
Old files are not deleted yet. (keeping them for reference for now)
Still target NS2.0
Class names/namespaces are not final.
Doc comments missing

* Disabling tests
@roji roji self-assigned this May 19, 2019
@smitpatel
Copy link
Contributor Author

Closing this as most of the things here have own tracking issues.

@smitpatel smitpatel added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Jun 6, 2019
@smitpatel smitpatel modified the milestones: 3.0.0, 3.0.0-preview6 Jun 6, 2019
@ajcvickers ajcvickers modified the milestones: 3.0.0-preview6, 3.0.0 Nov 11, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@smitpatel smitpatel

@roji roji

Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Projects
None yet
Milestone
3.0.0
Development

No branches or pull requests
4 participants
@ajcvickers @smitpatel @maumar @roji