Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.7, 10.8, 10.9, 10.10, 10.11
-
None
Description
In MDEV-26635 was changed behavior for ROW_NUMBER, but in view we still get 1 instead 0:
Test:
create view v1 as SELECT CAST('.00000000000000000000000000000000000001e111111111111111111111' AS DECIMAL(38,0)) AS a; |
select * from v1; |
drop view v1; |
Expected result:
a
|
99999999999999999999999999999999999999
|
Warnings:
|
Warning 1916 Got overflow when converting '' to DECIMAL. Value truncated |
Warning 1292 Truncated incorrect DECIMAL value: '.00000000000000000000000000000000000001e111111111111111111111' |
Warning 1264 Out of range value for column 'a' at row 0 |
Actual result:
a
|
99999999999999999999999999999999999999
|
Warnings:
|
Warning 1916 Got overflow when converting '' to DECIMAL. Value truncated |
Warning 1292 Truncated incorrect DECIMAL value: '.00000000000000000000000000000000000001e111111111111111111111' |
Warning 1264 Out of range value for column 'a' at row 1 |
Attachments
Issue Links
- is part of
-
MDEV-27691 make working view-protocol
-
- Open
-
- relates to
-
MDEV-28651 quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')
-
- Closed
-