Proxysql: JetBrains data tool show int as float (with a lot of 0)

[dungdm93]

I use DataGrip (2018.2) connect to MySQL cluster via ProxySQL, then I try some query and I got following result:

The table DDL:

create table django_content_type
(
  id        int auto_increment primary key,
  app_label varchar(100) not null,
  model     varchar(100) not null,
  constraint django_content_type_app_label_model_76bd3d3b_uniq
  unique (app_label, model)
);

I have tried other methods, such as: DataGrip connect to MySQL directly, mysql client (terminal) connect to ProxySQL.... but everything look good.

[renecannao]

DataGrip is this, right?
https://www.jetbrains.com/datagrip/
I will try to reproduce it.

[dungdm93]

Yes! It is or any JetBrains IDEs (PyCharm, IntelliJ,...) with database plugin.

[bsramin]

same problem here

[bsramin]

resolved here https://github.com/sysown/proxysql/issues/1192#issuecomment-404814889

[renecannao]

Added flag CLIENT_LONG_FLAG to CapabilityFlags in 1.4.12 and 2.0.0.
Certain libraries do not need that (C API for example), but others seems to rely on it.