Issue 88394 - Editing a query in design view causes an SQL error
Summary: Editing a query in design view causes an SQL error
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: OOo 2.4.1
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-04-17 15:21 UTC by jwt
Modified: 2008-05-05 13:02 UTC (History)
1 user (show)

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

Attachments
Sample database (23.86 KB, application/vnd.sun.xml.base)
2008-04-19 17:13 UTC, jwt 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jwt 2008-04-17 15:21:40 UTC 
Steps:
I open a query in design view
I make an alteration, say change the position of a column
I try to close the query saving the changes
I get a "Syntax error in SQL expression" message:
SQL Status: HY000
Error code: 1000

This seems to have started happening since I upgraded to OOo 2.4.0 (in Debian Lenny)
Comment 1 Frank Schönheit 2008-04-18 20:45:26 UTC 
cannot reproduce. Care to add more information about your distribution, your OOo
version (the one from www.openoffice.org or the distribution's version?). Best
would be if you attach a small sample database which allows to reproduce the
problem.
Comment 2 jwt 2008-04-19 17:03:47 UTC 
The problem seems to arise when there is a POSITION function in the SQL.  I will
attach a sample database.
The version is this one: http://packages.debian.org/lenny/openoffice.org .
Comment 3 jwt 2008-04-19 17:13:47 UTC 
Created attachment 53032 [details]
Sample database
Comment 4 Frank Schönheit 2008-05-05 10:43:06 UTC 
Can reproduce with the attached sample database - thanks for providing it.

Confirming, assigning, adding "regression" keyword.

Targeting to 2.4.1. Note this is still subject to approval by the Release Status
Team.
Comment 5 ocke.janssen 2008-05-05 11:23:56 UTC 
The statement in the query contains an error which we accepted in 2.3.1. You
have to change it like
SELECT "Data"."ID", "Data"."CustomerID", "Data"."Town", "Data"."Telephone",
"Map"."Description", "Data"."MoreData" FROM "Map" AS "Map", "Data" AS "Data"
WHERE "Map"."CustomerID" = "Data"."ID" AND POSITION( 'i' IN "Town" ) <> 0
The function POSITION returns an integer and is compared in the example with a
String. When you change that one into an Integer all went well.

Best regards,

Ocke
Comment 6 christoph.lukasiak 2008-05-05 13:02:18 UTC 
=> close