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


Subject
Views
Written By
Posted
468
June 12, 2020 12:47AM
192
June 12, 2020 12:52AM
106
June 12, 2020 03:01AM
129
June 12, 2020 11:17AM
Re: Mysql 8 stored procedure
104
June 14, 2020 01:39AM
85
June 14, 2020 10:53AM
88
June 15, 2020 06:13AM
107
June 15, 2020 12:29PM
129
June 15, 2020 12:46PM


Sorry, only registered users may post in this forum.

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.