MySQL Forums
Forum List  »  Stored Procedures

Re: Mysql 8 stored procedure
Posted by: Zoltan Szmutku
Date: June 14, 2020 01:39AM

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 .

Options: ReplyQuote

Written By
June 12, 2020 12:47AM
June 12, 2020 12:52AM
June 12, 2020 03:01AM
June 12, 2020 11:17AM
Re: Mysql 8 stored procedure
June 14, 2020 01:39AM
June 14, 2020 10:53AM
June 15, 2020 06:13AM
June 15, 2020 12:29PM
June 15, 2020 12:46PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.