-- syntax errors

-- test for extraneous comma

CREATE TABLE error_tbl (i int DEFAULT (100, ));

ERROR: parser: parse error at or near ","

ERROR: parser: parse error at or near "," at character 43

-- this will fail because gram.y uses b_expr not a_expr for defaults,

-- to avoid a shift/reduce conflict that arises from NOT NULL being

-- part of the column definition syntax:

CREATE TABLE error_tbl (b1 bool DEFAULT 1 IN (1, 2));

ERROR: parser: parse error at or near "IN"

ERROR: parser: parse error at or near "IN" at character 43

-- this should work, however:

CREATE TABLE error_tbl (b1 bool DEFAULT (1 IN (1, 2)));

DROP TABLE error_tbl;

ERROR: return type mismatch in function: declared to return integer, returns "unknown"

CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql

AS 'not even SQL';

ERROR: parser: parse error at or near "not"

ERROR: parser: parse error at or near "not" at character 1

CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql

AS 'SELECT 1, 2, 3;';

ERROR: function declared to return integer returns multiple columns in final SELECT