Issue 110581 - dbase filter TimeStamp lower and equal (<=) bad Results
Summary: dbase filter TimeStamp lower and equal (<=) bad Results
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-03 10:20 UTC by f5w1k
Modified: 2013-08-07 15:45 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 f5w1k 2010-04-03 10:20:01 UTC 
I do a SELECT on Database-Table and TimeStamp Field like this:
SELECT "table"."TimeStamp" >= {D '2010-01-01' } AND "table"."TimeStamp" <= {D
'2010-03-31' }
The Output shows Records from 2010-01-01 to 2010-03-30
It works: >, >=, <, 
but <= works not
I tested it on OOo 3.1 and 3.2
Comment 1 marc.neumann 2010-04-06 10:39:21 UTC 
confirm, set target and send to the right developer.
Comment 2 Frank Schönheit 2010-11-24 10:06:04 UTC 
cannot reproduce, neither with 3.2.1, nor with DEV300m94.

fs->msc: Since you wrote you already reproduced this - care to attach a bug doc?