BATsubselect: invalid argument: s must be sorted.

30 Jan 2013

      I keep getting a GDK error as follows:
Query succeeds if I change the order of filters in where clause!!!

sql>SELECT count(*****_sales) AS "Sales"
more>FROM tableName
more>WHERE client_id = 53
more>AND vendor_id = 1;
GDK reported error.
BATsubselect: invalid argument: s must be sorted.
sql>
sql>
sql>SELECT count(*****_sales) AS "Sales"
more>FROM tableName
more>WHERE vendor_id = 1
more>AND client_id = 53;
+--------+
| Sales  |
+========+
| 109593 |
+--------+
1 tuple (571.649ms)

I am running on an older revision of Feb13 branch.
Ubuntu 12.10
Attaching the MAL.

PS: http://www.mail-archive.com/checkin-list@monetdb.org/msg09267.html

Thanks and Regards,
Tapomay

BATsubselect: invalid argument: s must be sorted.

Tapomay Dey