Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-149

ODBC Connector 3.05 Bug: Connection Crashes with Timestamp INSERT INTO

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.5
    • 3.0.6
    • General
    • None
    • Windows

    Description

      The bug is related with the following Github issue:
      https://github.com/r-dbi/odbc/issues/194

      The problem is that when inserting a timestamp into a table by making use of:

      • MariaDB ODBC Connector 3.05 (x64).
      • MariaDB Server 10.2.8

      Although the table is created, no data is inserted into it, because the connection crashes when trying to INSERT INTO a table a TIMESTAMP / DATETIME column, which originates the RSession to crash.

      Thank you for a possible fix.
      Juan

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. ODBC-151 In SQLBindParameter BufferLength sets SQL_DESC_OCTET_LENGTH for fixed length types

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Lawrin Lawrin Novitsky added a comment -

            Thank you for your report.

            Would it be possible to provide ODBC trace for the crash? That would help a lot.

            Also I would appreciate if you filed other reports for other problems you face with our connectors. From your github error description, I assume this one is not the only problem you have.

            Lawrin Lawrin Novitsky added a comment - Thank you for your report. Would it be possible to provide ODBC trace for the crash? That would help a lot. Also I would appreciate if you filed other reports for other problems you face with our connectors. From your github error description, I assume this one is not the only problem you have.
            Lawrin Lawrin Novitsky added a comment -

            Ok, I've installed R, and could run your script, and repeat your crash. No need in the trace file so far.

            Lawrin Lawrin Novitsky added a comment - Ok, I've installed R, and could run your script, and repeat your crash. No need in the trace file so far.
            Juan Juan Telleria added a comment -

            Thank you.

            Juan Juan Telleria added a comment - Thank you.
            Lawrin Lawrin Novitsky added a comment -

            The fix and the testcase has been pushed into odbc-3.0 as 1273ebd. Not required in odbc-2.0

            Lawrin Lawrin Novitsky added a comment - The fix and the testcase has been pushed into odbc-3.0 as 1273ebd. Not required in odbc-2.0

            People

              Lawrin Lawrin Novitsky
              Juan Juan Telleria
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.