broken output

root@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a STRING;SELECT count(*) FROM datablocks.blocks;describe datablocks.blocks;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';ALTER TABLE datablocks.blocks DROP COLUMN a;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SET database = 'system';SHOW TABLES;SELECT * FROM users;CREATE USER benesch;SELECT * FROM users;SHOW USERS;SHOW TABLES;use system;SET database = 'system';SHOW TABLES;SELECT * FROM ui;CREATE TABLE system.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));describe table system.jobs;CREATE TABLE system.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs2 (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));SHOW CREATE TABLE systems.jobs2;SHOW CREATE TABLE systems.jobs;use system;SHOW TABLES;set database system;SET database = 'system';SHOW TABLES;SELECT * FROM namespace;DROP TABLE system.eventlog;use database = system;SET database = 'system';SHOW TABLES;SHOW CREATE TABLE eventlog;DROP TABLE system.descriptor;DROP TABLE system.eventlog;DROP TABLE system.lease;SHOW TABLES;SET database = 'system';SHOW TABLES;DROP TABLE zones;DROP TABLE ui;SET database = 'system';DROP TABLE ui;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;DROP TABLE zones;DROP TABLE system.ui;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE namespace;DROP TABLE descriptor;SELECT count(*) FROM eventlog;SELECT * FROM eventlog;DROP TABLE system.ui;SHOW USERS;revoke create from system.ui;revoke create on system.ui;revoke create on system.ui from all;revoke create on system.ui from *;revoke create on system.ui from users;revoke create on system.ui from userssk;revoke create on system.ui from root;revoke drop on system.ui from root;DROP TABLE system.ui;grant drop on system.namespace from root;grant drop on system.namespace to root;CREATE TABLE system (wat INT);CREATE TABLE system.t (wat INT);CREATE TABLE system.jobs (wat INT);create table (a int, b int, index (a));create table nikhil (a int, b int, index (a));create table id.nikhil (a int, b int, index (a));create table d.nikhil (a int, b int, index (a));CREATE DATABASE d;create table d.nikhil (a int, b int, index (a));CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));SET database = 'test';CREATE DATABASE test;SET database = 'test';CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));CREATE TABLE jobs (id                INT DEFAULT unique_rowid(),timestamp         TIMESTAMP NOT NULL DEFAULT now(),status            STRING NOT NULL,payload           BYTES,PRIMARY KEY (id, timestamp),);CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp));SELECT * FROM jobs;INSERT INTO jobs (status, payload)VALUES ('pending', {description = 'BACKUP foodb TO barstorage',creator = 'root',descriptor_id = 18,backup_details = {}})RETURNING id;INSERT INTO jobs(status) VALUES ('pending');SELECT * FROM jobs;INSERT INTO jobs(status, id) VALUES ('running', 221908925848354817);SELECT * FROM jobs;INSERT INTO jobs(status) VALUES ('pending') RETURNING id;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (sytem.jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id;SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, "10%");INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '10%');SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '20%');UPDATE jobs SET payload = '0%' WHERE status = 'pending';SELECT * FROM jobs;UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00');UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00'::timestamp);SELECT * FROM jobs;SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECTlatest.id AS id,latest.status AS status,latest.timestamp AS updated,initial.payload AS payload,initial.timestamp AS created,FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payloadFROM (SELECT id, max(timestamp) as timestamp FROM jobs GROUP BY id) AS latestJOIN jobs ON jobs.id = latest.id AND jobs.timestamp = latest.timestamp) AS latestJOIN jobs AS initial ON initial.id = latest.id AND initial.status = 'pending'WHERE latest.status IN ('pending', 'running')ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, initial.payload AS payload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY created;SELECT * FROM zones;SELECT * FROM system.zones;CREATE USER nikhil;CREATE DATABASE d;create table d.t;create table d.t (a int);create table d.t2 ();insert into d.t2;insert into d.t2 default values;SELECT * FROM d.t2;CREATE TABLE d.t3 ();select * from d.t3();select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM q;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM d.t3;CREATE TABLE d.t4 (a INT);ALTER TABLE d.t4 DROP COLUMN a;SHOW CREATE TABLE d.t4;SHOW TABLES;use database d;SET database = 'd';use database d;SHOW TABLES;SHOW CREATE TABLE t4;SELECT * FROM t4;CREATE TABLE t5 (a INT, b INT);CREATE TABLE d.t5 (a INT, b INT);INSERT INTO d.t5 DEFAULT VALUES;ALTER TABLE d.t5 DROP COLUMN b;ALTER TABLE d.t5 DROP COLUMN a;SELECT * FROM d.t5;SHOW CREATE TABLE d.t5;CREATE TABLE d.t6 (a INT);ALTER TABLE d.t6 DROP COLUMN a;SELECT * FROM d.t6;ALTER TABLE d.t6 DROP COLUMN a;CREATE TABLE d.t4 (a INT);CREATE TABLE d.t6 (a INT);CREATE TABLE d.t8 (a INT);ALTER TABLE d.t8 DROP COLUMN a;CREATE TABLE d.t6 (a INT);CREATE TABLE d.t9 (a INT);SELECT * FROM d.t9;INSERT INTO d.t9 DEFAULT VALUES;SELECT * FROM d.t9;CREATE TABLE d.t10 ();SELECT * FROM d.t10;SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW GRANTS;SHOW GRANTS ON nikhil;grant nikhil;grant 'nikhil';GRANT ALL ON nikhil TO nikhil;SHOW GRANTS ON nikhil;revoke root on nikhil;revoke all from root on nikhil;REVOKE ALL ON nikhil FROM root;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM nikhil;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON system.ui;REVOKE SELECT ON system.ui FROM nikhil;REVOKE SELECT ON * FROM nikhil;SHOW GRANTS ON nikhil;SHOW GRANTS ON *;REVOKE SELECT ON * FROM *;GRANT ALL ON t3 TO sksk;SHOW GRANTS ON t3;select from t3;select () from t3;SELECT 1;select;select ;CREATE TABLE d.jobs (id      INT DEFAULT unique_rowid() PRIMARY KEY,status  STRING NOT NULL,payload BYTES,INDEX   status);CREATE TABLE d.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, payload BYTES, INDEX (status));SELECT * FROM d.jobs;SELECT 1 FROM d.jobs;SELECT 1;SELECT * FROM d.jobs;CREATE TABLE d.t ();SHOW CREATE TABLE d.t;SELECT * FROM d.t;CREATE TABLE d.s ();SELECT * FROM d.s;insert into d.s;select * from 1;select * from t;seelect * from k;SELECT * FROM system.jobs;show grants system.jobs;SHOW GRANTS;SHOW GRANTS; jobs;show grants jobs;show grants on system.jobs;DROP TABLE system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;SHOW GRANTS ON system.jobs;SHOW TABLES;SET database = 'system';SHOW TABLES;SET database = 'system';SHOW TABLES;SELECT * FROM system.jobs;SET database = 'system';SELECT * FROM system.jobs;SHOW GRANTS ON system.jobs;SELECT * FROM nikhil;CREATE TABLE bench.bank (id INT PRIMARY KEY,balance INT,payload STRING,FAMILY (id, balance, payload);CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SHOW DATABASES;CREATE DATABASE bench;CREATE DATABASE nikhil;CREATE DATABASE n;CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SELECT * FROM bench.bank;BACKUP DATABASE bench TO 'foo1';BACKUP DATABASE bench TO 'foo2' INCREMENTAL FROM foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2, foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo1, foo2;SELECT * FROM system.jobs;SHOW TABLES;CREATE DATABASE d;CREATE TABLE t (a INT);SET database = 'd';CREATE TABLE t (a INT);BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM jobs;SELECT * FROM system.jobs;SELECT 1;SELECT 1, 2;SELECT 1, 2 union all;SELECT 1, 2 union all 2 3;SELECT 1, 2 union all 2, 3;SELECT  lFROM    generate_series(1, $n) l;SELECT l FROM generate_series(1, 10);SELECT * FROM generate_series(1, 10);SELECT * FROM (VALUES (1, 2), (3, 4)) AS q (col1, col2);SELECT * FROM (VALUES (1), (2));SELECT * FROM VALUES (1), (2);SELECT * FROM VALUES ((1), (2));SELECT * FROM (VALUES ((1), (2)));SELECT * FROM (VALUES ((1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (VALUES 1, 2, 3);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE DATABASE test;SET database = 'test';use;CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE packages (customer INT, "order" INT, id INT, address STRING(50), delivered BOOL, delivery_date DATE, PRIMARY KEY (customer, "order", id), CONSTRAINT fk_order FOREIGN KEY (customer, "order") REFERENCES orders) INTERLEAVE IN PARENT orders (customer, "order");show table system.jops;SHOW CREATE TABLE system.jobs;CREATE DATABASE bank;CREATE TABLE bank.accounts (id INT PRIMARY KEY, balance DECIMAL);INSERT INTO bank.accounts VALUES (1, 1000.50);SELECT * FROM bank.accounts;SHOW COLUMNS FROM system.eventlog;SHOW COLUMNS FROM system.jobs;ls;SELECT * FROM system.jobs;RESTORE FROM 'foo';RESTORE d FROM 'foo';SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW DATABASES;BACKUP q TO 'q';BACKUP a, b, c TO 'd';BACKUP asdgsadgs TO 'd';SELECT * FROM information_schema;SHOW DATABASES;SELECT SCHEMA_NAME FROM information_schema.schemata;select;SELECT 1;SELECT nil;update;update 1 set 1;create table t;CREATE TABLE t ();CREATE DATABASE d;SELECT 1 WHERE false;SELECT false;SELECT * where false;SET database = 'information_schema';SHOW TABLES;SHOW TABLES crdb_internal;SHOW TABLES from crdb_internal;SELECT * FROM crdb_internal.build_info;SELECT * FROM crdb_internal.leases;SELECT * FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables;SHOW CREATE TABLE system.eventlog;SHOW CREATE TABLE %[1]s;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = '%[1]s';SHOW CREATE TABLE eventlog;SHOW COLUMNS FROM system.eventlog;SHOW INDEXES FROM system.eventlog;SHOW GRANTS ON system.eventlog;SHOW CREATE TABLE system.eventlog;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = q;SHOW CREATE TABLE crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE "Table" = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = 'system.eventlog';SELECT * FROM crdb_internal.tables;SHOW CREATE TABLE crdb_internal.tables;SELECT start_key, end_key FROM crdb_internal.tables;SELECT name, start_key, end_key FROM crdb_internal.tables;SELECT name, database, start_key, end_key FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables\n\t\tWHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' AND DATABASE_NAME = 'system';show tables crdb_internal;show tables in crdb_internal;show tables crdb_internal;show tables from crdb_internal;SHOW COLUMNS FROM crdb_internal.tables;CREATE DATABASE q;SELECT * FROM crdb_internal.tables LIMIT 0;SELECT * FROM system.jobs;SHOW DATABASES;SELECT * FROM ledger;use database ledger;SET database = 'ledger';SELECT * FROM ledger;SHOW TABLES;SELECT * FROM accounts LIMIT 20;BACKUP accounts TO 'accounts';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts?sks';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts2?sks';SELECT * FROM system.jobs;RESTORE FROM accounts;RESTORE accounts FROM accounts;RESTORE accounts.accounts FROM accounts;RESTORE * FROM 'accounts';BACKUP accounts.accounts TO 'accounts2?sks';RESTOREaccounts.accounts FROM 'accounts2?sks';RESTORE accounts.accounts FROM 'accounts2?sks';SELECT * FROM system.jobs;RESTORE * FROM 'accounts';SELECT *;SHOW jobs;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;BACKUP foo TO 'foo';SELECT * FROM system."jobs";SHOW JOBS;RESTORE * FROM 'foo';BACKUP foo TO 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';RESTORE * FROM 'FOO';RESTORE * FROM 'foo';RESTORE * FROM 'foo222';RESTORE * FROM 'foo';BACKUP system.* TO 'foo';RESTORE * FROM 'foo';RESTORE system.* FROM 'foo';CREATE DATABASE newdb;RESTORE system.* FROM 'foo';RESTORE system.* FROM 'foo' into_db=nikhil;RESTORE system.* FROM 'foo' into_db='nikhil';RESTORE system.* FROM 'foo' (into_db='nikhil');RESTORE system.* FROM 'foo' ('into_db'='nikhil');RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');CREATE DATABASE nikhil;RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW DATABASES;SET database = 'startrek';SHOW TABLES;SHOW CREATE TABLE episodes;SHOW CREATE TABLE quotes;show columns episodes;show columns from episodes;SELECT count(*) FROM episodes;SELECT * FROM episodes;SELECT * FROM episodes WHERE season = 2;;SELECT * FROM episodes WHERE season = 2;SELECT * FROM episodes WHERE season = 3;ls;SELECT * FROM episodes WHERE season = 2;SHOW DATABASES;SHOW TABLES;SET database = 'system';SHOW TABLES FROM startrek;SELECT * FROM startrek.episodes;SELECT * FROM startrek.episodes WHERE season = 2;SELECT * FROM crdb_internal.jobs;SHOW USERS;SELECT * FROM system.users;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo2';BACKUP foo TO 'foo3';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs ORDER BY created;SELECT * FROM crdb_internal.jobs ORDER BY modifiedc;SELECT * FROM crdb_internal.jobs ORDER BY modified;SELECT * FROM crdb_internal.jobs LIMIT 2;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs LIMIT 2;SELECT * FROM system.namespace;CREATE DATABASE new;SELECT * FROM system.namespace;\?\exit\qSELECT start;\h\?select * from *;select * from ;SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT id, descriptor_ids FROM crdb_internal.jobs;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;create table (a int[]) ;create table t (a int[]) ;CREATE DATABASE d;create table d.t (a int[]) ;select [1, 2];select [1, 2]::intarray;select [1, 2]::int[];SELECT ARRAY[1, 2];SELECT unnest(ARRAY[1, 2]);create table d.t (a int[]) ;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT conrelid, unnest(conkey) AS connum FROM pg_constraint WHERE (contype = 'p') AND (conrelid = '"numbers"'::REGCLASS);SELECT unnest(conkey) FROM pg_constraint;SELECT unnest(ARRAY[1]), generate_series(2, 3);SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT unnest(conkey) FROM pg_constraint;SELECT 1 + generate_series(1, 3);SELECT generate_series(1, 3);SELECT generate_series(3, 1);SELECT generate_series(3, 1) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT * FROM generate_series(1, 3);SELECT * FROM generate_series(1, 3) + 1;SELECT * FROM generate_series(1, 3) + 1 as x;SELECT * FROM (generate_series(1, 3) + 1) as x;select from generate_series(1, 3);select * from generate_series(1, 3);SELECT s FROM t CROSS JOIN LATERAL (SELECT * FROM generate_series(t.id, t.id+1) AS s) AS _;SELECT (((a + (b * 2)) + (c * 3)) + (d * 4)) + (e * 5), CASE WHEN a < (b - 3) THEN 111 WHEN a <= b THEN 222 WHEN a < (b + 3) THEN 333 ELSE 444 END, abs(b - c), ((((a + b) + c) + d) + e) / 5, (a + (b * 2)) + (c * 3) FROM t1 WHERE (((e > c) OR (e < d)) AND (d > e)) AND EXISTS (SELECT 1 FROM t1 AS x WHERE x.b < t1.b) ORDER BY 4, 2, 1, 3, 5;(SELECT FROM VALUES (1, 2, 3));(SELECT VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));SELECT * FROM (VALUES (1), (2), (3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM (VALUES (1, 2, 3)));(SELECT * FROM (VALUES (1), (2), (3))));(SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3))) AS s;SELECT *, (SELECT t.a + 1)  FROM (SELECT a FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1  FROM (SELECT c1 FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1 FROM (SELECT * FROM (VALUES (1), (2), (3))) AS t (c1);SELECT * FROM generate_series(1, 3) AS c1;SELECT c1, c1 + 1 FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT *, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT _.*, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT generate_series(1, 2);SELECT generate_series(1, 3);SELECT * FROM generate_series(1, 3);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 3);select array(generate_series(1, 3));select array(generate_series(1, 3));SELECT generate_series(1, 3);select array(1, 2);select array 1, 2;SELECT ARRAY[1, 2, 3];SELECT ARRAY[generate_series(1, 2, 3)];select ARRAY(generate_series(1, 2, 3));SELECT generate_series(1, 2, 3);select ARRAY(generate_series(1, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 5, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) + 10;SELECT generate_series(1, 2) + 10 + 2;SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10 + generate_series(7, 2);SELECT generate_series(generate_series(3, 4), 5);SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(1, 2) + 99;SELECT 1;SELECT (1 + 2) + 3;SELECT 1 + generate_series(1, 2) + 99;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(2, 1);SELECT 1 + generate_series(1, 2);SELECT 3 + (3 * generate_series(1, 3));SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3, 4]);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3]);SELECT unnest(ARRAY[3, 4]) - 2, unnest(ARRAY['a', 'b']);SELECT 1 + generate_series(0, 2), unnest(ARRAY[2, 4, 6]) / 2;SELECT ascii(unnest(ARRAY['a', 'b', 'c']));SELECT chr(generate_series(65, 68));SELECT 1 + generate_series(0, 1), unnest(ARRAY[2, 4]) / 2;EXPLAIN (EXPRS) SELECT v, COUNT(1) FROM kv GROUP BY v ORDER BY COUNT(1);CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);CREATE DATABASE d;use database = d;use database d;SET database = 'd';CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);EXPLAIN (EXPRS) SELECT v, COUNT(k) FROM kv GROUP BY v ORDER BY COUNT(k);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT generate_series(1, 3);SELECT generate_series(generate_series(1, 3), 3);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77') ORDER BY generate_series(1, 3);SELECT * FROM a;SELECT * FROM 1;SELECT * from (values (1), (2)) as v;SELECT * from (values (1), (2)) as v order by generate_series();SELECT * from (values (1), (2)) as v order by generate_series(1, 3);SELECT * from (values (1), (2)) as v order by generate_series(1, 5);SELECT * from (values (1), (2)) as v order by generate_series(3, 1);SELECT * from (values (1), (2)) as v order by 1;SELECT * from (values (1), (2)) as v order by 1 desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SHOW TABLES;SET database = 'd';SHOW DATABASES;CREATE DATABASE d;SET database = 'd';ls;SHOW DATABASES;CREATE TABLE t (a INT);INSERT INTO t VALUES (1);INSERT INTO t VALUES (1) returning *;INSERT INTO t VALUES (1) returning * as q;INSERT INTO t VALUES (1) returning a as b;INSERT INTO t VALUES (1) returning a as a;INSERT INTO t VALUES (1) returning a as aaa;INSERT INTO t VALUES (1) returning generate_series(1, 3) as aaa;SELECT 1 + generate_series(1, 3);SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 1;SELECT GENERATE_SERIES(1, 2) + 8;SELECT GENERATE_SERIES(1, 2) + 9;SELECT GENERATE_SERIES(1, 2);SELECT LENGTH(1, 2);SELECT LENGTH('anik');SELECT LENGTH(1, 2);SELECT LENGTH('a');SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 9;SELECT a.attname, format_type(a.atttypid, a.atttypmod) AS data_type FROM pg_index AS i JOIN pg_attribute AS a ON (a.attrelid = i.indrelid) AND (a.attnum = ANY (i.indkey)) WHERE (i.indrelid = '"a"'::REGCLASS) AND i.indisprimary;SELECT GENERATE_SERIES(1, 2);SELECT 1 + generate_series(1, 3) FROM t WHERE generate_series > 3;SELECT 1 + generate_series(1, 3) WHERE generate_series > 3;SHOW DATABASES;BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs order by created;SELECT * FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM datablocks.blocks;SELECT count(*) FROM datablocks.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE FROM 'foo';RESTORE 'foo';RESTORE datablocks.* FROM 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP DATABASE datablocks2;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks3;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks3');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP TABLE datablocks3.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks4');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');CREATE DATABASE datablocks5;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;CREATE DATABASE datablocks3;CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks7;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks8;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks8');RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');CREATE DATABASE datablocks9;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks10;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks10');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');CREATE DATABASE datablocks11;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;create user;create user nikhil;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BACKUP datablocks.blocks TO 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');CREATE DATABASE datablocks100;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;create db goose;create database goose;ROLLBACK TRANSACTION;create database goose;SET database = 'goose';BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;ROLLBACK TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;DROP DATABASE goose;SELECT * FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks101;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks101');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;ls;SHOW DATABASES;DROP DATABASE tpch;SHOW DATABASES;CREATE DATABASE tpch;SELECT * FROM crdb_internal.jobs;BEGIN TRANSACTION;CREATE DATABASE q;CREATE TABLE q.q ();CREATE TABLE q.t (a INT, b INT);COMMIT TRANSACTION;BEGIN TRANSACTION;prepare select * from q.t;prepare q as select * from q.t;COMMIT TRANSACTION;RESTORE FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';CREATE DATABASE tpch;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';SHOW DATABASES;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';COPY states FROM 'states.csv';COPY states FROM states.csv;COPY states FROM STDIN;COPY states.states FROM STDIN;SELECT * FROM tbl;SHOW DATABASES;SELECT * FROM jobs;SELECT * FROM jobs;SHOW DATABASES;BACKUP DATABASE tpch TO 'foo';SHOW TABLES FROM tpch;BACKUP DATABASE tpch TO 'foo';BACKUP DATABASE datablocks TO 'foo';SHOW USERS;SHOW TABLES;SHOW TABLES FROM system;show create table from ui;show create table system.ui;SHOW DATABASES;SHOW TABLES FROM datablocks;BACKUP DATABASE datablocks TO 'foo';SHOW settings;SELECT * FROM system.settings;SET CLUSTER SETTING enterprise.enabled = true;SELECT * FROM system.settings;BACKUP DATABASE datablocks TO 'foo';RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');create table blocks2;create database blocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');SELECT * FROM crdb_internal.jobs;SHOW COLUMNS FROM crdb_internal.jobs;SELECT id, type, created, user, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, type, created, username, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, status, fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT status, fraction_completed FROM crdb_internal.jobs WHERE id = 235783388924116992 LIMIT 1;RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT/bUfy280nCGljw==';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=FzWMkVNcHorQ2IPG5il987GEmEzSxmV8WxXOZHzKV4XfvNTXHEDdBrsAIMB2/UutSPhhNQwVt9zs4dVXD/6w/w==';SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM tpch.region;SELECT count(*) FROM tpch.nation;SELECT count(*) FROM tpch.customer;SELECT count(*) FROM tpch.lineitem;SELECT tpch.lineitem FROM tpch.lineitem;SELECT li_orderkey FROM tpch.lineitem;SELECT l_orderkey FROM tpch.lineitem LIMIT 1;SELECT l_orderkey FROM tpch.lineitem ORDER BY random() LIMIT 1;SELECT FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783 AND l_partkey = 107348;SELECT * FROM tpch.lineitem WHERE (l_orderkey = 131783) AND (l_partkey = 107348);BACKUP tpch.lineitem TO '/Users/benesch/Desktop/lineitem';SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT description, finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT *;SHOW TABLES;SHOW DATABASES;BACKUP datablocks.blocks TO 'foo';BACKUP datablocks.blocks TO '/foo';BACKUP datablocks.blocks TO 'file://foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal:///foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal://./foo';BACKUP datablocks.blocks TO 'nodelocal://foo2';BACKUP datablocks.blocks TO 'nodelocal:///Users/benesch/Desktop/foo';SELECT * FROM system.jobs;SELECT fraction_completed FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT * FROM system.settings;SELECT description, fraction_completed FROM crdb_internal.jobs;selected now() - started() / fraction_completed from crdb_internal.jobs;select now() - started() / fraction_completed from crdb_internal.jobs;select now() - started / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_interroot@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a STRING;SELECT count(*) FROM datablocks.blocks;describe datablocks.blocks;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';ALTER TABLE datablocks.blocks DROP COLUMN a;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SET database = 'system';SHOW TABLES;SELECT * FROM users;CREATE USER benesch;SELECT * FROM users;SHOW USERS;SHOW TABLES;use system;SET database = 'system';SHOW TABLES;SELECT * FROM ui;CREATE TABLE system.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));describe table system.jobs;CREATE TABLE system.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs2 (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));SHOW CREATE TABLE systems.jobs2;SHOW CREATE TABLE systems.jobs;use system;SHOW TABLES;set database system;SET database = 'system';SHOW TABLES;SELECT * FROM namespace;DROP TABLE system.eventlog;use database = system;SET database = 'system';SHOW TABLES;SHOW CREATE TABLE eventlog;DROP TABLE system.descriptor;DROP TABLE system.eventlog;DROP TABLE system.lease;SHOW TABLES;SET database = 'system';SHOW TABLES;DROP TABLE zones;DROP TABLE ui;SET database = 'system';DROP TABLE ui;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;DROP TABLE zones;DROP TABLE system.ui;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE namespace;DROP TABLE descriptor;SELECT count(*) FROM eventlog;SELECT * FROM eventlog;DROP TABLE system.ui;SHOW USERS;revoke create from system.ui;revoke create on system.ui;revoke create on system.ui from all;revoke create on system.ui from *;revoke create on system.ui from users;revoke create on system.ui from userssk;revoke create on system.ui from root;revoke drop on system.ui from root;DROP TABLE system.ui;grant drop on system.namespace from root;grant drop on system.namespace to root;CREATE TABLE system (wat INT);CREATE TABLE system.t (wat INT);CREATE TABLE system.jobs (wat INT);create table (a int, b int, index (a));create table nikhil (a int, b int, index (a));create table id.nikhil (a int, b int, index (a));create table d.nikhil (a int, b int, index (a));CREATE DATABASE d;create table d.nikhil (a int, b int, index (a));CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));SET database = 'test';CREATE DATABASE test;SET database = 'test';CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));CREATE TABLE jobs (id                INT DEFAULT unique_rowid(),timestamp         TIMESTAMP NOT NULL DEFAULT now(),status            STRING NOT NULL,payload           BYTES,PRIMARY KEY (id, timestamp),);CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp));SELECT * FROM jobs;INSERT INTO jobs (status, payload)VALUES ('pending', {description = 'BACKUP foodb TO barstorage',creator = 'root',descriptor_id = 18,backup_details = {}})RETURNING id;INSERT INTO jobs(status) VALUES ('pending');SELECT * FROM jobs;INSERT INTO jobs(status, id) VALUES ('running', 221908925848354817);SELECT * FROM jobs;INSERT INTO jobs(status) VALUES ('pending') RETURNING id;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (sytem.jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id;SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, "10%");INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '10%');SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '20%');UPDATE jobs SET payload = '0%' WHERE status = 'pending';SELECT * FROM jobs;UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00');UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00'::timestamp);SELECT * FROM jobs;SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECTlatest.id AS id,latest.status AS status,latest.timestamp AS updated,initial.payload AS payload,initial.timestamp AS created,FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payloadFROM (SELECT id, max(timestamp) as timestamp FROM jobs GROUP BY id) AS latestJOIN jobs ON jobs.id = latest.id AND jobs.timestamp = latest.timestamp) AS latestJOIN jobs AS initial ON initial.id = latest.id AND initial.status = 'pending'WHERE latest.status IN ('pending', 'running')ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, initial.payload AS payload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY created;SELECT * FROM zones;SELECT * FROM system.zones;CREATE USER nikhil;CREATE DATABASE d;create table d.t;create table d.t (a int);create table d.t2 ();insert into d.t2;insert into d.t2 default values;SELECT * FROM d.t2;CREATE TABLE d.t3 ();select * from d.t3();select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM q;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM d.t3;CREATE TABLE d.t4 (a INT);ALTER TABLE d.t4 DROP COLUMN a;SHOW CREATE TABLE d.t4;SHOW TABLES;use database d;SET database = 'd';use database d;SHOW TABLES;SHOW CREATE TABLE t4;SELECT * FROM t4;CREATE TABLE t5 (a INT, b INT);CREATE TABLE d.t5 (a INT, b INT);INSERT INTO d.t5 DEFAULT VALUES;ALTER TABLE d.t5 DROP COLUMN b;ALTER TABLE d.t5 DROP COLUMN a;SELECT * FROM d.t5;SHOW CREATE TABLE d.t5;CREATE TABLE d.t6 (a INT);ALTER TABLE d.t6 DROP COLUMN a;SELECT * FROM d.t6;ALTER TABLE d.t6 DROP COLUMN a;CREATE TABLE d.t4 (a INT);CREATE TABLE d.t6 (a INT);CREATE TABLE d.t8 (a INT);ALTER TABLE d.t8 DROP COLUMN a;CREATE TABLE d.t6 (a INT);CREATE TABLE d.t9 (a INT);SELECT * FROM d.t9;INSERT INTO d.t9 DEFAULT VALUES;SELECT * FROM d.t9;CREATE TABLE d.t10 ();SELECT * FROM d.t10;SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW GRANTS;SHOW GRANTS ON nikhil;grant nikhil;grant 'nikhil';GRANT ALL ON nikhil TO nikhil;SHOW GRANTS ON nikhil;revoke root on nikhil;revoke all from root on nikhil;REVOKE ALL ON nikhil FROM root;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM nikhil;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON system.ui;REVOKE SELECT ON system.ui FROM nikhil;REVOKE SELECT ON * FROM nikhil;SHOW GRANTS ON nikhil;SHOW GRANTS ON *;REVOKE SELECT ON * FROM *;GRANT ALL ON t3 TO sksk;SHOW GRANTS ON t3;select from t3;select () from t3;SELECT 1;select;select ;CREATE TABLE d.jobs (id      INT DEFAULT unique_rowid() PRIMARY KEY,status  STRING NOT NULL,payload BYTES,INDEX   status);CREATE TABLE d.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, payload BYTES, INDEX (status));SELECT * FROM d.jobs;SELECT 1 FROM d.jobs;SELECT 1;SELECT * FROM d.jobs;CREATE TABLE d.t ();SHOW CREATE TABLE d.t;SELECT * FROM d.t;CREATE TABLE d.s ();SELECT * FROM d.s;insert into d.s;select * from 1;select * from t;seelect * from k;SELECT * FROM system.jobs;show grants system.jobs;SHOW GRANTS;SHOW GRANTS; jobs;show grants jobs;show grants on system.jobs;DROP TABLE system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;SHOW GRANTS ON system.jobs;SHOW TABLES;SET database = 'system';SHOW TABLES;SET database = 'system';SHOW TABLES;SELECT * FROM system.jobs;SET database = 'system';SELECT * FROM system.jobs;SHOW GRANTS ON system.jobs;SELECT * FROM nikhil;CREATE TABLE bench.bank (id INT PRIMARY KEY,balance INT,payload STRING,FAMILY (id, balance, payload);CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SHOW DATABASES;CREATE DATABASE bench;CREATE DATABASE nikhil;CREATE DATABASE n;CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SELECT * FROM bench.bank;BACKUP DATABASE bench TO 'foo1';BACKUP DATABASE bench TO 'foo2' INCREMENTAL FROM foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2, foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo1, foo2;SELECT * FROM system.jobs;SHOW TABLES;CREATE DATABASE d;CREATE TABLE t (a INT);SET database = 'd';CREATE TABLE t (a INT);BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM jobs;SELECT * FROM system.jobs;SELECT 1;SELECT 1, 2;SELECT 1, 2 union all;SELECT 1, 2 union all 2 3;SELECT 1, 2 union all 2, 3;SELECT  lFROM    generate_series(1, $n) l;SELECT l FROM generate_series(1, 10);SELECT * FROM generate_series(1, 10);SELECT * FROM (VALUES (1, 2), (3, 4)) AS q (col1, col2);SELECT * FROM (VALUES (1), (2));SELECT * FROM VALUES (1), (2);SELECT * FROM VALUES ((1), (2));SELECT * FROM (VALUES ((1), (2)));SELECT * FROM (VALUES ((1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (VALUES 1, 2, 3);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE DATABASE test;SET database = 'test';use;CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE packages (customer INT, "order" INT, id INT, address STRING(50), delivered BOOL, delivery_date DATE, PRIMARY KEY (customer, "order", id), CONSTRAINT fk_order FOREIGN KEY (customer, "order") REFERENCES orders) INTERLEAVE IN PARENT orders (customer, "order");show table system.jops;SHOW CREATE TABLE system.jobs;CREATE DATABASE bank;CREATE TABLE bank.accounts (id INT PRIMARY KEY, balance DECIMAL);INSERT INTO bank.accounts VALUES (1, 1000.50);SELECT * FROM bank.accounts;SHOW COLUMNS FROM system.eventlog;SHOW COLUMNS FROM system.jobs;ls;SELECT * FROM system.jobs;RESTORE FROM 'foo';RESTORE d FROM 'foo';SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW DATABASES;BACKUP q TO 'q';BACKUP a, b, c TO 'd';BACKUP asdgsadgs TO 'd';SELECT * FROM information_schema;SHOW DATABASES;SELECT SCHEMA_NAME FROM information_schema.schemata;select;SELECT 1;SELECT nil;update;update 1 set 1;create table t;CREATE TABLE t ();CREATE DATABASE d;SELECT 1 WHERE false;SELECT false;SELECT * where false;SET database = 'information_schema';SHOW TABLES;SHOW TABLES crdb_internal;SHOW TABLES from crdb_internal;SELECT * FROM crdb_internal.build_info;SELECT * FROM crdb_internal.leases;SELECT * FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables;SHOW CREATE TABLE system.eventlog;SHOW CREATE TABLE %[1]s;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = '%[1]s';SHOW CREATE TABLE eventlog;SHOW COLUMNS FROM system.eventlog;SHOW INDEXES FROM system.eventlog;SHOW GRANTS ON system.eventlog;SHOW CREATE TABLE system.eventlog;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = q;SHOW CREATE TABLE crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE "Table" = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = 'system.eventlog';SELECT * FROM crdb_internal.tables;SHOW CREATE TABLE crdb_internal.tables;SELECT start_key, end_key FROM crdb_internal.tables;SELECT name, start_key, end_key FROM crdb_internal.tables;SELECT name, database, start_key, end_key FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables\n\t\tWHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' AND DATABASE_NAME = 'system';show tables crdb_internal;show tables in crdb_internal;show tables crdb_internal;show tables from crdb_internal;SHOW COLUMNS FROM crdb_internal.tables;CREATE DATABASE q;SELECT * FROM crdb_internal.tables LIMIT 0;SELECT * FROM system.jobs;SHOW DATABASES;SELECT * FROM ledger;use database ledger;SET database = 'ledger';SELECT * FROM ledger;SHOW TABLES;SELECT * FROM accounts LIMIT 20;BACKUP accounts TO 'accounts';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts?sks';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts2?sks';SELECT * FROM system.jobs;RESTORE FROM accounts;RESTORE accounts FROM accounts;RESTORE accounts.accounts FROM accounts;RESTORE * FROM 'accounts';BACKUP accounts.accounts TO 'accounts2?sks';RESTOREaccounts.accounts FROM 'accounts2?sks';RESTORE accounts.accounts FROM 'accounts2?sks';SELECT * FROM system.jobs;RESTORE * FROM 'accounts';SELECT *;SHOW jobs;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;BACKUP foo TO 'foo';SELECT * FROM system."jobs";SHOW JOBS;RESTORE * FROM 'foo';BACKUP foo TO 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';RESTORE * FROM 'FOO';RESTORE * FROM 'foo';RESTORE * FROM 'foo222';RESTORE * FROM 'foo';BACKUP system.* TO 'foo';RESTORE * FROM 'foo';RESTORE system.* FROM 'foo';CREATE DATABASE newdb;RESTORE system.* FROM 'foo';RESTORE system.* FROM 'foo' into_db=nikhil;RESTORE system.* FROM 'foo' into_db='nikhil';RESTORE system.* FROM 'foo' (into_db='nikhil');RESTORE system.* FROM 'foo' ('into_db'='nikhil');RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');CREATE DATABASE nikhil;RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW DATABASES;SET database = 'startrek';SHOW TABLES;SHOW CREATE TABLE episodes;SHOW CREATE TABLE quotes;show columns episodes;show columns from episodes;SELECT count(*) FROM episodes;SELECT * FROM episodes;SELECT * FROM episodes WHERE season = 2;;SELECT * FROM episodes WHERE season = 2;SELECT * FROM episodes WHERE season = 3;ls;SELECT * FROM episodes WHERE season = 2;SHOW DATABASES;SHOW TABLES;SET database = 'system';SHOW TABLES FROM startrek;SELECT * FROM startrek.episodes;SELECT * FROM startrek.episodes WHERE season = 2;SELECT * FROM crdb_internal.jobs;SHOW USERS;SELECT * FROM system.users;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo2';BACKUP foo TO 'foo3';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs ORDER BY created;SELECT * FROM crdb_internal.jobs ORDER BY modifiedc;SELECT * FROM crdb_internal.jobs ORDER BY modified;SELECT * FROM crdb_internal.jobs LIMIT 2;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs LIMIT 2;SELECT * FROM system.namespace;CREATE DATABASE new;SELECT * FROM system.namespace;\?\exit\qSELECT start;\h\?select * from *;select * from ;SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT id, descriptor_ids FROM crdb_internal.jobs;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;create table (a int[]) ;create table t (a int[]) ;CREATE DATABASE d;create table d.t (a int[]) ;select [1, 2];select [1, 2]::intarray;select [1, 2]::int[];SELECT ARRAY[1, 2];SELECT unnest(ARRAY[1, 2]);create table d.t (a int[]) ;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT conrelid, unnest(conkey) AS connum FROM pg_constraint WHERE (contype = 'p') AND (conrelid = '"numbers"'::REGCLASS);SELECT unnest(conkey) FROM pg_constraint;SELECT unnest(ARRAY[1]), generate_series(2, 3);SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT unnest(conkey) FROM pg_constraint;SELECT 1 + generate_series(1, 3);SELECT generate_series(1, 3);SELECT generate_series(3, 1);SELECT generate_series(3, 1) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT * FROM generate_series(1, 3);SELECT * FROM generate_series(1, 3) + 1;SELECT * FROM generate_series(1, 3) + 1 as x;SELECT * FROM (generate_series(1, 3) + 1) as x;select from generate_series(1, 3);select * from generate_series(1, 3);SELECT s FROM t CROSS JOIN LATERAL (SELECT * FROM generate_series(t.id, t.id+1) AS s) AS _;SELECT (((a + (b * 2)) + (c * 3)) + (d * 4)) + (e * 5), CASE WHEN a < (b - 3) THEN 111 WHEN a <= b THEN 222 WHEN a < (b + 3) THEN 333 ELSE 444 END, abs(b - c), ((((a + b) + c) + d) + e) / 5, (a + (b * 2)) + (c * 3) FROM t1 WHERE (((e > c) OR (e < d)) AND (d > e)) AND EXISTS (SELECT 1 FROM t1 AS x WHERE x.b < t1.b) ORDER BY 4, 2, 1, 3, 5;(SELECT FROM VALUES (1, 2, 3));(SELECT VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));SELECT * FROM (VALUES (1), (2), (3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM (VALUES (1, 2, 3)));(SELECT * FROM (VALUES (1), (2), (3))));(SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3))) AS s;SELECT *, (SELECT t.a + 1)  FROM (SELECT a FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1  FROM (SELECT c1 FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1 FROM (SELECT * FROM (VALUES (1), (2), (3))) AS t (c1);SELECT * FROM generate_series(1, 3) AS c1;SELECT c1, c1 + 1 FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT *, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT _.*, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT generate_series(1, 2);SELECT generate_series(1, 3);SELECT * FROM generate_series(1, 3);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 3);select array(generate_series(1, 3));select array(generate_series(1, 3));SELECT generate_series(1, 3);select array(1, 2);select array 1, 2;SELECT ARRAY[1, 2, 3];SELECT ARRAY[generate_series(1, 2, 3)];select ARRAY(generate_series(1, 2, 3));SELECT generate_series(1, 2, 3);select ARRAY(generate_series(1, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 5, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) + 10;SELECT generate_series(1, 2) + 10 + 2;SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10 + generate_series(7, 2);SELECT generate_series(generate_series(3, 4), 5);SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(1, 2) + 99;SELECT 1;SELECT (1 + 2) + 3;SELECT 1 + generate_series(1, 2) + 99;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(2, 1);SELECT 1 + generate_series(1, 2);SELECT 3 + (3 * generate_series(1, 3));SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3, 4]);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3]);SELECT unnest(ARRAY[3, 4]) - 2, unnest(ARRAY['a', 'b']);SELECT 1 + generate_series(0, 2), unnest(ARRAY[2, 4, 6]) / 2;SELECT ascii(unnest(ARRAY['a', 'b', 'c']));SELECT chr(generate_series(65, 68));SELECT 1 + generate_series(0, 1), unnest(ARRAY[2, 4]) / 2;EXPLAIN (EXPRS) SELECT v, COUNT(1) FROM kv GROUP BY v ORDER BY COUNT(1);CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);CREATE DATABASE d;use database = d;use database d;SET database = 'd';CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);EXPLAIN (EXPRS) SELECT v, COUNT(k) FROM kv GROUP BY v ORDER BY COUNT(k);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT generate_series(1, 3);SELECT generate_series(generate_series(1, 3), 3);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77') ORDER BY generate_series(1, 3);SELECT * FROM a;SELECT * FROM 1;SELECT * from (values (1), (2)) as v;SELECT * from (values (1), (2)) as v order by generate_series();SELECT * from (values (1), (2)) as v order by generate_series(1, 3);SELECT * from (values (1), (2)) as v order by generate_series(1, 5);SELECT * from (values (1), (2)) as v order by generate_series(3, 1);SELECT * from (values (1), (2)) as v order by 1;SELECT * from (values (1), (2)) as v order by 1 desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SHOW TABLES;SET database = 'd';SHOW DATABASES;CREATE DATABASE d;SET database = 'd';ls;SHOW DATABASES;CREATE TABLE t (a INT);INSERT INTO t VALUES (1);INSERT INTO t VALUES (1) returning *;INSERT INTO t VALUES (1) returning * as q;INSERT INTO t VALUES (1) returning a as b;INSERT INTO t VALUES (1) returning a as a;INSERT INTO t VALUES (1) returning a as aaa;INSERT INTO t VALUES (1) returning generate_series(1, 3) as aaa;SELECT 1 + generate_series(1, 3);SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 1;SELECT GENERATE_SERIES(1, 2) + 8;SELECT GENERATE_SERIES(1, 2) + 9;SELECT GENERATE_SERIES(1, 2);SELECT LENGTH(1, 2);SELECT LENGTH('anik');SELECT LENGTH(1, 2);SELECT LENGTH('a');SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 9;SELECT a.attname, format_type(a.atttypid, a.atttypmod) AS data_type FROM pg_index AS i JOIN pg_attribute AS a ON (a.attrelid = i.indrelid) AND (a.attnum = ANY (i.indkey)) WHERE (i.indrelid = '"a"'::REGCLASS) AND i.indisprimary;SELECT GENERATE_SERIES(1, 2);SELECT 1 + generate_series(1, 3) FROM t WHERE generate_series > 3;SELECT 1 + generate_series(1, 3) WHERE generate_series > 3;SHOW DATABASES;BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs order by created;SELECT * FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM datablocks.blocks;SELECT count(*) FROM datablocks.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE FROM 'foo';RESTORE 'foo';RESTORE datablocks.* FROM 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP DATABASE datablocks2;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks3;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks3');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP TABLE datablocks3.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks4');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');CREATE DATABASE datablocks5;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;CREATE DATABASE datablocks3;CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks7;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks8;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks8');RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');CREATE DATABASE datablocks9;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks10;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks10');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');CREATE DATABASE datablocks11;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;create user;create user nikhil;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BACKUP datablocks.blocks TO 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');CREATE DATABASE datablocks100;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;create db goose;create database goose;ROLLBACK TRANSACTION;create database goose;SET database = 'goose';BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;ROLLBACK TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;DROP DATABASE goose;SELECT * FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks101;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks101');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;ls;SHOW DATABASES;DROP DATABASE tpch;SHOW DATABASES;CREATE DATABASE tpch;SELECT * FROM crdb_internal.jobs;BEGIN TRANSACTION;CREATE DATABASE q;CREATE TABLE q.q ();CREATE TABLE q.t (a INT, b INT);COMMIT TRANSACTION;BEGIN TRANSACTION;prepare select * from q.t;prepare q as select * from q.t;COMMIT TRANSACTION;RESTORE FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';CREATE DATABASE tpch;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';SHOW DATABASES;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';COPY states FROM 'states.csv';COPY states FROM states.csv;COPY states FROM STDIN;COPY states.states FROM STDIN;SELECT * FROM tbl;SHOW DATABASES;SELECT * FROM jobs;SELECT * FROM jobs;SHOW DATABASES;BACKUP DATABASE tpch TO 'foo';SHOW TABLES FROM tpch;BACKUP DATABASE tpch TO 'foo';BACKUP DATABASE datablocks TO 'foo';SHOW USERS;SHOW TABLES;SHOW TABLES FROM system;show create table from ui;show create table system.ui;SHOW DATABASES;SHOW TABLES FROM datablocks;BACKUP DATABASE datablocks TO 'foo';SHOW settings;SELECT * FROM system.settings;SET CLUSTER SETTING enterprise.enabled = true;SELECT * FROM system.settings;BACKUP DATABASE datablocks TO 'foo';RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');create table blocks2;create database blocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');SELECT * FROM crdb_internal.jobs;SHOW COLUMNS FROM crdb_internal.jobs;SELECT id, type, created, user, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, type, created, username, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, status, fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT status, fraction_completed FROM crdb_internal.jobs WHERE id = 235783388924116992 LIMIT 1;RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT/bUfy280nCGljw==';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=FzWMkVNcHorQ2IPG5il987GEmEzSxmV8WxXOZHzKV4XfvNTXHEDdBrsAIMB2/UutSPhhNQwVt9zs4dVXD/6w/w==';SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM tpch.region;SELECT count(*) FROM tpch.nation;SELECT count(*) FROM tpch.customer;SELECT count(*) FROM tpch.lineitem;SELECT tpch.lineitem FROM tpch.lineitem;SELECT li_orderkey FROM tpch.lineitem;SELECT l_orderkey FROM tpch.lineitem LIMIT 1;SELECT l_orderkey FROM tpch.lineitem ORDER BY random() LIMIT 1;SELECT FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783 AND l_partkey = 107348;SELECT * FROM tpch.lineitem WHERE (l_orderkey = 131783) AND (l_partkey = 107348);BACKUP tpch.lineitem TO '/Users/benesch/Desktop/lineitem';SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT description, finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT *;SHOW TABLES;SHOW DATABASES;BACKUP datablocks.blocks TO 'foo';BACKUP datablocks.blocks TO '/foo';BACKUP datablocks.blocks TO 'file://foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal:///foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal://./foo';BACKUP datablocks.blocks TO 'nodelocal://foo2';BACKUP datablocks.blocks TO 'nodelocal:///Users/benesch/Desktop/foo';SELECT * FROM system.jobs;SELECT fraction_completed FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT * FROM system.settings;SELECT description, fraction_completed FROM crdb_internal.jobs;selected now() - started() / fraction_completed from crdb_internal.jobs;select now() - started() / fraction_completed from crdb_internal.jobs;select now() - started / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_interroot@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a STRING;SELECT count(*) FROM datablocks.blocks;describe datablocks.blocks;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';ALTER TABLE datablocks.blocks DROP COLUMN a;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SET database = 'system';SHOW TABLES;SELECT * FROM users;CREATE USER benesch;SELECT * FROM users;SHOW USERS;SHOW TABLES;use system;SET database = 'system';SHOW TABLES;SELECT * FROM ui;CREATE TABLE system.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));describe table system.jobs;CREATE TABLE system.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs2 (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));SHOW CREATE TABLE systems.jobs2;SHOW CREATE TABLE systems.jobs;use system;SHOW TABLES;set database system;SET database = 'system';SHOW TABLES;SELECT * FROM namespace;DROP TABLE system.eventlog;use database = system;SET database = 'system';SHOW TABLES;SHOW CREATE TABLE eventlog;DROP TABLE system.descriptor;DROP TABLE system.eventlog;DROP TABLE system.lease;SHOW TABLES;SET database = 'system';SHOW TABLES;DROP TABLE zones;DROP TABLE ui;SET database = 'system';DROP TABLE ui;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;DROP TABLE zones;DROP TABLE system.ui;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE namespace;DROP TABLE descriptor;SELECT count(*) FROM eventlog;SELECT * FROM eventlog;DROP TABLE system.ui;SHOW USERS;revoke create from system.ui;revoke create on system.ui;revoke create on system.ui from all;revoke create on system.ui from *;revoke create on system.ui from users;revoke create on system.ui from userssk;revoke create on system.ui from root;revoke drop on system.ui from root;DROP TABLE system.ui;grant drop on system.namespace from root;grant drop on system.namespace to root;CREATE TABLE system (wat INT);CREATE TABLE system.t (wat INT);CREATE TABLE system.jobs (wat INT);create table (a int, b int, index (a));create table nikhil (a int, b int, index (a));create table id.nikhil (a int, b int, index (a));create table d.nikhil (a int, b int, index (a));CREATE DATABASE d;create table d.nikhil (a int, b int, index (a));CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));SET database = 'test';CREATE DATABASE test;SET database = 'test';CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));CREATE TABLE jobs (id                INT DEFAULT unique_rowid(),timestamp         TIMESTAMP NOT NULL DEFAULT now(),status            STRING NOT NULL,payload           BYTES,PRIMARY KEY (id, timestamp),);CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp));SELECT * FROM jobs;INSERT INTO jobs (status, payload)VALUES ('pending', {description = 'BACKUP foodb TO barstorage',creator = 'root',descriptor_id = 18,backup_details = {}})RETURNING id;INSERT INTO jobs(status) VALUES ('pending');SELECT * FROM jobs;INSERT INTO jobs(status, id) VALUES ('running', 221908925848354817);SELECT * FROM jobs;INSERT INTO jobs(status) VALUES ('pending') RETURNING id;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (sytem.jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id;SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, "10%");INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '10%');SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '20%');UPDATE jobs SET payload = '0%' WHERE status = 'pending';SELECT * FROM jobs;UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00');UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00'::timestamp);SELECT * FROM jobs;SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECTlatest.id AS id,latest.status AS status,latest.timestamp AS updated,initial.payload AS payload,initial.timestamp AS created,FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payloadFROM (SELECT id, max(timestamp) as timestamp FROM jobs GROUP BY id) AS latestJOIN jobs ON jobs.id = latest.id AND jobs.timestamp = latest.timestamp) AS latestJOIN jobs AS initial ON initial.id = latest.id AND initial.status = 'pending'WHERE latest.status IN ('pending', 'running')ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, initial.payload AS payload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY created;SELECT * FROM zones;SELECT * FROM system.zones;CREATE USER nikhil;CREATE DATABASE d;create table d.t;create table d.t (a int);create table d.t2 ();insert into d.t2;insert into d.t2 default values;SELECT * FROM d.t2;CREATE TABLE d.t3 ();select * from d.t3();select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM q;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM d.t3;CREATE TABLE d.t4 (a INT);ALTER TABLE d.t4 DROP COLUMN a;SHOW CREATE TABLE d.t4;SHOW TABLES;use database d;SET database = 'd';use database d;SHOW TABLES;SHOW CREATE TABLE t4;SELECT * FROM t4;CREATE TABLE t5 (a INT, b INT);CREATE TABLE d.t5 (a INT, b INT);INSERT INTO d.t5 DEFAULT VALUES;ALTER TABLE d.t5 DROP COLUMN b;ALTER TABLE d.t5 DROP COLUMN a;SELECT * FROM d.t5;SHOW CREATE TABLE d.t5;CREATE TABLE d.t6 (a INT);ALTER TABLE d.t6 DROP COLUMN a;SELECT * FROM d.t6;ALTER TABLE d.t6 DROP COLUMN a;CREATE TABLE d.t4 (a INT);CREATE TABLE d.t6 (a INT);CREATE TABLE d.t8 (a INT);ALTER TABLE d.t8 DROP COLUMN a;CREATE TABLE d.t6 (a INT);CREATE TABLE d.t9 (a INT);SELECT * FROM d.t9;INSERT INTO d.t9 DEFAULT VALUES;SELECT * FROM d.t9;CREATE TABLE d.t10 ();SELECT * FROM d.t10;SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW GRANTS;SHOW GRANTS ON nikhil;grant nikhil;grant 'nikhil';GRANT ALL ON nikhil TO nikhil;SHOW GRANTS ON nikhil;revoke root on nikhil;revoke all from root on nikhil;REVOKE ALL ON nikhil FROM root;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM nikhil;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON system.ui;REVOKE SELECT ON system.ui FROM nikhil;REVOKE SELECT ON * FROM nikhil;SHOW GRANTS ON nikhil;SHOW GRANTS ON *;REVOKE SELECT ON * FROM *;GRANT ALL ON t3 TO sksk;SHOW GRANTS ON t3;select from t3;select () from t3;SELECT 1;select;select ;CREATE TABLE d.jobs (id      INT DEFAULT unique_rowid() PRIMARY KEY,status  STRING NOT NULL,payload BYTES,INDEX   status);CREATE TABLE d.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, payload BYTES, INDEX (status));SELECT * FROM d.jobs;SELECT 1 FROM d.jobs;SELECT 1;SELECT * FROM d.jobs;CREATE TABLE d.t ();SHOW CREATE TABLE d.t;SELECT * FROM d.t;CREATE TABLE d.s ();SELECT * FROM d.s;insert into d.s;select * from 1;select * from t;seelect * from k;SELECT * FROM system.jobs;show grants system.jobs;SHOW GRANTS;SHOW GRANTS; jobs;show grants jobs;show grants on system.jobs;DROP TABLE system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;SHOW GRANTS ON system.jobs;SHOW TABLES;SET database = 'system';SHOW TABLES;SET database = 'system';SHOW TABLES;SELECT * FROM system.jobs;SET database = 'system';SELECT * FROM system.jobs;SHOW GRANTS ON system.jobs;SELECT * FROM nikhil;CREATE TABLE bench.bank (id INT PRIMARY KEY,balance INT,payload STRING,FAMILY (id, balance, payload);CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SHOW DATABASES;CREATE DATABASE bench;CREATE DATABASE nikhil;CREATE DATABASE n;CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SELECT * FROM bench.bank;BACKUP DATABASE bench TO 'foo1';BACKUP DATABASE bench TO 'foo2' INCREMENTAL FROM foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2, foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo1, foo2;SELECT * FROM system.jobs;SHOW TABLES;CREATE DATABASE d;CREATE TABLE t (a INT);SET database = 'd';CREATE TABLE t (a INT);BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM jobs;SELECT * FROM system.jobs;SELECT 1;SELECT 1, 2;SELECT 1, 2 union all;SELECT 1, 2 union all 2 3;SELECT 1, 2 union all 2, 3;SELECT  lFROM    generate_series(1, $n) l;SELECT l FROM generate_series(1, 10);SELECT * FROM generate_series(1, 10);SELECT * FROM (VALUES (1, 2), (3, 4)) AS q (col1, col2);SELECT * FROM (VALUES (1), (2));SELECT * FROM VALUES (1), (2);SELECT * FROM VALUES ((1), (2));SELECT * FROM (VALUES ((1), (2)));SELECT * FROM (VALUES ((1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (VALUES 1, 2, 3);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE DATABASE test;SET database = 'test';use;CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE packages (customer INT, "order" INT, id INT, address STRING(50), delivered BOOL, delivery_date DATE, PRIMARY KEY (customer, "order", id), CONSTRAINT fk_order FOREIGN KEY (customer, "order") REFERENCES orders) INTERLEAVE IN PARENT orders (customer, "order");show table system.jops;SHOW CREATE TABLE system.jobs;CREATE DATABASE bank;CREATE TABLE bank.accounts (id INT PRIMARY KEY, balance DECIMAL);INSERT INTO bank.accounts VALUES (1, 1000.50);SELECT * FROM bank.accounts;SHOW COLUMNS FROM system.eventlog;SHOW COLUMNS FROM system.jobs;ls;SELECT * FROM system.jobs;RESTORE FROM 'foo';RESTORE d FROM 'foo';SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW DATABASES;BACKUP q TO 'q';BACKUP a, b, c TO 'd';BACKUP asdgsadgs TO 'd';SELECT * FROM information_schema;SHOW DATABASES;SELECT SCHEMA_NAME FROM information_schema.schemata;select;SELECT 1;SELECT nil;update;update 1 set 1;create table t;CREATE TABLE t ();CREATE DATABASE d;SELECT 1 WHERE false;SELECT false;SELECT * where false;SET database = 'information_schema';SHOW TABLES;SHOW TABLES crdb_internal;SHOW TABLES from crdb_internal;SELECT * FROM crdb_internal.build_info;SELECT * FROM crdb_internal.leases;SELECT * FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables;SHOW CREATE TABLE system.eventlog;SHOW CREATE TABLE %[1]s;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = '%[1]s';SHOW CREATE TABLE eventlog;SHOW COLUMNS FROM system.eventlog;SHOW INDEXES FROM system.eventlog;SHOW GRANTS ON system.eventlog;SHOW CREATE TABLE system.eventlog;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = q;SHOW CREATE TABLE crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE "Table" = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = 'system.eventlog';SELECT * FROM crdb_internal.tables;SHOW CREATE TABLE crdb_internal.tables;SELECT start_key, end_key FROM crdb_internal.tables;SELECT name, start_key, end_key FROM crdb_internal.tables;SELECT name, database, start_key, end_key FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables\n\t\tWHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' AND DATABASE_NAME = 'system';show tables crdb_internal;show tables in crdb_internal;show tables crdb_internal;show tables from crdb_internal;SHOW COLUMNS FROM crdb_internal.tables;CREATE DATABASE q;SELECT * FROM crdb_internal.tables LIMIT 0;SELECT * FROM system.jobs;SHOW DATABASES;SELECT * FROM ledger;use database ledger;SET database = 'ledger';SELECT * FROM ledger;SHOW TABLES;SELECT * FROM accounts LIMIT 20;BACKUP accounts TO 'accounts';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts?sks';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts2?sks';SELECT * FROM system.jobs;RESTORE FROM accounts;RESTORE accounts FROM accounts;RESTORE accounts.accounts FROM accounts;RESTORE * FROM 'accounts';BACKUP accounts.accounts TO 'accounts2?sks';RESTOREaccounts.accounts FROM 'accounts2?sks';RESTORE accounts.accounts FROM 'accounts2?sks';SELECT * FROM system.jobs;RESTORE * FROM 'accounts';SELECT *;SHOW jobs;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;BACKUP foo TO 'foo';SELECT * FROM system."jobs";SHOW JOBS;RESTORE * FROM 'foo';BACKUP foo TO 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';RESTORE * FROM 'FOO';RESTORE * FROM 'foo';RESTORE * FROM 'foo222';RESTORE * FROM 'foo';BACKUP system.* TO 'foo';RESTORE * FROM 'foo';RESTORE system.* FROM 'foo';CREATE DATABASE newdb;RESTORE system.* FROM 'foo';RESTORE system.* FROM 'foo' into_db=nikhil;RESTORE system.* FROM 'foo' into_db='nikhil';RESTORE system.* FROM 'foo' (into_db='nikhil');RESTORE system.* FROM 'foo' ('into_db'='nikhil');RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');CREATE DATABASE nikhil;RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW DATABASES;SET database = 'startrek';SHOW TABLES;SHOW CREATE TABLE episodes;SHOW CREATE TABLE quotes;show columns episodes;show columns from episodes;SELECT count(*) FROM episodes;SELECT * FROM episodes;SELECT * FROM episodes WHERE season = 2;;SELECT * FROM episodes WHERE season = 2;SELECT * FROM episodes WHERE season = 3;ls;SELECT * FROM episodes WHERE season = 2;SHOW DATABASES;SHOW TABLES;SET database = 'system';SHOW TABLES FROM startrek;SELECT * FROM startrek.episodes;SELECT * FROM startrek.episodes WHERE season = 2;SELECT * FROM crdb_internal.jobs;SHOW USERS;SELECT * FROM system.users;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo2';BACKUP foo TO 'foo3';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs ORDER BY created;SELECT * FROM crdb_internal.jobs ORDER BY modifiedc;SELECT * FROM crdb_internal.jobs ORDER BY modified;SELECT * FROM crdb_internal.jobs LIMIT 2;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs LIMIT 2;SELECT * FROM system.namespace;CREATE DATABASE new;SELECT * FROM system.namespace;\?\exit\qSELECT start;\h\?select * from *;select * from ;SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT id, descriptor_ids FROM crdb_internal.jobs;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;create table (a int[]) ;create table t (a int[]) ;CREATE DATABASE d;create table d.t (a int[]) ;select [1, 2];select [1, 2]::intarray;select [1, 2]::int[];SELECT ARRAY[1, 2];SELECT unnest(ARRAY[1, 2]);create table d.t (a int[]) ;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT conrelid, unnest(conkey) AS connum FROM pg_constraint WHERE (contype = 'p') AND (conrelid = '"numbers"'::REGCLASS);SELECT unnest(conkey) FROM pg_constraint;SELECT unnest(ARRAY[1]), generate_series(2, 3);SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT unnest(conkey) FROM pg_constraint;SELECT 1 + generate_series(1, 3);SELECT generate_series(1, 3);SELECT generate_series(3, 1);SELECT generate_series(3, 1) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT * FROM generate_series(1, 3);SELECT * FROM generate_series(1, 3) + 1;SELECT * FROM generate_series(1, 3) + 1 as x;SELECT * FROM (generate_series(1, 3) + 1) as x;select from generate_series(1, 3);select * from generate_series(1, 3);SELECT s FROM t CROSS JOIN LATERAL (SELECT * FROM generate_series(t.id, t.id+1) AS s) AS _;SELECT (((a + (b * 2)) + (c * 3)) + (d * 4)) + (e * 5), CASE WHEN a < (b - 3) THEN 111 WHEN a <= b THEN 222 WHEN a < (b + 3) THEN 333 ELSE 444 END, abs(b - c), ((((a + b) + c) + d) + e) / 5, (a + (b * 2)) + (c * 3) FROM t1 WHERE (((e > c) OR (e < d)) AND (d > e)) AND EXISTS (SELECT 1 FROM t1 AS x WHERE x.b < t1.b) ORDER BY 4, 2, 1, 3, 5;(SELECT FROM VALUES (1, 2, 3));(SELECT VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));SELECT * FROM (VALUES (1), (2), (3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM (VALUES (1, 2, 3)));(SELECT * FROM (VALUES (1), (2), (3))));(SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3))) AS s;SELECT *, (SELECT t.a + 1)  FROM (SELECT a FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1  FROM (SELECT c1 FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1 FROM (SELECT * FROM (VALUES (1), (2), (3))) AS t (c1);SELECT * FROM generate_series(1, 3) AS c1;SELECT c1, c1 + 1 FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT *, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT _.*, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT generate_series(1, 2);SELECT generate_series(1, 3);SELECT * FROM generate_series(1, 3);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 3);select array(generate_series(1, 3));select array(generate_series(1, 3));SELECT generate_series(1, 3);select array(1, 2);select array 1, 2;SELECT ARRAY[1, 2, 3];SELECT ARRAY[generate_series(1, 2, 3)];select ARRAY(generate_series(1, 2, 3));SELECT generate_series(1, 2, 3);select ARRAY(generate_series(1, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 5, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) + 10;SELECT generate_series(1, 2) + 10 + 2;SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10 + generate_series(7, 2);SELECT generate_series(generate_series(3, 4), 5);SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(1, 2) + 99;SELECT 1;SELECT (1 + 2) + 3;SELECT 1 + generate_series(1, 2) + 99;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(2, 1);SELECT 1 + generate_series(1, 2);SELECT 3 + (3 * generate_series(1, 3));SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3, 4]);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3]);SELECT unnest(ARRAY[3, 4]) - 2, unnest(ARRAY['a', 'b']);SELECT 1 + generate_series(0, 2), unnest(ARRAY[2, 4, 6]) / 2;SELECT ascii(unnest(ARRAY['a', 'b', 'c']));SELECT chr(generate_series(65, 68));SELECT 1 + generate_series(0, 1), unnest(ARRAY[2, 4]) / 2;EXPLAIN (EXPRS) SELECT v, COUNT(1) FROM kv GROUP BY v ORDER BY COUNT(1);CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);CREATE DATABASE d;use database = d;use database d;SET database = 'd';CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);EXPLAIN (EXPRS) SELECT v, COUNT(k) FROM kv GROUP BY v ORDER BY COUNT(k);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT generate_series(1, 3);SELECT generate_series(generate_series(1, 3), 3);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77') ORDER BY generate_series(1, 3);SELECT * FROM a;SELECT * FROM 1;SELECT * from (values (1), (2)) as v;SELECT * from (values (1), (2)) as v order by generate_series();SELECT * from (values (1), (2)) as v order by generate_series(1, 3);SELECT * from (values (1), (2)) as v order by generate_series(1, 5);SELECT * from (values (1), (2)) as v order by generate_series(3, 1);SELECT * from (values (1), (2)) as v order by 1;SELECT * from (values (1), (2)) as v order by 1 desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SHOW TABLES;SET database = 'd';SHOW DATABASES;CREATE DATABASE d;SET database = 'd';ls;SHOW DATABASES;CREATE TABLE t (a INT);INSERT INTO t VALUES (1);INSERT INTO t VALUES (1) returning *;INSERT INTO t VALUES (1) returning * as q;INSERT INTO t VALUES (1) returning a as b;INSERT INTO t VALUES (1) returning a as a;INSERT INTO t VALUES (1) returning a as aaa;INSERT INTO t VALUES (1) returning generate_series(1, 3) as aaa;SELECT 1 + generate_series(1, 3);SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 1;SELECT GENERATE_SERIES(1, 2) + 8;SELECT GENERATE_SERIES(1, 2) + 9;SELECT GENERATE_SERIES(1, 2);SELECT LENGTH(1, 2);SELECT LENGTH('anik');SELECT LENGTH(1, 2);SELECT LENGTH('a');SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 9;SELECT a.attname, format_type(a.atttypid, a.atttypmod) AS data_type FROM pg_index AS i JOIN pg_attribute AS a ON (a.attrelid = i.indrelid) AND (a.attnum = ANY (i.indkey)) WHERE (i.indrelid = '"a"'::REGCLASS) AND i.indisprimary;SELECT GENERATE_SERIES(1, 2);SELECT 1 + generate_series(1, 3) FROM t WHERE generate_series > 3;SELECT 1 + generate_series(1, 3) WHERE generate_series > 3;SHOW DATABASES;BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs order by created;SELECT * FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM datablocks.blocks;SELECT count(*) FROM datablocks.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE FROM 'foo';RESTORE 'foo';RESTORE datablocks.* FROM 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP DATABASE datablocks2;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks3;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks3');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP TABLE datablocks3.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks4');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');CREATE DATABASE datablocks5;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;CREATE DATABASE datablocks3;CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks7;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks8;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks8');RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');CREATE DATABASE datablocks9;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks10;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks10');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');CREATE DATABASE datablocks11;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;create user;create user nikhil;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BACKUP datablocks.blocks TO 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');CREATE DATABASE datablocks100;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;create db goose;create database goose;ROLLBACK TRANSACTION;create database goose;SET database = 'goose';BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;ROLLBACK TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;DROP DATABASE goose;SELECT * FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks101;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks101');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;ls;SHOW DATABASES;DROP DATABASE tpch;SHOW DATABASES;CREATE DATABASE tpch;SELECT * FROM crdb_internal.jobs;BEGIN TRANSACTION;CREATE DATABASE q;CREATE TABLE q.q ();CREATE TABLE q.t (a INT, b INT);COMMIT TRANSACTION;BEGIN TRANSACTION;prepare select * from q.t;prepare q as select * from q.t;COMMIT TRANSACTION;RESTORE FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';CREATE DATABASE tpch;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';SHOW DATABASES;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';COPY states FROM 'states.csv';COPY states FROM states.csv;COPY states FROM STDIN;COPY states.states FROM STDIN;SELECT * FROM tbl;SHOW DATABASES;SELECT * FROM jobs;SELECT * FROM jobs;SHOW DATABASES;BACKUP DATABASE tpch TO 'foo';SHOW TABLES FROM tpch;BACKUP DATABASE tpch TO 'foo';BACKUP DATABASE datablocks TO 'foo';SHOW USERS;SHOW TABLES;SHOW TABLES FROM system;show create table from ui;show create table system.ui;SHOW DATABASES;SHOW TABLES FROM datablocks;BACKUP DATABASE datablocks TO 'foo';SHOW settings;SELECT * FROM system.settings;SET CLUSTER SETTING enterprise.enabled = true;SELECT * FROM system.settings;BACKUP DATABASE datablocks TO 'foo';RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');create table blocks2;create database blocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');SELECT * FROM crdb_internal.jobs;SHOW COLUMNS FROM crdb_internal.jobs;SELECT id, type, created, user, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, type, created, username, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, status, fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT status, fraction_completed FROM crdb_internal.jobs WHERE id = 235783388924116992 LIMIT 1;RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT/bUfy280nCGljw==';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=FzWMkVNcHorQ2IPG5il987GEmEzSxmV8WxXOZHzKV4XfvNTXHEDdBrsAIMB2/UutSPhhNQwVt9zs4dVXD/6w/w==';SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM tpch.region;SELECT count(*) FROM tpch.nation;SELECT count(*) FROM tpch.customer;SELECT count(*) FROM tpch.lineitem;SELECT tpch.lineitem FROM tpch.lineitem;SELECT li_orderkey FROM tpch.lineitem;SELECT l_orderkey FROM tpch.lineitem LIMIT 1;SELECT l_orderkey FROM tpch.lineitem ORDER BY random() LIMIT 1;SELECT FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783 AND l_partkey = 107348;SELECT * FROM tpch.lineitem WHERE (l_orderkey = 131783) AND (l_partkey = 107348);BACKUP tpch.lineitem TO '/Users/benesch/Desktop/lineitem';SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT description, finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT *;SHOW TABLES;SHOW DATABASES;BACKUP datablocks.blocks TO 'foo';BACKUP datablocks.blocks TO '/foo';BACKUP datablocks.blocks TO 'file://foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal:///foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal://./foo';BACKUP datablocks.blocks TO 'nodelocal://foo2';BACKUP datablocks.blocks TO 'nodelocal:///Users/benesch/Desktop/foo';SELECT * FROM system.jobs;SELECT fraction_completed FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT * FROM system.settings;SELECT description, fraction_completed FROM crdb_internal.jobs;selected now() - started() / fraction_completed from crdb_internal.jobs;select now() - started() / fraction_completed from crdb_internal.jobs;select now() - started / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_interroot@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a STRING;SELECT count(*) FROM datablocks.blocks;describe datablocks.blocks;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';ALTER TABLE datablocks.blocks DROP COLUMN a;SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'blocks';SET database = 'system';SHOW TABLES;SELECT * FROM users;CREATE USER benesch;SELECT * FROM users;SHOW USERS;SHOW TABLES;use system;SET database = 'system';SHOW TABLES;SELECT * FROM ui;CREATE TABLE system.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, INDEX status_idx (status));describe table system.jobs;CREATE TABLE system.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE DATABASE systems;CREATE TABLE systems.jobs (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));CREATE TABLE systems.jobs2 (id INT DEFAULT unique_rowid(), status STRING NOT NULL, percentCompleted DECIMAL(5,2), payload BYTES, PRIMARY KEY (status, id));SHOW CREATE TABLE systems.jobs2;SHOW CREATE TABLE systems.jobs;use system;SHOW TABLES;set database system;SET database = 'system';SHOW TABLES;SELECT * FROM namespace;DROP TABLE system.eventlog;use database = system;SET database = 'system';SHOW TABLES;SHOW CREATE TABLE eventlog;DROP TABLE system.descriptor;DROP TABLE system.eventlog;DROP TABLE system.lease;SHOW TABLES;SET database = 'system';SHOW TABLES;DROP TABLE zones;DROP TABLE ui;SET database = 'system';DROP TABLE ui;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;DROP TABLE zones;DROP TABLE system.ui;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE rangelog;SHOW TABLES;SHOW TABLES;DROP TABLE eventlog;DROP TABLE namespace;DROP TABLE descriptor;SELECT count(*) FROM eventlog;SELECT * FROM eventlog;DROP TABLE system.ui;SHOW USERS;revoke create from system.ui;revoke create on system.ui;revoke create on system.ui from all;revoke create on system.ui from *;revoke create on system.ui from users;revoke create on system.ui from userssk;revoke create on system.ui from root;revoke drop on system.ui from root;DROP TABLE system.ui;grant drop on system.namespace from root;grant drop on system.namespace to root;CREATE TABLE system (wat INT);CREATE TABLE system.t (wat INT);CREATE TABLE system.jobs (wat INT);create table (a int, b int, index (a));create table nikhil (a int, b int, index (a));create table id.nikhil (a int, b int, index (a));create table d.nikhil (a int, b int, index (a));CREATE DATABASE d;create table d.nikhil (a int, b int, index (a));CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));SET database = 'test';CREATE DATABASE test;SET database = 'test';CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp), INDEX (status, created), INDEX (created));CREATE TABLE jobs (id                INT DEFAULT unique_rowid(),timestamp         TIMESTAMP NOT NULL DEFAULT now(),status            STRING NOT NULL,payload           BYTES,PRIMARY KEY (id, timestamp),);CREATE TABLE jobs (id INT DEFAULT unique_rowid(), timestamp TIMESTAMP NOT NULL DEFAULT now(), status STRING NOT NULL, payload BYTES, PRIMARY KEY (id, timestamp));SELECT * FROM jobs;INSERT INTO jobs (status, payload)VALUES ('pending', {description = 'BACKUP foodb TO barstorage',creator = 'root',descriptor_id = 18,backup_details = {}})RETURNING id;INSERT INTO jobs(status) VALUES ('pending');SELECT * FROM jobs;INSERT INTO jobs(status, id) VALUES ('running', 221908925848354817);SELECT * FROM jobs;INSERT INTO jobs(status) VALUES ('pending') RETURNING id;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (sytem.jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, latest.status AS status, latest.payload AS payload FROM (SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id;SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT id, status, payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, "10%");INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '10%');SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;INSERT INTO jobs(status, id, payload) VALUES ('running', 221908925848354817, '20%');UPDATE jobs SET payload = '0%' WHERE status = 'pending';SELECT * FROM jobs;UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00');UPDATE jobs SET payload = '5%' WHERE (id = 221908925848354817) AND (timestamp = '2017-02-22 19:27:25.973661+00:00'::timestamp);SELECT * FROM jobs;SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp);SELECT latest.id, latest.status AS status, latest.payload AS payload FROM (SELECT latest.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECT latest.id, latest.status AS status, initial.payload AS payload FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY timestamp;SELECTlatest.id AS id,latest.status AS status,latest.timestamp AS updated,initial.payload AS payload,initial.timestamp AS created,FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payloadFROM (SELECT id, max(timestamp) as timestamp FROM jobs GROUP BY id) AS latestJOIN jobs ON jobs.id = latest.id AND jobs.timestamp = latest.timestamp) AS latestJOIN jobs AS initial ON initial.id = latest.id AND initial.status = 'pending'WHERE latest.status IN ('pending', 'running')ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, initial.payload AS payload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY initial.timestamp;SELECT latest.id AS id, latest.status AS status, latest.timestamp AS updated, latest.payload AS latestPayload, initial.payload AS initialPayload, initial.timestamp AS created FROM (SELECT jobs.id, jobs.timestamp, jobs.status, jobs.payload FROM (SELECT id, max(timestamp) AS timestamp FROM jobs GROUP BY id) AS latest JOIN jobs ON (jobs.id = latest.id) AND (jobs.timestamp = latest.timestamp)) AS latest JOIN jobs AS initial ON (initial.id = latest.id) AND (initial.status = 'pending') WHERE latest.status IN ('pending', 'running') ORDER BY created;SELECT * FROM zones;SELECT * FROM system.zones;CREATE USER nikhil;CREATE DATABASE d;create table d.t;create table d.t (a int);create table d.t2 ();insert into d.t2;insert into d.t2 default values;SELECT * FROM d.t2;CREATE TABLE d.t3 ();select * from d.t3();select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM q;select * from d.t3;select * from d.t3;select * from d.t3;SELECT * FROM d.t3;CREATE TABLE d.t4 (a INT);ALTER TABLE d.t4 DROP COLUMN a;SHOW CREATE TABLE d.t4;SHOW TABLES;use database d;SET database = 'd';use database d;SHOW TABLES;SHOW CREATE TABLE t4;SELECT * FROM t4;CREATE TABLE t5 (a INT, b INT);CREATE TABLE d.t5 (a INT, b INT);INSERT INTO d.t5 DEFAULT VALUES;ALTER TABLE d.t5 DROP COLUMN b;ALTER TABLE d.t5 DROP COLUMN a;SELECT * FROM d.t5;SHOW CREATE TABLE d.t5;CREATE TABLE d.t6 (a INT);ALTER TABLE d.t6 DROP COLUMN a;SELECT * FROM d.t6;ALTER TABLE d.t6 DROP COLUMN a;CREATE TABLE d.t4 (a INT);CREATE TABLE d.t6 (a INT);CREATE TABLE d.t8 (a INT);ALTER TABLE d.t8 DROP COLUMN a;CREATE TABLE d.t6 (a INT);CREATE TABLE d.t9 (a INT);SELECT * FROM d.t9;INSERT INTO d.t9 DEFAULT VALUES;SELECT * FROM d.t9;CREATE TABLE d.t10 ();SELECT * FROM d.t10;SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW GRANTS;SHOW GRANTS ON nikhil;grant nikhil;grant 'nikhil';GRANT ALL ON nikhil TO nikhil;SHOW GRANTS ON nikhil;revoke root on nikhil;revoke all from root on nikhil;REVOKE ALL ON nikhil FROM root;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM nikhil;SHOW GRANTS ON nikhil;REVOKE SELECT ON nikhil FROM root;SHOW GRANTS ON system.ui;REVOKE SELECT ON system.ui FROM nikhil;REVOKE SELECT ON * FROM nikhil;SHOW GRANTS ON nikhil;SHOW GRANTS ON *;REVOKE SELECT ON * FROM *;GRANT ALL ON t3 TO sksk;SHOW GRANTS ON t3;select from t3;select () from t3;SELECT 1;select;select ;CREATE TABLE d.jobs (id      INT DEFAULT unique_rowid() PRIMARY KEY,status  STRING NOT NULL,payload BYTES,INDEX   status);CREATE TABLE d.jobs (id INT PRIMARY KEY DEFAULT unique_rowid(), status STRING NOT NULL, payload BYTES, INDEX (status));SELECT * FROM d.jobs;SELECT 1 FROM d.jobs;SELECT 1;SELECT * FROM d.jobs;CREATE TABLE d.t ();SHOW CREATE TABLE d.t;SELECT * FROM d.t;CREATE TABLE d.s ();SELECT * FROM d.s;insert into d.s;select * from 1;select * from t;seelect * from k;SELECT * FROM system.jobs;show grants system.jobs;SHOW GRANTS;SHOW GRANTS; jobs;show grants jobs;show grants on system.jobs;DROP TABLE system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;show grants on system.jobs;SHOW GRANTS ON system.jobs;SHOW TABLES;SET database = 'system';SHOW TABLES;SET database = 'system';SHOW TABLES;SELECT * FROM system.jobs;SET database = 'system';SELECT * FROM system.jobs;SHOW GRANTS ON system.jobs;SELECT * FROM nikhil;CREATE TABLE bench.bank (id INT PRIMARY KEY,balance INT,payload STRING,FAMILY (id, balance, payload);CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SHOW DATABASES;CREATE DATABASE bench;CREATE DATABASE nikhil;CREATE DATABASE n;CREATE DATABASE bench;CREATE TABLE bench.bank (id INT PRIMARY KEY, balance INT, payload STRING, FAMILY (id, balance, payload));SELECT * FROM bench.bank;BACKUP DATABASE bench TO 'foo1';BACKUP DATABASE bench TO 'foo2' INCREMENTAL FROM foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo2, foo1;BACKUP DATABASE bench TO 'foo3' INCREMENTAL FROM foo1, foo2;SELECT * FROM system.jobs;SHOW TABLES;CREATE DATABASE d;CREATE TABLE t (a INT);SET database = 'd';CREATE TABLE t (a INT);BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM system.jobs;BACKUP d TO 'foo';SELECT * FROM jobs;SELECT * FROM system.jobs;SELECT 1;SELECT 1, 2;SELECT 1, 2 union all;SELECT 1, 2 union all 2 3;SELECT 1, 2 union all 2, 3;SELECT  lFROM    generate_series(1, $n) l;SELECT l FROM generate_series(1, 10);SELECT * FROM generate_series(1, 10);SELECT * FROM (VALUES (1, 2), (3, 4)) AS q (col1, col2);SELECT * FROM (VALUES (1), (2));SELECT * FROM VALUES (1), (2);SELECT * FROM VALUES ((1), (2));SELECT * FROM (VALUES ((1), (2)));SELECT * FROM (VALUES ((1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (VALUES 1, 2, 3);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE DATABASE test;SET database = 'test';use;CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE customers (id INT PRIMARY KEY, name STRING(50));CREATE TABLE orders (customer INT, id INT, total DECIMAL(20,5), PRIMARY KEY (customer, id), CONSTRAINT fk_customer FOREIGN KEY (customer) REFERENCES customers) INTERLEAVE IN PARENT customers (customer);CREATE TABLE packages (customer INT, "order" INT, id INT, address STRING(50), delivered BOOL, delivery_date DATE, PRIMARY KEY (customer, "order", id), CONSTRAINT fk_order FOREIGN KEY (customer, "order") REFERENCES orders) INTERLEAVE IN PARENT orders (customer, "order");show table system.jops;SHOW CREATE TABLE system.jobs;CREATE DATABASE bank;CREATE TABLE bank.accounts (id INT PRIMARY KEY, balance DECIMAL);INSERT INTO bank.accounts VALUES (1, 1000.50);SELECT * FROM bank.accounts;SHOW COLUMNS FROM system.eventlog;SHOW COLUMNS FROM system.jobs;ls;SELECT * FROM system.jobs;RESTORE FROM 'foo';RESTORE d FROM 'foo';SHOW TABLES;SET database = 'd';SHOW TABLES;SHOW DATABASES;BACKUP q TO 'q';BACKUP a, b, c TO 'd';BACKUP asdgsadgs TO 'd';SELECT * FROM information_schema;SHOW DATABASES;SELECT SCHEMA_NAME FROM information_schema.schemata;select;SELECT 1;SELECT nil;update;update 1 set 1;create table t;CREATE TABLE t ();CREATE DATABASE d;SELECT 1 WHERE false;SELECT false;SELECT * where false;SET database = 'information_schema';SHOW TABLES;SHOW TABLES crdb_internal;SHOW TABLES from crdb_internal;SELECT * FROM crdb_internal.build_info;SELECT * FROM crdb_internal.leases;SELECT * FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables;SHOW CREATE TABLE system.eventlog;SHOW CREATE TABLE %[1]s;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = '%[1]s';SHOW CREATE TABLE eventlog;SHOW COLUMNS FROM system.eventlog;SHOW INDEXES FROM system.eventlog;SHOW GRANTS ON system.eventlog;SHOW CREATE TABLE system.eventlog;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE table = q;SHOW CREATE TABLE crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = q;SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE "Table" = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE Table = 'system.eventlog';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE 'Table' = 'system.eventlog';SELECT * FROM crdb_internal.tables;SHOW CREATE TABLE crdb_internal.tables;SELECT start_key, end_key FROM crdb_internal.tables;SELECT name, start_key, end_key FROM crdb_internal.tables;SELECT name, database, start_key, end_key FROM crdb_internal.tables;SELECT START_KEY, END_KEY FROM crdb_internal.tables\n\t\tWHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' DATABASE_NAME = 'system';SELECT START_KEY, END_KEY FROM crdb_internal.tables WHERE NAME = 'eventlog' AND DATABASE_NAME = 'system';show tables crdb_internal;show tables in crdb_internal;show tables crdb_internal;show tables from crdb_internal;SHOW COLUMNS FROM crdb_internal.tables;CREATE DATABASE q;SELECT * FROM crdb_internal.tables LIMIT 0;SELECT * FROM system.jobs;SHOW DATABASES;SELECT * FROM ledger;use database ledger;SET database = 'ledger';SELECT * FROM ledger;SHOW TABLES;SELECT * FROM accounts LIMIT 20;BACKUP accounts TO 'accounts';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts?sks';SELECT * FROM system.jobs;BACKUP accounts TO 'accounts2?sks';SELECT * FROM system.jobs;RESTORE FROM accounts;RESTORE accounts FROM accounts;RESTORE accounts.accounts FROM accounts;RESTORE * FROM 'accounts';BACKUP accounts.accounts TO 'accounts2?sks';RESTOREaccounts.accounts FROM 'accounts2?sks';RESTORE accounts.accounts FROM 'accounts2?sks';SELECT * FROM system.jobs;RESTORE * FROM 'accounts';SELECT *;SHOW jobs;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW INCOMPLETE JOBS;BACKUP foo TO 'foo';SELECT * FROM system."jobs";SHOW JOBS;RESTORE * FROM 'foo';BACKUP foo TO 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';BACKUP system."jobs" TO 'foo';RESTORE * FROM 'foo';RESTORE * FROM 'FOO';RESTORE * FROM 'foo';RESTORE * FROM 'foo222';RESTORE * FROM 'foo';BACKUP system.* TO 'foo';RESTORE * FROM 'foo';RESTORE system.* FROM 'foo';CREATE DATABASE newdb;RESTORE system.* FROM 'foo';RESTORE system.* FROM 'foo' into_db=nikhil;RESTORE system.* FROM 'foo' into_db='nikhil';RESTORE system.* FROM 'foo' (into_db='nikhil');RESTORE system.* FROM 'foo' ('into_db'='nikhil');RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');CREATE DATABASE nikhil;RESTORE system.* FROM 'foo' WITH OPTIONS ('into_db'='nikhil');SHOW JOBS;SHOW INCOMPLETE JOBS;SHOW JOBS;SHOW DATABASES;SET database = 'startrek';SHOW TABLES;SHOW CREATE TABLE episodes;SHOW CREATE TABLE quotes;show columns episodes;show columns from episodes;SELECT count(*) FROM episodes;SELECT * FROM episodes;SELECT * FROM episodes WHERE season = 2;;SELECT * FROM episodes WHERE season = 2;SELECT * FROM episodes WHERE season = 3;ls;SELECT * FROM episodes WHERE season = 2;SHOW DATABASES;SHOW TABLES;SET database = 'system';SHOW TABLES FROM startrek;SELECT * FROM startrek.episodes;SELECT * FROM startrek.episodes WHERE season = 2;SELECT * FROM crdb_internal.jobs;SHOW USERS;SELECT * FROM system.users;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo2';BACKUP foo TO 'foo3';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs ORDER BY created;SELECT * FROM crdb_internal.jobs ORDER BY modifiedc;SELECT * FROM crdb_internal.jobs ORDER BY modified;SELECT * FROM crdb_internal.jobs LIMIT 2;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs LIMIT 2;SELECT * FROM system.namespace;CREATE DATABASE new;SELECT * FROM system.namespace;\?\exit\qSELECT start;\h\?select * from *;select * from ;SELECT * FROM crdb_internal.jobs;BACKUP foo TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT id, descriptor_ids FROM crdb_internal.jobs;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;create table (a int[]) ;create table t (a int[]) ;CREATE DATABASE d;create table d.t (a int[]) ;select [1, 2];select [1, 2]::intarray;select [1, 2]::int[];SELECT ARRAY[1, 2];SELECT unnest(ARRAY[1, 2]);create table d.t (a int[]) ;SELECT id, unnest(descriptor_ids) FROM crdb_internal.jobs;SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT conrelid, unnest(conkey) AS connum FROM pg_constraint WHERE (contype = 'p') AND (conrelid = '"numbers"'::REGCLASS);SELECT unnest(conkey) FROM pg_constraint;SELECT unnest(ARRAY[1]), generate_series(2, 3);SELECT unnest(ARRAY[1, 2]), generate_series(3, 4), x FROM (VALUES (5), (6)) AS t (x);SELECT unnest(conkey) FROM pg_constraint;SELECT 1 + generate_series(1, 3);SELECT generate_series(1, 3);SELECT generate_series(3, 1);SELECT generate_series(3, 1) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT * FROM generate_series(1, 3);SELECT * FROM generate_series(1, 3) + 1;SELECT * FROM generate_series(1, 3) + 1 as x;SELECT * FROM (generate_series(1, 3) + 1) as x;select from generate_series(1, 3);select * from generate_series(1, 3);SELECT s FROM t CROSS JOIN LATERAL (SELECT * FROM generate_series(t.id, t.id+1) AS s) AS _;SELECT (((a + (b * 2)) + (c * 3)) + (d * 4)) + (e * 5), CASE WHEN a < (b - 3) THEN 111 WHEN a <= b THEN 222 WHEN a < (b + 3) THEN 333 ELSE 444 END, abs(b - c), ((((a + b) + c) + d) + e) / 5, (a + (b * 2)) + (c * 3) FROM t1 WHERE (((e > c) OR (e < d)) AND (d > e)) AND EXISTS (SELECT 1 FROM t1 AS x WHERE x.b < t1.b) ORDER BY 4, 2, 1, 3, 5;(SELECT FROM VALUES (1, 2, 3));(SELECT VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));SELECT * FROM (VALUES (1), (2), (3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM VALUES (1, 2, 3));(SELECT * FROM (VALUES (1, 2, 3)));(SELECT * FROM (VALUES (1), (2), (3))));(SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (VALUES (1), (2), (3));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3)));SELECT * FROM (SELECT * FROM (VALUES (1), (2), (3))) AS s;SELECT *, (SELECT t.a + 1)  FROM (SELECT a FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1  FROM (SELECT c1 FROM (VALUES (1), (2), (3))) AS t (c1);SELECT t.c1 FROM (SELECT * FROM (VALUES (1), (2), (3))) AS t (c1);SELECT * FROM generate_series(1, 3) AS c1;SELECT c1, c1 + 1 FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS c1;SELECT * FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT *, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT _.*, c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT c1, c1 + 1 AS c2 FROM generate_series(1, 3) AS _ (c1);SELECT generate_series(1, 2);SELECT generate_series(1, 3);SELECT * FROM generate_series(1, 3);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT unnest(conkey) FROM pg_constraint;SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 2) ;SELECT generate_series(1, 3);select array(generate_series(1, 3));select array(generate_series(1, 3));SELECT generate_series(1, 3);select array(1, 2);select array 1, 2;SELECT ARRAY[1, 2, 3];SELECT ARRAY[generate_series(1, 2, 3)];select ARRAY(generate_series(1, 2, 3));SELECT generate_series(1, 2, 3);select ARRAY(generate_series(1, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 5, 2);SELECT generate_series(1, 2);SELECT generate_series(1, 2) + 1;SELECT generate_series(1, 2) + 10;SELECT generate_series(1, 2) + 10 + 2;SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10 + generate_series(7, 2);SELECT generate_series(generate_series(3, 4), 5);SELECT generate_series(1, 2) + 10 + generate_series(7);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT generate_series(1, 2) + 10;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(1, 2) + 99;SELECT 1;SELECT (1 + 2) + 3;SELECT 1 + generate_series(1, 2) + 99;SELECT 1 + generate_series(1, 2);SELECT 1 + generate_series(2, 1);SELECT 1 + generate_series(1, 2);SELECT 3 + (3 * generate_series(1, 3));SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3, 4]);SELECT unnest(ARRAY[1, 2]), unnest(ARRAY['a', 'b']), unnest(ARRAY[3]);SELECT unnest(ARRAY[3, 4]) - 2, unnest(ARRAY['a', 'b']);SELECT 1 + generate_series(0, 2), unnest(ARRAY[2, 4, 6]) / 2;SELECT ascii(unnest(ARRAY['a', 'b', 'c']));SELECT chr(generate_series(65, 68));SELECT 1 + generate_series(0, 1), unnest(ARRAY[2, 4]) / 2;EXPLAIN (EXPRS) SELECT v, COUNT(1) FROM kv GROUP BY v ORDER BY COUNT(1);CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);CREATE DATABASE d;use database = d;use database d;SET database = 'd';CREATE TABLE kv (k INT PRIMARY KEY, v INT, w INT, s STRING);EXPLAIN (EXPRS) SELECT v, COUNT(k) FROM kv GROUP BY v ORDER BY COUNT(k);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT generate_series(1, 3);SELECT generate_series(generate_series(1, 3), 3);SELECT LENGTH('roach7'), LENGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77');SELECT LENGTH('roach7'), LeNGTH(b'roach77') ORDER BY generate_series(1, 3);SELECT * FROM a;SELECT * FROM 1;SELECT * from (values (1), (2)) as v;SELECT * from (values (1), (2)) as v order by generate_series();SELECT * from (values (1), (2)) as v order by generate_series(1, 3);SELECT * from (values (1), (2)) as v order by generate_series(1, 5);SELECT * from (values (1), (2)) as v order by generate_series(3, 1);SELECT * from (values (1), (2)) as v order by 1;SELECT * from (values (1), (2)) as v order by 1 desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) desc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SELECT * from (values (1), (2)) as v order by generate_series(3, 1) asc;SHOW TABLES;SET database = 'd';SHOW DATABASES;CREATE DATABASE d;SET database = 'd';ls;SHOW DATABASES;CREATE TABLE t (a INT);INSERT INTO t VALUES (1);INSERT INTO t VALUES (1) returning *;INSERT INTO t VALUES (1) returning * as q;INSERT INTO t VALUES (1) returning a as b;INSERT INTO t VALUES (1) returning a as a;INSERT INTO t VALUES (1) returning a as aaa;INSERT INTO t VALUES (1) returning generate_series(1, 3) as aaa;SELECT 1 + generate_series(1, 3);SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 1;SELECT GENERATE_SERIES(1, 2) + 8;SELECT GENERATE_SERIES(1, 2) + 9;SELECT GENERATE_SERIES(1, 2);SELECT LENGTH(1, 2);SELECT LENGTH('anik');SELECT LENGTH(1, 2);SELECT LENGTH('a');SELECT GENERATE_SERIES(1, 2);SELECT GENERATE_SERIES(1, 2) + 9;SELECT a.attname, format_type(a.atttypid, a.atttypmod) AS data_type FROM pg_index AS i JOIN pg_attribute AS a ON (a.attrelid = i.indrelid) AND (a.attnum = ANY (i.indkey)) WHERE (i.indrelid = '"a"'::REGCLASS) AND i.indisprimary;SELECT GENERATE_SERIES(1, 2);SELECT 1 + generate_series(1, 3) FROM t WHERE generate_series > 3;SELECT 1 + generate_series(1, 3) WHERE generate_series > 3;SHOW DATABASES;BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';BACKUP datablocks TO 'foo';BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs;SELECT * FROM crdb_internal.jobs order by created;SELECT * FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;BACKUP datablocks.* TO 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM datablocks.blocks;SELECT count(*) FROM datablocks.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE FROM 'foo';RESTORE 'foo';RESTORE datablocks.* FROM 'foo';SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fractionCompleted FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT * FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP DATABASE datablocks2;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks3;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks3');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;DROP TABLE datablocks3.blocks;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks4');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');CREATE DATABASE datablocks5;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks5');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks4;CREATE DATABASE datablocks3;CREATE DATABASE datablocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks2');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks7;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks7');CREATE DATABASE datablocks8;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks8');RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');CREATE DATABASE datablocks9;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks9');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks10;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks10');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');CREATE DATABASE datablocks11;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks11');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;create user;create user nikhil;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BACKUP datablocks.blocks TO 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');CREATE DATABASE datablocks100;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks100');SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;create db goose;create database goose;ROLLBACK TRANSACTION;create database goose;SET database = 'goose';BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES ($1, $2);COMMIT TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;ROLLBACK TRANSACTION;BEGIN TRANSACTION;CREATE TABLE goose_db_version (id SERIAL NOT NULL, version_id BIGINT NOT NULL, is_applied BOOLEAN NOT NULL, tstamp TIMESTAMP NULL DEFAULT now(), PRIMARY KEY (id));INSERT INTO goose_db_version(version_id, is_applied) VALUES (1, false);COMMIT TRANSACTION;DROP DATABASE goose;SELECT * FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created limit 1;SELECT * FROM crdb_internal.jobs;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;CREATE DATABASE datablocks101;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='datablocks101');SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT fraction_completed FROM crdb_internal.jobs order by created desc limit 1;ls;SHOW DATABASES;DROP DATABASE tpch;SHOW DATABASES;CREATE DATABASE tpch;SELECT * FROM crdb_internal.jobs;BEGIN TRANSACTION;CREATE DATABASE q;CREATE TABLE q.q ();CREATE TABLE q.t (a INT, b INT);COMMIT TRANSACTION;BEGIN TRANSACTION;prepare select * from q.t;prepare q as select * from q.t;COMMIT TRANSACTION;RESTORE FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';CREATE DATABASE tpch;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';SHOW DATABASES;RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';create database tpch; RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';RESTORE tpch.* FROM '/Users/benesch/Downloads/tpch';COPY states FROM 'states.csv';COPY states FROM states.csv;COPY states FROM STDIN;COPY states.states FROM STDIN;SELECT * FROM tbl;SHOW DATABASES;SELECT * FROM jobs;SELECT * FROM jobs;SHOW DATABASES;BACKUP DATABASE tpch TO 'foo';SHOW TABLES FROM tpch;BACKUP DATABASE tpch TO 'foo';BACKUP DATABASE datablocks TO 'foo';SHOW USERS;SHOW TABLES;SHOW TABLES FROM system;show create table from ui;show create table system.ui;SHOW DATABASES;SHOW TABLES FROM datablocks;BACKUP DATABASE datablocks TO 'foo';SHOW settings;SELECT * FROM system.settings;SET CLUSTER SETTING enterprise.enabled = true;SELECT * FROM system.settings;BACKUP DATABASE datablocks TO 'foo';RESTORE datablocks.* FROM 'foo';RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');create table blocks2;create database blocks2;RESTORE datablocks.* FROM 'foo' WITH OPTIONS ('into_db'='blocks2');SELECT * FROM crdb_internal.jobs;SHOW COLUMNS FROM crdb_internal.jobs;SELECT id, type, created, user, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, type, created, username, description FROM crdb_internal.jobs ORDER BY created DESC LIMIT 5;SELECT id, status, fraction_completed FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT status, fraction_completed FROM crdb_internal.jobs WHERE id = 235783388924116992 LIMIT 1;RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=XD71ljL470gUC8emxIYGtOG0uTLoCQNLWIDj4JBV1KVpbd6Pfg2WEuR5g2tOcpWkPqNNzEfT/bUfy280nCGljw==';RESTORE tpch.* FROM 'azure://backup-test/benchmarks/tpch/scalefactor-1?AZURE_ACCOUNT_NAME=cockroachbackuptest&AZURE_ACCOUNT_KEY=FzWMkVNcHorQ2IPG5il987GEmEzSxmV8WxXOZHzKV4XfvNTXHEDdBrsAIMB2/UutSPhhNQwVt9zs4dVXD/6w/w==';SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM tpch.region;SELECT count(*) FROM tpch.nation;SELECT count(*) FROM tpch.customer;SELECT count(*) FROM tpch.lineitem;SELECT tpch.lineitem FROM tpch.lineitem;SELECT li_orderkey FROM tpch.lineitem;SELECT l_orderkey FROM tpch.lineitem LIMIT 1;SELECT l_orderkey FROM tpch.lineitem ORDER BY random() LIMIT 1;SELECT FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783;SELECT * FROM tpch.lineitem WHERE l_orderkey = 131783 AND l_partkey = 107348;SELECT * FROM tpch.lineitem WHERE (l_orderkey = 131783) AND (l_partkey = 107348);BACKUP tpch.lineitem TO '/Users/benesch/Desktop/lineitem';SELECT * FROM crdb_internal.jobs ORDER BY created DESC LIMIT 1;SELECT finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT description, finished - started FROM crdb_internal.jobs ORDER BY created DESC;SELECT *;SHOW TABLES;SHOW DATABASES;BACKUP datablocks.blocks TO 'foo';BACKUP datablocks.blocks TO '/foo';BACKUP datablocks.blocks TO 'file://foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal:///foo';BACKUP datablocks.blocks TO 'nodelocal://foo';BACKUP datablocks.blocks TO 'nodelocal://./foo';BACKUP datablocks.blocks TO 'nodelocal://foo2';BACKUP datablocks.blocks TO 'nodelocal:///Users/benesch/Desktop/foo';SELECT * FROM system.jobs;SELECT fraction_completed FROM system.jobs;SELECT fraction_completed FROM crdb_internal.jobs;SELECT description, fraction_completed FROM crdb_internal.jobs;SELECT * FROM system.settings;SELECT description, fraction_completed FROM crdb_internal.jobs;selected now() - started() / fraction_completed from crdb_internal.jobs;select now() - started() / fraction_completed from crdb_internal.jobs;select now() - started / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;select started + (now() - started) / fraction_completed from crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SET CLUSTER SETTING engineccl.time_bound_iterators = true;SELECT * FROM system.settings;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT description, fraction_completed FROM crdb_internal.jobs order by created desc limit 1;SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-06-15 12:45:00';SHOW DATABASES;SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-07-15 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-10-15 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-12-15 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-15 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-30 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-20 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-22 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-23 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-25 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-24 12:45:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-24 00:00:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-24 05:00:00';SELECT count(*) FROM datablocks.blocks AS OF SYSTEM TIME '2016-11-24 10:00:00';SHOW CREATE TABLE datablocks.blocks;SELECT * FROM datablocks.blocks ORDER BY block_num DESC LIMIT 1;SELECT * FROM datablocks.blocks LIMIT 1;SELECT * FROM datablocks.blocks LIMIT 2;SHOW CREATE TABLE datablocks.blocks;SELECT * FROM datablocks.blocks order by block_id desc LIMIT 2;SELECT * FROM datablocks.blocks order by block_id desc LIMIT 1;SELECT * FROM datablocks.blocks order by block_id desc LIMIT 100;SELECT * FROM datablocks.blocks order by block_id desc LIMIT 1;SELECT * FROM datablocks.blocks order by block_id desc LIMIT 1 as of system time '2016-11-24 10:00:00';SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc;SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc limit 1;SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc limit 1;SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc limit 1;SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc limit 1;SELECT * FROM datablocks.blocks as of system time '2016-11-24 10:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-24 00:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-24 18:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-24 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-25 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-26 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-28 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-30 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-12-10 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-12-01 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-28 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-30 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 16:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 12:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 00:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 05:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 02:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 03:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 01:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 00:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 00:30:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 00:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 01:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 05:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-29 00:00:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-28 23:30:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-28 22:30:00' order by block_id desc limit 10;SELECT * FROM datablocks.blocks as of system time '2016-11-28 22:30:00' order by block_id desc limit 10;