Issue 96936 - Report built with wizard can't execute query
Summary: Report built with wizard can't execute query
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2008-12-05 09:16 UTC by jcrovetti
Modified: 2009-09-30 09:42 UTC (History)
1 user (show)

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


Attachments
error msg box (95.68 KB, image/jpeg)
2008-12-05 09:17 UTC, jcrovetti
no flags Details
screen print of the sql editor and the value of the command in the report source (71.47 KB, image/jpeg)
2008-12-05 09:18 UTC, jcrovetti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jcrovetti 2008-12-05 09:16:36 UTC
I created a quite complex query.
To get it easier to read, it spreads on several lines in the sql query editor.
If I try to execute the query, it works fine.

Then I run report wizard. Everything goes fine : all the fields of the query are
detected.

Final step, I finish the report and try to execute it : it crashes and gives me
a msg box containing the whole query and telling me it cannot be executed.

I finnaly found the reason why : if you open the "report source" and go to the
"command" section, the value field contains the query of the report : the query
is converted by the wizard from multi-line (in the sql editor) to single line
WITHOUT adding any space between the formerly existing lines

If you remove what's in the "value" field, then the report works fine.
Comment 1 jcrovetti 2008-12-05 09:17:25 UTC
Created attachment 58533 [details]
error msg box
Comment 2 jcrovetti 2008-12-05 09:18:33 UTC
Created attachment 58534 [details]
screen print of the sql editor and the value of the command in the report source
Comment 3 drewjensen.inbox 2008-12-06 00:10:57 UTC
@jcrovetti - I have tried to duplicate the failure using the embedded database
model w/ 3.0 on Linux. Although I can see where the command is 'concatenated
w/out a space' as you show in this case the report does not fail. (hsqldb embedded)

- it appears that you are connecting to MySQL, is that correct? 

- I am changing the priority on the issue to a P3 per the standard issuetraker
documentation, see
http://qa.openoffice.org/scdocs/ddIssues_EnterModify.html#priority
Comment 4 jcrovetti 2008-12-06 16:43:46 UTC
Hi,

I use a Mysql database.
Sorry, I should have been more precise.
Comment 5 Mechtilde 2009-07-27 16:38:39 UTC
and which connector do you use?

Do you also try this query with the Sun-Report-Builder?
Comment 6 Mechtilde 2009-09-30 09:41:50 UTC
no response -> invalid
Comment 7 Mechtilde 2009-09-30 09:42:17 UTC
-< closed