Issue 68601 - wrong column names / data when executing sample query on given MySQL database
Summary: wrong column names / data when executing sample query on given MySQL database
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m181
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks: 68046
  Show dependency tree
 
Reported: 2006-08-14 12:55 UTC by Frank Schönheit
Modified: 2008-02-13 06:26 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2006-08-14 12:55:38 UTC 
(MySQL 5.1, MySQL Connector/J 3.1.13
- import http://www.openoffice.org/nonav/issues/showattachment.cgi/38494/i68598.sql
  into a MySQL database of your choice
- create a MySQL/JDBC database document connecting to this database
- in this document, open a new query design in SQL mode
- enter the following SQL statement
SELECT `projects`.`Name` AS `Project name`, `parent projects`.`Name` AS `Parent
project name`, `employees`.`Name` AS `Lead`, `release`.`Name` AS `Release`, 0 AS
`sub projects`, `projects`.`InitialEffortMin` AS `init effort (min)`,
`projects`.`InitialEffortMax` AS `init effort (max)`, `projects`.`Comments`,
`projects`.`EndDate`, `categories`.`Name` AS `Category`, `projects`.`Status`,
`projects`.`URL`, `progress`.`Name` AS `Progress`, `teams`.`Name` AS `Team` FROM
`progress` AS `progress` RIGHT OUTER JOIN ( `employees` AS `employees` RIGHT
OUTER JOIN ( `projects` AS `projects` LEFT OUTER JOIN `release` AS `release` ON
`projects`.`Release` = `release`.`ProductID` ) ON `employees`.`EmployeeID` =
`projects`.`Lead` ) ON `progress`.`ProgressID` = `projects`.`Progress`,
`projects` AS `parent projects`, `categories` AS `categories`, `teams` AS
`teams` WHERE ( `parent projects`.`ProjectID` = `projects`.`ParentProject` AND
`categories`.`CategoryID` = `projects`.`Category` AND `teams`.`TeamID` =
`projects`.`Team` ) AND ( ( `projects`.`ParentProject` IS NOT NULL ) )
- execute the statement
=> there are two columns "Team" at the end of the result set, and the column
"EndDate" is completely missing.
- switch on "Execute SQL command directly" in the toolbar
- execute the statement
=> the columns in the result set are as expected
Comment 1 Frank Schönheit 2006-08-14 13:17:17 UTC 
targeting to 2.0.4 in agreement with QA (MSC)
Comment 2 Frank Schönheit 2006-08-14 13:48:53 UTC 
This used to work in m175. It broke somewhere between m175 and m181, but cannot
find out in more detail, since the query did not work before m181 because of
other bugs. Probably, this is a regression of CWS qiq.
Comment 3 Frank Schönheit 2006-08-15 12:05:22 UTC 
fixed in CWS dba204d

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba204d
Comment 4 marc.neumann 2006-08-17 09:26:09 UTC 
verified in CWS dba205a

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba205a
Comment 5 marc.neumann 2006-08-17 09:26:52 UTC 
reassign to msc
Comment 6 Frank Schönheit 2008-02-13 06:26:40 UTC 
seen in OOH680:m6, closing