-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.3
-
Fix Version/s: 10.2.4
-
Component/s: Optimizer - Window functions
-
Labels:
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
|