regression.diffs.txt

*** ./expected/float8-fp-exception.out	Thu Mar 30 10:46:00 2000
--- ./results/float8.out	Fri Nov  1 10:16:14 2002
***************
*** 149,161 ****
        | 1.2345678901234e-200 |                    0
  (5 rows)
  
  SELECT sqrt(float8 '64') AS eight;
   eight 
  -------
       8
  (1 row)
  
- -- square root 
  SELECT |/ float8 '64' AS eight;
   eight 
  -------
--- 149,194 ----
        | 1.2345678901234e-200 |                    0
  (5 rows)
  
+ -- ceil
+ select ceil(f1) as ceil_f1 from float8_tbl f;
+        ceil_f1        
+ ----------------------
+                     0
+                  1005
+                   -34
+  1.2345678901234e+200
+                     1
+ (5 rows)
+ 
+ -- floor
+ select floor(f1) as floor_f1 from float8_tbl f;
+        floor_f1       
+ ----------------------
+                     0
+                  1004
+                   -35
+  1.2345678901234e+200
+                     0
+ (5 rows)
+ 
+ -- sign
+ select sign(f1) as sign_f1 from float8_tbl f;
+  sign_f1 
+ ---------
+        0
+        1
+       -1
+        1
+        1
+ (5 rows)
+ 
+ -- square root 
  SELECT sqrt(float8 '64') AS eight;
   eight 
  -------
       8
  (1 row)
  
  SELECT |/ float8 '64' AS eight;
   eight 
  -------

======================================================================

*** ./expected/alter_table.out	Sat Oct 19 04:35:43 2002
--- ./results/alter_table.out	Fri Nov  1 10:17:19 2002
***************
*** 940,1168 ****
  alter table atacc1 drop d;
  alter table atacc1 drop b;
  select * from atacc1;
