Issue 18040 - statement improperly changed when executing sample query
Summary: statement improperly changed when executing sample query
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC2
Hardware: PC Windows 2000
: P3 Trivial with 1 vote (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 18039 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-08-08 16:47 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-08-08 16:47:14 UTC
* use a MySQL database of your choice, and import the script netjuke.sql from
issue 18039
(http://www.openoffice.org/issues/showattachment.cgi?attach_id=8345&file=netjuke.sql)
* create a ODBC data source for this database, and a OOo data source using the
ODBC data source
* create a new query, use the select statement in netjuke_query.sql from issue
18039
(http://www.openoffice.org/issues/showattachment.cgi?attach_id=8346&file=netjuke_query.sql)
* display this query in the data source browser
=> another query is executed. It seems that OOo incorrectly changed the
statement from

  SELECT `artists`.name, `albums`.name
  FROM `albums`, `tracks`, `artists`
  WHERE `albums`.id = `tracks`.al_id AND `artists`.id = `tracks`.ar_id
  GROUP BY `tracks`.al_id
  ORDER BY `artists`.name

to

  SELECT `artists`.`name`, `albums`.`name`
  FROM `albums`, `tracks`, `artists`
  GROUP BY `tracks`.`al_id`
  HAVING  0 = 1

which definately isn't equivalent
Comment 1 Frank Schönheit 2003-08-08 16:53:42 UTC
targeting.

fs->oj: Targeting this for 1.1.1 for now. Depending on the effort and
risk, we may re-target for 2.0.
Comment 2 Frank Schönheit 2003-08-08 22:11:38 UTC
*** Issue 18039 has been marked as a duplicate of this issue. ***
Comment 3 ocke.janssen 2003-08-26 12:19:32 UTC
change target
Comment 4 ocke.janssen 2003-08-26 14:45:44 UTC
Fixed in oj07
Comment 5 ocke.janssen 2003-09-23 07:34:26 UTC
Have to reopen it due to new bug. :-(
Comment 6 ocke.janssen 2003-11-28 10:17:55 UTC
.
Comment 7 ocke.janssen 2004-01-30 08:55:30 UTC
.fixed
Comment 8 hans_werner67 2004-02-02 12:32:23 UTC
change subcomponent to 'none'
Comment 9 ocke.janssen 2004-02-10 11:00:44 UTC
.
Comment 10 marc.neumann 2004-03-01 09:45:38 UTC
set to fixed
Comment 11 marc.neumann 2004-03-01 09:48:18 UTC
verify in CWS oj07
Comment 12 marc.neumann 2004-04-27 10:08:29 UTC
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc