[Libreoffice-bugs] [Bug 51767] New: RTL: Named Parameters not supported in MySQL ODBC queries in Ubuntu 12.04

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 51767
           Summary: RTL: Named Parameters not supported in MySQL ODBC
                    queries in Ubuntu 12.04
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.2 RC1
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: leeand00 at gmail.com


Created attachment 63873
  --> https://bugs.freedesktop.org/attachment.cgi?id=63873
A screenshot of the bug occurring.

Problem description: 
More information at the thread here: http://bit.ly/LSg9Sb

I added a single parameter to a query I was writing and I expected to see a
result; instead I saw a dialog box with some errors in it.

I have LibreOffice Base connected to MySQL using libmyodbc on Ubuntu 12.04


Steps to reproduce:
1. Install the following on Ubuntu 12.04: 

1.1. MySQL Database (Ver 14.14 Distrib 5.5.22 for debian-linux-gnu (i686) using
readline 6.2) 
1.2. LibraOffice Base (3.5.3.2 Build ID 350m1 (Build:2)). 

2. Install a database of some sort to query...

3. Connect via ODBC, and my /etc/odbc.ini looks like this: 

[DESP] 
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so 
Description = MyODBC 3.51 Driver DSN 
SERVER = localhost 
PORT = 
USER = root 
Password = XXXXX 
Database = DigitalEditionsSolution 
OPTION = 3 
SOCKET = 

4. Create a LibreOffice Base file and Configure it to connect via the ODBC
DataSource you defined above...

5. With the new LibreOffice Base file opened, click "Queries" and click "Create
Query in SQL View..."

6. Enter a query that contains a named parameter of the format ':parameterName'

7. Watch as the driver displays the same errors as listed in the description of
this bug.

Current behavior:
An error dialog is display when running the query with several errors display: 


"The data content could not be loaded"
"SQL Status: 07009

Invalid descriptor index."
"You tried to set a parameter at position '1' but there is/are only '0'
parameter(s) allowed. One reason may be that the property
"ParameterNameSubstitution" is not set to TRUE in the data source."

"The commmand leading to this error is:

SELECT `dfw`.`fk_desp_id`, `dfw`.`fk_dfws_id`, `dfw`.`Features_f_id`,
`desp`.`name` AS `DESP_Name`, `f`.`name` AS `FeatureName`, `dfws`.`name` AS
`ResponseState` FROM `DESP_Feature_Weak_State` `dfws` RIGHT OUTER JOIN (
`DigitalEditionsSolutionProvider` `desp` INNER JOIN ( `Features` `f` INNER JOIN
`DESP_Features_Weak` `dfw` ON `f`.`f_id` = `dfw`.`Features_f_id` ) ON
`desp`.`desp_id` = `dfw`.`fk_desp_id` ) ON `dfws`.`dfws_id` =
`dfw`.`fk_dfws_id` WHERE `desp`.`desp_id` = :despnum AND ( `f`.`name` =
`auto-linking-of-email-addresses:yes` OR `f`.`name` =
`auto-linking-of-urls:yes` OR `f`.`name` = `newsstandsupport:yes` ) ORDER BY
`fk_desp_id`
"

Expected behavior:
The results of the query displayed in a table.

Platform (if different from the browser): 
Ubuntu Linux 12.04 LTS

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