https://bugs.freedesktop.org/show_bug.cgi?id=77428
Priority: medium
Bug ID: 77428
Assignee: [email protected]
Summary: EDITING: Link field is corrupted with H2 JDBC
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.3.3 rc
Component: Database
Product: LibreOffice
Created attachment 97344
--> https://bugs.freedesktop.org/attachment.cgi?id=97344&action=edit
Editor meshes link field name.
Used H2 database engine 1.4.177.
Problem description:
Steps to reproduce:
1. Use a simple master-detail table construct with a foreign key constraint.
2. Use Wizard to Create a Form...
3. Open form.
Current behavior:
When a form is build, the Link field is corrupted with a starting double quote
replacing the first character of the field name and the last character is also
replaced with a double quote ("). Eg. FIELDNAME becomes "IELDNAM"
When hand correcting the .ods file with deleting the " out, in order to
get a working version, the link field name the "IELDNAM" version is displayed
in the editor.
Using the editor again, the field names will be redecorated with superfluous
double quotes.
This result in a "The data content could not be loaded." error, and the
database reports: Syntax error in SQL statement "SELECT * FROM
""TESTSLICK"".""CHEAPTRIP"".""PTR_FARES"" WHERE ( ""STOPPINGPLACE_B"" =
:[*]LINK_FROM_STOPPLACE ) "; expected "ALL, ANY, SOME, SELECT, FROM"; SQL
statement:
SELECT * FROM "TESTSLICK"."CHEAPTRIP"."PTR_FARES" WHERE ( "STOPPINGPLACE_B" =
:link_from_STOPPLACE ) [42001-177]
Expected behavior:
Performing with loaded data.
Operating System: Windows 7
Version: 4.2.3.3 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
