[asterisk-bugs] [Asterisk 0017872]: update_odbc always reports that : Key field 'ipaddr' does not exist in table ... Update will fail

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17872 
====================================================================== 
Reported By:                spanov
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   17872
Category:                   Resources/res_config_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.6.2.11 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-08-16 15:04 CDT
Last Modified:              2010-08-17 13:31 CDT
====================================================================== 
Summary:                    update_odbc always reports that : Key field 'ipaddr'
does not exist in table ...  Update will fail
Description: 
I've set up reatime configuration for sippeers and sipregs via ODBC
connected to Oracle 11g. There are a lot of warning (update_odbc always
reports that : Key field 'ipaddr' does not exist in table ...  Update will
fail) in the CLI while new SIP registration.
I assume that it's case sensitive issue since actually, the column ipaddr
is updated correctly. By default Oracle return all columns in uppercase.
====================================================================== 

---------------------------------------------------------------------- 
 (0126026) spanov (reporter) - 2010-08-17 13:31
 https://issues.asterisk.org/view.php?id=17872#c126026 
---------------------------------------------------------------------- 
I've attached screen shot of CLI. You can find asterisk version and output
there.
By putting some logging to ast_odbc_find_column function I meant that I
added the following line

struct odbc_cache_columns *ast_odbc_find_column(struct odbc_cache_tables
*table, const char *colname
{
struct odbc_cache_columns *col;
AST_RWLIST_TRAVERSE(&table->columns, col, list) {
ast_log(LOG_WARNING, "Compare '%s' '%s'",col->name,colname);
if (strcasecmp(col->name, colname) == 0) {
return col;
}
....
<------>}


and I assumed that I saw warnings like Compare .....
But nothing happened. So that I assumed that AST_RWLIST_TRAVERSE can find
no columns. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-08-17 13:31 spanov         Note Added: 0126026                          
======================================================================