[asterisk-bugs] [JIRA] (ASTERISK-29933) cdr_adaptive_odbc: datetime type not supported

[Caesar (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-29933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=258137#comment-258137 ] 

Caesar commented on ASTERISK-29933:
-----------------------------------

Yes, I am waiting on the Contributor license approval.

> cdr_adaptive_odbc: datetime type not supported
> ----------------------------------------------
>
>                 Key: ASTERISK-29933
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29933
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: CDR/cdr_adaptive_odbc
>    Affects Versions: 18.9.0
>         Environment: Centos 7
>            Reporter: Caesar
>            Assignee: Caesar
>
> When using Mysql ODBC Connector (libmyodbc8w.so) and adaptive ODBC, there is an issue when writing to Datetime columns. In the Asterisk console, the following warning appears:
> cdr_adaptive_odbc.c:731 odbc_log: Column type 9 (field 'asterisk:cdr:start') is unsupported at this time.
> mysql> describe cdr;
> +-------------+--------------+------+-----+---------+----------------+
> | Field       | Type         | Null | Key | Default | Extra          |
> +-------------+--------------+------+-----+---------+----------------+
> | start       | datetime     | YES  |     | NULL    |                |
> Proposal:
> I see TIMESTAMP field type is already considered in the case within the cdr_adaptive_odbc.c, we can simply add Datetime to the switch.



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