← Back to team overview

maria-developers team mailing list archive

Re: Feature Request - Working auto_inc rement on BlackHole Engine

 

On 05/15/2013 09:24 PM, Roberto Spadim wrote:
hum, maybe a 'global variable' + a 'counter' function could do the job?

select add_and_return(@global_var,1)
could return old global_var value +1, and set the global_var to +1

just a idea.. like GET_LOCK(str,timeout) do, but without timeout

How would the function avoid the race condition?
Is it actually possible to have user-defined global variables?

Gordan



Follow ups

References