Changes between Initial Version and Version 1 of Ticket #2755
- Timestamp:
- Aug 30, 2023, 9:30:27 AM (15 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #2755
- Property Owner changed from to
- Property Summary FIX - rasql - pow with parenthesis in second paramter failed → FIX - rasql - pow should support integer parameter and parentheses
-
Ticket #2755 – Description
initial v1 1 The pow function currently supports only floating-point exponent, e.g. 2 {{{ 3 SELECT pow(2, 2.0) 4 }}} 5 It should also support integer type exponents (octet, char, short, ushort, long, ulong), i.e. these shouldn't return an error: 6 {{{ 7 SELECT pow(2, 2o) 8 SELECT pow(2, 2c) 9 SELECT pow(2, 2s) 10 SELECT pow(2, 2us) 11 SELECT pow(2, 2) 12 SELECT pow(2, 2ul) 13 }}} 1 14 15 Also, it has trouble parsing exponent expressions, e.g. 2 16 {{{ 3 17 SELECT encode(POW(c, ( 2.5 ) ), "png" , "{\"metadata\":{\"resolution\":\"1\"},\"nodata\":[]}") FROM test_mr AS c 4 18 }}} 5 6 19 7 20 with error