Re: Mysql 8 stored procedure
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 .
Subject
Views
Written By
Posted
1040
June 12, 2020 12:47AM
515
June 12, 2020 12:52AM
380
June 12, 2020 03:01AM
405
June 12, 2020 11:17AM
Re: Mysql 8 stored procedure
387
June 14, 2020 01:39AM
311
June 14, 2020 10:53AM
333
June 15, 2020 06:13AM
431
June 15, 2020 12:29PM
388
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.