Issue 67968 - in query edit, deleteing table results in bad sql
Summary: in query edit, deleteing table results in bad sql
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-07-31 07:32 UTC by jmills
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

Attachments
base file (67.11 KB, application/vnd.sun.xml.base)
2006-07-31 07:32 UTC, jmills 		no flags Details
create table sql script (3.04 KB, text/plain)
2006-08-01 08:51 UTC, marc.neumann 		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 jmills 2006-07-31 07:32:08 UTC 
attached base file; edit query "DeleteTableError"; select and delete
QualifyingTimes; run query.  says:

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

you now can't save, or view the sql to find out whats up.
this only happens if you can contact the (mysql) db.

if the db is offline, you can't edit the query in this way - you get an error
and the sql appears.  THEN you can edit the sql directly and save it!!!  used
this as workaround
Comment 1 jmills 2006-07-31 07:32:41 UTC 
Created attachment 38137 [details]
base file
Comment 2 marc.neumann 2006-08-01 08:51:51 UTC 
Created attachment 38167 [details]
create table sql script
Comment 3 christoph.lukasiak 2006-10-25 16:33:55 UTC 
does msc's hint help further - is this issue still alive?
Comment 4 christoph.lukasiak 2006-11-20 15:50:48 UTC 
no respond -> seems to be solved in between
Comment 5 christoph.lukasiak 2006-11-20 15:53:38 UTC 
close -> do not hestitate to reopen this issue if still occurs in current
version and you have anything to add to improve the reproducibility