https://bugs.documentfoundation.org/show_bug.cgi?id=152450
Bug ID: 152450
Summary: PostgreSQL JDBC: Creating query - table alias is
always appended by GUI, special settings wont work
here
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open a JDBC-connection to PostgreSQL.
Create a query by the GUI.
Switch design view off.
Code is like this:
SELECT * FROM "public"."Table1" "Table1"
There is an alias for "public"."Table1".
Close the editor (query isn't needed any more).
Go to Edit → Database → Advanced Settings → Special Settings
"Append the table alias name on SELECT statements" isn't set.
You could set this or unset this - there is no difference while creating a
query in GUI.
This isn't only a "cosmetical" problem, because of
https://bugs.documentfoundation.org/show_bug.cgi?id=130376
An autoincremented value won't be shown in PostgreSQL if query is created with
an alias.
Every time you open a query in Design mode the alias will be set. So you have
to change to direct SQL code and remove the alias to get a query, which will
run with autoincremented values.
--
You are receiving this mail because:
You are the assignee for the bug.
