Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.3
Description
10.2.3 beta
The following query works
select TDEC.CDEC, min( distinct TDEC.CDEC ) over () from TDEC |
|
CDEC min( distinct TDEC.CDEC ) over () |
<null> -1 |
-1 -1
|
0 -1
|
1 -1
|
0.1 -1
|
10 -1
|
The same query applied to a simple view that projects the table does not
select `tdec`.`RNUM` AS `RNUM`,`tdec`.`CDEC` AS `CDEC` from `tdec` |
|
|
select VDEC.CDEC, min( distinct VDEC.CDEC ) over () from VDEC |
|
CDEC min( distinct VDEC.CDEC ) over () |
<null> 10 |
-1 10
|
0 10
|
1 10
|
0.1 10
|
10 10
|
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
10.2.3 beta
The following query works select TDEC.CDEC, min( distinct TDEC.CDEC ) over () from TDEC CDEC min( distinct TDEC.CDEC ) over () <null> -1 -1 -1 0 -1 1 -1 0.1 -1 10 -1 The same query applied to a simple view that projects the table does not select `tdec`.`RNUM` AS `RNUM`,`tdec`.`CDEC` AS `CDEC` from `tdec` select VDEC.CDEC, min( distinct VDEC.CDEC ) over () from VDEC CDEC min( distinct VDEC.CDEC ) over () <null> 10 -1 10 0 10 1 10 0.1 10 10 10 |
10.2.3 beta
The following query works {code:sql} select TDEC.CDEC, min( distinct TDEC.CDEC ) over () from TDEC CDEC min( distinct TDEC.CDEC ) over () <null> -1 -1 -1 0 -1 1 -1 0.1 -1 10 -1 {code} The same query applied to a simple view that projects the table does not {code:sql} select `tdec`.`RNUM` AS `RNUM`,`tdec`.`CDEC` AS `CDEC` from `tdec` select VDEC.CDEC, min( distinct VDEC.CDEC ) over () from VDEC CDEC min( distinct VDEC.CDEC ) over () <null> 10 -1 10 0 10 1 10 0.1 10 10 10 {code} |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 10.2 [ 14601 ] | |
Assignee | Vicentiu Ciorbaru [ cvicentiu ] |
Labels | 10.2-rc |
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 [ 79313 ] | MariaDB v4 [ 151578 ] |