close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 14 years ago

Last modified 14 years ago

#1002 assigned defect

Problem in DBSeriesTable dealing with NULL Series

Reported by: jmdedios Owned by: Jorge
Priority: normal Milestone: Mantainance
Component: Database Version: 2.0.1
Severity: major Keywords: DBSeriesTable NULL
Cc:

Description

When you try to execute the following code, it generates this Warning:
Warning: [XXX] (Funcion DBSeriesTable) Fecha repetida en el registro 4 y2010m01d03 == y2010m01d03
and it generates a Set in which 'NoNULL' Serie doesn't start with value 1 on January first but with value 44 on January third.
It should show a warning saying that it will generate a NULL serie or something like that, and this shouldn't affect the next serie of the set.
This code is executed in TOL version 2.0.1 b.0.38.alpha.

Al ejecutar la siguiente expresión TOL produce un efecto extraño:
DBSeriesTable(
"select

'nom_' + nomCol,
fecha,
sum(val)

from
(

select NULL as nomCol, convert(datetime, '2010-01-03', 120) as fecha , 44 as val
from dual union
select 'NoNULL' as nomCol, convert(datetime, '2010-01-01', 120) as fecha, 1 as val
from dual union
select 'NoNULL' as nomCol, convert(datetime, '2010-01-02', 120) as fecha, 2 as val
from dual union
select 'NoNULL' as nomCol, convert(datetime, '2010-01-03', 120) as fecha, 3 as val
from dual union
select 'NoNULL' as nomCol, convert(datetime, '2010-01-04', 120) as fecha, 4 as val
from dual

) A
group by

'nom_' + nomCol,
fecha

order by

'nom_' + nomCol,
fecha", Diario, val?);

Change History (1)

comment:1 Changed 14 years ago by Víctor de Buen Remiro

Component: KernelDatabase
Milestone: Mantainance
Owner: changed from Víctor de Buen Remiro to Jorge
Status: newassigned
Note: See TracTickets for help on using tickets.