https://bugs.documentfoundation.org/show_bug.cgi?id=153942
Bug ID: 153942
Summary: EDITING Default Value "CURRENT_TIMESTAMP" not shown
and not saved
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
New table, I want a TIMESTAMP column with an automatic value =
CURRENT_TIMESTAMP.
If I enter "CURRENT_TIMESTAMP" in the column's default value, save, close and
re-open the table, the defaut value is empty and "CURRENT_TIMESTAMP" is not use
if I insert a row in the table.
Bypass : I need to run the SQL Query : "ALTER TABLE "my-table" ALTER COLUMN
"my-timestamp-column" SET DEFAULT CURRENT_TIMESTAMP"
After that, the default value is still empty in the edit mode, but it is used.
--
You are receiving this mail because:
You are the assignee for the bug.
