diff options
Diffstat (limited to 'src/test/regress/sql/errors.sql')
-rw-r--r-- | src/test/regress/sql/errors.sql | 252 |
1 files changed, 0 insertions, 252 deletions
diff --git a/src/test/regress/sql/errors.sql b/src/test/regress/sql/errors.sql deleted file mode 100644 index db041fa9cbf..00000000000 --- a/src/test/regress/sql/errors.sql +++ /dev/null @@ -1,252 +0,0 @@ --- --- ERRORS --- - --- bad in postquel, but ok in postsql -select 1 - - --- --- UNSUPPORTED STUFF - --- doesn't work --- attachas nonesuch --- --- doesn't work --- notify pg_class --- - --- --- RETRIEVE - --- missing relation name -select - --- no such relation -select * from nonesuch; - --- bad name in target list -select nonesuch from pg_database; --- bad attribute name on lhs of operator -select * from pg_database where nonesuch = pg_database.datname; - --- bad attribute name on rhs of operator -select * from pg_database where pg_database.datname = nonesuch; - - --- bad select distinct on syntax, distinct attribute missing -select distinct on (foobar) from pg_database; - - --- bad select distinct on syntax, distinct attribute not in target list -select distinct on (foobar) * from pg_database; - - --- --- DELETE - --- missing relation name (this had better not wildcard!) -delete from; - --- no such relation -delete from nonesuch; - - --- --- DESTROY - --- missing relation name (this had better not wildcard!) -drop table; - --- no such relation -drop table nonesuch; - - --- --- RENAME - - --- relation renaming - --- missing relation name -alter table rename; - --- no such relation -alter table nonesuch rename to newnonesuch; - --- no such relation -alter table nonesuch rename to stud_emp; - --- conflict -alter table stud_emp rename to aggtest; - --- self-conflict -alter table stud_emp rename to stud_emp; - - --- attribute renaming - --- no such relation -alter table nonesuchrel rename column nonesuchatt to newnonesuchatt; - --- no such attribute -alter table emp rename column nonesuchatt to newnonesuchatt; - --- conflict -alter table emp rename column salary to manager; - --- conflict -alter table emp rename column salary to oid; - - --- --- TRANSACTION STUFF - --- not in a xact -abort; - --- not in a xact -end; - - --- --- DEFINE AGGREGATE - --- sfunc/finalfunc type disagreement -create aggregate newavg2 (sfunc = int4pl, - basetype = int4, - stype = int4, - finalfunc = int2um, - initcond = '0'); - --- left out basetype -create aggregate newcnt1 (sfunc = int4inc, - stype = int4, - initcond = '0'); - - --- --- REMOVE INDEX - --- missing index name -drop index; - --- bad index name -drop index 314159; - --- no such index -drop index nonesuch; - - --- --- REMOVE AGGREGATE - --- missing aggregate name -drop aggregate; - --- missing aggregate type -drop aggregate newcnt1; - --- bad aggregate name -drop aggregate 314159 (int); - --- bad aggregate type -drop aggregate newcnt (nonesuch); - --- no such aggregate -drop aggregate nonesuch (int4); - --- no such aggregate for type -drop aggregate newcnt (float4); - - --- --- REMOVE FUNCTION - --- missing function name -drop function (); - --- bad function name -drop function 314159(); - --- no such function -drop function nonesuch(); - - --- --- REMOVE TYPE - --- missing type name -drop type; - --- bad type name -drop type 314159; - --- no such type -drop type nonesuch; - - --- --- DROP OPERATOR - --- missing everything -drop operator; - --- bad operator name -drop operator equals; - --- missing type list -drop operator ===; - --- missing parentheses -drop operator int4, int4; - --- missing operator name -drop operator (int4, int4); - --- missing type list contents -drop operator === (); - --- no such operator -drop operator === (int4); - --- no such operator by that name -drop operator === (int4, int4); - --- no such type1 -drop operator = (nonesuch); - --- no such type1 -drop operator = ( , int4); - --- no such type1 -drop operator = (nonesuch, int4); - --- no such type2 -drop operator = (int4, nonesuch); - --- no such type2 -drop operator = (int4, ); - - --- --- DROP RULE - --- missing rule name -drop rule; - --- bad rule name -drop rule 314159; - --- no such rule -drop rule nonesuch on noplace; - --- bad keyword -drop tuple rule nonesuch; - --- no such rule -drop instance rule nonesuch on noplace; - --- no such rule -drop rewrite rule nonesuch; - |