| Summary: | Query → Edit in SQL-View treats file as changed when no changes have occurred | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | boriente <barryoriente> |
| Component: | Base | Assignee: | Caolán McNamara <caolan.mcnamara> |
| Status: | RESOLVED FIXED | ||
| Severity: | minor | CC: | caolan.mcnamara, iplaw67, raal, robert |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 7.2.2.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:7.3.0 target:7.2.5 | ||
| Crash report or crash signature: | Regression By: | ||
|
Description
boriente
2021-11-07 18:37:46 UTC
Think you are writing about a query: Right mouse click on a query Edit in SQL-View Query indicates it has been changed This happens here with LO 7.2.2.2, not with LO 7.1.5.2 on OpenSUSE 15.2 64bit rpm Linux. So it's a regression. @boriente : what do you mean by "when I open a SQL file in Base" ? There is no direct mechanism by which to open SQL files (which are usually text files, with a ".sql" file extension, unless you mean that you load them into Writer and yet you mention that the problem you are seeing doesn't occur in Writer ? Please be more precise in your detailed explanation of how to reproduce the problem. If Robert has correctly deduced that your are talking about copy/pasting a SQL query (presumably from a separate file), then please correct the title of this bug to reflect that. Sorry for the confusion. I'm not copy/pasting. I'm using BASE. I have a database that I have written queries against. When I right click the existing query in Base and choose "Edit in SQl Mode" the query opens as having been changed (see little red dot on the Save icon) when I haven't made any changes yet. This is from a previous comment by Robert Grobkopf (which pretty much sums up what just wrote above): Right mouse click on a query Edit in SQL-View Query indicates it has been changed This happens here with LO 7.2.2.2, not with LO 7.1.5.2 on OpenSUSE 15.2 64bit rpm Linux. So it's a regression. (In reply to boriente from comment #3) > Sorry for the confusion. > > I'm not copy/pasting. I'm using BASE. I have a database that I have written > queries against. When I right click the existing query in Base and choose > "Edit in SQl Mode" the query opens as having been changed (see little red > dot on the Save icon) when I haven't made any changes yet. > > > This is from a previous comment by Robert Grobkopf (which pretty much sums > up what just wrote above): > Right mouse click on a query > Edit in SQL-View > Query indicates it has been changed Thanks for the clarification, and I see that the title has already been changed to reflect the situation. Thanks to whoever it was ! This seems to have begun at the below commit. Adding Cc: to Caolán McNamara ; Could you possibly take a look at this one? Thanks 2a82ac4cd48a43ff63eb367b8804735565bc9a4b is the first bad commit commit 2a82ac4cd48a43ff63eb367b8804735565bc9a4b Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Aug 3 16:50:39 2021 +0200 source 5b98dd53c7dc101d3a5ff693d3f0520ec1abd3d1 https://git.libreoffice.org/core/+/5b98dd53c7dc101d3a5ff693d3f0520ec1abd3d1 tdf#143657 'execute' button doesn't get enabled when contents changed Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e467d936452bd428fe71339803fa22eb0a5f31e2 Resolves: tdf#145582 modify called too often 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. done in trunk, backport to 7-2 in gerrit Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/7cffe43f0dc063b90e60f1698c30444297fb6f6a Resolves: tdf#145582 modify called too often It will be available in 7.2.4. 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. 7.2.4 was a hotfix release, updating target in status-whiteboard |