Icon View Incident Report

Serious 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 Comments
LIST now uses a proper NULL check, and will concatenate empty (as opposed to NULL) strings to the list.


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