优点数据库服务器崩溃

发布于 2024-12-21 09:11:51 字数 525 浏览 1 评论 0原文

以下查询会导致 Advantage 数据库服务器崩溃：

SELECT +SUM(0) FROM SYSTEM.IOTA

请注意 SUM(0) 之前的 +，这是罪魁祸首。如果我将 + 替换为 -，则不会发生错误。

如果我在本地模式下执行此查询，则会弹出此错误：

poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError = 2203;  
[iAnywhere Solutions][Advantage SQL Engine]
An error was encountered while reading an intermediate or temporary file.

我在测试时发现了问题，即使我同意在聚合指令之前添加 + 没有意义，它也不应该崩溃服务器！

谢谢

原文

The following query makes an Advantage Database Server crash:

SELECT +SUM(0) FROM SYSTEM.IOTA

Note the + before SUM(0), this is the culprit.
If I replace + by -, no error occurs.

If I execute this query in local mode, this error pops up:

poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError = 2203;  
[iAnywhere Solutions][Advantage SQL Engine]
An error was encountered while reading an intermediate or temporary file.

I discovered the problem while testing and, even if I agree there is no point to add a + before an aggregation instruction, it should not crash the server!

Thanks

分享到QQ

分享到微博