[SERVER-25186] Add support for a default collation for views Created: 20/Jul/16  Updated: 14/Mar/17  Resolved: 06/Sep/16

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 3.3.14

Type: Task Priority: Major - P3
Reporter: Kyle Suarez Assignee: Kyle Suarez
Resolution: Done Votes: 0
Labels: read-only-views
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
is documented by DOCS-8905 Document the behavior of views and co... Closed
Related
Backwards Compatibility: Fully Compatible
Participants:

 Description   

Like collections, views should have a default collation. You can specify a default collation for a view at creation time; if no collation is specified, the view's default collation is the "simple" collator.

The default collation of a view should not be overridden. This prevents a user from circumventing field-level redaction performed in the view pipeline that is implemented with string comparisons. The following operations should fail with an OptionNotSupportedOnView error:

  • Specifying a per-operation collation that differs from an operation involving a view, whether directly or via $lookup or $graphLookup
  • Performing any operation that involves multiple views (i.e. via $lookup or $graphLookup) where the views don't all have the same collation
  • Creating a view to depend on another view that does not have a matching collation
  • Modifying a view to depend on another view that does not have a matching collation


 Comments   
Comment by Kyle Suarez [ 06/Sep/16 ]

Marking documentation changes as "Needed," since we will have to document the behavior of views with collation.

Comment by Githook User [ 06/Sep/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-25186 fix comment for ViewCatalog::modifyView
Branch: master
https://github.com/mongodb/mongo/commit/62354acdcff2b4653165c3b3477997cdac4e84b8

Comment by Githook User [ 06/Sep/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-25186 check view collation during create/collMod

Users cannot create/modify a view that overrides the collation of another view.
Branch: master
https://github.com/mongodb/mongo/commit/792342e2bcae24607b5ddca54e18c00c637d4f83

Comment by Githook User [ 06/Sep/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-25186 support a default collation for views

Users may specify a default collation when creating a view. Operations involving
a view cannot override the view's default collation.
Branch: master
https://github.com/mongodb/mongo/commit/f515afc5dd533dc2ddc3d80697d9ff96709f9f0d

Generated at Thu Feb 08 04:08:30 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.