Issue 87836 - list field after update 2.4 does not work - approved
Summary: list field after update 2.4 does not work - approved
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: OOo 2.4.1
Assignee: marc.neumann
QA Contact: issues@dba
Keywords: regression
Depends on:
Blocks: 88258
  Show dependency tree
Reported: 2008-04-03 20:34 UTC by lamron99
Modified: 2009-07-20 14:52 UTC (History)
1 user (show)

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

show create table File (2.32 KB, text/plain)
2008-04-08 20:09 UTC, lamron99
no flags Details
Screenshot Example after update 2.4 (159.57 KB, text/plain)
2008-04-08 20:10 UTC, lamron99
no flags Details
Database file with formular (38.32 KB, application/vnd.sun.xml.base)
2008-04-08 20:11 UTC, lamron99
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description lamron99 2008-04-03 20:34:10 UTC
I am using an writer document as a frontend for a mysql database.
There is one main table for the document and different other tables related to
the main table.
In the document I am using the related tables to fill list fields.
Since several versions of OO it worked witout any problem.
Now, after the update to 2.4 these list fields are empty.
Only when I click on it, I can see all the entries.
I re-installed Version 2.3.1 and everything is ok.
Best regards
Comment 1 Frank Schönheit 2008-04-07 14:06:55 UTC
any chance of providing a sample document to reproduce this, perhaps with the
result of a "SHOW CREATE TABLE <table_name>", which allows to reproduce the
structure of the involved table(s).
Comment 2 Frank Schönheit 2008-04-08 09:48:37 UTC
If there weren't the sentence "Only when I click on it, I can see all the
entries" in the bug description, I would assume it is the same problem as issue
88034 ...
Comment 3 lamron99 2008-04-08 20:09:02 UTC
Created attachment 52663 [details]
show create table File
Comment 4 lamron99 2008-04-08 20:10:04 UTC
Created attachment 52664 [details]
Screenshot Example after update 2.4
Comment 5 lamron99 2008-04-08 20:11:02 UTC
Created attachment 52665 [details]
Database file with formular
Comment 6 Frank Schönheit 2008-04-08 21:04:04 UTC
could reproduce with the given sample database/document, after adding some data.

effectively, for an existent (not a newly entered) record, the list boxes
display an empty string, instead of the string which they should take from their
underlying list.

Targeting to 2.4.1 (though note the target still needs to be approved by other
Comment 7 Frank Schönheit 2008-04-08 21:59:57 UTC
This was a speciality with how MySQL treated numeric columns ... There was an
optimization in OOo 2.4 that for filling the list boxes list, we now ask the
database directly, instead of letting the data pass a number of high-level
layers which do some normalization.
Now, one of those normalizations was that when we asked for the string value of
a numeric column, which contained for instance the number 10, then we got "10".
With the optimization, we asked the MySQL driver directly, which returns
"000010" in this case - which simply killed our program logic ...

Fixed in CWS dba241b.
Comment 8 Frank Schönheit 2008-04-08 22:06:55 UTC
correcting priority
Comment 9 marc.neumann 2008-04-23 10:15:15 UTC
verified in CWS dba241b

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
Comment 10 marc.neumann 2008-04-23 10:18:54 UTC
reassign to msc
Comment 11 uwe.luebbers 2008-04-28 11:59:24 UTC
added "approved" to the title, because it will be easier to work with the 2.4.1 meta issue 
during release status meetings.
Comment 12 uwe.luebbers 2008-04-28 12:00:22 UTC
added "approved" to the title, because it will be easier to work with the 2.4.1 meta issue 
during release status meetings.
Comment 13 marc.neumann 2008-04-28 12:31:54 UTC
FYI: an automatic test case for this issue will be written
Comment 14 thorsten.ziehm 2009-07-20 14:52:21 UTC
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
If you want to know more about the handling of fixed/verified issues =>