To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114309
Issue #|114309
Summary|NULL Boolean values being sent when NOT NULL specified
| in SQL Create Table
Component|Database access
Version|OOo 3.2.1
Platform|Macintosh
URL|
OS/Version|Mac OS X
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|anotheralan
--- Additional comments from anothera...@openoffice.org Sat Sep 4 14:36:52
+ 2010 ---
If a table is created directly from SQL with a Boolean field that is set to NOT
NULL, errors arise when trying to insert new records where no changes are made
to the field.
(Note: there is a related bug
"http://www.openoffice.org/issues/show_bug.cgi?id=114304"; where DEFAULT values
for booleans are not being set properly, but this addresses a case where no
Default value is defined, but NOT NULL is. According to the HSQLDB docs
"http://hsqldb.org/doc/guide/ch09.html#create_table-section"; this should be a
valid definition).
Editing the table, the boolean field initially appears in an unchecked/FALSE/No
state, but if no change is made to it, a NULL value is sent when attempting to
create the record. This causes an error as described below.
For a walkthru example:
>From the Tools->SQL... Menu, run the following to create a new table with a
boolean value set to NOT NULL:
CREATE TABLE "testTable" ("pKey" INTEGER IDENTITY PRIMARY KEY, "testBool"
BOOLEAN NOT NULL, "testText" VARCHAR(50));
Run the View->Refresh Tables option to see the update table.
In the "Tables" view, double click on the "testTable" to open it directly.
The "testBool" field shows up as unchecked/FALSE.
Enter some text in the "testText" field and hit return or tab to add the
record.
An error occurs saying:
Error inserting the new record
Attempt to insert null into a non-nullable column: column: testBool table:
testTable in statement [INSERT INTO "testTable" ("testBool", "testText") VALUES
(?,?)]
Toggle the testBool to checked/TRUE and then back to unchecked/FALSE and try to
insert the record again and it works as expected.
-
Opening the testTable in edit mode, the GUI presents the default value for
"testBool" as "No". However, this does not correspond with the behavior seen
above. If the Default value in the GUI is toggled to "Yes" and then back to "No"
and saved, data entry directly into the table as described above works as
expected with no errors. (Note, you may have to click out of the Default value
field after changing to "Yes" in order for it to be seen as a change.)
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
