Hi, Andreas, Here is how I understand the SQL standard,
select count(*) ... should return a table with one row and one column, and the content of the single value should be the value of "count(*)". So if you ask how many rows the table object has, it should return 1, similarly for the number of columns. One needs to get the actual content of the table to find out how many rows satisfy the query conditions. I guess what you want might be a tabula object. To get that one, leave the select clause a blank string or a nil pointer. Since I did not see anything in SQL standard about a missing select clause, I have implementation a table with a certain number of rows but without columns -- a fairly silly object, but might be what you are after. If anyone knows exactly what the SQL standard intended, please let us know. John On 3/3/2010 10:10 AM, Andreas Streichardt wrote: > Hi, > > the cursor of tabele currently returns wrong results. When creating a tabele > object the result is put into nrows and nRows() is hardcoded to return 1. > > However when using the tabele cursor to fetch the results it accesses nRows() > to get the result. This is wrong. It should access nrows directly in order to > get the correct result. > > Patch is attached. > > Kind regards, > > Andreas Streichardt > > > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
