Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.0.11
-
None
-
2017-18, 2017-19, 2017-20, 2017-21
Description
The following table and query will cause exemgr to crash and not return results (happens whether the table has no rows or any values)
CREATE TABLE test.test (
|
id INT,
|
integerfield int
|
) ENGINE=Columnstore;
|
 |
SELECT id,
|
kpi1
|
FROM (SELECT id,
|
((SUM(integerfield))/
|
(SUM(integerfield))
|
)*100 kpi1
|
FROM test.test
|
GROUP BY id) kpi
|
WHERE kpi1 IS NOT NULL;
|
Removing either the *100 in the subquery or where kpi1 is not null causes the query to work.