'Max' of text field doesn't work in related records
11.0v4 and 12.0v2
Operating system version
OS X 10.8
Description of the issue
The manual for the 'max' function states 1. it works for text fields, and 2. it works over related records.
However from my testing I've found while 'max' works for text fields within the same record, numeric fields in related records, but not text fields in related records.
This would be consistent with the 'max' summary field which also can't process text fields.
Steps to reproduce the problem
'key' as numeric, field1 as numeric, field2 as text
first record: key=1, field1=10, field2='a'
2nd record: key=1, field1=11, field2='b'
key as numeric
max1=Max(table2::field1) /* Result as number */
max2=Max(table2::field2) /* Result as text */
one record with key=1
tables are related on 'key'
max1 shows 11, max2 shows 'b'
max1 shows 11, max2 shows nothing
Exact text of any error message(s) that appear
Don't try to use 'max' on text fields in related records!