Fw: Inconsistency in data selection. count*

Niels Nes Niels.Nes at cwi.nl
Mon Jan 21 19:20:40 CET 2013


On Mon, Jan 21, 2013 at 06:44:28PM +0100, Stefan Manegold wrote:
> Tapomay,
> 
> what exactly is / are all the differences between the two versions /
> instances?
> 
> Hardware, OS, compiler, MonetDB version, way the data is loaded/modified,
> etc.
> 
> Stefan

Tapomay,

My guess is that you created the data which now gives problems on a
earlier version which had bugs. Now you recreated with a fresh db.

Could you try to, reload your data (from scratch) like you did
on your new system, also on your old. Please let us know if
the problems persists.

Niels
> 
> On Mon, Jan 21, 2013 at 06:28:14AM -0800, Tapomay Dey wrote:
> > Forwarding to dev forum. Not appropriate for user list.
> > 
> > ----- Forwarded Message -----
> > From: Tapomay Dey <tapomay at yahoo.com>
> > To: Communication channel for Monet DB users <users-list at monetdb.org> 
> > Sent: Monday, January 21, 2013 2:39 PM
> > Subject: Inconsistency in data selection. count* 
> >  
> > 
> > select count(*) from table;
> > 
> > Results: 168466 rows
> > select count(*) from table where column=0;
> > 
> > Results: 168466 rows
> > select count(*) from table where column<>0;
> > 
> > Results: 168466 rows
> > 
> > When I do a "select column from table where client_id=0 limit 5;" I see correct non-zero values in the result although the selection condition is that the column value must be 0.
> > I put the data on another instance/machine - I don't see this issue.
> > 
> > Plz find a screenshot@ https://picasaweb.google.com/115470548136322675830/January212013?authuser=0&authkey=Gv1sRgCIDllbOOmqDqOQ&feat=directlink
> > 
> > Another case:
> > sql>select count(*) from table2 where column2=0;
> > | 391326 |
> > 
> > sql>select count(*) from table2 where column2<>0;
> > 
> > | 141108 |
> > sql>select count(*) from table2;
> > 
> > | 399326 |
> > 
> > sql>select column2 from table2 where column2=0 limit 5;
> > +-----------+
> > | column2 |
> > +===========+
> > |        53 |
> > |        53 |
> > |        53 |
> > |        53 |
> > |        53 |
> > +-----------+
> > 5 tuples (156.631ms)
> > 
> > Regards, 
> > Tapomay
> > _______________________________________________
> > users-list mailing list
> > users-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
> 
> > _______________________________________________
> > developers-list mailing list
> > developers-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/developers-list
> 
> 
> -- 
> | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
> _______________________________________________
> developers-list mailing list
> developers-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/developers-list

-- 
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098 	sip:4098 at sip.cwi.nl
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20130121/c629bc92/attachment.sig>


More information about the developers-list mailing list