Strange error

This message was edited 1 time. Last update was at 12 Jan 2010 13:15:42

Hi GridSQL Team,

I'm encoutering an error when I try to get a percentage of a population in gridsql.

Here's a test setup:

create table tmp_test1234 (id int) REPLICATED;

insert into tmp_test1234 VALUES (1);
insert into tmp_test1234 VALUES (2);
insert into tmp_test1234 VALUES (3);
insert into tmp_test1234 VALUES (4);
insert into tmp_test1234 VALUES (5);
insert into tmp_test1234 VALUES (6);
insert into tmp_test1234 VALUES (7);
insert into tmp_test1234 VALUES (;

SELECT count(*) as counter, (SELECT COUNT(*) from tmp_test1234) as total
FROM tmp_test1234;

Running the query on the replicated table returns:
8;8

However, on a partitioned table, gridsql returns the values for each node in the cluster:
8;8
8;8
8;8
8;8
8;8
8;8
8;8
8;8

Any thoughts?

Thanks

Jon

Actually, it should complain about using a subquery in the SELECT clause (you can use subqueries in the FROM clause). Please rewrite your query in such a manner.

Regards,

Mason Sharp