Issue 120022 - MySQL table is fine, but it is in trouble in base
Summary: MySQL table is fine, but it is in trouble in base
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-18 14:49 UTC by Fred Bakker
Modified: 2013-01-29 21:46 UTC (History)
4 users (show)

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

Attachments
File containing MySQL and Base information (852.50 KB, application/octet-stream)
2012-06-18 14:49 UTC, Fred Bakker 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Fred Bakker 2012-06-18 14:49:06 UTC 
Created attachment 78382 [details]
File containing MySQL and Base information

The table Alerts in MySQL looks fine; if you make a connection to it and ask for records it makes rubish of it. If you open a form with the correct field and field names you got rubish
Comment 1 Li Feng Wang 2012-06-21 07:59:10 UTC 
I use your table structure and data, and can't reproduce with AOO3.4 release version on WindowsXP.

my env:
1)MySQL server and Base are on the same machine.
2)connect Mysql with JDBC 
3)MySQL version 5.5.22
  MySQL JDBC Connector version 5.1.19
Comment 2 iplaw67 2012-06-21 09:57:29 UTC 
Fred,
It might help if you told us exactly which connector you are using...


Alex
Comment 3 r4zoli 2012-09-09 06:39:43 UTC 
No information about the connection type, change component to none.

The MySQL native driver development moved to apache-extras:
http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/
due to license incompatibilities.

If the bug connected to native driver, feel free to submit an issue in new place:
http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/issues/list