Opened 16 months ago
Closed 15 months ago
#2755 closed defect (fixed)
FIX - rasql - pow should support integer parameter and parentheses
Reported by: | Bang Pham Huu | Owned by: | Dimitar Misev |
---|---|---|---|
Priority: | major | Milestone: | 10.2 |
Component: | server | Version: | 10.2 |
Keywords: | Cc: | ||
Complexity: | Medium |
Description (last modified by )
The pow function currently supports only floating-point exponent, e.g.
SELECT pow(2, 2.0)
It should also support integer type exponents (octet, char, short, ushort, long, ulong), i.e. these shouldn't return an error:
SELECT pow(2, 2o) SELECT pow(2, 2c) SELECT pow(2, 2s) SELECT pow(2, 2us) SELECT pow(2, 2) SELECT pow(2, 2ul)
Also, it has trouble parsing exponent expressions, e.g.
SELECT encode(POW(c, ( 2.5 ) ), "png" , "{\"metadata\":{\"resolution\":\"1\"},\"nodata\":[]}") FROM test_mr AS c
with error
rasdaman error 300: Parsing error 300 in line 1, column 22: Unexpected name (
Change History (4)
comment:1 by , 15 months ago
Description: | modified (diff) |
---|---|
Owner: | changed from | to
Summary: | FIX - rasql - pow with parenthesis in second paramter failed → FIX - rasql - pow should support integer parameter and parentheses |
comment:2 by , 15 months ago
comment:3 by , 15 months ago
Owner: | changed from | to
---|
comment:4 by , 15 months ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
For code examples see the implementation of
mod
.