Project: Birt
Bug 236561 Result set from temp table returns null
Reported: 2008-06-10 23:29:21 | Status: closed fixed

Description: Result set from temp table returns null Build number: 2.3.0.v20080611-0630 Steps to reproduce: 1, New a stored procedure in SQLServer 2005 like: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[ACTesting] AS BEGIN IF OBJECT_ID('tempdb..#t_1') is not null drop table #t_1 SELECT customerNumber, customerName INTO #t_1 FROM dbo.Customers SELECT * FROM #t_1 END 2, New a stored procedure dataset call this procedure 3, Preview dataset Actual result: When excuting the procedure in SQLServer2005, value can be retrieved, but value returns null in BIRT Dataset preview Error log:

Files changed in fix:
data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/executor/DataSourceQuery.java data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/CallStatement.java