I have a problem with using a Futures query on a query that does not have
explicit columns. The query that is problematic is as follows: "SHOW META;"
(see http://sphinxsearch.com/docs/1.10/sphinxql-show-meta.html) This query
returns a table that always has two columns and several rows. Now when I
execute the query as follows, everything works fine:
var query = session.CreateSQLQuery("SHOW META");
var metaData = query.List(); // metadata is a list of object[] instances of
length two
The variable "metadata" will now contains a list of object[] instances of
length 2, where each object[] item in the list contains the value of the first
column (Variable_name) and the value of the second column (Variable).
However, when I try to convert this query to a Futures query, I get back a list
of object[] instances of length 0:
var query = session.CreateSQLQuery("SHOW META");
var futureQuery = query.Future<object[]>();
var values = futureQuery.ToList();
var metaData = query.List(); // metadata is a list of object[] instances of
length zero
In other words, I do get an object[] for each row in the result but there is no
data added to it. What am I doing wrong? Or is this a limitation of NHibernate?
