On Mon, Jun 10, 2013 at 9:34 PM, Flavio Coelho <
fccoelho@gmail.com> 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 <
Stefan.Manegold@cwi.nl>
> 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 <
fccoelho@gmail.com> 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
>