[Bug] 'order by name desc' can't work

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.

### Version

1.0.0

### Describe the bug and provide the minimal reproduce step

exec:
'select _state_id_, name from root.G9990002.terminal where _state_id_<='Sck-20-13' order by name desc'

produced a error:
700: Error occurred while parsing SQL to physical plan: line 1:91 no viable alternative at input

However,
select _state_id_, name from root.G9990002.terminal where _state_id_<='Sck-20-13' order by time desc

executed correctly.

### What did you expect to see?

the following sql execute failed:

select _state_id_, name from root.G9990002.terminal where _state_id_<='Sck-20-13' order by name desc

### What did you see instead?

select _state_id_, name from root.G9990002.terminal where _state_id_<='Sck-20-13' order by name desc

can be executed correctly.

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

首先，在 IoTDB 1.0.0 上复现报告中的查询和可正常工作的 `order by time desc` 变体，然后跟踪 `order by name desc` 的 SQL 解析路径。当按名称排序的查询能够稳定地完成解析和执行，同时现有的按时间排序查询仍能正常工作时，即视为完成。

由索引模型根据 Issue 内容生成。