No, Id is not set as primary key. here is the schema: sql>\d notas_c CREATE TABLE "sys"."notas_c" ( "id" BIGINT, "instalacao" BIGINT, "data_de_criacao_da_nota" DATE, "data_do_encerramento_da_nota" DATE, "tipo_de_nota_de_servico" VARCHAR(32), "descricao_do_tipo_de_nota" VARCHAR(256), "codificacao_da_nota" VARCHAR(32), "descricao_da_codificacao_da_nota" VARCHAR(256), "data_fim_da_avaria" DATE, "status_do_usuario" VARCHAR(32), "descricao_do_status_do_usuario" VARCHAR(256) ); Yes we will open a bug report. thanks, Flávio On Mon, Jun 10, 2013 at 4:53 PM, Lefteris <lsidir@gmail.com> wrote:
yes! from what you send it seems like it is returning empty strings, not trimming columns. Is id set as primary key?
Can you fill in a bug report including the schema and the least amount of data that reproduces this problem?
thank you
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
On Mon, Jun 10, 2013 at 9:47 PM, Flavio Coelho <fccoelho@gmail.com> wrote: 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
-- 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