taosdata/TDengine

base64 decode for column, like mysql FROM_BASE64(str)

Open

#25,945 opened on May 28, 2024

View on GitHub
 (0 comments) (0 reactions) (0 assignees)C (5,002 forks)batch import
help wantedquestion

Repository metrics

Stars
 (24,849 stars)
PR merge metrics
 (Avg merge 1d 1h) (4 merged PRs in 30d)

Description

General Questions A general question should be related to TDengine's user's manual, user experience, milestones, business cooperations etc. Before you ask a question, please:

  1. Try searching for answers in the official documentation
  2. Try searching in the existing issues on GitHub
  3. Try searching on tech forums such as Stack Overflow, Quora, CSDN, v2ex etc.
  4. Try using online searching engines such as Google, Bing, Baidu

If all the ways above couldn't help, please clearly and concisely describe what the question is. dear tdengine team: i find base64 function in this repo, https://github.com/search?q=repo%3Ataosdata%2FTDengine%20base64&type=code is there a function like mysql FROM_BASE64(str) that i can use select FROM_BASE64('${column_value}') from ${table_name} in tdengine

Contributor guide

Research direction
Implement a SQL function FROM BASE64 that decodes a base64 encoded string. Study the existing base64 encode implementation in the codebase and follow the same pattern to add the decode counterpart. Add tests and ensure it works in SQL queries.
Tech stack
csql
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
CSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65