Issue 18041 - "execute statement directly" not respected in data source browser
Summary: "execute statement directly" not respected in data source browser
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 (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-08 16:53 UTC by Frank Schönheit
Modified: 2010-11-10 16:13 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:53:32 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.
Comment 1 Frank Schönheit 2003-08-08 16:54:15 UTC
targeting
Comment 2 ocke.janssen 2003-08-20 10:11:44 UTC
Fixed in oj07
Comment 3 hans_werner67 2004-02-02 12:32:25 UTC
change subcomponent to 'none'
Comment 4 ocke.janssen 2004-02-10 11:01:05 UTC
.
Comment 5 marc.neumann 2004-02-11 11:22:59 UTC
verify in CWS oj07
Comment 6 marc.neumann 2004-02-11 11:23:17 UTC
verify in CWS oj07
Comment 7 marc.neumann 2004-04-27 10:08:02 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
Comment 8 guesoulkuhor 2010-11-10 16:13:09 UTC
Created attachment 73120