https://bugs.documentfoundation.org/show_bug.cgi?id=152585
Bug ID: 152585
Summary: Postgres Interval Keyword not Working
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Connected to a postgres database when trying to save a query containing the
'interval' keywork I get an exception:
Postgres Version:
PostgreSQL 15.0 (Debian 15.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by
gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
Query:
select date_naissance + interval '1 month' from employe;
Error Stack Trace:
SQL Status: HY000
Error code: 1000
Syntax error in SQL statement at
/build/libreoffice-fresh/src/libreoffice-7.4.3.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:110
SQL Status: HY000
Error code: 1000
at
/build/libreoffice-fresh/src/libreoffice-7.4.3.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:109
SQL Status: HY000
Error code: 1000
syntax error at
/build/libreoffice-fresh/src/libreoffice-7.4.3.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:108
--
You are receiving this mail because:
You are the assignee for the bug.
