Issue 120022

Summary: MySQL table is fine, but it is in trouble in base
Product: Base Reporter: Fred Bakker <bakker.de.bruyne>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: iplaw67, issues, phoenix.wanglf, r4zoli
Version: 3.4.0   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
File containing MySQL and Base information none

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