pingcap / pingcap/docs

Document TiDB float to int cast behavior

Open
#1,002 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

2024-tidb-docs-dash help wanted status/TODO tracked
Dominant language
Python
Stars
617
Forks
724
Avg merge
2d 10h
Merged PRs (30d)
223

Description

Change Request

This repository is ONLY used to solve issues related to DOCS.
For other issues (related to TiDB, PD, etc), please move to other repositories.

Please answer the following questions before submitting your issue. Thanks!

  1. Describe what you find is inappropriate or missing in the existing docs.

Missing a mysql compatibility difference

  1. Describe your suggestion or addition.

TiDB is not always the same as MySQL when converting decimal/float values to numerics. Both are correct according to the SQL standard, but MySQL may differ.

  1. Provide some reference materials (documents, websites, etc) if you could.

https://github.com/pingcap/tidb/issues/9905

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the referenced TiDB issue 9905 and review the existing documentation for decimal and float conversion behavior. Done means the documentation explains the TiDB/MySQL compatibility difference and the relevant cast behavior clearly.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.