[asterisk-bugs] [JIRA] (ASTERISK-29933) Adaptive ODBC Driver DateTime field

[Caesar (JIRA)]

Caesar created ASTERISK-29933:
---------------------------------

             Summary: Adaptive ODBC Driver DateTime field
                 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


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)