Re: Mysql 8 stored procedure

[Zoltan Szmutku]

Thanks your answer Peter.

I used a developer error handler and yesterday I stepped closer to the problem.
I have a select command so that ask field list from information_schema.
Then I make a REPLACE command string in a cycle based on that field list then I execute it..
"Replace into end_table (select asked_field_list from temp_table)"

Here is the problem. My field list select command give me a list in ABC order. So the REPLACE command go to error, because I not use field list section in the REPLACE command.

So the problem is solved. I add a ORDER BY ORDINAL_POSITION addition to my field list select command.

It is ok. But I am not understand why work the original (without addition) REPLACE into command on 5.6 server, and why not works on 8.0 server after install database and sometimes why get well without any special interaction... same command all the time...
I think there are some server bug here .