1bar input.sql /^CREATE TABLE bar (m INT) SELECT n FROM foo;$/;" t 2m input.sql /^CREATE TABLE bar (m INT) SELECT n FROM foo;$/;" E table:bar 3n input.sql /^CREATE TABLE bar (m INT) SELECT n FROM foo;$/;" E table:bar 4bar input.sql /^CREATE TABLE bar (UNIQUE (n)) SELECT n FROM foo;$/;" t 5n input.sql /^CREATE TABLE bar (UNIQUE (n)) SELECT n FROM foo;$/;" E table:bar 6artists_and_works input.sql /^CREATE TABLE artists_and_works$/;" t 7name input.sql /^ SELECT artist.name, COUNT(work.artist_id) AS number_of_works$/;" E table:artists_and_works 8number_of_works input.sql /^ SELECT artist.name, COUNT(work.artist_id) AS number_of_works$/;" E table:artists_and_works 9foo input.sql /^CREATE TABLE foo (a TINYINT NOT NULL) SELECT b+1 AS a FROM bar;$/;" t 10a input.sql /^CREATE TABLE foo (a TINYINT NOT NULL) SELECT b+1 AS a FROM bar;$/;" E table:foo 11a input.sql /^CREATE TABLE foo (a TINYINT NOT NULL) SELECT b+1 AS a FROM bar;$/;" E table:foo 12