for Splice Machine Tutorial Video: Using Command Prompts for Transactions

cp_transactions_2.sql

-- second console

set schema CP;

select * from DOMAIN_DATA;

-- table doesn't exist in this session yet, therefore
-- ERROR 42X05:  Table/View 'DOMAIN_DATA'  does not exist.

-- switch to first console, commit changes

select * from DOMAIN_DATA;

-- information is shown properly now after commit
-- after rollback, data is only shown for first commit
-- if not commited, nor autocommit set to on, then we only see what existed before the commit, or after a rollback.
-- play around with this on two consoles to get a sense of how this works