Created attachment 71864 [details]
comparative screenshot between isql and ActualTech ODBC driver
On Mac OSX, it is possible to access mysql and postgresql data sources via the Actual Technologies ODBC driver. This is paying software, but a free trial is available for testing that returns the first three rows of the result set.
On the daily master build :
Version 184.108.40.206.alpha0+ (Build ID: 1e65f0176a9243274971321ffa5b6462130904e)
TinderBox: MacOSX-Intel@1-built_no-moz_on_10.6.8, Branch:master, Time: 2012-12-20_00:42:24
the display of the table is corrupted by spurious padding characters added after the actual data.
A screenshot comparison showing the data displayed using the ActualTechnologies driver and isql clearly shows this difference.
adding Lionel, Thorsten, Norbert to CC
I have contacted Actual Technologies about this with the same information.
Tested also with :
LO 334 : even worse display results, virtually all of the varchar/char fields are truncated to the first character of the data string
LO 357 : no problem, displays correctly.
LO 364 : no problem, displays correctly.
So this is definitely a regression introduced somewhere during 3.7/4.0 development.
Marking as such.
Are the affected fields only VARCHAR, or also CHAR?
The client field is VARCHAR, the country field is CHAR, so the answer is both. This sounds similar to the bug that we saw in the bibliography db, but I thought that had been fixed ?
(In reply to comment #5)
> Hi Lionel,
> The client field is VARCHAR, the country field is CHAR, so the answer is
> both. This sounds similar to the bug that we saw in the bibliography db, but
> I thought that had been fixed ?
The country field is a CHAR(2) field type.
*** This bug has been marked as a duplicate of bug 58693 ***