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
<Martin.Kersten@cwi.nl> wrote:
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-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