Skip to content
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

mysql insert decimal error #2211

Closed
michaeljinxq opened this issue Apr 15, 2019 · 1 comment
Closed

mysql insert decimal error #2211

michaeljinxq opened this issue Apr 15, 2019 · 1 comment

Comments

@michaeljinxq
Copy link

sharding proxy version
https://dist.apache.org/repos/dist/dev/incubator/shardingsphere/4.0.0-RC1/apache-shardingsphere-incubating-4.0.0-RC1-sharding-proxy-bin.tar.gz

(1)
create table tbname1 (id int primary key,key_price decimal(16,2) DEFAULT NULL);

(2)
mysql> INSERT INTO tbname1 VALUES (1,13.00);
ERROR 10002 (C1000): 2Unknown exception: [For input string: "13.00"]

thanks

@codefairy08
Copy link
Contributor

it could not convert double string value to number, it must convert to double

codefairy08 added a commit to codefairy08/incubator-shardingsphere that referenced this issue Apr 16, 2019
codefairy08 added a commit to codefairy08/incubator-shardingsphere that referenced this issue Apr 16, 2019
terrymanu added a commit that referenced this issue Apr 16, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants