Mysql table or query result integer columns shows many decimal zeros
Hi!
I have a Mysql database connection. If I quering or just open the table, the integer cols conatains a lot of decimal zeros (i didn't count it).
I didn't find solution for this "problem", please help me to solve it.
Thanks in advance!
Please sign in to leave a comment.
Are you using ProxySQL? They have this issue: https://github.com/sysown/proxysql/issues/1192 - try to update ProxySQL to at least version 1.4.6.
Hello!
Thank You for your answer! I use PHPStorm database connection (JDBC) trugh SSH. If I use ProxySql, i didn't know about it :)
Is your MySQL server private and do you have administrative access to it?
Did you check how this works without PhpStorm e.g. MySQL console?
Hi, I checked the console result and ewerything is fine. There are no useless decimal zeros.
Unfortunately, the fact that it's only PhpStorm that's affected doesn't tell us much: https://youtrack.jetbrains.com/issue/DBE-5704#comment=27-2684337
ProxySQL is a load balancer for MySQL, so to you it may be transparent - could you please contact your DB admin and check if ProxySQL is involved after all? As the issue you're seeing fits quite well into the bug.
I am using Alibaba Cloud products to encounter the same problem, how can I solve it, product address: https://dsql.console.aliyun.com/ Please also adapt, ask Aliyun's products, say you are here The problem, please see the screenshot below. There are a lot of 0s behind the integer. But when I click on this element it shows normal again!
Greetings!
The issue is still exists (PHPstorm ver.: 2018.2.5)
I made a perception: if I make a query like this (select id from table), the result will have unnecessary decimal zeros. But, when I make a union query like this (select id from table where id = 1 union select id from table where id = 2) result will have no unnecessary decimal zeros!
We're using ProxySql, but zeros showing only in PHPstorm. Try'd with: console: no zeros, ODBC driver: no zeros, NAVICAT: no zeros, netbeans(mysql-connector-java-5.1.23): no zeros.
@444108853, @Mihály Hanol
1) Pease try in in latest IDE versions (2019.2.x as well as 2019.3 EAP build)
2) If still the same, please report it to https://youtrack.jetbrains.com/issue/DBE-5704 or create new ticket there so devs can have another look: https://youtrack.jetbrains.com/issues/DBE