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
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:
Depends on:
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: ---

File containing MySQL and Base information (852.50 KB, application/octet-stream)
2012-06-18 14:49 UTC, Fred Bakker
no flags Details

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
It might help if you told us exactly which connector you are using...

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:
due to license incompatibilities.

If the bug connected to native driver, feel free to submit an issue in new place: