Menu

#85 MULTISET OPERATORS are not supported

next_release
closed
nobody
None
5
2012-01-22
2012-01-14
No

From Wernfried Domscheit

Please check Oracle Doc for Multiset Conditon:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions006.htm

Keyword \"OF\" is optional for MEMBER and SUBMULTISET,
according your code in PLSQL.jj it is mandatory. (But I\'m
always assiduous and include it in my PL/SQL Code, so it
works fine for me, anyway :-)

Also Multiset *Operators* are not supported (see
http://docs.oracle.com/cd/B28359_01/server.111/b28286/operators006.htm\),
I can open a new bug if you like, otherwise see below:

This PL/SQL does not work:
CREATE OR REPLACE PROCEDURE ChangeIpTraffic IS
syncReference FDN_TABLE_TYPE :=
FDN_TABLE_TYPE(\'10.10.10.10\', \'20.20.20.20\');
BEGIN
syncReference := syncReference MULTISET EXCEPT
FDN_TABLE_TYPE(\'20.20.20.20\');
END;

ParseException at package <d:\\Temp\\ChangeIpTraffic.txt>:
net.sourceforge.pldoc.parser.ParseException: Encountered \"
<IDENTIFIER> \"MULTISET \"\" at line
6, column 40.
Was expecting one of:
\"/\" ...
\";\" ...
\"=\" ...
\"!\" ...
\"<\" ...
\">\" ...
\"+\" ...
\"-\" ...
\"||\" ...
\"**\" ...
\"*\" ...
\"AND\" ...
\"BETWEEN\" ...
\"FROM\" ...
\"IN\" ...
\"IS\" ...
\"LIKE\" ...
\"MEMBER\" ...
\"MOD\" ...
\"NOT\" ...
\"OR\" ...
\"A\" ...
\"EMPTY\" ...
\"SUBMULTISET\" ...

Last consumed token: \"syncReference\"

Discussion

  • Stuart Turton

    Stuart Turton - 2012-01-14
     
  • Stuart Turton

    Stuart Turton - 2012-01-22

    Fix scheduled for the next release.

     
  • Stuart Turton

    Stuart Turton - 2012-01-22

    Fixed - released on 0.9.10

     
  • Stuart Turton

    Stuart Turton - 2012-01-22
    • milestone: --> next_release
    • status: open --> closed
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.