https://issues.apache.org/ooo/show_bug.cgi?id=123487
Bug ID: 123487
Issue Type: DEFECT
Summary: Impossible to add an Integer field type whose property
"Entry required" is set to Yes for a particular file
Product: Base
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
I have a strange OO Base file in which no matter which table I'm trying, I
cannot insert any new Integer field (ie column) whose "Entry required" property
is set to Yes.
I have reduced the file to contain only ONE table with one row data and the
problem is still reproducible. (Optional: even if the table contains no data,
the problem is still there)
Steps to reproduce the bug:
1. Open the appended base file (whose tables are using embedded HSQL database
engine)
2. Right-click on the only table and choose Edit
3. Insert a new field (ie column):
a. Name = i1
b. Type = Integer [INTEGER]
c. Change "Entry required" to "Yes"
4. Save
Result:
On step 4, there is an error dialog. "More" button gives the following details:
* SQL Status: S1000
Error while saving the table design
* SQL Status: s0021
Error code: -58
Column constraints are not acceptable in statement [ALTER TABLE "table1" ADD
"i1" INTEGER NOT NULL]
Notes:
* "checkpoint defrag" has no effect
* testing in both:
. XP Pro 32bit + JRE 7 update 40 + OOO 4.0.1
. Win7 Pro 64bit + JRE 7 update 40 + OOO 4.0.1
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
