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 #:  113114   Status: Reported
subselect from stored procedure is not working when group by take action
Project:  InterBase Build #:  WI-V10.0.5.595
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Basic functionality failure Date Reported:  2/27/2013 3:18:20 AM
Severity:    Serious / Highly visible problem Last Updated: 2/27/2013 6:01:07 PM
Platform:    Not OS or platform specific Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
subselect from stored procedure is not working when group by take action.

see [STEPS]
Steps to Reproduce:
1. create simple procedure

SET TERM ^ ;
CREATE PROCEDURE TEST (
    TEST_PARAM integer )
RETURNS (
    TEST_OUT integer )
AS
BEGIN
  TEST_OUT = TEST_PARAM;
  suspend;
END^
SET TERM ; ^

2. try this select

SELECT (SELECT TEST_OUT FROM TEST(1)) FROM RDB$DATABASE R GROUP BY R.RDB$RELATION_ID

Acc: error "Invalid column reference
Exp: return 1

but without group by this work as expected
if test is a table this also work only from procedure this raise error
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01