Bug 144712 - Database Advanced Settings: Help Inconsistent with Settings Window
Summary: Database Advanced Settings: Help Inconsistent with Settings Window
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
7.2.1.1 rc
Hardware: All All
: medium minor
Assignee: Olivier Hallot
URL:
Whiteboard: target:7.3.0
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2021-09-25 03:00 UTC by flywire
Modified: 2021-09-29 13:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Base_External_Table_Advanced-Settings (18.90 KB, image/png)
2021-09-25 03:00 UTC, flywire
Details
Full-source specialsettingspage dialog (69.23 KB, image/png)
2021-09-27 15:27 UTC, Olivier Hallot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description flywire 2021-09-25 03:00:38 UTC
Created attachment 175248 [details]
Base_External_Table_Advanced-Settings

In Base requires a SQLite database with a table in it - see https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite

1. run following SQL in Tools → SQL

CREATE TABLE org(
  name TEXT PRIMARY KEY,
  boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);

2. Right-Click a Table, Database, Advanced Settings

==========

1. Help topic is not in same order as Settings Window which makes it harder to use.
2. Note: Help 14 "Ignore currency field information" App description is "Respect the result set type from the database driver"

==========

Help App Description
1    1   Use SQL92 naming constraints
2    3   Use keyword AS before table alias names
3    11  End text lines with CR + LF
4    2   Append the table alias name in SELECT statements
5    4   Use Outer Join syntax '{OJ }'
6    5   Ignore the privileges from the database driver
7    6   Replace named parameters with ?
8    7   Display version columns (when available)
9    8   Use the catalog name in SELECT statements
10   9   Use the schema name in SELECT statements
11   10  Create index with ASC or DESC statement
12   16  Comparison of Boolean values
13   12  Form data input checks for required fields
14   15  Ignore currency field information
15   13  Use ODBC conformant date/time literals
16   14  Supports primary keys
Comment 1 Ming Hua 2021-09-25 07:01:33 UTC
The help being discussed here should be:
https://help.libreoffice.org/latest/en-US/text/sdatabase/dabaadvpropdat.html

Setting to NEW based on discrepancy between the attached screenshot and help text.
Comment 2 Olivier Hallot 2021-09-27 15:25:26 UTC
The actual dialog has more parameters than the image. See attached dialog source image.
Comment 3 Olivier Hallot 2021-09-27 15:27:17 UTC
Created attachment 175296 [details]
Full-source specialsettingspage dialog
Comment 4 Commit Notification 2021-09-27 17:54:09 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/1d27e06d9c1222fc7ef3d058cd78e6102aceaf47

tdf#144712 Add extended tips to special database settings dialog

It will be available in 7.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Commit Notification 2021-09-28 13:23:55 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/7a89e385e842191c215e407541a96343fbb5dc97

tdf#144712 Database Advanced Settings: Help Inconsistent
Comment 6 flywire 2021-09-29 13:05:45 UTC
(In reply to Commit Notification from comment #4)
> It will be available in 7.3.0.
Fixed:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 891dfac4bcb600cec2c860bde6d0c8607305102e
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded