Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.3
-
Windows 10 Pro 1607 x64, 128GB RAM, i7 6800k MariaDB 10.2.3 Beta
Description
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
+------+---------+
|
| id | next_id |
|
+------+---------+
|
| 1 | 2 |
|
| 2 | 3 |
|
| 3 | 4 |
|
| 4 | 5 |
|
| 5 | 6 |
|
| 6 | 7 |
|
| 7 | 8 |
|
| 8 | 9 |
|
| 9 | 10 |
|
| 10 | 11 |
|
+------+---------+
|
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Environment | Windows 10 Pro 1607 x64, 128GB RAM, i7 6800k MariaDB 10.2.2 Beta | Windows 10 Pro 1607 x64, 128GB RAM, i7 6800k MariaDB 10.2.3 Beta |
Description |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
+------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+ |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
{{+------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+}} |
Description |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
{{+------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+}} |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
{{+------+---------+ | id | next_id | +------+---------+ | 1 | 1 | | 2 | 4097 | | 3 | 4097 | | 4 | 4097 | | 5 | 4097 | | 6 | 4097 | | 7 | 4097 | | 8 | 4097 | | 9 | 4097 | | 10 | 4097 | +------+---------+}} |
Description |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
{{+------+---------+ | id | next_id | +------+---------+ | 1 | 1 | | 2 | 4097 | | 3 | 4097 | | 4 | 4097 | | 5 | 4097 | | 6 | 4097 | | 7 | 4097 | | 8 | 4097 | | 9 | 4097 | | 10 | 4097 | +------+---------+}} |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
+------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+ |
Description |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
+------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+ |
Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.
{noformat} +------+---------+ | id | next_id | +------+---------+ | 1 | 2 | | 2 | 3 | | 3 | 4 | | 4 | 5 | | 5 | 6 | | 6 | 7 | | 7 | 8 | | 8 | 9 | | 9 | 10 | | 10 | 11 | +------+---------+ {noformat} |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Component/s | Optimizer - Window functions [ 13502 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] | |
Priority | Minor [ 4 ] | Major [ 3 ] |
Labels | 10.2-rc |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] | Sergei Petrunia [ psergey ] |
Assignee | Sergei Petrunia [ psergey ] | Vicentiu Ciorbaru [ cvicentiu ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Fix Version/s | 10.2.4 [ 22116 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 79037 ] | MariaDB v4 [ 151465 ] |
Thank you I couldn't get the formatting to work.