pingcap / pingcap/tidb

implement some Oracle functions based on TiDB

Open
#57,815 0 comments 0 reactions 0 assignees View on GitHub
type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

To implement some Oracle functions based on TiDB.

### Development branch
- https://github.com/pingcap/tidb/tree/feature/release-8.5-oracle-func-impl

### Funtions
These are functions blow:
- [x] nvl
- [x] nvl2
- [x] to_date
- [x] to_char
- [x] to_number
- [x] abs
- [x] decode
- [x] sysdate
- [x] sys_guid
- [x] substr
- [x] add_months
- [x] months_between
- [x] systimestamp
- [x] next_day
- [x] instr
- [x] wm_concat

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the feature/release-8.5-oracle-func-impl branch and compare its state with the checked function list in this issue. Identify which listed Oracle-compatible functions are still incomplete and confirm the expected behavior from the existing TiDB implementation. Done means the remaining functions are implemented and the issue's checklist can be completed.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.