| Summary: | ASTERISK-06946: [patch] When selecting multiple columns commas are converted to pipes resulting in query failure. | ||
| Reporter: | Chris Field (cfieldmtm) | Labels: | |
| Date Opened: | 2006-05-10 11:58:26 | Date Closed: | 2011-06-07 14:08:22 |
| Priority: | Minor | Regression? | No |
| Status: | Closed/Complete | Components: | Applications/General |
| Versions: | Frequency of Occurrence | ||
| Related Issues: | |||
| Environment: | Attachments: | ( 0) patch_for_pipes.patch | |
| Description: | When doing something like: MYSQL(Query resultid ${connid} SELECT username,first_name,last_name,phone,domain FROM subscriber .... ) by the time it gets to the mysql backend it looks like: SELECT username|first_name|last_name|phone|domain FROM subscriber .... I have attached a patch to fix, i will fax the disclaimer shortly. ****** ADDITIONAL INFORMATION ****** OS: Red Hat Enterprise Linux ES release 3 (Taroon) Mysql: mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) mysqlclient library: libmysqlclient.so.14.0.0 | ||
| Comments: | By: Serge Vecher (serge-v) 2006-05-19 14:39:47 can you please review the CODING-GUIDELINES and fix the white-space stuff accordingly? thanks. By: Tilghman Lesher (tilghman) 2006-05-20 09:51:56 Actually, the fix is much simpler: just backslash the commas in extensions.conf, and the commas will be passed to the application. | ||