Open the attachment form bug 143656. Go to Tools → SQL. Copy SELECT * FROM "Person" WHERE "Name" LIKE '%*' and paste it to "Command to execute". Chose "Show output of "select" statements". Now try to press "Execute". "Execute" won't be activated. This bug appears in Version: 7.2.0.2 / LibreOffice Community Build ID: 614be4f5c67816389257027dc5e56c801a547089 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded (OpenSUSE 15.2 64bit rpm Linux)
On pc Debian x86-64 with master sources updated today, I could reproduce this.
I don't reproduce on Win10 with LO 7.1.5.2
Caolán: any thoughts here even if it shouldn't be the welding process since direct sql conversion has been done in 2019 and the bug isn't reproduced in 7.1.5.2 ?
*** Bug 143648 has been marked as a duplicate of this bug. ***
Caolán: I wonder if it could be related to https://cgit.freedesktop.org/libreoffice/core/commit/?id=44f7674ffda49257dcc1709256dfc4676d12165c weld OQueryTextView its plausible with the EditEngine replacement for the SQL editor that the undo could be integrated better than the current check-if-the-text-has-changed timeout method. But that's left unchanged with this commit. but this one has been push in August 2020 so 7.1.5 should fail since it must include it. However, it seems the timer mechanism or at least the mechanism which detects that the text content changed may be related.
I think this is a problem since... commit 73c9ef661d9ef6237d3fd3c259fd040a545b44cf Date: Tue Jul 6 18:51:38 2021 +0200 tdf#132740 don't broadcast if modified status has not changed
lets try and rework this in light of how that changed how the editengine worked
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5b98dd53c7dc101d3a5ff693d3f0520ec1abd3d1 tdf#143657 'execute' button doesn't get enabled when contents changed 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.
backports to 7-2 and 7-2-0 in gerrit
I confirm I don't reproduce the bug with your patch, thank you Caolán!
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/ac5d22c15f2e374b4458145abfd458e58b2f2e77 tdf#143657 'execute' button doesn't get enabled when contents changed It will be available in 7.2.1. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-2-0": https://git.libreoffice.org/core/commit/508d9f5d9c33855735820ce272c6eee9f8dda09e tdf#143657 'execute' button doesn't get enabled when contents changed It will be available in 7.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.