Singlestore BIGINT UNSIGNED columns returned incorrectly

[dron-dronych]

What language are you using?

Python 3.10.

What version are you using?

connectorx 0.4.5

What database are you using?

Singlestore 5.7.32

What dataframe are you using?

Pandas

Can you describe your bug?

Having a BIGINT UNSIGNED column with big values are returned incorrectly. I have noticed the last four digits are different from the actual values.

What are the steps to reproduce the behavior?

Example query / code

create table test
(id bigint unsigned not null);

insert into test
(id) values
(10), (20), (1), (2087271583674132669);

df = cx.read_sql('singlestoredb://root:root@localhost:3306/testdb', 'select id from test;')

df['id'].astype(int)

What is the error?

2087271583674132736 instead of 2087271583674132669. Note how I have to manually cast the values to int while they should automatically be returned as ints instead. Thats possibly where the issues lies.

[dron-dronych]

actually its the bug with Singlestore itself. need to explicitly cast your table to int like

select id:>BIGINT from test;

and then the output is correct.

[dron-dronych]

after some experiments i found the native connection via their dedicated client and through pandas.read_sql() gives the proper uint64 (expected) so maybe there is an issue with connectorx. probably the admins should reopen this @wangxiaoying