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

Empieza reproduciendo la consulta reportada y la variante funcional `order by time desc` con IoTDB 1.0.0; después, sigue la ruta de análisis sintáctico de SQL para `order by name desc`. Se considera terminado cuando la consulta ordenada por nombre se analiza y ejecuta de forma coherente, mientras la consulta existente ordenada por tiempo sigue funcionando.

Escrito por el modelo de indexación a partir del texto del issue.