On Mon, Jun 10, 2013 at 9:47 PM, Flavio Coelho <
fccoelho@gmail.com> wrote:
> I get the same missing columns.
>
>
> On Mon, Jun 10, 2013 at 4:44 PM, Lefteris <
lsidir@gmail.com> 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 <
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
>> >
>> > _______________________________________________
>> > 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
>
> _______________________________________________
> 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