https://bugs.freedesktop.org/show_bug.cgi?id=52097
Bug #: 52097
Summary: Report Builder edit of Data Filter results in bad SQL
syntax.
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
A report built with Report Builder containing the following data filter
executes correctly.:
( "Medical"."Date" >= {D '2011-01-01' } AND "Medical"."Date" < {D '2012-01-01'
} )
When edited in the filter criteria interface of Report Builder the result
becomes:
( "Medical"."Date" >= '{D ''2011-01-01'' }' AND "Medical"."Date" < '{D
''2013-01-01'' }' )
and, the report fails with an error message saying "Syntax error in SQL
expression".
(Note that the only edit made was to change the second date from 2012 to 2013.)
It appears that extraneous single quote (') marks are inserted in the SQL
command.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
