The same problem appears in MongoDB Adapter. 0: jdbc:calcite:model=mongodb/target/test-cla> select city from zips limit 5; +----------------------+ | CITY | +----------------------+ | AGAWAM | | CUSHMAN | | BARRE | | BELCHERTOWN | | BLANDFORD | +----------------------+ 5 rows selected (0.184 seconds)
0: jdbc:calcite:model=mongodb/target/test-cla> select char_length(city) from zips limit 5; Error: Error while executing SQL "select char_length(city) from zips limit 5": Translation of CHAR_LENGTH(CAST(ITEM($0, 'city')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary") is not supported by MongoProject (state=,code=0) 0: jdbc:calcite:model=mongodb/target/test-cla> select upper(city) from zips limit 5; Error: Error while executing SQL "select upper(city) from zips limit 5": Translation of UPPER(CAST(ITEM($0, 'city')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary") is not supported by MongoProject (state=,code=0)