|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: A non-existing function call doesn't generate any error
From: Zabach, Elke (elke.zabach
sap.com)
Date: Tue Feb 10 2004 - 09:47:53 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
news wrote:
>
> Hello,
> I just would like to let you know, that I've noticed
> SAP DB is acting really strange when non-existing function
> is used in SELECT clause.
> For example:
> SELECT SILLY_NAME_OF_FUNCTION(MY_COLUMN) FROM MY_TABLE,
> returns all rows from MY_TABLE for column MY_COLUMN.
> IMHO some error that the given function doesnt exist would be very
> appreciated.
> I use 7.3.0.40, didn't check with 7.5 nor 7.4.
>
> Best regards,
>
> Marcin
That is a known topic.
As reference manual tells us a <named_select_statement> is known,
looking like this
select cursorname (<select_list>) from ...
doing the same as
declare cursorname for select <select_list> from ...
This is known because of downward-compatibility.
Starting with 7.5.01 this confusing named_select_statement does not exist any more.
Elke
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]