Summary:	ASTERISK-15042: [patch] realtime function does not return pair when database value is null
Reporter:	sohosys (sohosys)	Labels:
Date Opened:	2009-10-27 10:43:29	Date Closed:	2009-12-04 10:22:16.000-0600
Priority:	Minor	Regression?	No
Status:	Closed/Complete	Components:	Functions/func_realtime
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) 20091029__issue16138.diff.txt
Description:	this is the same issue reported in https://issues.asterisk.org/view.php?id=15615#c108403 the previous issue was closed, stating that it was corrected in 1.6.x. We are still experiencing this issue in 1.6.0.13. the function is rather useless if a the return does not contain the same number of pairs on every query of the same table. this is a bigger issue in 1.6 than 1.4 since app_realtime is no longer in 1.6
Comments:	By: Leif Madsen (lmadsen) 2009-10-28 09:06:53 Assigned to Tilghman for review. By: Tilghman Lesher (tilghman) 2009-10-28 09:23:10 Which realtime backend are you using? By: sohosys (sohosys) 2009-10-28 09:28:44 MySQL By: Tilghman Lesher (tilghman) 2009-10-28 09:46:49 Patch uploaded against addons-1.6.0. By: sohosys (sohosys) 2009-10-28 09:48:47 thank you, we will try to test today By: sohosys (sohosys) 2009-10-28 17:37:01 still no go. only pairs where the column has a value are returned. What we are expecting is that a column with a null value is in the string as such, like "callerid=,username=3035551212,secret=123456,callgroup=" where callerid and callgroup are in the table with null values. even with this patch the values are ommited if null, and there are a a varying number of pairs in the return, which changes the position of the needed data from query to query. By: Tilghman Lesher (tilghman) 2009-10-29 00:27:37 Okay, found where it's being removed.  New patch uploaded. By: Tilghman Lesher (tilghman) 2009-12-04 00:00:52.000-0600 Testing results?  Bueller? By: sohosys (sohosys) 2009-12-04 05:49:15.000-0600 the patch did resolve the issue. By: Digium Subversion (svnbot) 2009-12-04 10:17:34.000-0600 Repository: asterisk Revision: 233050 U   trunk/addons/res_config_mysql.c ------------------------------------------------------------------------ r233050 | tilghman | 2009-12-04 10:08:58 -0600 (Fri, 04 Dec 2009) | 7 lines Update the mysql driver to always return NULL columns, as this is needed for the realtime API to work correctly. (closes issue ASTERISK-15042) Reported by: sohosys Patches:       20091029__issue16138.diff.txt uploaded by tilghman (license 14) Tested by: sohosys ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=233050 By: Digium Subversion (svnbot) 2009-12-04 10:19:02.000-0600 Repository: asterisk-addons Revision: 1070 U   branches/1.6.0/res/res_config_mysql.c ------------------------------------------------------------------------ r1070 | tilghman | 2009-12-04 10:19:01 -0600 (Fri, 04 Dec 2009) | 7 lines Update the mysql driver to always return NULL columns, as this is needed for the realtime API to work correctly. (closes issue ASTERISK-15042) Reported by: sohosys Patches:       20091029__issue16138.diff.txt uploaded by tilghman (license 14) Tested by: sohosys ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk-addons?view=rev&revision=1070 By: Digium Subversion (svnbot) 2009-12-04 10:20:08.000-0600 Repository: asterisk-addons Revision: 1071 U   branches/1.6.1/res/res_config_mysql.c ------------------------------------------------------------------------ r1071 | tilghman | 2009-12-04 10:20:08 -0600 (Fri, 04 Dec 2009) | 7 lines Update the mysql driver to always return NULL columns, as this is needed for the realtime API to work correctly. (closes issue ASTERISK-15042) Reported by: sohosys Patches:       20091029__issue16138.diff.txt uploaded by tilghman (license 14) Tested by: sohosys ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk-addons?view=rev&revision=1071 By: Digium Subversion (svnbot) 2009-12-04 10:22:15.000-0600 Repository: asterisk-addons Revision: 1072 U   branches/1.6.2/res/res_config_mysql.c ------------------------------------------------------------------------ r1072 | tilghman | 2009-12-04 10:22:15 -0600 (Fri, 04 Dec 2009) | 7 lines Update the mysql driver to always return NULL columns, as this is needed for the realtime API to work correctly. (closes issue ASTERISK-15042) Reported by: sohosys Patches:       20091029__issue16138.diff.txt uploaded by tilghman (license 14) Tested by: sohosys ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk-addons?view=rev&revision=1072