[SERVER-35013] Support base conversion in $convert Created: 16/May/18  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: Aggregation Framework, Querying
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Minor - P4
Reporter: Adinoyi Omuya Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 2
Labels: BIC, expression
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-32930 Trig functions in the aggregation fra... Closed
is related to SERVER-55386 Support hex conversion and binary ope... Backlog
Assigned Teams:
Query Optimization
Participants:

 Description   

CONV() Convert numbers between different number bases (add as modes to `$convert`)
See https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html for reference.



 Comments   
Comment by Asya Kamsky [ 09/Aug/22 ]

Still looking to do this somewhat semi-regularly, in particular converting long to hex (hex equivalent string).

Comment by Patrick Meredith [ 22/Oct/18 ]

$round and $trunc (with precision argument) will be handled under SERVER-15926. Ticket description changed to reflect that this ticket is now only adding base conversion to $convert.

Comment by Patrick Meredith [ 22/Oct/18 ]

DEGREES and RADIANS were folded into SERVER-32930

Comment by Asya Kamsky [ 09/Oct/18 ]

CONV is "convert number to string providing from_base and to_base"

Comment by Asya Kamsky [ 17/May/18 ]

Of the others, there are simple workarounds in agg available for SIGN and TRUNCATE.

Comment by Asya Kamsky [ 17/May/18 ]

Removed ROUND() as that's tracked in SERVER-15926

Comment by Asya Kamsky [ 17/May/18 ]

Removed
RAND() Return a random floating-point value
as that's already tracked in SERVER-30405

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