Issue 24073 - Query Designer forgets about comparison parameters
Summary: Query Designer forgets about comparison parameters
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-03 23:06 UTC by ucs0802
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
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 ucs0802 2004-01-03 23:06:23 UTC 
When designing a query like 
 
SELECT * FROM mytable WHERE floatfield_1 - floatfield_2 <> 0 order by mykey 
 
the UI Query designer will forget the 0 in the "criterion" field. You can 
save the query ok, but next time you edit it the 0 will be gone. If you don't 
edit the query you can use it as expected (e.g. in a spreadsheet). 
 
To reproduce: Create a query like the one above. Enter the "<> 0" into the 
criterion field. Save the query and close. The reedit the query. The criterion  
field will only have the "<>" in it, not the 0. Is there a problem with 
literals ? 
 
Platform: Mandrake 9.2 on i686 
DB: ODBC with PostgreSQL on the same machine (V 7.3.2) 
Oo 1.1.0 
UnixODBC 2.2.4
Comment 1 marc.neumann 2004-01-05 08:16:48 UTC 
Hi,

I can reproduce this. Here a step-by-step description for better reproducing
next time.

1. create a dbase tabel (Table1) with 2 decimal fields (number1 and number2)
2. insert some values
3. create a new query in the sql view and insert the following sql string.

select * from Table1 where number1 - number2 <> 0

4. execute the query everything works fine.
5. switch to the design view and back to the sql view

==>> error messages. The query can't execute anymore.

Send to the right developer and set a target.

Bye Marc
Comment 2 ocke.janssen 2004-01-29 10:40:34 UTC 
Fixed in cws oj08
Comment 3 hans_werner67 2004-02-02 12:21:10 UTC 
change subcomponent to 'none'
Comment 4 ocke.janssen 2004-02-02 14:11:37 UTC 
.
Comment 5 marc.neumann 2004-03-02 10:35:27 UTC 
set to fixed
Comment 6 marc.neumann 2004-03-02 10:35:47 UTC 
verify in CWS oj08
Comment 7 marc.neumann 2004-04-27 10:01:56 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