Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: InterBase/Server    [ Add a report in this area ]  
Report #:  122621   Status: Closed
EXECUTE STATEMENT does not support NULL in returning values!
Project:  InterBase Build #:  XE, XE3
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Basic functionality failure Date Reported:  2/19/2014 11:42:25 PM
Severity:    Critical / Show Stopper Last Updated: 4/1/2014 9:42:02 PM
Platform:    Not OS or platform specific Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : XE3 Update4
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
try steeps
i test this on XE and recent XE3
Steps to Reproduce:
1. create this procedure

CREATE PROCEDURE AAA
RETURNS
(
  A1 INTEGER,
  A2 INTEGER,
  A3 INTEGER,
  DT1 TIMESTAMP,
  DT2 TIMESTAMP,
  DT3 TIMESTAMP
)
AS
BEGIN
  A1 = NULL;
  DT1 = NULL;

  SELECT CAST(NULL AS INTEGER), CAST(NULL AS TIMESTAMP) FROM RDB$DATABASE INTO :A2, DT2;

  EXECUTE STATEMENT 'SELECT CAST(NULL AS INTEGER), CAST(NULL AS TIMESTAMP) FROM RDB$DATABASE' INTO :A3, DT3;

  SUSPEND;
END


commit;

select * from AAA

resultset:
A1        A2      A3  DT1      DT2      DT3
NULL   NULL 0    NULL    NULL    1858-11-17


Actual: A3 = 0 and DT3=1858-11-17
Expected A3 = NULL and DT3 = NULL

Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01