MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: MySql Percentile works in Select statement but not Function - ?
Posted by: Peter Brawley
Date: March 29, 2021 09:46PM

MySQL version?

I don't see an initialisation of user var @curRank.

IAC ...

If it's 8.0, your use of user vars is deprecated, you should convert the query to use windowing functions.

If it's 5.7 and initialising @curRank doesn't fix your problem, please provide a self-standing sql script with enough data to demonstrate the problem.

If it's pre-5.7, your version's past eol, all bets are off.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySql Percentile works in Select statement but not Function - ?
3041
Jason Wisdom
March 29, 2021 07:11PM
Re: MySql Percentile works in Select statement but not Function - ?
718
Jason Wisdom
March 29, 2021 07:16PM
Re: MySql Percentile works in Select statement but not Function - ?
752
Peter Brawley
March 29, 2021 09:46PM
Re: MySql Percentile works in Select statement but not Function - ?
808
Jason Wisdom
March 30, 2021 07:36PM
Re: MySql Percentile works in Select statement but not Function - ?
704
Peter Brawley
March 30, 2021 08:51PM


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.