View Incident Report

Serious

Reported By: Roy Lambert
Reported On: 3/18/0011
For: Version 2.05 Build 4

# 3414 LIST Aggregate Function Ignoring Empty Strings

I've set the default for some columns to an empty string. The following SQL statement returns a list of 5 items not the 10 there should be. The top 5 are empty strings and seem to be ignored. If I maliciously alter the 7th item to an empty string I still get 5 items with the 2nd being an empty line.

select list(_page,#13) from contents where _id <= 10

Comments

LIST now uses a proper NULL check, and will concatenate empty (as opposed to NULL) strings to the list.

Resolution

Fixed Problem on 3/20/2011 in version 2.05 build 5

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap