Re: Inconsistency in select

10 Jun 2013


      I get the same missing columns.

On Mon, Jun 10, 2013 at 4:44 PM, Lefteris  wrote:
...
Hi,
trying giving the following command inside the mclient before running
any queries.
\w-1
do you still see missing columns? If yes, we will need to have a
closer look at the problem, otherwise it is just mclient trimming
columns to make a better presentable result.
On Mon, Jun 10, 2013 at 9:34 PM, Flavio Coelho  wrote:
...
It is not. The tuple returned by the second query has no missing data. On
the first line of the table generated by the first query,  there is Two
missing elements in the tuple.
can you see it?
On Mon, Jun 10, 2013 at 3:26 PM, Stefan Manegold 
wrote:
...
Dear Flavio,
please correct me if I'm wrong, but to me is appears that the one tuple
returned by your second query it the first tuple returned by your first
query, isn't it?
If so, I see no problem at all ...
But as said, maybe I overlook something or understood your
question/problem wrongly ...
Best,
Stefan
Flavio Coelho  wrote:
...
Dear list,
We have found this strange inconsistency when selecting from data.
Consider the two following select clauses:
in the first one with a "where" filter, we notice a number of missing
data on the resulting table (hint: they are not really missing in the
database).
However if we look to any of the specific lines which appear to have
missing data, as done in the second select, we confirm that the data is
there (not missing).
What is going on? Am I doing anything wrong? Is this a bug of the
mclient?
the version I am running is this:
MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)
sql>select * from notas_c where instalacao=412307404;
+-------------+-----------+------------+------------+------+--------------+------+------------------------------+------------+-----------+--------------------------------------------------+
...
...
| id          | instalaca | data_de_cr | data_do_en | tipo |
descricao_do
| codi | descricao_da_codificacao_da_ | data_fim_d | status_do |
descricao_do_status_do_usuario                   |
:             : o         : iacao_da_n : cerramento : _de_ :
_tipo_de_not
: fica : nota                         : a_avaria   : _usuario  :
:
:             :           : ota        : _da_nota   : nota : a
: cao_ :                              :            :           :
:
:             :           :            :            : _de_ :
: da_n :                              :            :           :
:
:             :           :            :            : serv :
: ota  :                              :            :           :
:
:             :           :            :            : ico  :
:      :                              :            :           :
:
+=============+===========+============+============+======+==============+======+==============================+============+===========+==================================================+
...
|    35004675 | 412307404 | 2007-10-22 | 2011-06-14 | AF   |
| AF01 |                              | 2007-10-30 | NPRO ARQU | Laudo
Válido Improcedente//Enviado via Interface |
| 10009362195 | 412307404 | 2009-10-28 | 2009-10-31 | AL   |
| AL06 |                              | 2009-10-31 | VIRE EXEC |
Vistoria
Reprovada//Executada no Campo           |
| 10009372721 | 412307404 | 2009-10-29 | 2009-11-17 | AG   |
| AG22 |                              | 2009-11-17 | PRO       |
Procedente
|
| 10009455607 | 412307404 | 2009-11-10 | 2009-11-17 | AD   |
| AD05 |                              | 2009-11-16 | EXEC      |
Executada
no Campo                               |
| 10010449356 | 412307404 | 2010-03-30 | 2010-08-11 | AJ   |
| AJ11 |                              | 2010-08-11 | EXEC      |
Executada
no Campo                               |
| 10010832683 | 412307404 | 2010-05-21 | 2010-05-24 | AD   |
| AD05 |                              | 2010-05-24 | REJE      |
Rejeitada
|
| 10011114747 | 412307404 | 2010-06-29 | 2010-06-30 | AG   |
| AG44 | Serviço fora do prazo        | 2010-06-30 | IMP       |
Improcedente                                     |
| 10011308855 | 412307404 | 2010-07-22 | 2010-07-28 | AD   |
| AD05 | BO - Manutenção na lente     | 2010-07-28 | EXEC      |
Executada
no Campo                               |
| 10011475191 | 412307404 | 2010-08-11 | 2010-08-16 | AB   |
| AB08 | AB08 Auc c/subst c ramal Tri | 2010-08-16 | EXEC      |
Executada
no Campo                               |
| 10012702114 | 412307404 | 2011-01-05 | 2011-01-10 | A3   |
| A375 | Corte MCV exec na rede       | 2011-01-07 | EXEC      |
Executada
no Campo                               |
| 10014234776 | 412307404 | 2011-06-14 | 2011-06-15 | A3   |
| A375 | Corte MCV exec na rede       | 2011-06-15 | EXEC      |
Executada
no Campo                               |
| 10014271409 | 412307404 | 2011-06-15 | 2011-06-16 | A5   | Religação
BT
| A513 | Religa Normal-Exec Rede      | 2011-06-16 | EXEC      |
Executada
no Campo                               |
+-------------+-----------+------------+------------+------+--------------+------+------------------------------+------------+-----------+--------------------------------------------------+
...
12 tuples (0.9s)
sql>select * from notas_c where id=35004675;
+----------+-----------+------------+------------+------+--------------------+------+--------------------------------+------------+-----------+---------------------------------------------+
...
| id       | instalaca | data_de_cr | data_do_en | tipo |
descricao_do_tipo_ | codi | descricao_da_codificacao_da_no |
data_fim_d |
status_do | descricao_do_status_do_usuario              |
:          : o         : iacao_da_n : cerramento : _de_ : de_nota
: fica : ta                             : a_avaria   : _usuario  :
:
:          :           : ota        : _da_nota   : nota :
: cao_ :                                :            :           :
:
:          :           :            :            : _de_ :
: da_n :                                :            :           :
:
:          :           :            :            : serv :
: ota  :                                :            :           :
:
:          :           :            :            : ico  :
:      :                                :            :           :
:
+==========+===========+============+============+======+====================+======+================================+============+===========+=============================================+
...
| 35004675 | 412307404 | 2007-10-22 | 2011-06-14 | AF   | VerifTensão
Fornec | AF01 | Verif Tensão Fornecimento - BT | 2007-10-30 | NPRO
ARQU |
Laudo Válido Improcedente//Enviado via Inte |
:          :           :            :            :      :
:      :                                :            :           :
rface
:
+----------+-----------+------------+------------+------+--------------------+------+--------------------------------+------------+-----------+---------------------------------------------+
...
1 tuple (325.965ms)
--
Flávio Codeço Coelho
================
+55(21) 3799-5567
Professor
Escola de Matemática Aplicada
Fundação Getulio Vargas
Praia de Botafogo, 190 sala 312
Rio de Janeiro - RJ
22250-900
Brasil
________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
--
| Stefan.Manegold@CWI.nl | Database Architectures (DA) |
| www.CWI.nl/~manegold | Science Park 123 (L321) |
| +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
--
Flávio Codeço Coelho
================
+55(21) 3799-5567
Professor
Escola de Matemática Aplicada
Fundação Getulio Vargas
Praia de Botafogo, 190 sala 312
Rio de Janeiro - RJ
22250-900
Brasil
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
-- 
Flávio Codeço Coelho
================
+55(21) 3799-5567
Professor
Escola de Matemática Aplicada
Fundação Getulio Vargas
Praia de Botafogo, 190 sala 312
Rio de Janeiro - RJ
22250-900
Brasil