https://issues.apache.org/ooo/show_bug.cgi?id=125101
Issue ID: 125101
Issue Type: DEFECT
Summary: Base crashes when calculation included in query
Product: Base
Version: 4.1.0
Hardware: Mac
OS: Mac OSX, 10.7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83563
--> https://issues.apache.org/ooo/attachment.cgi?id=83563&action=edit
4 tables 1 query, no form
BASE crashes when I load this query. All tables & columns from them included in
query. Query originally set up using GUI. Query runs ok without calculation &
crashes when added.
Here is SQL.
SELECT "EXPENSES"."DATE", "EXPENSES"."MILES", "EXPENSES"."FARES",
"EXPENSES"."TOLLS_PARK", "EXPENSES"."MEALS", "EXPENSES"."HOTEL",
"EXPENSES"."EXPLAIN", "LOCATION"."LOCALE", "CATEGORY"."CATEG",
"DESCRIP"."DESC",
”MILES”*”MIRATE”+”MEALS”+”HOTEL”+”FARES”+”TOOL_PARK” AS "TOTAL"
FROM "EXPENSES", "LOCATION", "CATEGORY", "DESCRIP"
WHERE "EXPENSES"."LocID" = "LOCATION"."LocID"
AND "EXPENSES"."CatID" = "CATEGORY"."CatID"
AND "EXPENSES"."DescID" = "DESCRIP"."DescID"
I have added parens around MILES*MIRATE, I have removed the expression from
TOTAL & created a separate column ”MILES”*”MIRATE” AS "M_DLRS".
I then replaced MILES*MIRATE with M_DLRS in TOTAL equation.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
