https://bugs.documentfoundation.org/show_bug.cgi?id=156816
Bug ID: 156816
Summary: Base Field Properties enhancement in table design
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
It would be better if it were possible to create tables in Base (Insert ->
Table Design...) with more details on the columns (Field Properties) composing
the table, like:
- Be able to specify the precision for SQL types TIMESTAMP and TIME
- Be able to give a default value for the column which can be an SQL function
of the underlying database (ie: CURRENT_TIMESTAMP(9))
Steps to Reproduce:
1. In Base create a new table with: Insert -> Table design...
2. Create a column of SQL type TIMESTAMP(9) (ie: with nanoseconds precision)
3. Set as default value for this column the SQL function CURRENT_TIMESTAMP(9)
Actual Results:
Neither the precision nor the default value will be taken into account in the
creation of the new table.
Expected Results:
Be able to control how Base displays and handles column property fields to be
able to create columns by setting precision and default value.
Reproducible: Always
User Profile Reset: No
Additional Info:
If we use the TypeInfoSettings
(https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/JDBCConnectionProperties.html#TypeInfoSettings)
property, as is used in the jdbcDriverOOo version 1.0.4 driver, then it is
possible to manage the precision on the TIMESTAMP and TIME (and TIMESTAMP WITH
TIME ZONE and TIME WITH TIME ZONE), however it is impossible to manage a
default value.
--
You are receiving this mail because:
You are the assignee for the bug.
