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

[ bug ] 查询DECIMAL(65, 0)数据前端展示错误 #1250

Closed
1ness opened this issue Nov 25, 2021 · 3 comments
Closed

[ bug ] 查询DECIMAL(65, 0)数据前端展示错误 #1250

1ness opened this issue Nov 25, 2021 · 3 comments

Comments

@1ness
Copy link

1ness commented Nov 25, 2021

在提交 issue 前,请查阅以下资源,请先进行搜索来保证没有类似的 issue。
文档 | FAQ

重现步骤

1.发现 Archery SQL 数据查询工具对数值类型的字段有显示错误
select * from x where amount = '186322984999999995904'

期待结果和实际结果

期待结果:
查出来的amount值应该为186322984999999995904
实际结果:
image

截图

如上

错误日志

版本信息

应用版本/分支:
Release v1.8.1
部署方式:Docker

@weideguo
Copy link
Collaborator

应该是前端boostrap的处理出现错误,可能需要转成字符串以避免这个错误
1637926407(1)

@hhyo
Copy link
Owner

hhyo commented Nov 28, 2021

查询结果中有做bigint_as_string的处理,可以确认下相关逻辑

@hhyo hhyo changed the title [ bug ] [ bug ] 查询bigint数据前端展示错误 Nov 28, 2021
@1ness 1ness changed the title [ bug ] 查询bigint数据前端展示错误 [ bug ] 查询DECIMAL(65, 0)数据前端展示错误 Nov 29, 2021
@1ness
Copy link
Author

1ness commented Nov 29, 2021

查询结果中有做bigint_as_string的处理,可以确认下相关逻辑
是说这段代码吗?目前有看到这个逻辑,但实际情况并没起作用?
return HttpResponse(json.dumps(result, cls=ExtendJSONEncoderFTime, bigint_as_string=True),
content_type='application/json')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants