Columns w/ INDEX OFF cannot be aggregated.

[jeffnappi]

Just discovered this when attempting to sum() some statistics columns that I had set to INDEX OFF.

At a minimum the documentation should be updated to reflect that this is the case.

[dobe]

jep, you are right. we'll document it - this issue will be updated once we have this on master.

the background is, that internally fieldcaches are used for aggregation, which only exist for indexed fields.

thanks, bernd

[jeffnappi]

Great, that makes sense.

[lukasender]

@jeffnappi A new release has just been published. A short section explaining the behaviour of non-indexed fields has been added. https://crate.io/docs/stable/sql/ddl.html#indices-and-fulltext-search

thank you very much for your help! :)