Just another follow up on this.
Today I began migrating the test database and the test queries to MySQL.
My setup is WinXP SP2, MySQL 5.0.24 ( Latest stable release ), JDBC
5.0.3 latest release.
Since upgrading the server and the connector OOo 2.0.3 doesn't seem to
want to play nice at all - pretty much the same error with any select
statement:
"Unknown type 246 in column x or y in binary encoded result set" where x
and y are real numbers of course. This seems to happen with columns of
type double, real, date and datetime.
I don't think I changed any setting from the upgrade. Anyway using
OOD680_M1 all seems well.
But I digress, the interesting thing so far is this.
I have a test query in the HSQL test database of:
SELECT "ID", "VARCHAR_1", LEFT( "VARCHAR_1", 4 ) AS "RES_1" FROM "Table1"
This ends up becoming this for the MySQL test database:
SELECT `ID`, `VARCHAR_1`, LEFT( `VARCHAR_1`, 4 ) AS `RES_1` FROM
`openoffice`.`test_table_1` AS `test_table_1`
OK, so here is the odd part ( I might feel an issue coming on here ).
Both run fine with the designer turned on.
Both run fine in SQL view and escape processing turned on.
Turn escape processing off and the HSQL version runs as expected. Under
MySQL the column RES_1 is returned with a null string for a name and all
null values in the result set. Removing the column alias has no effect
- the query runs, but is useless in direct mode.
Any MySQL/JDBC guru's out there with any idea of what is up?
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
