﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1002	Problem in DBSeriesTable dealing with NULL Series	jmdedios	Jorge	"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""]]);"	defect	assigned	normal	Mantainance	Database	2.0.1	major		DBSeriesTable NULL	
