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

Inizia riproducendo la query segnalata e la variante funzionante `order by time desc` con IoTDB 1.0.0, quindi traccia il percorso di parsing SQL per `order by name desc`. Il lavoro è completo quando la query ordinata per nome viene analizzata ed eseguita in modo coerente, mentre la query esistente ordinata per tempo continua a funzionare.

Scritto dal modello di indicizzazione a partire dal testo della issue.