summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/errors.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/errors.sql')
-rw-r--r--src/test/regress/sql/errors.sql252
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;
-