diff options
Diffstat (limited to 'src/test/regress/sql/alter_table.sql')
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 120 |
1 files changed, 60 insertions, 60 deletions
diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 5d1d773b052..2be9f021fce 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -1,60 +1,60 @@ -- -- add attribute -- -CREATE TABLE temp (initial int4); +CREATE TABLE tmp (initial int4); -ALTER TABLE temp ADD COLUMN a int4; +ALTER TABLE tmp ADD COLUMN a int4; -ALTER TABLE temp ADD COLUMN b name; +ALTER TABLE tmp ADD COLUMN b name; -ALTER TABLE temp ADD COLUMN c text; +ALTER TABLE tmp ADD COLUMN c text; -ALTER TABLE temp ADD COLUMN d float8; +ALTER TABLE tmp ADD COLUMN d float8; -ALTER TABLE temp ADD COLUMN e float4; +ALTER TABLE tmp ADD COLUMN e float4; -ALTER TABLE temp ADD COLUMN f int2; +ALTER TABLE tmp ADD COLUMN f int2; -ALTER TABLE temp ADD COLUMN g polygon; +ALTER TABLE tmp ADD COLUMN g polygon; -ALTER TABLE temp ADD COLUMN h abstime; +ALTER TABLE tmp ADD COLUMN h abstime; -ALTER TABLE temp ADD COLUMN i char; +ALTER TABLE tmp ADD COLUMN i char; -ALTER TABLE temp ADD COLUMN j abstime[]; +ALTER TABLE tmp ADD COLUMN j abstime[]; -ALTER TABLE temp ADD COLUMN k dt; +ALTER TABLE tmp ADD COLUMN k dt; -ALTER TABLE temp ADD COLUMN l tid; +ALTER TABLE tmp ADD COLUMN l tid; -ALTER TABLE temp ADD COLUMN m xid; +ALTER TABLE tmp ADD COLUMN m xid; -ALTER TABLE temp ADD COLUMN n oid8; +ALTER TABLE tmp ADD COLUMN n oid8; ---ALTER TABLE temp ADD COLUMN o lock; -ALTER TABLE temp ADD COLUMN p smgr; +--ALTER TABLE tmp ADD COLUMN o lock; +ALTER TABLE tmp ADD COLUMN p smgr; -ALTER TABLE temp ADD COLUMN q point; +ALTER TABLE tmp ADD COLUMN q point; -ALTER TABLE temp ADD COLUMN r lseg; +ALTER TABLE tmp ADD COLUMN r lseg; -ALTER TABLE temp ADD COLUMN s path; +ALTER TABLE tmp ADD COLUMN s path; -ALTER TABLE temp ADD COLUMN t box; +ALTER TABLE tmp ADD COLUMN t box; -ALTER TABLE temp ADD COLUMN u tinterval; +ALTER TABLE tmp ADD COLUMN u tinterval; -ALTER TABLE temp ADD COLUMN v datetime; +ALTER TABLE tmp ADD COLUMN v datetime; -ALTER TABLE temp ADD COLUMN w timespan; +ALTER TABLE tmp ADD COLUMN w timespan; -ALTER TABLE temp ADD COLUMN x float8[]; +ALTER TABLE tmp ADD COLUMN x float8[]; -ALTER TABLE temp ADD COLUMN y float4[]; +ALTER TABLE tmp ADD COLUMN y float4[]; -ALTER TABLE temp ADD COLUMN z int2[]; +ALTER TABLE tmp ADD COLUMN z int2[]; -INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, +INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z) VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}', @@ -63,67 +63,67 @@ INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]', '1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}'); -SELECT * FROM temp; +SELECT * FROM tmp; -DROP TABLE temp; +DROP TABLE tmp; -- the wolf bug - schema mods caused inconsistent row descriptors -CREATE TABLE temp ( +CREATE TABLE tmp ( initial int4 ); -ALTER TABLE temp ADD COLUMN a int4; +ALTER TABLE tmp ADD COLUMN a int4; -ALTER TABLE temp ADD COLUMN b name; +ALTER TABLE tmp ADD COLUMN b name; -ALTER TABLE temp ADD COLUMN c text; +ALTER TABLE tmp ADD COLUMN c text; -ALTER TABLE temp ADD COLUMN d float8; +ALTER TABLE tmp ADD COLUMN d float8; -ALTER TABLE temp ADD COLUMN e float4; +ALTER TABLE tmp ADD COLUMN e float4; -ALTER TABLE temp ADD COLUMN f int2; +ALTER TABLE tmp ADD COLUMN f int2; -ALTER TABLE temp ADD COLUMN g polygon; +ALTER TABLE tmp ADD COLUMN g polygon; -ALTER TABLE temp ADD COLUMN h abstime; +ALTER TABLE tmp ADD COLUMN h abstime; -ALTER TABLE temp ADD COLUMN i char; +ALTER TABLE tmp ADD COLUMN i char; -ALTER TABLE temp ADD COLUMN j abstime[]; +ALTER TABLE tmp ADD COLUMN j abstime[]; -ALTER TABLE temp ADD COLUMN k dt; +ALTER TABLE tmp ADD COLUMN k dt; -ALTER TABLE temp ADD COLUMN l tid; +ALTER TABLE tmp ADD COLUMN l tid; -ALTER TABLE temp ADD COLUMN m xid; +ALTER TABLE tmp ADD COLUMN m xid; -ALTER TABLE temp ADD COLUMN n oid8; +ALTER TABLE tmp ADD COLUMN n oid8; ---ALTER TABLE temp ADD COLUMN o lock; -ALTER TABLE temp ADD COLUMN p smgr; +--ALTER TABLE tmp ADD COLUMN o lock; +ALTER TABLE tmp ADD COLUMN p smgr; -ALTER TABLE temp ADD COLUMN q point; +ALTER TABLE tmp ADD COLUMN q point; -ALTER TABLE temp ADD COLUMN r lseg; +ALTER TABLE tmp ADD COLUMN r lseg; -ALTER TABLE temp ADD COLUMN s path; +ALTER TABLE tmp ADD COLUMN s path; -ALTER TABLE temp ADD COLUMN t box; +ALTER TABLE tmp ADD COLUMN t box; -ALTER TABLE temp ADD COLUMN u tinterval; +ALTER TABLE tmp ADD COLUMN u tinterval; -ALTER TABLE temp ADD COLUMN v datetime; +ALTER TABLE tmp ADD COLUMN v datetime; -ALTER TABLE temp ADD COLUMN w timespan; +ALTER TABLE tmp ADD COLUMN w timespan; -ALTER TABLE temp ADD COLUMN x float8[]; +ALTER TABLE tmp ADD COLUMN x float8[]; -ALTER TABLE temp ADD COLUMN y float4[]; +ALTER TABLE tmp ADD COLUMN y float4[]; -ALTER TABLE temp ADD COLUMN z int2[]; +ALTER TABLE tmp ADD COLUMN z int2[]; -INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, +INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, v, w, x, y, z) VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 'Mon May 1 00:30:30 1995', 'c', '{Mon May 1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}', @@ -132,9 +132,9 @@ INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u, '(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]', '1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}'); -SELECT * FROM temp; +SELECT * FROM tmp; -DROP TABLE temp; +DROP TABLE tmp; -- |