https://bugs.documentfoundation.org/show_bug.cgi?id=173981
Bug ID: 173981
Summary: Query Editor: Changing Function will be ignored by
Button "Execute query" if Function only selected and
Cursor isn't set to other Position.
Product: LibreOffice
Version: 26.8.1.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 209092
--> https://bugs.documentfoundation.org/attachment.cgi?id=209092&action=edit
Littel database for testing. Follow instruction and start executing of query by
Icon, not by F5 or through Edit → Run Query.
Open the attach Base file.
Create a new query by GUI.
Choose table "tbl_Test".
Choose fields "Text" and "Date".
Choose function "Group" for field "Text".
Choose function "Maximum" for field "Date".
Execute this query directly by using Icon for executing query (without saving,
without setting cursor elsewhere).
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid expression in the select list (not contained in either an aggregate
function or the GROUP BY clause)
caused by
'isc_dsql_prepare'
Have a look at function for field "Date".
Function had been set back to "(no function)".
Choose function again, set cursor to blank field in "Criterion".
Now the query could be executed without any error.
Choose function again.
Press F5 or go to "Edit" → "Run Query".
Query will work well.
Expected behavior: A function, which had been selected, should be recognized by
the Icon.
Version: 26.8.1.1 (X86_64)
Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
