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