View Incident Report

Serious

Reported By: Rolf Frei
Reported On: 3/4/2001
For: Version 2.07 Build 1

# 733 Default Ordering of Canned Result Sets Incorrect for Non-ANSI Standard Source Tables

The following query uses ANSII ordering. That means, any lower chars are behind all upper chars. The field Subject has no index so the result is canned.

The output is:

Ansdfg
Zskdkjfs
akdjk
bjshdkd

The table language is "German (Swiss)".

SELECT Subject FROM NLOutbox
WHERE Sent IS NULL
ORDER BY Subject

Resolution

Fixed Problem on 3/4/2001 in version 2.08 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap