[sr-dev] [tracker] Task opened: dbtext - send empty string in non-null

[sip-router]

THIS IS AN AUTOMATED MESSAGE, DO NOT REPLY.

A new Flyspray task has been opened.  Details are below. 

User who did this - Olle Johansson (oej) 

Attached to Project - sip-router
Summary - dbtext - send empty string in non-null
Task Type - Bug Report
Category - Core
Status - Unconfirmed
Assigned To - 
Operating System - All
Severity - Low
Priority - Normal
Reported Version - Development
Due in Version - Undecided
Due Date - Undecided
Details - When using db_text drivers, the driver responds with a NULL string if the declaration says "(string,NULL)". If NULL is not declared, dbtext doesn't read the data and fails.

I need to be able to send an empty string into the dialplan, in the subst/repl fields. Dialplan doesn't accept a NULL string as input for these fields.

The solution is:
- If column is declared as (String) send "" for empty strings
- If column is declared as (string, null) send NULL for empty strings.

Maybe we need a config setting or a default value like
(string,default="")
(int,default=123)

I will try to look into this soon.

More information can be found at the following URL:
http://sip-router.org/tracker/index.php?do=details&task_id=501

You are receiving this message because you have requested it from the Flyspray bugtracking system.  If you did not expect this message or don't want to receive mails in future, you can change your notification settings at the URL shown above.