Re: recursive search
From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Sun, 11 Sep 2016 05:12:28 +0200
Message-ID: <1948725.iZASKD2KPV_at_PointedEars.de>
Date: Sun, 11 Sep 2016 05:12:28 +0200
Message-ID: <1948725.iZASKD2KPV_at_PointedEars.de>
Thomas 'PointedEars' Lahn wrote:
> [15! appears to be the maximum factorial that can be computed with this
> procedure in the default MySQLd setup.]
However, the function^Wprocedure can be improved by changing the type of `result` and `fac_result` to BIGINT UNSIGNED or DOUBLE(53, 0) UNSIGNED, so that it produces correct results for greater factorials if mysqld(8) is invoked with --thread_stack=N and a greater N than the default.
-- PointedEars Twitter: _at_PointedEars2 Please do not cc me. / Bitte keine Kopien per E-Mail.Received on Sun Sep 11 2016 - 05:12:28 CEST