-
Notifications
You must be signed in to change notification settings - Fork 5.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
json_extract get wrong decimal when insert into table #12178
Labels
component/expression
component/json
help wanted
Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines.
severity/major
sig/execution
SIG execution
type/bug
The issue is confirmed as a bug.
Comments
In TiDB:
and
|
24 tasks
55 tasks
Confirming this issue still exists in master: drop table if exists ta;
create table ta(id decimal(60,2));
insert into ta values (JSON_EXTRACT('{"c": "1234567890123456789012345678901234567890123456789012345"}', '$.c'));
select * from ta;
..
mysql> select * from ta;
+------------------------------------------------------------+
| id |
+------------------------------------------------------------+
| 1234567890123456800000000000000000000000000000000000000.00 |
+------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select tidb_version()\G
*************************** 1. row ***************************
tidb_version(): Release Version: v4.0.0-beta.2-782-gb72e47e6d
Edition: Community
Git Commit Hash: b72e47e6db8863c08e47714391cf937b0f1c3269
Git Branch: master
UTC Build Time: 2020-07-15 01:26:06
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
1 row in set (0.00 sec) |
ghost
added
the
component/json
label
Jul 25, 2020
ghost
added
the
component/expression
label
Jul 25, 2020
Closed
lzmhhh123
added
challenge-program
help wanted
Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines.
labels
Dec 4, 2020
/unlabel challenge-program |
The issue has been removed from the challenge program. |
Please edit this comment or add a new comment to complete the following informationNot a bug
Duplicate bug
BugNote: Make Sure that 'component', and 'severity' labels are added 1. Root Cause Analysis (RCA) (optional)2. Symptom (optional)3. All Trigger Conditions (optional)4. Workaround (optional)5. Affected versions6. Fixed versions |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
component/expression
component/json
help wanted
Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines.
severity/major
sig/execution
SIG execution
type/bug
The issue is confirmed as a bug.
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
If possible, provide a recipe for reproducing the error.
tidb-server -V
or runselect tidb_version();
on TiDB)?SIG slack channel
#sig-exec
Score
300
Mentor
The text was updated successfully, but these errors were encountered: