Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | basic join impossible with ODBC and JDBC | ||
---|---|---|---|
Product: | Base | Reporter: | Unknown <non-migrated> |
Component: | code | Assignee: | Frank Schönheit <frank.schoenheit> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P2 | CC: | issues |
Version: | OOo 1.0.2 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
Unknown
2003-05-16 22:49:40 UTC
Wrong component krevice, we should focus on one problem per IssueZilla issue - let's take the "select count(*)..." problem here. (For the problems of setting up MySQL, I suggest users@dba.openoffice.org). Can you attach a mysqldump of the table in question - just to be sure that we're all talking about the same when we try to reproduce this. Perhaps you want to fill it with some dummy data, if the original data is confidential. sorry for the delay in my response. i've been pugnaciously twiddling with my system trying to get MySQL 3.51 to work with UNIXodbc 2.2.5 and I have blown away MySQL 2.50 so I can't reproduce the problem. I finally got MySQL 3.51 to work with OpenOffice and the problem really doesn't occur. I still can't get the UNIXodbc gui, ODBCConfig, to work at all. In case anyone has similar problems, I get the error: ------- Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed and a gui window pops up saying: Failed to execute SQLManageDataSources(). <OK> when i click <OK>, i get a window that says: The most likely reason for this is that the Qt GUI plugin could not be found or could not be loaded. Ensure that libodbcinstQ.* files are in the library search path. The patch can be altered by setting the LTDL_LIBRARY_PATH environment variable. <OK> but the files exist in /usr/local/lib which is in my LD_LIBRARY_PATH and my LTDL_LIBRARY_PATH. ------- In summary, the following query works correctly for me now, but it didn't work with MySql 2.50: select count(*), publish from bugs left join buggroups on bug_id=bug_b where bug_b IS NULL and publish<>'rejected' and publish<>'batch-rejected' group by publish Therefore, this bug can be closed as a duplicate of 10479. Thanks and sorry for the duplicate! *** This issue has been marked as a duplicate of 10479 *** closing change subcomponent to 'none' |