[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!

Commencez par reproduire la requête signalée et la variante fonctionnelle `order by time desc` avec IoTDB 1.0.0, puis suivez le chemin d’analyse SQL pour `order by name desc`. Le travail est terminé lorsque la requête triée par nom est analysée et exécutée de manière cohérente, tandis que la requête existante triée par temps continue de fonctionner.

Rédigé par le modèle d'indexation à partir du texte de l'issue.