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 17 years ago

Last modified 14 years ago

#593 new defect

DBSeriesColumn doesn't work with null

Reported by: mdiaz Owned by: Jorge
Priority: high Milestone:
Component: Database Version: 1.1.6
Severity: critical Keywords:
Cc: Alfredo Torre, Javier Portugal

Description

DBSeriesColumn dosen't work. Try to run this code, C1 takes the value of NULL.

Text Query.001 =
"
select 'c1' as id_ser, convert(datetime, '20080101', 120) as id_date, 3 UNION
select 'c1' as id_ser, convert(datetime, '20080102', 120) as id_date, 2 UNION
select 'c1' as id_ser, convert(datetime, '20080103', 120) as id_date, 1 UNION
select NULL as id_ser, convert(datetime, '20080101', 120) as id_date, 8 UNION
select NULL as id_ser, convert(datetime, '20080102', 120) as id_date, 7 UNION
select NULL as id_ser, convert(datetime, '20080103', 120) as id_date, 6
order by 1, 2
";
Set XXXXXXX.001 = DBSeriesColumn(Query.001, C, 0);

Change History (2)

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

Component: SetAlgebra → Database
Owner: changed from Víctor de Buen Remiro to Jorge
Summary: Dosen't work with null → DBSeriesColumn doesn't work with null

comment:2 Changed 14 years ago by Pedro Gea

Priority: highest → high
Note: See TracTickets for help on using tickets.