Issue 106964 - Field size not changes in table design mode
Summary: Field size not changes in table design mode
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m61
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-17 08:01 UTC by r4zoli
Modified: 2013-02-07 22:33 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description r4zoli 2009-11-17 08:01:37 UTC 
Field size not changes in table design mode, with some data types.
binary, text, decimal, numeric. 
Reproduce:
- open existing table in edit mode or create new one,
- add new field
- select Field type: Tiny Integer field length became 8,
- change Field type to: text[varchar], field length not changes, remains 8,
- change Field type to: integer, field length became 32,
- change Field type to: text[varchar], field length not changes remains 32,
- change Field type to: double, field length became 64,
- change Field type to: text[varchar], field length not changes remains 64,
- change Field type to: date, field changes,
- change Field type to: text[varchar], field length changes to 50,
Comment 1 ocke.janssen 2009-11-30 09:12:04 UTC 
Which behavior do you prefer? I don't get where the error is. And is this also
true for OOo 320?
Comment 2 r4zoli 2009-11-30 09:44:01 UTC 
I checked again, it is same in 320, it not connected to hsqldb19.

May be it is not defect more an enhancement.

Can be better if you can get the default value when you change data type, in
design view.