Created attachment 177322 [details] Two tables for testing - one has been changed column "Stamp"to default TIMESTAMP Open the attached database. There are two tables. Table1 has been changed through Tolls → SQL with ALTER TABLE "Table1" ALTER COLUMN "Stamp" SET DEFAULT CURRENT_TIMESTAMP; This give the useless message: 1: /home/buildslave/source/libo-core/connectivity/source/drivers/firebird/StatementCommonBase.cxx:420 but it works. Table2 is for testing this with a fresh table, but the message will be always the same. Nothing which says "Table has been changed" or "Default has been set" … This Bug appears in LO 7.3.0.1 on OpenSUSE 15.3 64bit rpm Linux
Hi Robert, All I see is "1:" displayed in the output window of the Tools > SQL window - is that what you mean ? I can confirm that the statement is executed and new entries into the table get the current timestamp.
Tested with Version: 7.3.0.1 / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 8; OS: Mac OS X 12.1; UI render: Skia/Metal; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
(In reply to Alex Thurgood from comment #1) > Hi Robert, > > All I see is "1:" displayed in the output window of the Tools > SQL window - > is that what you mean ? No, not only 1: Here is again the message it gives here in Tools → SQL 1: /home/buildslave/source/libo-core/connectivity/source/drivers/firebird/StatementCommonBase.cxx:420 … and this information is useless for a normal user, good for a developer to find the part of the code.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Robert Großkopf from comment #3) > > No, not only 1: > Here is again the message it gives here in Tools → SQL > > 1: > /home/buildslave/source/libo-core/connectivity/source/drivers/firebird/ > StatementCommonBase.cxx:420 Ah, sorry, then not reproducible on macOS for me - specific to Suse ?
I ran ALTER TABLE "Table1" ALTER COLUMN "Stamp" SET DEFAULT CURRENT_TIMESTAMP; via Tools - SQL and I saw the same message and nothing was done to the table (or at least I have no idea how to check it). Arch Linux 64-bit Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.4.3-1 Calc: threaded
(In reply to Buovjaga from comment #6) > I ran > > ALTER TABLE "Table1" ALTER COLUMN "Stamp" SET DEFAULT CURRENT_TIMESTAMP; > > via Tools - SQL and I saw the same message and nothing was done to the table > (or at least I have no idea how to check it). Input a new row, don't fill "Stamp" with data. Save the row. Current timestamp will be written. The SQL-code works, but the message is useless.
I gave a try with https://gerrit.libreoffice.org/c/core/+/154755
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9b887f63147914793f881c0cf4a730a46d6f688c tdf#146584: FB Setting default with ALTER TABLE works but gives useless message It will be available in 24.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.
Let's put this one to fixed. Don't hesitate to reopen this tracker if I missed something.