My schema is:

create table my_table (col_a date, col_b varchar(1024), col_c varchar(128), col_d varchar(128), col_e varchar(128));

I have approx 5,000,000 entries.

The following queries not work:

select count(col_b) from my_table;

select distinct(col_b) from my_table;

select 1 from my_table group by col_b;

Giving the error:

GDK reported error.

BATproject: does not match always

They work fine on all other fields. I don't know precisely what triggers this. I've tried to create some small sample values but I can only reproduce this on my large data set.

I'm actually trying to do more interesting aggregation, but this is a minimal way to trigger the error. I'm using Jan2014-SP2 on Mac OS X 10.9.2 .

Thanks

Joe