Hi, Matt, There is good reason for the difference. The cause is that the function doQuery is using the older style output routine while the function doQuaere is using a output routine with finer controls. Our intention is to switch to use doQuaere in the near term. In the short-term if you want to be sure to invoke doQuaere, then make sure you have a period in your query string (something very arbitrary;-), something like changing 0 to 0.0.
John On 3/27/13 11:04 AM, Matt Bomhoff wrote: > Hello, > > I am wondering why the output format is different for the two queries below > that only differ by the 'chr' where clause? Fastbit v1.3.5 is installed. > > Query1 > ====== > ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select > chr,start,stop,strand,value1,value2 where chr like 'NC_006090%' and start > 0 > and stop < 99999" > > "NC_006090.3", 32386, 32412, 1, 0.0332527, 0.0012 > "NC_006090.3", 32857, 32913, 1, 0.00270446, 5.4e-12 > "NC_006090.3", 68859, 68900, 1, 0.000538718, 0.00096 > "NC_006090.3", 69668, 69685, -1, 0.0133321, 0.0059 > > doQuery:: evaluate(SELECT chr,start,stop,strand,value1,value2 FROM 4 WHERE > chr like 'NC_006090%' and start > 0 and stop < 99999) produced 5 hits > > Query2 > ====== > ibis -d /opt/apache/CoGe/data//experiments/0/0/0/378 -q "select > chr,start,stop,strand,value1,value2 where chr='NC_006090.3' and start > 0 and > stop < 99999" > > doQuaere -- "SELECT chr,start,stop,strand,value1,value2 WHERE > chr='NC_006090.3' and start > 0 and stop < 99999" produced a table with 5 > rows and 6 columns > doQuaere -- the first row (of 5) from the result table for "SELECT > chr,start,stop,strand,value1,value2 WHERE chr='NC_006090.3' and start > 0 and > stop < 99999" > "NC_006090.3", 32386, 32412, 1, 0.0332527017466677, 0.0012 > > > The db was created with ardea -m \"chr:key, start:unsigned long, > stop:unsigned long, strand:byte, value1:double, value2:double\" > > Thanks! > Matt > _______________________________________________ > 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
