[SERVER-31477] Support of LTRIM RTRIM TRIM function in mongodb Created: 09/Oct/17  Updated: 30/Oct/23  Resolved: 08/Feb/18

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

Type: New Feature Priority: Major - P3
Reporter: Sushant Choudhary Assignee: Charlie Swanson
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
is documented by DOCS-11325 Docs for SERVER-31477: Support of LTR... Closed
Duplicate
is duplicated by SERVER-30172 Allow accessing StringData from a str... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query 2018-01-29, Query 2018-02-12
Participants:

 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.



 Comments   
Comment by Githook User [ 08/Feb/18 ]

Author:

{'email': 'charlie.swanson@mongodb.com', 'name': 'Charlie Swanson', 'username': 'cswanson310'}

Message: SERVER-31477 Add $trim, $ltrim and $rtrim expressions.
Branch: master
https://github.com/mongodb/mongo/commit/d043792471717cd59f8d56728d59abf4fdbab6df

Comment by Sushant Choudhary [ 20/Oct/17 ]

ian.whalen Yeah I am definitely interest in doing this by myself.

Comment by Ian Whalen (Inactive) [ 20/Oct/17 ]

sushant.choudhary if you're interested in doing this yourself we'll want to get a scope approved with syntax included. Please send me an email and we can figure out if/how to schedule that.

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