Bug 152585 - Postgres Interval Keyword not Working
Summary: Postgres Interval Keyword not Working
Status: RESOLVED DUPLICATE of bug 51779
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-18 20:53 UTC by Alexander
Modified: 2022-12-18 22:51 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander 2022-12-18 20:53:30 UTC 
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
Comment 1 Stéphane Guillou (stragu) 2022-12-18 22:51:01 UTC 
I assume that this is because the interval datatype is not supported, which is tracked in bug 51779.

*** This bug has been marked as a duplicate of bug 51779 ***