I have a problem that appears to have arrived in one of the recent
updates. I must admit that the help files do not list the function as a
SELECT ... GROUP BY specifically, but it used to work.
Create a table consisting of one Integer and one text 30 column: The
real table is, of course much wider, but this will serve as an example.
CREATE TABLE TestTable ( +
IDCol INTEGER, +
TextValue TEXT (30) )
LOAD TestTable
1,"One"
1,"Two"
1,"Three"
2,"One"
2,"Four"
END
-- An index on IDCol makes no difference to the results.
CREATE INDEX TestTable ON TestTable (IDCol)
-- Nor does this index
CREATE INDEX TestTable2 ON TestTable (IDCol,TextValue)
-- I tried this with and without parens around the LISTOF() function.
SELECT IDCol, (LISTOF(TextValue)) +
FROM TestTable +
GROUP BY IDCol
This results in an error message that the row width exceeds 4,096 and
the select fails. This worked up until update 30909, but that might have
been an oversight somewhere. It appears to have broken at 30909.
Anyone have any ideas? This is used to create a summary of the text
values in a column for a compressed data report in comma delimited string.
I will rework to use a cursor in the mean time.
Thanks!
Albert
