Fw: Inconsistency in data selection. count*

Stefan Manegold Stefan.Manegold at cwi.nl
Mon Jan 21 18:44:28 CET 2013


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

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) |



More information about the developers-list mailing list