Hello
On 23-APR-2003 Zaiti Harun wrote:
Hi,
I am trying to do the following scenario in Oracle mode
in Sapdb 7.3 kernel:
create sequence a
--statement successfully executed
select a.nextval from dual
--statement successfully executed
1
create synonym b for a
--statement successfully executed
select b.nextval from dual
--General Error;-4020 pos(8) unknown sequence name b
Is this a bug or expected behavior (it works fine in Oracle)
Please email me directly as I am not subscribed to the list
As far as I know, no reply was posted to the list nor to him.
So I posted a similar question on 16-JUN-2003:
I don't succeed in using a synonym for an other
user's sequence in SAP DB 7.4 (Kernel 7.4.3 Build
014-120-037-952) on Windows.
Am I doing something wrong or does SAPDB not (yet)
support this?
Here some sample SQL code in order for you to
reproduce the scene:
**** UserA ****
CREATE SEQUENCE my_globalid INCREMENT BY 1 START
WITH 1000000 CACHE 500 NOCYCLE
//
CREATE PUBLIC SYNONYM my_globalid FOR my_globalid
//
GRANT SELECT ON my_globalid TO userB
//
--> these statements got executed successfully
**** UserB ****
SELECT userA.my_globalid.nextval FROM dual
//
--> this works well and yields 1000001, then 1000002,
then 1000003 ...
SELECT my_globalid.nextval FROM dual
//
--> this results in an error: "Unknown sequence name". Why?
[...]
Thanks to Thomas Anhaus from SAP for his reply (17-JUN-2003):
You are doing nothing wrong, instead there's simply
a bug in the name resolution of public synonyms for
sequences.
It's relatively simple to fix the bug, so you can
expect it very soon. There unfortunately is no
workaround in the meantime.
As version 7.4.03.25 was published on 24-JUN-2003, I hoped
to find the bug solved. Unfortunately, this does not seem
to be the case.
So I tried to have a look at http://www.sapdb.org/webpts,
SAP DB's Problem Tracking System in order to find status
information about this bug.
But the search for "public synonym" or "sequence synonym"
revealed nothing.
My questions:
- Did I miss something when trying to search Web PTS?
- Are there bugs which do NOT get listed on Web PTS?
- Can anyone tell me about the status of the "synonym
for sequence" bug?
- When is the next version of SAP DB for Windows
scheduled to be published?
Thanks,
Christian
--
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Jetzt ein- oder umsteigen und USB-Speicheruhr als Pr�mie sichern!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
