You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

ROLLBACK

Rolls back the open transaction if one exists.

Syntax

ROLLBACK [ WORK ] [ AND [ NO ] CHAIN ] [ [ NO ] RELEASE ]

Remarks

  • [ AND [ NO ] CHAIN ] and [ [ NO ] RELEASE ] are ignored as these options are not currently supported by MemSQL.
  • This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands ).