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

[Question] CAST DECIMAL 長度錯誤 #9549

Open
tonyfud opened this issue May 8, 2024 · 3 comments
Open

[Question] CAST DECIMAL 長度錯誤 #9549

tonyfud opened this issue May 8, 2024 · 3 comments
Assignees

Comments

@tonyfud
Copy link

tonyfud commented May 8, 2024

请描述您的问题.
v 2.5

SQL执行失败,请检查表、字段、关联关系等信息是否正确并重新编辑。exception while executing query: While executing SQL [SELECT CAST(id AS DECIMAL(18, 0)) AS f_ax_0 FROM test.stock_info LIMIT 100 OFFSET 0] on JDBC sub-schema [errCode = 2, detailMessage = (172.30.221.160)[CANCELLED][E-124][E-124] Arithmetic overflow no enable stack]

正常應該是 CAST(id AS DECIMAL(19, 0)) 我是 19為長度, 爲什麽自動搞成 18呢? 創建數據集全都是這種問題報錯,沒法用。

數據源是 aliyun 的 Doris -> selectdb

@tonyfud
Copy link
Author

tonyfud commented May 8, 2024

SELECT LENGTH(1266897420672184322);

@tonyfud
Copy link
Author

tonyfud commented May 8, 2024

也沒地方設置吧 强制 cast 關掉。

@yayanpei-fit2cloud
Copy link

感谢你的反馈,我们对这里进行了优化,今天发布v2.6版本,建议您升级到v2.6版本。

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

No branches or pull requests

3 participants