Database integer dispalyed as float
Hey,
When I use the "Database Tools and SQL" plugin (integrated datagrip support) and retrieve data from the database, my integer values are displayed as floats. For example: 1.000000000000000000000000000000000000000000000000000000000000000000
Is this a setting that I messed up?
请先登录再写评论。
Hi there,
What's the database provider? How IDE is recognizing those fields (is it INT, DECIMAL or something else)? What's your Data Source definition (maybe you have used some additional parameters)?
It works just fine here with my MySQL and SQL Server databases.
P.S. This one looks related: https://youtrack.jetbrains.com/issue/DBE-5704. Is your situation is the same and you use MySQL with ProxySQL? Maybe this will help you as well: https://github.com/sysown/proxysql/issues/1192#issuecomment-404814889
The database provider is MySQL in this case and looking at the table structure it is about an INT(11) field.
I've not set any additional parameters as to my knowledge.
https://youtrack.jetbrains.com/issue/DBE-5704 << the trailing zero's are my problem and is thus related to using ProxySql. Used a docker MySql database to confirm it.
Thanks for pointing me into the right direction!