https://bugs.documentfoundation.org/show_bug.cgi?id=166358
Bug ID: 166358
Summary: Inconsistent support of math functions in base queries
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I was trying to move a calculation from a report into a query.
The calculation used the Power or "^" function in the report as
[Field1] * (1.05 ^ [field2]
Which works.
Moving this into a querying SQL in the form
"table"."field1" * (1.05 ^ "table"."field2") as "New Val"
results in a SQL error
simplifying to
"table"."field1" * (1.05 ^ 2) as "New Val"
Further testing shows some functions working and others not. The following is
not an a fully exhaustive test.
Simple math function work and The following functions work
EXP
LOG
LOG10
RAND
ROUND
Theses do not
INT
PI
POWER (or ^)
PRODUCT
Steps to Reproduce:
1. Crete a query using SQL using the above functions
2.
3.
Actual Results:
"Syntax error in SQL statement"
Expected Results:
Consistent results
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.3.1 (AARCH64) / LibreOffice Community
Build ID: d8d1af5f77df955194e52baabe19324532ac8e8b
CPU threads: 8; OS: macOS 15.5; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
