https://bugs.documentfoundation.org/show_bug.cgi?id=156534
Bug ID: 156534
Summary: Firebirds DATEADD function can't be executed in Design
View, only can be executed in SQL direcct
Product: LibreOffice
Version: 7.6.0.1 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Firebird's DATEADD function can't be executed in Design View, only can be
executed in SQL direct, so can't be used in editable queries, because SQL
Direct don't generate editable queries
Steps to Reproduce:
1. Create a table with at least one date field
2. Create a query in SQL View similar to this: SELECT "ID", "F1", DATEADD( DAY,
5, "F1" ) "F1+5" FROM "T1"
3. Execute the query in with *Run SQL command directly* activated
4. Try to execute the query with *Run SQL command directly* desactivated
Actual Results:
In 3. It runs, but the result query is not editable
In 4. It don't run
Expected Results:
In 4. It Should run and produce an editable query
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.0.1 (X86_64) / LibreOffice Community
Build ID: 776eaf34564cbf3f034a0ba1fd1d5c32ff9ccf1c
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
