Hi,
I have done as you suggested and here is the result:
first tuple returned by the query *select * from notas_c where
instalacao=412307404;*
*[ 35004675, 412307404, 2007-10-22, 2011-06-14, "AF",
"", "AF01", "", 2007-10-30, "NPRO ARQU", "Laudo Válido
Improcedente//Enviado via Interface" ]*
The same tuple returned by direct query *select * from notas_c where
id=35004675;* :
*[ 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
Interface" ]*
*
*
Note the missing elements on the second tuple.
On Mon, Jun 10, 2013 at 3:04 PM, Martin Kersten
Hi,
I would advice you to first run the client with the ' -f raw' option, that will not truncate information. This can assure that all data is returned. Mclient has heuristics to deal with too many columns/ wide fields. This may be sitting the way your data is organised. A more restrictive target list for your query might help
regards, Martin
On 6/10/13 8:01 PM, 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-listhttp://mail.monetdb.org/mailman/listinfo/users-list
______________________________**_________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://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