Bug 54631 - : Running query containing CONCAT() field causes Base to crash
Summary: : Running query containing CONCAT() field causes Base to crash
Status: CLOSED DUPLICATE of bug 53557
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-07 10:14 UTC by Lafcad
Modified: 2012-09-07 10:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lafcad 2012-09-07 10:14:30 UTC 
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
Comment 1 Alex Thurgood 2012-09-07 10:33:36 UTC 

*** This bug has been marked as a duplicate of bug 53557 ***