Bug 1249704
| Summary: | Parameters do not work with LIKE in BASE | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | John Griffiths <fedora.jrg01> |
| Component: | libreoffice | Assignee: | Caolan McNamara <caolanm> |
| Status: | CLOSED UPSTREAM | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 22 | CC: | caolanm, dtardon, erack, ltinkl, mstahl, sbergman |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-08-04 07:23:08 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Description of problem: Parameters do not substitute correctly when using the LIKE keyword in a WHERE clause of a query. Version-Release number of selected component (if applicable): libreoffice-base-4.4.4.3-6.fc22.x86_64 How reproducible: always Steps to Reproduce: 1. Create a query using LIKE without a parameter and execute it. It returns records. 2. Substitute a parameter for part of the LIKE. 3. Execute it. Receive error. Actual results: Get error. Using More from error dialog shows "SQL Status: 22023 The column index is out of range: 1, number of columns: 0." Expected results: Data should return. Additional info: Here are two queries. One without parameter that works and one with that does not work. The parameter is prompted for by LibreOffice, the query is just not executed properly. SELECT "first_name", "last_name", "spouse", "address", "ml_num", "ml_address" FROM "floridasun"."contacts" "contacts" WHERE lower("address") like '%' || 'venice' || '%' SELECT "first_name", "last_name", "spouse", "address", "ml_num", "ml_address" FROM "floridasun"."contacts" "contacts" WHERE lower("address") like lower('%' || :address || '%')