Skip to content

Instantly share code, notes, and snippets.

@sheldonh
Created August 25, 2009 13:40
Show Gist options
  • Save sheldonh/174696 to your computer and use it in GitHub Desktop.
Save sheldonh/174696 to your computer and use it in GitHub Desktop.
-- On node writer:
-- ---------------
DROP TABLE test;
CREATE TABLE test (
name VARCHAR(255)
);
set autocommit=0;
set transaction isolation level read committed;
begin;
-- On node reader:
-- ---------------
set autocommit=0;
set transaction isolation level read committed;
begin;
-- On node writer:
-- ---------------
INSERT INTO test VALUES ('bob');
-- On node reader:
-- ---------------
SELECT * from test;
-- returns the row with bob in it!!!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment