Documentation Request Summary:

See design document here: https://docs.google.com/document/d/17pZUwYOBuEmggRoXpoPxXcYPYGSE0CN3npf2FoqrboQ/edit#

Description

SERVER-31477 implements the $trim, $ltrim, and $rtrim aggregation operators:

Scope of changes (files that need work and how much)

• 3 new aggregation reference files
• meta/aggregation-quick-reference
• ref-toc-aggregation-operators
• Updated release notes

Impact to other docs outside of this product

BI Connector docs may need to be updated iff there is documentation about which SQL functions can be pushed down.

MVP (work and date?)

Resources (e.g. Scope Docs, Invision)

• Design document: https://docs.google.com/document/d/17pZUwYOBuEmggRoXpoPxXcYPYGSE0CN3npf2FoqrboQ/edit#heading=h.dqtnpqkb4s9g
• Syntax document: https://docs.google.com/document/d/1OnN2S3K8-4CfM1ytS_zoV4c7B0P5UOnRfy7u0UGxecE/edit#heading=h.x27gezq30brn

Engineering Ticket Description:

LRIM RTRIM TRIM are basic operation available for string literal.

Currently mongodb does not have it because of that, BI connector is not able to push down RTRIM LTRIM TRIM functions to mongod.

every string comparison in mysql disregarding right padding of whitespace. Hence we need to support that otherwise doing it in-memory will be performance impact on BI- Connector.