[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 Julien Nabet changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |serval2...@yahoo.fr |desktop.org | Status|NEW |ASSIGNED --- Comment #8 from Julien Nabet --- I gave a try with https://gerrit.libreoffice.org/c/core/+/154755 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 Julien Nabet changed: What|Removed |Added Blocks|116968 |51780 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base (for _new_ files) https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 Julien Nabet changed: What|Removed |Added Blocks||116968 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 --- Comment #7 from Robert Großkopf --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 Buovjaga changed: What|Removed |Added Ever confirmed|0 |1 CC||ilmari.lauhakangas@libreoff ||ice.org Status|UNCONFIRMED |NEW --- Comment #6 from Buovjaga --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 --- Comment #5 from Alex Thurgood --- (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 ? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 --- Comment #3 from Robert Großkopf --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 --- Comment #2 from Alex Thurgood --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Alex Thurgood --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146584] Firebird: Setting default with ALTER TABLE gives useless message but sets default
https://bugs.documentfoundation.org/show_bug.cgi?id=146584 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.