P1-[4.0 Bug Hunting]-[Window Function]-over function is weird

[sre-bot]

Description

Bug Hunter issue tidb-challenge-program/bug-hunting-issue#93

---

Bug Report

1. What did you do?

mysql> create table t(a int, b int);                                                                                                                                               Query OK, 0 rows affected (0.00 sec)   

mysql> insert into t values(1,2);
Query OK, 1 row affected (0.00 sec)
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
mysql> insert into t values(4,5);
Query OK, 1 row affected (0.00 sec)
                                                                                                                                                                                                                                                    
mysql> select (select sum(a) over ())  from t ;
+-------------------------+
| (select sum(a) over ()) |
+-------------------------+
|                       1 |
|                    NULL |
+-------------------------+
2 rows in set (0.00 sec)

mysql> select sum(a) over ()  from t ;
+----------------+
| sum(a) over () |
+----------------+
|              5 |
|              5 |
+----------------+
2 rows in set (0.00 sec)

2. What did you expect to see?

mysql> select (select sum(a) over ())  from t ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '())  from t' at line 1

mysql> select sum(a) over ()  from t ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '()  from t' at line 1

3. What did you see instead?

The results don't make any sense.

4. What version of TiDB are you using? (tidb-server -V or run select tidb_version(); on TiDB)

Reproducible on master branch:

commit 38298c2e3e8ae6438b2b9caa696586087ea58a4d (HEAD -> master, origin/master, origin/HEAD)
Author: Zhuomin(Charming) Liu <[email protected]>
Date:   Fri May 22 17:40:10 2020 +0800

mysql> select tidb_version();                                                                                                                                                      
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------$--------------------------------------------------------+
| tidb_version()
                                                        |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------$--------------------------------------------------------+
| Release Version: None
Edition: None
Git Commit Hash: None
Git Branch: None
UTC Build Time: None
GoVersion: go1.13.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SIG slack channel

#sig-exec

Score

• 900

Mentor

• @lzmhhh123

[dyzsr]

/assign

[lzmhhh123]

Wrong issue.

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions