Grant of "ON COMMIT REFRESH" shows up as syntax error


Yes, I know the beta’s closed, but if I don’t get this out now, I’ll forgets.

In the Editor, this valid statement:

GRANT ON COMMIT REFRESH ON myschema.mytable TO myuser;

…shows up with a syntax error, probably due to the poorly worded “ON COMMIT REFRESH” grantable.

I’ll logoff and wait for someone to tell me I’m full of beans. Hey, I’m full of something, so it might as well be beans.



Hi Rich,

If this is a valid statement (and I have no doubt about that) then it is a bug in the syntax checker. I’ll have that fixed asap.



For completeness, this was fixed in QP5.dll version 5.254, released on Jul 22.