Apache OpenOffice (AOO) Bugzilla – Issue 18040
statement improperly changed when executing sample query
Last modified: 2006-05-31 14:29:06 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
targeting. fs->oj: Targeting this for 1.1.1 for now. Depending on the effort and risk, we may re-target for 2.0.
*** Issue 18039 has been marked as a duplicate of this issue. ***
change target
Fixed in oj07
Have to reopen it due to new bug. :-(
.
.fixed
change subcomponent to 'none'
set to fixed
verify in CWS oj07
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