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
Transition | Time In Source Status | Execution Times |
---|
|
1d 15h 46m | 1 |
|
22d 5h 19m | 1 |
|
15h 41m | 1 |