[asterisk-bugs] [JIRA] (ASTERISK-21794) CLI realtime update2 to default value or null

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-21794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-21794:
------------------------------------

    Assignee: Cedric BASSAGET
      Status: Waiting for Feedback  (was: Triage)

I've not used this command before, but..

{noformat}
ubuntu*CLI> core show help realtime update2
Usage: realtime update2 <family> <colmatch> <valuematch> [... <colmatch5> <valuematch5>] NULL <colupdate> <newvalue>
   Update a single variable, requiring one or more fields to match using the
   RealTime driver.  You must supply a family name, a column to update, a new
   value, and at least one column and value to match.
   Ex: realtime update sippeers name bobsphone ipaddr 127.0.0.1 NULL port 4343
   will execute SQL as
   UPDATE sippeers SET port='4343' WHERE name='bobsphone' and ipaddr='127.0.0.1'
{noformat}

According to the usage you should be doing:

CLI> realtime update2 sippeers name 100 NULL deny NULL

What happens when you try it that way?
                
> CLI realtime update2 to default value or null
> ---------------------------------------------
>
>                 Key: ASTERISK-21794
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-21794
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_realtime
>    Affects Versions: 1.8.21.0
>         Environment: kernel 2.6.32-279.22.1.el6.centos.plus.x86_64 #1 SMP Wed Feb 6 05:16:56 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
>            Reporter: Cedric BASSAGET
>            Assignee: Cedric BASSAGET
>            Severity: Minor
>
> It seems it's not possible to reset a field froma mysql database to it's default value or tu NULL value with update2 :
> CLI> realtime update2 sippeers name 100 deny "NULL" <- writes "NULL" as string in the field
> CLI> realtime update2 sippeers name 100 deny NULL <- writes NULL as string in the field
> CLI> realtime update2 sippeers name 100 deny DEFAULT <- writes DEFAULT as string in the field
> Regards,
> Cédric

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira