[Libreoffice-bugs] [Bug 30919] New: SQL "CAST" function won't work on MySQL backend

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=30919

           Summary: SQL "CAST" function won't work on MySQL backend
           Product: LibreOffice
           Version: unspecified
          Platform: x86 (IA32)
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: libreoffice
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: omagaldadze at avoe.ge


reproduction:

1. Connect base to mysql database
2. make query with the following code:
   Select CAST("columnname" as CHAR) from "TABLE1" 

end it will yield an error msgbox.


The above code works fine on embedded (HSQLDB) database. It is persistent on
linux and windows. Also tried with native connector and jdbc connector.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.