[asterisk-bugs] [JIRA] (ASTERISK-30096) cel_odbc: Column type 9 (field 'cdr:cel:eventtime') is unsupported at this time

[Asterisk Team (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-30096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Asterisk Team updated ASTERISK-30096:
-------------------------------------

    Target Release Version/s: 19.6.0

>  cel_odbc: Column type 9 (field 'cdr:cel:eventtime') is unsupported at this time
> --------------------------------------------------------------------------------
>
>                 Key: ASTERISK-30096
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-30096
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: CEL/cel_odbc
>    Affects Versions: 18.12.1
>            Reporter: Morvai Szabolcs
>            Assignee: Kevin Harwell
>      Target Release: 19.6.0, 16.28.0, 18.14.0
>
>
> The same issue which resolved in: ASTERISK-30023
> The issue appears with ODBC driver: 
> *mysql-connector-odbc:amd64 8.0.29-1ubuntu20.04 amd64        MySQL ODBC driver*
> MySQL version:
> *mysql  Ver 8.0.29 for Linux on x86_64 (MySQL Community Server - GPL)*
> Ubuntu version: *Ubuntu 20.04.4 LTS*
> Resolve this issue with adding 
> {code}
> --- asterisk-18.12.1/cel/cel_odbc.c~     2022-05-19 15:51:28.000000000 +0000
> +++ asterisk-18.12.1/cel/cel_odbc.c 	 2022-06-03 08:23:05.422181784 +0000
> @@ -606,6 +606,7 @@
>                                         break;
>                                 case SQL_TYPE_TIMESTAMP:
>                                 case SQL_TIMESTAMP:
> +                               case SQL_DATETIME:
>                                         if (ast_strlen_zero(colptr)) {
>                                                 continue;
>                                         } else {
> {code}
> line to cel/cel_odbc.c file.



--
This message was sent by Atlassian JIRA
(v6.2#6252)