Following Errors about aggregate functions should be reported at the syntax analysis stage

[ringfa11]

Question
In testcase result file test/case/result/primary-aggregation-func.result,
I found that some incorrect usages of aggregate functions are reported as Failure

However, I believe they should be reported as syntax errors. I tried MySQL version 8.0.34 on Windows, and it also gave syntax errors

[hnwyllmm]

Good question!
I think you're right. The error message response by observer is not good enough.
Currently, miniob use plain string as the response and request message, so it is difficult to describe information clearly.
As a better option, miniob support mysql protocol now and we can fix such issues by mysql protocol. In the future, we can use mysql protocol as the basic protocol to do test.

[ringfa11]

How can I switch to mysql protocal in miniob?
I have tried ./build/bin/observer -f ./etc/observer.ini -P mysql, but it seems not right.

[hnwyllmm]

What's wrong?

[hnwyllmm]

Which mysql client did you use?
mysql 8.0 is not tested yet.

[ringfa11]

Which mysql client did you use? mysql 8.0 is not tested yet.

Thanks for your reply.
I got stuck because I just don't know how to connect observer with mysql client......
So I try blindly.
By the way, I have tried like this.
At left panel,I start server.
At right, I try to connect.
Connection seems to build ok, but I can't get a prompt shell.

My mysql client version is Ver 8.0.34.

[hnwyllmm]

Sorry for that mysql-client 8.x is not tested.
I created an issue #274