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

Insert query error decimal + longtext

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.5, 3.0.6
    • 3.0.7, 2.0.19
    • General
    • None
    • Windows server 2012 R2

    Description

      Executing following query:

      insert into some_table values(-0.0042 ,'please fixed price!!!\r\nAl@1,613.3 EUR/t; drums as usual')

      in ADODB causes
      with ODBC connector 3.0.6 crash,
      with ODBC connector 3.0.5 error:
      [ma-3.0.5][10.3.9-MariaDB]Commands out of sync; you can't run this command now

      test case & ODBC trace attached...

      Attachments

        1. test.vbs
          0.3 kB
          Marek Šrom
        2. SQL.LOG
          30 kB
          Marek Šrom

        Activity

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

          Thank you for your report.
          It's a bit different report, than 146, right?

          Out of sync in 3.0.5 makes me think that was parsing problem. And crash in 3.0.6 may be because (client side) parser chokes on the query. Well, will see.

          Lawrin Lawrin Novitsky added a comment - Thank you for your report. It's a bit different report, than 146, right? Out of sync in 3.0.5 makes me think that was parsing problem. And crash in 3.0.6 may be because (client side) parser chokes on the query. Well, will see.
          marek.srom Marek Šrom added a comment -

          Yes it is not (from my point of view related to issue 146, but maybe it is related to decimal values, because when -0.0042 is changed to 0.0042 it works ok, but also removing ";" in string literal makes it work...

          marek.srom Marek Šrom added a comment - Yes it is not (from my point of view related to issue 146, but maybe it is related to decimal values, because when -0.0042 is changed to 0.0042 it works ok, but also removing ";" in string literal makes it work...
          Lawrin Lawrin Novitsky added a comment -

          The fix and the testcase have been to pushed to master and odbc-3.0 as 548db71

          Lawrin Lawrin Novitsky added a comment - The fix and the testcase have been to pushed to master and odbc-3.0 as 548db71
          marek.srom Marek Šrom added a comment -

          Thank you, I’ll build from source and test, I have found amother queries with similar problem and will see if it solves all of them...

          marek.srom Marek Šrom added a comment - Thank you, I’ll build from source and test, I have found amother queries with similar problem and will see if it solves all of them...
          Lawrin Lawrin Novitsky added a comment -

          I can only appreciate that!

          Lawrin Lawrin Novitsky added a comment - I can only appreciate that!
          marek.srom Marek Šrom added a comment -

          The reported query is ok, unfortunately our application crashes when using ODBC 3.0.6 (it did crash also with the stable release 3.0.6 without this fix)... I applied the fix to 3.0.5, it works ok also for the remaining queries with "out of sync" problem... I try to isolate the problem with 3.0.6 and report a new issue... Thanks

          marek.srom Marek Šrom added a comment - The reported query is ok, unfortunately our application crashes when using ODBC 3.0.6 (it did crash also with the stable release 3.0.6 without this fix)... I applied the fix to 3.0.5, it works ok also for the remaining queries with "out of sync" problem... I try to isolate the problem with 3.0.6 and report a new issue... Thanks
          Lawrin Lawrin Novitsky added a comment -

          So... do I understand correctly that the problem in this report is fixed by the patch in both 3.0.6 and 3.0.5, but you have crash in 3.0.6 not related to this issue?
          Than I guess it's better to open new issue.

          Lawrin Lawrin Novitsky added a comment - So... do I understand correctly that the problem in this report is fixed by the patch in both 3.0.6 and 3.0.5, but you have crash in 3.0.6 not related to this issue? Than I guess it's better to open new issue.
          marek.srom Marek Šrom added a comment -

          I think so, don’t know the reason of crash with 3.0.6. Keep this issue closed and When I find the problem I’ll open a new one...

          marek.srom Marek Šrom added a comment - I think so, don’t know the reason of crash with 3.0.6. Keep this issue closed and When I find the problem I’ll open a new one...

          People

            Lawrin Lawrin Novitsky
            marek.srom Marek Šrom
            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.