Hi,

I have the same request that I run on the same server, the same database in two different mclient.
The results are not the same.

There is no activity on the server, no other query running.

pcoustillas@groupelemonde:~$ mclient lemonde
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014-SP1)
Database: MonetDB v11.19.7 (Oct2014-SP1), 'mapi:monetdb://groupelemonde:50000/lemonde'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>TRACE SELECT count(*) FROM ref__cookies__lemonde__os;
+------+
| L1 |
+======+
| 97 |
+------+
1 tuple (14.885ms)
+-------+---------------------------------------------------------------------------------------------------------------------+
| ticks | stmt |
+=======+=====================================================================================================================+
| 2 | X_2 := sql.mvc(); |
| 13 | X_3:bat[:oid,:oid] =<tmp_32275>[97] := sql.tid(X_2=0,"sys","ref__cookies__lemonde__os"); |
| 32 | X_6:bat[:oid,:int] =<tmp_5355>[97] := sql.bind(X_2=0,"sys","ref__cookies__lemonde__os","id",0); |
| 9 | X_9=<tmp_26020>[97] := algebra.leftfetchjoin(X_3=<tmp_32275>:bat[:oid,:oid][97],X_6=<tmp_5355>:bat[:oid,:int][97]); |
| 1 | X_10 := aggr.count(X_9=<tmp_26020>[97]); |
| 503 | barrier X_31 := language.dataflow(); |
| 4 | sql.exportValue(1,"sys.L1","L1","wrd",64,0,6,X_10=97:wrd,""); |
| 0 | end s2_4; |
| 555 | function user.s2_4(); |
| 627 | X_5:void := user.s2_4(); |
+-------+---------------------------------------------------------------------------------------------------------------------+
10 tuples (14.976ms)

pcoustillas@groupelemonde:~$ mclient lemonde
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014-SP1)
Database: MonetDB v11.19.7 (Oct2014-SP1), 'mapi:monetdb://groupelemonde:50000/lemonde'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>TRACE SELECT count(*) FROM ref__cookies__lemonde__os;
+------+
| L1 |
+======+
| 0 |
+------+
1 tuple (6.841ms)
+-------+------------------------------------------------------------------------------------------------------------------+
| ticks | stmt |
+=======+==================================================================================================================+
| 2 | X_2 := sql.mvc(); |
| 13 | X_3:bat[:oid,:oid] =<tmp_47161>[0] := sql.tid(X_2=0,"sys","ref__cookies__lemonde__os"); |
| 9 | X_6:bat[:oid,:int] =<tmp_4226>[0] := sql.bind(X_2=0,"sys","ref__cookies__lemonde__os","id",0); |
| 9 | X_9=<tmp_17466>[0] := algebra.leftfetchjoin(X_3=<tmp_47161>:bat[:oid,:oid][0],X_6=<tmp_4226>:bat[:oid,:int][0]); |
| 1 | X_10 := aggr.count(X_9=<tmp_17466>[0]); |
| 531 | barrier X_29 := language.dataflow(); |
| 21 | sql.exportValue(1,"sys.L1","L1","wrd",64,0,6,X_10=0:wrd,""); |
| 0 | end s2_1; |
| 727 | function user.s2_1(); |
| 868 | X_5:void := user.s2_1(); |
+-------+------------------------------------------------------------------------------------------------------------------+
10 tuples (6.951ms)

any ideas ?

thanks

Pierre

--
1G6
52 route de bischwiller
67300 Schiltigheim
Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35