Apache OpenOffice (AOO) Bugzilla – Issue 108100
Table edit window not save default values to script
Last modified: 2013-08-07 15:45:09 UTC
Open attached database. Open Item table for edit, the DEALER (integer) field has default value 0. Open table for data input the default value is shown. Close database, rename file to .zip, open database script in text editor. In table the DEALER (INTEGER) field not contain default value. Consequence the relation designer will show error when this field go to the relationship: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=26194
Created attachment 67016 [details] bugdoc
confirm , set target and send to the right developer
this isn't easy to fix, and a long-standing problem: The defaults shown in the UI are *not* the defaults as known to the database engine, but "client-side" defaults. They're used only when displaying the respective table field in some form/control, but the engine doesn't know about it.
But this was the decided upon design, client side only. Is it now open to change?
not "now", probably ... I think that we should address this in the future, by distinguishing between client-side and server-side defaults. However, this is not done by passing, it needs non-negligible effort. Thus, given the list of other things, I'd say Marc was a little bit too optimistic with the "3.x" target.
I think at least should be warned in the field description.