https://bugs.documentfoundation.org/show_bug.cgi?id=97723
Bug ID: 97723
Summary: Query <= not working
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
I am using Libre 5.0.4,I am using libre base as front end and mysql as
backend,i had created a query of ChallanDate_Min and ChallanDate_Max using sql
design view,
SELECT "tbl_generateid".*,"tbl_particularid".*
FROM
"odb_vishwakarmaenterprises"."tbl_generateid" ,
"odb_vishwakarmaenterprises"."tbl_particularid"
WHERE
"tbl_generateid"."ChallanID" = "tbl_particularid"."Challan_ID"
AND
(("Party_ID" = :var_PARTY_ID) OR (:var_PARTY_ID IS NULL))
AND
(("ChallanDate" >= :var_DATE_FROM) OR (:var_DATE_FROM IS NULL))
AND
(("ChallanDate" <= :var_DATE_TILL) OR (:var_DATE_TILL IS NULL))
AND
(("ChallanID" = :var_CHALLAN_ID) OR (:var_CHALLAN_ID IS NULL))
The following where condition:
(("ChallanDate" <= :var_DATE_TILL) OR (:var_DATE_TILL IS NULL))
doesnot give values equal to :var_DATE_TILL buts gives values less than
:var_DATE_TILL.
And on contrary the following where condition:
(("ChallanDate" >= :var_DATE_FROM) OR (:var_DATE_FROM IS NULL))
gives perfect values of equal to greater than :var_DATE_FROM IS NULL.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
