Re: Store procedure select fails

[Peter Brawley]

Why not just use GUIDs?

If there's a imperative reason you must write a custom sproc for this, given the primitive language and absence of debugging toools with MySQL sprocs, they're a pain. The only debugging method I know is the brute force method of stubs & drivers we learned long ago in school, before fancy debuggers existed. Stub out the controlling values in user variables and track what's happening.

I do see a coding error: x like y returns true only where x exactly equals y, but if you're using the like operator you presumably want x like concat(y,'%'), or x like concat('%',y,'%').

(To preserve text formatting in posted code, use BBCode code tags.)