Apache OpenOffice (AOO) Bugzilla – Issue 18041
"execute statement directly" not respected in data source browser
Last modified: 2010-11-10 16:13:09 UTC
* MySQL database * use the SQL script from issue 18039 to create sample data * create an ODBC data source and a OOo data source to connect to this sample data * create a new query for the OOo data source. Use the statement from netjuke_query.sql, from issue 18039, for this query * switch on "execute SQL statement directly" * save the query * display the query in the data source browser => The system loops The loop is issue 18039, but the what is brough up here is that the data source browser does not seem to respect the "execute directly" setting. The statement is transformed 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 fs->oj: Is there a good reason for this transformation? Finally, "execute directly" does mean "don't touch my statement", and we should interpret it this way.
targeting
Fixed in oj07
change subcomponent to 'none'
.
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
Created attachment 73120