[asterisk-bugs] [Asterisk 0014034]: app_queue does not update on realtime update

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=14034 
====================================================================== 
Reported By:                cristiandimache
Assigned To:                otherwiseguy
====================================================================== 
Project:                    Asterisk
Issue ID:                   14034
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.0.2 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-12-08 17:33 CST
Last Modified:              2008-12-15 11:05 CST
====================================================================== 
Summary:                    app_queue does not update on realtime update
Description: 
We use app_queue with realtime MySQL. We want to set a different strategy,
so we change the content of the MySQL table to reflect this.
However, the change is not reflected in app_queue unless Asterisk is
restarted.
====================================================================== 

---------------------------------------------------------------------- 
 (0096400) otherwiseguy (administrator) - 2008-12-15 11:05
 http://bugs.digium.com/view.php?id=14034#c96400 
---------------------------------------------------------------------- 
On a change to NULL?  Personally, I would say that if anyone is changing to
NULL (as opposed to it being NULL to begin with) and expecting a behavior,
then they should wet up the DB with the field NOT NULL with a default to
whatever they want to happen.  I don't think there is an easy way to change
the queue to get the behavior on it being set to NULL, so I'm going to
close this with the above workaround as my suggestion to fixing. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-12-15 11:05 otherwiseguy   Note Added: 0096400                          
======================================================================