[sqlite] String concatenation disallowed within a RAISE function?

[Samuel R. Neff]

It seems I can't use string concatenation within a RAISE call.  This code:

        SELECT RAISE(ROLLBACK, 'test');

Works fine but this code

        SELECT RAISE(ROLLBACK, 'test' || 'ing');

Gives an error

        SQL error: near "||": syntax error

Is this correct behavior?  I found a work-around by doing this:

        SELECT RAISE(ROLLBACK, ERROR_TEXT) FROM (SELECT 'test' || 'ing'
ERROR_TEXT);

but I would think || should work within RAISE directly.

Thanks,

Sam


-------------------------------------------
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------