Issue 59868 - Repeated Column errors on editing Integer, Decimal, Numeric data types
Summary: Repeated Column errors on editing Integer, Decimal, Numeric data types
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2005-12-29 09:43 UTC by beaucoder
Modified: 2006-05-31 14:29 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description beaucoder 2005-12-29 09:43:31 UTC
Using MySQL or JDBC drivers for MySQL tables. 

Cannot edit a table if it contains Integer, Decimal or Numeric columns.

Error: SQL Status: S1000

Unknown type '246 in column 6 of 14 in binary-encoded result set.

Error constantly appears on trying to edit/insert rows in the table.

If ALL columns are Varchar, for example, NO errors occur on edit/insert.

Changing the table layout and setting any column from Varchar to one of the
numerics (Integer, Decimal, Numeric) then invokes the error above if any numeric
data exists in the column modified. If it is empty, I can edit the table and put
a numeric value in the column. But after closing the table and attempting to
edit/insert into the table again I will repeatedly get the above error.

How to fix? Workaround??

Thanks,

Ken Wagner
Comment 1 christoph.lukasiak 2006-02-08 16:39:04 UTC
what jdbc driver do you use (ver. number)?
Comment 2 hwoarang 2006-02-25 14:30:24 UTC
Can't reproduce with OOo2.0.2rc3 x JDBC connector 3.1.12.

Ignoring the extreme slowness here, there's no error editing values in Integer
columns.

beaucoder, can you, please, try with latest version ?

thank you.

Hwoarang
Comment 3 christoph.lukasiak 2006-03-08 09:30:28 UTC
does this problem still occure - please send more details
Comment 4 hwoarang 2006-03-16 17:40:12 UTC
Closing due lack of information.

Reopen it if necessary.

Hwoarang
Comment 5 hwoarang 2006-03-16 17:40:31 UTC
closing.