[Deploying Sakai] Crazy function names in SAKAI_REALM_FUNCTION in MySQL, maybe Oracle too

[Will Humphries]

Hello Jean-Francois,

Those function names come from an OSP bug, they were removed from osp 
source and authz .sql around 2.5 
https://jira.sakaiproject.org/browse/SAK-11846 . I don't have them in 
any database, but other MySQL schools with installations that are 
several years old might. It seems like they shouldn't be needed, but you 
might confirm by grepping for them in your /osp .

-Will

On 7/13/12 5:52 AM, Jean-Francois Leveque wrote:
> Hi,
>
> I don't know when this happened, but I think there's something wrong in
> my database.
>
>   > select FUNCTION_NAME from SAKAI_REALM_FUNCTION where FUNCTION_NAME
> like 'annc.%';
> +--------------------------------+
> | FUNCTION_NAME                  |
> +--------------------------------+
> | annc.all.groups                |
> | annc.delete.any                |
> | annc.delete.own                |
> | annc.new                       |
> | annc.read                      |
> | annc.read.drafts               |
> | annc.revise.any                |
> | annc.revise.anyannc.revise.own |
> | annc.revise.anyasn.delete      |
> | annc.revise.anyasn.grade       |
> | annc.revise.anyasn.new         |
> | annc.revise.anyasn.read        |
> | annc.revise.anyasn.revise      |
> | annc.revise.anyasn.submit      |
> | annc.revise.own                |
> +--------------------------------+
> 15 rows in set (0.00 sec)
>
> Am I the only one?
>
> I think the 7 that begin with annc.revise.anya have nothing to do here.
> Could someone else confirm?
>
> Cheers,
>
> J-F
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"