Description: when trying to edit the table of a HSQLDB database, the [Field Name] [Field Type] [Descrioption] should be shown and editable in columns as in LO V7.6 and earlier, but they are not Steps to Reproduce: 1. open an existing odb Database file 2. click on Tables on the left pane 3. right click on your table to edit the structure 4. nothing will appear Actual Results: the screen is empty. When trying to edit the table of a database, the [Field Name] [Field Type] [Descrioption] are not shown/editable in columns as in LO V7.6 and earlier Expected Results: when trying to edit the table of a database, the [Field Name] [Field Type] [Descrioption] should be shown and editable in columns as in LO V7.6 and earlier Reproducible: Always User Profile Reset: No Additional Info: recently installed — KB5039299 (OS Build 19045.4598) Preview
Created attachment 195080 [details] screenshot to edit Tables screenshot to edit Tables
Created attachment 195081 [details] screenshot of empty table screenshot of empty table
Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (en_US); UI: en-US Calc: CL threaded
this is the troublemaker ! Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: de-DE (en_US); UI: en-US Calc: CL threaded
Have opened a table of internal HSQLDB for editing. Could see all entries, but couldn't change any entry. Only possibility is to add new entries or to delete old entries. Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc 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 All works well with LO 24.2.4.2 on the same system. Have switched the title of this bug to show only one bug: Isn't editable.
Tested again. Have tested erroneously first with an external HSQLDB. With internal HSQLDB all works well. So I can't confirm the buggy behavior.
Reproducible Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded and Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: bff48f885e3aad560776a42e451a735ed6c72c57 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded With internal Firebird or HSQLDB Not reproducible with Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Created attachment 195092 [details] Screenshot showing the issue
Let's raise the importance, it's no possible to create or edit a database with this issue.
I repro with a Windows daily master build, but strangely not with the latest commits of 24.8 or 25.2 bibisect repos. On Linux everything works fine.
*** Bug 162066 has been marked as a duplicate of this bug. ***
I can reproduce with a brand new database, using the defaults (embedded HSQLDB), in the 24.8 RC1. It affects both Table Design View and Create View. Version: 24.8.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 318462181c709ed29c01eb3239b4d600d7b82ecc CPU threads: 4; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US
(In reply to Stéphane Guillou (stragu) from comment #12) > I can reproduce with a brand new database, using the defaults (embedded > HSQLDB), in the 24.8 RC1. Sorry, I meant beta 1, but prashantchanchal777 can reproduce with RC1 in duplicate bug 162066.
The problem exists also in other connections different than HSQL/Firebird (for example MariaDB), so the title shouldn't reflect any database name
I can reproduce it if I build with --enable-mergelibs=more @Noel, I thought you might be interested in this issue
Regression introduced by: author Noel Grandin <noel.grandin@collabora.co.uk> 2024-03-05 13:58:37 +0200 committer Noel Grandin <noel.grandin@collabora.co.uk> 2024-03-05 18:31:35 +0100 commit bacb92275c0c474d09146c0409cb547aef6551cf (patch) tree fdda8289ab70c6aec5beddaa9681db18ca5670b4 parent 74a31f1b262f9770409ee68e04433adb7e3ab10c (diff) add dbu to --enable-mergelibs=more
Issue not reproducible on mac when building with --enable-mergelibs=more
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ab704c00fd7a80e412b00cce9a8fb64e8937cc15 tdf#161865 Base Table Design View not editable It will be available in 25.2.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.
Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/43c15054a33fdd7d543f26dc9a46a6ba93d3271b tdf#161865 Base Table Design View not editable It will be available in 24.8.0.2. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e22dfeef0c0bfb4ed11ae08b2331a0103384f3f5 related tdf#161865: fix another ODR violation It will be available in 25.2.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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/789bc2e858f1ed5c05e4b83b41399289d481bddb related tdf#161865: fix another ODR violation It will be available in 24.8.0.2. 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.