[CALCITE-6026] MongoDB: Column is not quoted in "order by" clause and throws JsonParseException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: mongodb-adapter
• Labels: pull-request-available
• Assignee: Tim Nieradzik
• Reporter: Tim Nieradzik
• Created: 26/Sep/23 07:38
• Updated: 10/Nov/23 11:34
• Resolved: 26/Sep/23 08:30

Description

The following query fails with a JsonParseException:

select state as "STATE", avg(pop) as "AVG(pop)"
from zips
group by "STATE"
order by "AVG(pop)" 

 
Stack trace:
 

org.bson.json.JsonParseException: JSON reader was expecting ':' but found '('.
	at org.bson.json.JsonReader.readBsonType(JsonReader.java:150)
	at org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:85)
	at org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:42)
	at org.bson.codecs.BsonDocumentCodec.readValue(BsonDocumentCodec.java:104)
	at org.bson.codecs.BsonDocumentCodec.decode(BsonDocumentCodec.java:87)
	at org.bson.BsonDocument.parse(BsonDocument.java:66)
	at org.apache.calcite.adapter.mongodb.MongoTable.aggregate(MongoTable.java:138)
	at org.apache.calcite.adapter.mongodb.MongoTable.access$200(MongoTable.java:53)
	at org.apache.calcite.adapter.mongodb.MongoTable$MongoQueryable.aggregate(MongoTable.java:189) 

 

This is caused by the column name in the "order by" clause not being escaped.

 

Issue Links

• links to: GitHub Pull Request #3443