[asterisk-bugs] [Asterisk 0016893]: Realtime queue does not re-read announce variable from mysql after first use

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16893 
====================================================================== 
Reported By:                haakon
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16893
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     acknowledged
Target Version:             1.6.2.11
Asterisk Version:           SVN 
JIRA:                       SWP-964 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-02-24 07:39 CST
Last Modified:              2010-07-20 18:30 CDT
====================================================================== 
Summary:                    Realtime queue does not re-read announce variable
from mysql after first use
Description: 
I am using realtime queues extensively with * 1.6.1.

Everything works great. Asterisk reads new values from the queue table
each time a user enters the queue.
Except from one thing: announcements. The "announce" variable from the
queue table, doesn't seem to be read more than once, if it has already
found a value.

Example:
I create a queue in the queue table, and add announce = "my_audio_file"
Then I call in, and the agent gets the audio file played correctly before
they are set up.

Then I set the announce field to NULL, or empty it with a empty string.
Now if i call in, the agent still gets the audio file set up earlier.

I even tried changing the ID of the queue entry in mysql (because i know
the queue_members table require this).
But it still reads the "ghost" value of announce.
====================================================================== 

---------------------------------------------------------------------- 
 (0124779) tilghman (administrator) - 2010-07-20 18:30
 https://issues.asterisk.org/view.php?id=16893#c124779 
---------------------------------------------------------------------- 
In your description, you say that you set the announce field to NULL or to
the empty string.  It should not work the same way if you do either.  NULL
is a special value in realtime that means "act like this field doesn't
exist", whereas an empty string does exist.  When set to NULL, the value
does not propagate back to the queue, so it cannot reset the value. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-20 18:30 tilghman       Note Added: 0124779                          
======================================================================