apache / apache/iotdb

[Bug] There is a logical error in the precedence of arithmetic operators.

未关闭
#14,290 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Java
星标
6.4k
派生
1.2k
平均合并
1 天 23 小时
30 天内合并 PR
115

描述

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.

### Version

version 1.3.3 (Build: ad95a7e)

### Describe the bug and provide the minimal reproduce step

```
DROP DATABASE root.db0
CREATE DATABASE root.db0

CREATE TIMESERIES root.db0.t1 WITH datatype=INT32;
INSERT INTO root.db0(timestamp, t1) VALUES (1641024000000, 0);

# query 1
SELECT (t1 * -1000) FROM root.db0

# query 2
SELECT (t1 * (-1000)) FROM root.db0
```

### What did you expect to see?

Query 1 returned result set: **-0**

Query 2 returned result set: **-0**

### What did you see instead?

Query 1 returned result set: **-1000**

Query 2 returned result set: **-0**

### Anything else?

Dear IoTDB team, In the above scenario, we combine the `unary negation operator` with column t1 and perform a multiplication operation to examine the result returned by IotDB. In Query 1, we did not enclose `-t1` in parentheses to treat it as a whole, and the returned result was **-1000**, which does not match our expectations. In principle, the unary negation operator should have a higher precedence than the multiplication operator, and the presence or absence of parentheses should not affect the final result.

### Are you willing to submit a PR?

- [x] I'm willing to submit a PR!

贡献指南

打开贡献指南

调研方向

Payload 未指明任何实现文件或测试。首先针对 IoTDB 运行 issue 中的最小复现,并比较 query 1 与 query 2;当两个表达式都产生预期的等价结果,且一元否定的优先级高于乘法时,即表示完成。

由索引模型根据 Issue 内容生成。

评估

技术栈
java, sql
领域
databases
Issue 类型
缺陷
难度
3/5
预计耗时
1-2 天
活跃度
停滞
描述清晰度
基本清楚
新手友好度
38/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。