| Summary: | ASTERISK-27888: SQL fetch error on query which return 0 columns | ||
| Reporter: | Alexei Gradinari (alexei gradinari) | Labels: | |
| Date Opened: | 2018-05-31 10:25:12 | Date Closed: | 2018-06-12 07:37:22 |
| Priority: | Major | Regression? | |
| Status: | Closed/Complete | Components: | Functions/func_odbc |
| Versions: | 13.21.0 | Frequency of Occurrence | |
| Related Issues: | |||
| Environment: | Attachments: | ||
| Description: | The functions acf_odbc_read/cli_odbc_read ignore a number of columns in the SQLNumResultCols.
If the number of columns is zero it means no data. In this case, a SQLFetch function has to be not called, because it will cause an error. | ||
| Comments: | By: Asterisk Team (asteriskteam) 2018-05-31 10:25:13.026-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Friendly Automation (friendly-automation) 2018-06-12 07:37:23.589-0500 Change 9070 merged by Jenkins2: func_odbc: NODATA if SQLNumResultCols returned 0 columns on readsql [https://gerrit.asterisk.org/9070|https://gerrit.asterisk.org/9070] By: Friendly Automation (friendly-automation) 2018-06-12 07:52:35.290-0500 Change 9134 merged by Jenkins2: func_odbc: NODATA if SQLNumResultCols returned 0 columns on readsql [https://gerrit.asterisk.org/9134|https://gerrit.asterisk.org/9134] By: Friendly Automation (friendly-automation) 2018-06-12 08:08:07.615-0500 Change 9133 merged by George Joseph: func_odbc: NODATA if SQLNumResultCols returned 0 columns on readsql [https://gerrit.asterisk.org/9133|https://gerrit.asterisk.org/9133] | ||