[Libreoffice-bugs] [Bug 52097] New: Report Builder edit of Data Filter results in bad SQL syntax.

[bugzilla-daemon at freedesktop.org]

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: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jdm212 at juno.com


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.