[asterisk-bugs] [Asterisk 0016655]: [patch] Double fields in SQL query

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16655 
====================================================================== 
Reported By:                Yarik_rad
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16655
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.6.0.21 
JIRA:                       SWP-780 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           1.6.2.7
====================================================================== 
Date Submitted:             2010-01-20 04:48 CST
Last Modified:              2010-04-15 10:40 CDT
====================================================================== 
Summary:                    [patch] Double fields in SQL query
Description: 
Try to connect Asterisk server with PostgreSQl database I've double fields
in SQL quere send to datbase.

Here is log of database server:

COMMAND:  INSERT INTO cdr
("calldate","clid","src","dst","dcontext","channel","dstchannel","lastapp","lastdata","duration","billsec","disposition","amaflags",
"uniqueid","calldate","clid","src","dst","dcontext","channel","dstchannel","lastapp","lastdata","duration","billsec","disposition","amaflags","uniqueid","calldate",
"clid","src","dst","dcontext","channel","dstchannel","lastapp","lastdata","duration","billsec","disposition","amaflags","accountcode","uniqueid","userfield",
"calldate","clid","src","dst","dcontext","channel","dstchannel","lastapp","lastdata","duration","billsec","disposition","amaflags","accountcode","uniqueid","userfield")
VALUES ('2010-01-20 13:43:16','"User714"
<714>','714','9060','kvartira','SIP/714-00000057','SIP/pstn-00000058','Dial','SIP/999060 at pstn',13,2,'ANSWERED',3,'1263984196.87',
'2010-01-20 13:43:16','"User714"
<714>','714','9060','kvartira','SIP/714-00000057','SIP/pstn-00000058','Dial','SIP/999060 at pstn',13,2,'ANSWERED',3,'1263984196.87',
'2010-01-20 13:43:16','"User714"
<714>','714','9060','kvartira','SIP/714-00000057','SIP/pstn-00000058','Dial','SIP/999060 at pstn',13,2,'ANSWERED',3,'','1263984196.87','',
'2010-01-20 13:43:16','"User714"
<714>','714','9060','kvartira','SIP/714-00000057','SIP/pstn-00000058','Dial','SIP/999060 at pstn',13,2,'ANSWERED',3,'','1263984196.87','')



====================================================================== 

---------------------------------------------------------------------- 
 (0120470) lmadsen (administrator) - 2010-04-15 10:40
 https://issues.asterisk.org/view.php?id=16655#c120470 
---------------------------------------------------------------------- 
OK, I'm going to close this issue then. Because 1.6.0 and 1.6.1 are nearly
their maintenance release period (next month) there is very little chance
this will get reviewed and committed prior to the expiry of maintenance on
those branches.

Since this works with 1.6.2.x, then we'll close this issue and state that
people who need this functionality should move to 1.6.2.x

Thanks for the update! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-04-15 10:40 lmadsen        Note Added: 0120470                          
2010-04-15 10:40 lmadsen        Status                   ready for testing =>
closed
2010-04-15 10:40 lmadsen        Resolution               open => fixed       
2010-04-15 10:40 lmadsen        Fixed in Version          => 1.6.2.7         
======================================================================