https://bugs.freedesktop.org/show_bug.cgi?id=54631
Bug #: 54631
Summary: : Running query containing CONCAT() field causes Base
to crash
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Database
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: lafcadio6...@gmail.com
Problem description: After updating to version 3.6.1.2, the queries containing
CONCAT() or "field1" || "field2" fields cannot be directly run without causing
Base to crash. Opening a form containing a listbox populated with such a query
also causes a crash. However, concat fields are still working within the
columns of a subform without causing a crash.
Steps to reproduce:
1. Query example:
SELECT "isbn" || ' - ' || "title" AS "article", "isbn", "title", "year",
"priceEur", "hide" FROM "tableCatalogue" WHERE "hide" = 0 ORDER BY "isbn" ASC
2. Same behaviour if query written as:
SELECT CONCAT( CONCAT( "isbn", ' - ' ), "title" ) AS "article", "isbn",
"title", "year", "priceEur", "hide" FROM "tableCatalogue" WHERE "hide" = 0
ORDER BY "isbn" ASC
Current behavior: CONCAT() causes Base to crash.
Expected behavior: CONCAT() works properly.
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20100101 Firefox/15.0
--
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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