!   
! --
! (1 row)
! 
! drop table atacc1;
! -- test inheritance
! create table parent (a int, b int, c int);
! insert into parent values (1, 2, 3);
! alter table parent drop a;
! create table child (d varchar(255)) inherits (parent);
! insert into child values (12, 13, 'testing');
! select * from parent;
!  b  | c  
! ----+----
!   2 |  3
!  12 | 13
! (2 rows)
! 
! select * from child;
!  b  | c  |    d    
! ----+----+---------
!  12 | 13 | testing
! (1 row)
! 
! alter table parent drop c;
! select * from parent;
!  b  
! ----
!   2
!  12
! (2 rows)
! 
! select * from child;
!  b  |    d    
! ----+---------
!  12 | testing
! (1 row)
! 
! drop table child;
! drop table parent;
! -- test copy in/out
! create table test (a int4, b int4, c int4);
! insert into test values (1,2,3);
! alter table test drop a;
! copy test to stdout;
! 2	3
! copy test(a) to stdout;
! ERROR:  Relation "test" has no column "a"
! copy test("........pg.dropped.1........") to stdout;
! ERROR:  Relation "test" has no column "........pg.dropped.1........"
! copy test from stdin;
! ERROR:  copy: line 1, Extra data after last expected column
! lost synchronization with server, resetting connection
! SET autocommit TO 'on';
! select * from test;
!  b | c 
! ---+---
!  2 | 3
! (1 row)
! 
! copy test from stdin;
! select * from test;
!  b  | c  
! ----+----
!   2 |  3
!  21 | 22
! (2 rows)
! 
! copy test(a) from stdin;
! ERROR:  Relation "test" has no column "a"
! copy test("........pg.dropped.1........") from stdin;
! ERROR:  Relation "test" has no column "........pg.dropped.1........"
! copy test(b,c) from stdin;
! select * from test;
!  b  | c  
! ----+----
!   2 |  3
!  21 | 22
!  31 | 32
! (3 rows)
! 
! drop table test;
! -- test inheritance
! create table dropColumn (a int, b int, e int);
! create table dropColumnChild (c int) inherits (dropColumn);
! create table dropColumnAnother (d int) inherits (dropColumnChild);
! -- these two should fail
! alter table dropColumnchild drop column a;
! ERROR:  ALTER TABLE: Cannot drop inherited column "a"
! alter table only dropColumnChild drop column b;
! ERROR:  ALTER TABLE: Cannot drop inherited column "b"
! -- these three should work
! alter table only dropColumn drop column e;
! alter table dropColumnChild drop column c;
! alter table dropColumn drop column a;
! create table renameColumn (a int);
! create table renameColumnChild (b int) inherits (renameColumn);
! create table renameColumnAnother (c int) inherits (renameColumnChild);
! -- these three should fail
! alter table renameColumnChild rename column a to d;
! ERROR:  renameatt: inherited attribute "a" may not be renamed
! alter table only renameColumnChild rename column a to d;
! ERROR:  Inherited attribute "a" must be renamed in child tables too
! alter table only renameColumn rename column a to d;
! ERROR:  Inherited attribute "a" must be renamed in child tables too
! -- these should work
! alter table renameColumn rename column a to d;
! alter table renameColumnChild rename column b to a;
! -- this should work
! alter table renameColumn add column w int;
! -- this should fail
! alter table only renameColumn add column x int;
! ERROR:  Attribute must be added to child tables too
! -- Test corner cases in dropping of inherited columns
! create table p1 (f1 int, f2 int);
! create table c1 (f1 int not null) inherits(p1);
! NOTICE:  CREATE TABLE: merging attribute "f1" with inherited definition
! -- should be rejected since c1.f1 is inherited
! alter table c1 drop column f1;
! ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
! -- should work
! alter table p1 drop column f1;
! -- c1.f1 is still there, but no longer inherited
! select f1 from c1;
!  f1 
! ----
! (0 rows)
! 
! alter table c1 drop column f1;
! select f1 from c1;
! ERROR:  Attribute "f1" not found
! drop table p1 cascade;
! NOTICE:  Drop cascades to table c1
! create table p1 (f1 int, f2 int);
! create table c1 () inherits(p1);
! -- should be rejected since c1.f1 is inherited
! alter table c1 drop column f1;
! ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
! alter table p1 drop column f1;
! -- c1.f1 is dropped now, since there is no local definition for it
! select f1 from c1;
! ERROR:  Attribute "f1" not found
! drop table p1 cascade;
! NOTICE:  Drop cascades to table c1
! create table p1 (f1 int, f2 int);
! create table c1 () inherits(p1);
! -- should be rejected since c1.f1 is inherited
! alter table c1 drop column f1;
! ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
! alter table only p1 drop column f1;
! -- c1.f1 is NOT dropped, but must now be considered non-inherited
! alter table c1 drop column f1;
! drop table p1 cascade;
! NOTICE:  Drop cascades to table c1
! create table p1 (f1 int, f2 int);
! create table c1 (f1 int not null) inherits(p1);
! NOTICE:  CREATE TABLE: merging attribute "f1" with inherited definition
! -- should be rejected since c1.f1 is inherited
! alter table c1 drop column f1;
! ERROR:  ALTER TABLE: Cannot drop inherited column "f1"
! alter table only p1 drop column f1;
! -- c1.f1 is still there, but no longer inherited
! alter table c1 drop column f1;
! drop table p1 cascade;
! NOTICE:  Drop cascades to table c1
! create table p1(id int, name text);
! create table p2(id2 int, name text, height int);
! create table c1(age int) inherits(p1,p2);
! NOTICE:  CREATE TABLE: merging multiple inherited definitions of attribute "name"
! create table gc1() inherits (c1);
! select relname, attname, attinhcount, attislocal
! from pg_class join pg_attribute on (pg_class.oid = pg_attribute.attrelid)
! where relname in ('p1','p2','c1','gc1') and attnum > 0 and not attisdropped
! order by relname, attnum;
!  relname | attname | attinhcount | attislocal 
! ---------+---------+-------------+------------
!  c1      | id      |           1 | f
!  c1      | name    |           2 | f
!  c1      | id2     |           1 | f
!  c1      | height  |           1 | f
!  c1      | age     |           0 | t
!  gc1     | id      |           1 | f
!  gc1     | name    |           1 | f
!  gc1     | id2     |           1 | f
!  gc1     | height  |           1 | f
!  gc1     | age     |           1 | f
!  p1      | id      |           0 | t
!  p1      | name    |           0 | t
!  p2      | id2     |           0 | t
!  p2      | name    |           0 | t
!  p2      | height  |           0 | t
! (15 rows)
! 
! -- should work
! alter table only p1 drop column name;
! -- should work. Now c1.name is local and inhcount is 0.
! alter table p2 drop column name;
! -- should be rejected since its inherited
! alter table gc1 drop column name;
! ERROR:  ALTER TABLE: Cannot drop inherited column "name"
! -- should work, and drop gc1.name along
! alter table c1 drop column name;
! -- should fail: column does not exist
! alter table gc1 drop column name;
! ERROR:  Relation "gc1" has no column "name"
! -- should work and drop the attribute in all tables
! alter table p2 drop column height;
! select relname, attname, attinhcount, attislocal
! from pg_class join pg_attribute on (pg_class.oid = pg_attribute.attrelid)
! where relname in ('p1','p2','c1','gc1') and attnum > 0 and not attisdropped
! order by relname, attnum;
!  relname | attname | attinhcount | attislocal 
! ---------+---------+-------------+------------
!  c1      | id      |           1 | f
!  c1      | id2     |           1 | f
!  c1      | age     |           0 | t
!  gc1     | id      |           1 | f
!  gc1     | id2     |           1 | f
!  gc1     | age     |           1 | f
!  p1      | id      |           0 | t
!  p2      | id2     |           0 | t
! (8 rows)
! 
! drop table p1, p2 cascade;
! NOTICE:  Drop cascades to table c1
! NOTICE:  Drop cascades to table gc1
--- 940,943 ----
  alter table atacc1 drop d;
  alter table atacc1 drop b;
  select * from atacc1;
! calloc: Invalid argument

======================================================================