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

[Cedric BASSAGET (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-21794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=206696#comment-206696 ] 

Cedric BASSAGET edited comment on ASTERISK-21794 at 5/22/13 3:21 AM:
---------------------------------------------------------------------

Hi Rusty,

It gives me a syntax error :
[code]
*CLI> realtime update2 sippeers name 100.ocetest NULL deny NULL
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'
[/code]
                
      was (Author: rico29):
    Hi Rusty,

It gives me a syntax error :

*CLI> realtime update2 sippeers name 100.ocetest NULL deny NULL
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'




                  
> 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