On Mon, Feb 11, 2013 at 8:46 AM, Stephan Beal <[email protected]> wrote:
> Hiho, > > Summary: i'm getting an incorrect/unexpected MIN()/MAX() results and have > no clue why. After running these results by a colleague, we're both > confused, and thus this post. Here's my data (JMeter output) and results: > Is is possible that some of the [elapsed] values are strings instead of integers? What does this say: SELECT DISTINCT typeof(elapsed) FROM res WHERE label='access service'; > > SQLite version 3.7.16 2013-01-03 19:34:46 > (built from sources updated an hour or so ago) > ... > sqlite> .header on > sqlite> select * from res where label='access service'; > ts,elapsed,label,rc,msg,thread,dataType,success,bytes,latency > 1360586493370,27,access service,200,OK,Thread Group 1-1,text,true,4379,27 > 1360586494947,20,access service,200,OK,Thread Group 1-2,text,true,4378,20 > 1360586496927,6,access service,200,OK,Thread Group 1-3,text,true,4378,6 > 1360586499102,5,access service,200,OK,Thread Group 1-4,text,true,4378,5 > 1360586501135,6,access service,200,OK,Thread Group 1-5,text,true,4378,6 > 1360586503112,5,access service,200,OK,Thread Group 1-6,text,true,4378,5 > 1360586505116,7,access service,200,OK,Thread Group 1-7,text,true,4378,7 > 1360586507133,6,access service,200,OK,Thread Group 1-8,text,true,4378,6 > 1360586509333,6,access service,200,OK,Thread Group 1-9,text,true,4377,6 > 1360586511238,6,access service,200,OK,Thread Group 1-10,text,true,4378,6 > 1360586513321,6,access service,200,OK,Thread Group 1-11,text,true,4378,6 > 1360586515244,7,access service,200,OK,Thread Group 1-12,text,true,4378,7 > 1360586517295,6,access service,200,OK,Thread Group 1-13,text,true,4378,6 > 1360586519255,6,access service,200,OK,Thread Group 1-14,text,true,4378,6 > 1360586521261,5,access service,200,OK,Thread Group 1-15,text,true,4378,5 > 1360586523329,6,access service,200,OK,Thread Group 1-16,text,true,4378,6 > 1360586525316,6,access service,200,OK,Thread Group 1-17,text,true,4377,6 > 1360586527325,6,access service,200,OK,Thread Group 1-18,text,true,4378,6 > 1360586529301,6,access service,200,OK,Thread Group 1-19,text,true,4378,6 > 1360586531308,6,access service,200,OK,Thread Group 1-20,text,true,4378,6 > > > Notice that the min/max "elapsed" values are 5 and 27, respectively. Now my > results (which i cannot explain)... > > sqlite> SELECT label, count(*), MIN(elapsed), AVG(elapsed), MAX(elapsed) > FROM res where label='access service'; > label,count(*),MIN(elapsed),AVG(elapsed),MAX(elapsed) > access service,20,20,7.7,7 > > sqlite> SELECT label, count(*), MIN(elapsed), AVG(elapsed), MAX(elapsed) > FROM res where label='access service' GROUP BY label; > label,count(*),MIN(elapsed),AVG(elapsed),MAX(elapsed) > access service,20,20,7.7,7 > > sqlite> select count(*) from res where label='access service'; > count(*) > 20 > > sqlite> select MIN(elapsed) from res where label='access service'; > MIN(elapsed) > 20 > > sqlite> select AVG(elapsed) from res where label='access service'; > AVG(elapsed) > 7.7 > > sqlite> select MAX(elapsed) from res where label='access service'; > MAX(elapsed) > 7 > > sqlite> select label, MAX(elapsed) from res group by label; > label,MAX(elapsed) > access service,7 > autocomplete: choose LeadSource,70 > autocomplete: choose LeadType,79 > ... > > sqlite> select MIN(elapsed), MAX(elapsed) from res where label='access > service'; > MIN(elapsed) MAX(elapsed) > 20 7 > > > i'm very confused. Surely i'm doing something wrong here (as i refuse to > believe that this is an sqlite3 bug)? > > :-? > > PS: i'm not an sql guru. > > -- > ----- stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
