Problem: InfoBright v3.3.1 and v3.3.2beta crash and disconnect with the following setup/query on Windows XP Pro:
1) create a new table
CREATE TABLE `MYTABLE` (
`ID` VARCHAR(100) NOT NULL
);
2) populate table with the following six rows of data:
100
100
200
300
300
300
3) run this query
(select distinct ID, count(ID) as aaa from MYTABLE where ID=‘100’ or ID=‘300’ group by ID)
union
(select distinct ID, 0 as aaa from MYTABLE where ID not in (select ID from MYTABLE where ID=‘100’ or ID=‘300’))
order by ID
4)
crash
5) desired output
ID aaa
100 2
200 0
300 3
Also, any suggestions on a more elegant way to write that query are appreciated :^)
