View Incident Report

Minor

Reported By: Michael Binette
Reported On: 8/24/2004
For: Version 4.10 Build 1

# 1834 SQL GROUP BY Containing Invalid Column Causes AV Instead of Error

When I do the following SQL in dbsys or my application I get an Access Violation. The SQL is actually wrong since I did not include inv_debit_id in the SELECT portion of the SQL statement. If I add inv_debit_id to the SELECT portion then it works as expected without an Access Violation.

SELECT
      SUM(inv_debit_amount)
FROM
      invoice
WHERE
      inv_debit_id = 16300
GROUP BY
      inv_debit_id;

Resolution

Fixed Problem on 8/26/2004 in version 4.11 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap