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

When performing a query with an aggregate function such as Count or Sum from MSAccess, an error is returned

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.5
    • Fix Version/s: 2.0.17, 3.0.6
    • Component/s: General
    • Labels:
      None
    • Environment:
      Windows 7 Professional 64 bit. MS Access 2010 32 bit

      Description

      When running the following query:
      SELECT Count(tblContacts.contactID) AS CountOfcontactID, tblContacts.firstName
      FROM tblContacts
      GROUP BY tblContacts.firstName

      The error returned is:
      "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

      The error is is returned using Count, Sum, Avg, StDev and Var. But not when using Min, Max, First or Last.

      This error is not generated if using the MySQL ODBC connector to connect to the same database.

      connector log attached.

        Attachments

          Activity

            People

            • Assignee:
              Lawrin Lawrin Novitsky
              Reporter:
              immortal Martin Lane
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: