Hi John, when i select "DISTINCT(c_1) as n, c_2" using the table::select interface on a table with more than one row i get the expected result:
"n" => number of distinct rows according to the value of column c_2 "count0" => number of matching rows according to the value of column c_2 "c_2" => respective value of column c_2 If i select the same on a table with only one row i get: "n" => value of column c_1 "count0" => 1 "c_2" => value of column c_2 If i select the same on a table with two rows having different values in c_2 i get this: "n" => value of column c_1 (i.e. 47) "count0" => 1 "c_2" => value of column c_2 (i.e. 2) "n" => value of column c_1 (i.e. 48) "count0" => 1 "c_2" => value of column c_2 (i.e. 1) I'm not sure if this is a feature or a bug could you please explain it to me. Kind regards, Bernd Jaenichen -- -- Bernd Jaenichen Senior Software Developer | [email protected] Phone +49 2233 7933 795 | Fax +49 2233 7933 788 Globalpark AG | Kalscheurener Str. 19a | 50354 Huerth | Germany Vorstand/Chief Executive Officer (CEO) | Dr. Lorenz Graef Vorsitzender d. Aufsichtsrats/Chairperson of the Supervisory Board | Dr. Richard C. Geibel | HRG Amtsgericht Koeln/Entered on Cologne Local Court Commercial Register | HRB 64032 GLOBALPARK - manage what matters | http://www.globalpark.de _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
