core/sql/regress/core/TEST037

-- Test: TEST037 (Core)
-- @@@ START COPYRIGHT @@@
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--
-- @@@ END COPYRIGHT @@@
--
-- Functionality: Makes sure that non-reserved words are really non-reserved,
-- and reserved words are really reserved.
-- Expected files: EXPECTED037
-- Tables created: table_name, system_name
-- This test is run against MX tables only.
-- Limitations:
-- To do: 
-- Revision history:
-- (10/05/02) Move test to core from fullstack2, without any change.    
-- (11/22/02) Merged in R1.8 changes: AFTER no longer raises error 3128
--                                    use envvar SQLPARSER_FLAGS
-- (11/25/02) Restored the way of SQLPARSER_FLAGS settings
-- (11/25/02) Restored the test back to its 10/05/02 version

set schema $$TEST_SCHEMA$$;

drop table table_name;
drop table system_name;

log LOG037 clear;

?ifMX

create table table_name
( ABSOLUTE int not null 
, ACCESS int not null 
, ANSIVARCHAR int not null 
, ASCENDING int not null 
, ATTRIBUTE int not null 
, ATTRIBUTES int not null 
, AUDIT int not null 
, AUTOCOMMIT int not null 
, AUDITCOMPRESS int not null 
, BIGINT int not null 
, BLOCKSIZE int not null 
, BUFFERED int not null 
, BYTES int not null 
, CATALOG_NAME int not null 
, CHARACTER_SET int not null 
, CHARACTER_SET_CATALOG int not null 
, CHARACTER_SET_NAME int not null 
, CHARACTER_SET_SCHEMA int not null 
, CLASS_ORIGIN int not null 
, CLEARONPURGE int not null 
, COLLATION_CATALOG int not null 
, COLLATION_NAME int not null 
, COLLATION_SCHEMA int not null 
, COLUMN_NAME int not null 
, COLUMN_NUMBER int not null 
, COMMAND_FUNCTION int not null 
, COMMITTED int not null 
, COMP  int not null 
, CONDITION_NUMBER int not null 
, CONFIG int not null 
, CONNECTION_NAME int not null 
, CONSTRAINT_CATALOG int not null 
, CONSTRAINT_NAME int not null 
, CONSTRAINT_SCHEMA int not null 
, CONTROL int not null 
, CURSOR_NAME int not null 
, DATA int not null 
--,DATETIME int not null 
, DATETIME_CODE int not null 
, DCOMPRESS int not null 
, DEFINITION int not null 
, DESCENDING int not null 
, DISPLAY int not null 
, DROPPABLE int not null 
, DSLACK int not null 
, DYNAMIC_FUNCTION int not null 
, ENTRY  int not null 
, EUROPEAN int not null 
, EXCLUSIVE int not null 
, EXIT int not null 
, EXPLAIN  int not null 
, FN int not null 
--,FRACTION int not null 
, GBYTES int not null 
, HASH int not null 
, HEADING  int not null 
, HEADINGS int not null 
, HIGH_VALUE int not null 
, HISTOGRAM int not null 
, INDEX_TABLE int not null 
, INDICATOR_DATA int not null 
, INDICATOR_POINTER int not null 
, INDICATOR_TYPE int not null 
, INITIALIZE int not null 
, INTERNALSP int not null 
, ISLACK int not null 
, KBYTES int not null 
);
invoke table_name;
create table system_name
( LARGEINT int not null 
, LEADING_PRECISION int not null 
, LENGTH int not null 
, LINE_NUMBER int not null 
, LOAD_TABLE int not null 
, LOCATION int not null 
, LOCK int not null 
, LOCKLENGTH int not null 
, LONG int not null 
, LOW_VALUE int not null 
, MAXSIZE int not null 
, MBYTES int not null 
, MESSAGE_LEN int not null 
, MESSAGE_OCTET_LEN int not null 
, MESSAGE_TEXT int not null 
, MODE int not null 
, MORE int not null 
, MOVE int not null 
, MOVEMENT  int not null 
, NAME int not null 
, NATIVE int not null 
, NONDROPPABLE  int not null 
, NULLABLE int not null 
, NUMBER int not null 
, PARTITION int not null 
, PARTITION_TABLE int not null 
, QUERY int not null 
, RANGE int not null 
, REINITIALIZE int not null 
, RENAME int not null 
, REPEATABLE int not null 
, RESOURCE_FORK int not null 
, RETURNED_LENGTH int not null 
, RETURNED_OCTET_LENGTH int not null 
, RETURNED_SQLSTATE int not null 
, ROW_COUNT int not null 
, ROW_NUMBER int not null 
, SCALE int not null 
, SCHEMA_NAME int not null 
, SEPARATE int not null 
, SEQUENCE int not null 
, SERIALIZABLE int not null 
, SERIALWRITES int not null 
, SERVER_NAME int not null 
, SHAPE int not null 
, SHARE int not null 
, SIDEINSERTS int not null 
, SIGNED int not null 
, SOURCE_FILE int not null 
, SQL_WARNING int not null 
, SQLMP int not null 
, STATEMENT int not null 
, STATIC int not null 
, STATISTICS int not null 
, STORE int not null 
, SUBCLASS_ORIGIN int not null 
, SUBSYSTEM_ID int not null 
, SYS_GUID int not null 
, system_name int not null 
, TABLE_NAME int not null 
, TYPE int not null 
, UNBOUNDED int not null 
, UNCOMMITTED int not null 
, UNLOCK int not null 
, UNNAMED int not null 
, UNSIGNED int not null 
, USA int not null 
, VARIABLE_DATA int not null 
, VARIABLE_POINTER int not null 
, VSBB int not null 
, WAITED int not null 
);
invoke system_name;

--
-- Checks a few reserved words
--
create view abs  as select usa from table_name;
create view avg  as select usa from table_name;
create view converttimestamp  as select usa from table_name;
create view dateformat as select usa from table_name;
create view dayofweek  as select usa from table_name;
create view encode_key as select usa from table_name;
create view invoke  as select usa from table_name;
create view juliantimestamp  as select usa from table_name;
create view sqlerror  as select usa from table_name;
create view sqlstate  as select usa from table_name;
create view stddev  as select usa from table_name;
create view table  as select usa from table_name;
create view upshift  as select usa from table_name;
create view variance  as select usa from table_name;

drop table table_name;
drop table system_name;
?ifMX

-- Check reserved and non-reserved words as identifiers.

-- Expect error [3128]
prepare s1 from SELECT AFTER AFTER from (values(0)) AFTER(AFTER);

-- Expect error [3128]
prepare s1 from SELECT ASYNC ASYNC from (values(0)) ASYNC(ASYNC);

-- Expect error [3128]
prepare s1 from SELECT AT AT from (values(0)) AT(AT);

-- Expect error [3128]
prepare s1 from SELECT BEFORE BEFORE from (values(0)) BEFORE(BEFORE);

-- Expect error [3128]
prepare s1 from SELECT BIT_LENGTH BIT_LENGTH from (values(0)) BIT_LENGTH(BIT_LENGTH);

-- Expect error [15001]
prepare s1 from SELECT BOOLEAN BOOLEAN from (values(0)) BOOLEAN(BOOLEAN);

-- Expect error [3128]
prepare s1 from SELECT BREADTH BREADTH from (values(0)) BREADTH(BREADTH);

-- Expect error [3128]
prepare s1 from SELECT COMPLETION COMPLETION from (values(0)) COMPLETION(COMPLETION);

-- Expect error [3128]
prepare s1 from SELECT CONNECT CONNECT from (values(0)) CONNECT(CONNECT);

-- Expect error [3128]
prepare s1 from SELECT CYCLE CYCLE from (values(0)) CYCLE(CYCLE);

-- Expect error [3128]
prepare s1 from SELECT DEFERRABLE DEFERRABLE from (values(0)) DEFERRABLE(DEFERRABLE);

-- Expect error [3128]
prepare s1 from SELECT DEFERRED DEFERRED from (values(0)) DEFERRED(DEFERRED);

-- Expect error [3128]
prepare s1 from SELECT DEPTH DEPTH from (values(0)) DEPTH(DEPTH);

-- Expect error [3128]
prepare s1 from SELECT DICTIONARY DICTIONARY from (values(0)) DICTIONARY(DICTIONARY);

-- Expect error [3128]
prepare s1 from SELECT DISCONNECT DISCONNECT from (values(0)) DISCONNECT(DISCONNECT);

-- Expect error [3128]
prepare s1 from SELECT DOMAIN DOMAIN from (values(0)) DOMAIN(DOMAIN);

-- Expect error [3128]
prepare s1 from SELECT EACH EACH from (values(0)) EACH(EACH);

-- Expect error [3128]
prepare s1 from SELECT EQUALS EQUALS from (values(0)) EQUALS(EQUALS);

-- Expect error [3128]
prepare s1 from SELECT EXEC EXEC from (values(0)) EXEC(EXEC);

-- Expect error [3128]
prepare s1 from SELECT GENERAL GENERAL from (values(0)) GENERAL(GENERAL);

-- Expect SYNTAX error now that we use IDENTITY as a token
prepare s1 from SELECT IDENTITY IDENTITY from (values(0)) IDENTITY(IDENTITY);

-- Expect error [3128]
prepare s1 from SELECT INITIALLY INITIALLY from (values(0)) INITIALLY(INITIALLY);

-- Expect error [3128]
prepare s1 from SELECT INSENSITIVE INSENSITIVE from (values(0)) INSENSITIVE(INSENSITIVE);

-- Expect error [3128]
prepare s1 from SELECT LEAVE LEAVE from (values(0)) LEAVE(LEAVE);

-- Expect error [3128]
prepare s1 from SELECT LESS LESS from (values(0)) LESS(LESS);

-- Expect syntax error, LIMIT must be double quoted.
prepare s1 from SELECT LIMIT LIMIT from (values(0)) LIMIT(LIMIT);

-- Expect error [3128]
prepare s1 from SELECT LOOP LOOP from (values(0)) LOOP(LOOP);

-- Expect error [3128]
prepare s1 from SELECT MODIFY MODIFY from (values(0)) MODIFY(MODIFY);

-- Expect error [3128]
prepare s1 from SELECT NEW NEW from (values(0)) NEW(NEW);

-- Expect error [3128]
prepare s1 from SELECT NEXT NEXT from (values(0)) NEXT(NEXT);

-- Expect error [15001]
prepare s1 from SELECT NONE NONE from (values(0)) NONE(NONE);

-- Expect error [3128]
prepare s1 from SELECT OBJECT OBJECT from (values(0)) OBJECT(OBJECT);

-- Expect error [3128]
prepare s1 from SELECT OID OID from (values(0)) OID(OID);

-- Expect error [3128]
prepare s1 from SELECT OLD OLD from (values(0)) OLD(OLD);

-- Expect error [3128]
prepare s1 from SELECT OPERATORS OPERATORS from (values(0)) OPERATORS(OPERATORS);

-- Expect error [3128]
prepare s1 from SELECT OTHERS OTHERS from (values(0)) OTHERS(OTHERS);

-- Expect error [3128]
prepare s1 from SELECT PAD PAD from (values(0)) PAD(PAD);

-- Expect error [3128]
prepare s1 from SELECT PARAMETERS PARAMETERS from (values(0)) PARAMETERS(PARAMETERS);

-- Expect error [3128]
prepare s1 from SELECT PENDANT PENDANT from (values(0)) PENDANT(PENDANT);

-- Expect error [3128]
prepare s1 from SELECT PREORDER PREORDER from (values(0)) PREORDER(PREORDER);

-- Expect error [3128]
prepare s1 from SELECT PRESERVE PRESERVE from (values(0)) PRESERVE(PRESERVE);

-- Expect error [3128]
prepare s1 from SELECT PRIOR PRIOR from (values(0)) PRIOR(PRIOR);

-- Expect error [3128]
prepare s1 from SELECT PRIVATE PRIVATE from (values(0)) PRIVATE(PRIVATE);

-- Expect error [15001]
prepare s1 from SELECT PROTECTED PROTECTED from (values(0)) PROTECTED(PROTECTED);

-- Expect error [3128]
prepare s1 from SELECT REF REF from (values(0)) REF(REF);

-- Expect error [3128]
prepare s1 from SELECT REFERENCING REFERENCING from (values(0)) REFERENCING(REFERENCING);

-- Expect error [3128]
prepare s1 from SELECT RELATIVE RELATIVE from (values(0)) RELATIVE(RELATIVE);

-- Expect error [3128]
prepare s1 from SELECT RESIGNAL RESIGNAL from (values(0)) RESIGNAL(RESIGNAL);

-- Expect error [3128]
prepare s1 from SELECT RETURNS RETURNS from (values(0)) RETURNS(RETURNS);

-- Expect error [3128]
prepare s1 from SELECT ROUTINE ROUTINE from (values(0)) ROUTINE(ROUTINE);

-- Expect error [3128]
prepare s1 from SELECT ROW ROW from (values(0)) ROW(ROW);

-- Expect error [3128]
prepare s1 from SELECT SAVEPOINT SAVEPOINT from (values(0)) SAVEPOINT(SAVEPOINT);

-- Expect error [3128]
prepare s1 from SELECT SCROLL SCROLL from (values(0)) SCROLL(SCROLL);

-- Expect error [3128]
prepare s1 from SELECT SEARCH SEARCH from (values(0)) SEARCH(SEARCH);

-- Expect error [3128]
prepare s1 from SELECT SENSITIVE SENSITIVE from (values(0)) SENSITIVE(SENSITIVE);

-- Expect error [3128]
prepare s1 from SELECT SIGNAL SIGNAL from (values(0)) SIGNAL(SIGNAL);

-- Expect error [3128]
prepare s1 from SELECT SIMILAR SIMILAR from (values(0)) SIMILAR(SIMILAR);

-- Expect error [3128]
prepare s1 from SELECT SQLEXCEPTION SQLEXCEPTION from (values(0)) SQLEXCEPTION(SQLEXCEPTION);

-- Expect error [3128]
prepare s1 from SELECT SQLSTATE SQLSTATE from (values(0)) SQLSTATE(SQLSTATE);

-- Expect error [3128]
prepare s1 from SELECT SQLWARNING SQLWARNING from (values(0)) SQLWARNING(SQLWARNING);

-- Expect error [3128]
prepare s1 from SELECT STRUCTURE STRUCTURE from (values(0)) STRUCTURE(STRUCTURE);

-- Expect error [3128]
prepare s1 from SELECT SYSTEM_USER SYSTEM_USER from (values(0)) SYSTEM_USER(SYSTEM_USER);

-- Expect error [3128]
prepare s1 from SELECT TEMPORARY TEMPORARY from (values(0)) TEMPORARY(TEMPORARY);

-- Expect error [3128]
prepare s1 from SELECT TEST TEST from (values(0)) TEST(TEST);

-- Expect error [3128]
prepare s1 from SELECT THERE THERE from (values(0)) THERE(THERE);

-- Expect error [3128]
prepare s1 from SELECT TIMEZONE_HOUR TIMEZONE_HOUR from (values(0)) TIMEZONE_HOUR(TIMEZONE_HOUR);

-- Expect error [3128]
prepare s1 from SELECT TIMEZONE_MINUTE TIMEZONE_MINUTE from (values(0)) TIMEZONE_MINUTE(TIMEZONE_MINUTE);

-- Expect error [3128]
prepare s1 from SELECT TRANSLATION TRANSLATION from (values(0)) TRANSLATION(TRANSLATION);

-- Expect error [3128]
prepare s1 from SELECT TRIGGER TRIGGER from (values(0)) TRIGGER(TRIGGER);

-- Expect error [3128]
prepare s1 from SELECT UNDER UNDER from (values(0)) UNDER(UNDER);

-- Expect error [3128]
prepare s1 from SELECT USAGE USAGE from (values(0)) USAGE(USAGE);

-- Expect error [3128]
prepare s1 from SELECT VARIABLE VARIABLE from (values(0)) VARIABLE(VARIABLE);

-- Expect error [3128]
prepare s1 from SELECT VIRTUAL VIRTUAL from (values(0)) VIRTUAL(VIRTUAL);

-- Expect error [3128]
prepare s1 from SELECT VISIBLE VISIBLE from (values(0)) VISIBLE(VISIBLE);

-- Expect error [3128]
prepare s1 from SELECT WAIT WAIT from (values(0)) WAIT(WAIT);

-- Expect error [3128]
prepare s1 from SELECT WHILE WHILE from (values(0)) WHILE(WHILE);

-- Expect error [3128]
prepare s1 from SELECT ZONE ZONE from (values(0)) ZONE(ZONE);

-- Expect error [3128]
prepare s1 from SELECT CAST CAST from (values(0)) CAST(CAST);

-- Expect error [3128]
prepare s1 from SELECT CHARACTER_LENGTH CHARACTER_LENGTH from (values(0)) CHARACTER_LENGTH(CHARACTER_LENGTH);

-- Expect error [3128]
prepare s1 from SELECT CHAR_LENGTH CHAR_LENGTH from (values(0)) CHAR_LENGTH(CHAR_LENGTH);

-- Expect error [3128]
prepare s1 from SELECT DOUBLE DOUBLE from (values(0)) DOUBLE(DOUBLE);

-- Expect error [3128]
prepare s1 from SELECT ELSE ELSE from (values(0)) ELSE(ELSE);

-- Expect error [3128]
prepare s1 from SELECT END END from (values(0)) END(END);

-- Expect error [3128]
prepare s1 from SELECT FLOAT FLOAT from (values(0)) FLOAT(FLOAT);

-- Expect error [3128]
prepare s1 from SELECT LOWER LOWER from (values(0)) LOWER(LOWER);

-- Expect error [3128]
prepare s1 from SELECT MIN MIN from (values(0)) MIN(MIN);

-- Expect error [3128]
prepare s1 from SELECT NATIONAL NATIONAL from (values(0)) NATIONAL(NATIONAL);

-- Expect error [3128]
prepare s1 from SELECT NCHAR NCHAR from (values(0)) NCHAR(NCHAR);

-- Expect error [3128]
prepare s1 from SELECT OCTET_LENGTH OCTET_LENGTH from (values(0)) OCTET_LENGTH(OCTET_LENGTH);

-- Expect error [3128]
prepare s1 from SELECT POSITION POSITION from (values(0)) POSITION(POSITION);

-- Expect error [3128]
prepare s1 from SELECT PRECISION PRECISION from (values(0)) PRECISION(PRECISION);

-- Expect error [3128]
prepare s1 from SELECT REAL REAL from (values(0)) REAL(REAL);

-- Expect error [3128]
prepare s1 from SELECT SUBSTRING SUBSTRING from (values(0)) SUBSTRING(SUBSTRING);

-- Expect error [3128]
prepare s1 from SELECT SQL_FLOAT SQL_FLOAT from (values(0)) SQL_FLOAT(SQL_FLOAT);

-- Expect error [3128]
prepare s1 from SELECT SQL_REAL SQL_REAL from (values(0)) SQL_REAL(SQL_REAL);

-- Expect error [3128]
prepare s1 from SELECT SQL_VARCHAR SQL_VARCHAR from (values(0)) SQL_VARCHAR(SQL_VARCHAR);

-- Expect error [3128]
prepare s1 from SELECT TRIM TRIM from (values(0)) TRIM(TRIM);

-- Expect error [3128]
prepare s1 from SELECT UPPER UPPER from (values(0)) UPPER(UPPER);

-- Expect error [3128]
prepare s1 from SELECT UPSHIFT UPSHIFT from (values(0)) UPSHIFT(UPSHIFT);

-- Expect error [3128]
prepare s1 from SELECT VARCHAR VARCHAR from (values(0)) VARCHAR(VARCHAR);

-- Expect error [3128]
prepare s1 from SELECT VARYING VARYING from (values(0)) VARYING(VARYING);

-- Expect SYNTAX error
prepare s1 from SELECT COLLATE COLLATE from (values(0)) COLLATE(COLLATE);

-- Expect SYNTAX error
prepare s1 from SELECT DATE DATE from (values(0)) DATE(DATE);

-- Expect SYNTAX error
prepare s1 from SELECT DAY DAY from (values(0)) DAY(DAY);

-- Expect SYNTAX error
prepare s1 from SELECT DEFAULT DEFAULT from (values(0)) DEFAULT(DEFAULT);

-- Expect SYNTAX error
prepare s1 from SELECT HOUR HOUR from (values(0)) HOUR(HOUR);

-- Expect SYNTAX error
prepare s1 from SELECT INTERVAL INTERVAL from (values(0)) INTERVAL(INTERVAL);

-- Expect SYNTAX error
prepare s1 from SELECT MINUTE MINUTE from (values(0)) MINUTE(MINUTE);

-- Expect SYNTAX error
prepare s1 from SELECT MONTH MONTH from (values(0)) MONTH(MONTH);

-- Expect SYNTAX error
prepare s1 from SELECT RIGHT RIGHT from (values(0)) RIGHT(RIGHT);

-- Expect SYNTAX error
prepare s1 from SELECT SECOND SECOND from (values(0)) SECOND(SECOND);

-- Expect SYNTAX error
prepare s1 from SELECT THEN THEN from (values(0)) THEN(THEN);

-- Expect SYNTAX error
prepare s1 from SELECT TIME TIME from (values(0)) TIME(TIME);

-- Expect SYNTAX error
prepare s1 from SELECT TIMESTAMP TIMESTAMP from (values(0)) TIMESTAMP(TIMESTAMP);

-- Expect SYNTAX error
prepare s1 from SELECT UNION UNION from (values(0)) UNION(UNION);

-- Expect SYNTAX error
prepare s1 from SELECT YEAR YEAR from (values(0)) YEAR(YEAR);

-- Expect SYNTAX error
prepare s1 from SELECT ACTION ACTION from (values(0)) ACTION(ACTION);

-- Expect SYNTAX error
prepare s1 from SELECT ADD ADD from (values(0)) ADD(ADD);

-- Expect SYNTAX error
prepare s1 from SELECT ALIAS ALIAS from (values(0)) ALIAS(ALIAS);

-- Expect SYNTAX error
prepare s1 from SELECT ALLOCATE ALLOCATE from (values(0)) ALLOCATE(ALLOCATE);

-- Expect SYNTAX error
prepare s1 from SELECT ALTER ALTER from (values(0)) ALTER(ALTER);

-- Expect SYNTAX error
prepare s1 from SELECT ARE ARE from (values(0)) ARE(ARE);

-- Expect SYNTAX error
prepare s1 from SELECT ASSERTION ASSERTION from (values(0)) ASSERTION(ASSERTION);

-- Expect SYNTAX error
prepare s1 from SELECT AUTHORIZATION AUTHORIZATION from (values(0)) AUTHORIZATION(AUTHORIZATION);

-- Expect SYNTAX error
prepare s1 from SELECT BIT BIT from (values(0)) BIT(BIT);

-- Expect SYNTAX error
prepare s1 from SELECT CALL CALL from (values(0)) CALL(CALL);

-- Expect SYNTAX error
prepare s1 from SELECT CASCADE CASCADE from (values(0)) CASCADE(CASCADE);

-- Expect SYNTAX error
prepare s1 from SELECT CASCADED CASCADED from (values(0)) CASCADED(CASCADED);

-- Expect SYNTAX error
prepare s1 from SELECT COALESCE COALESCE from (values(0)) COALESCE(COALESCE);

-- Expect SYNTAX error
prepare s1 from SELECT COLLATION COLLATION from (values(0)) COLLATION(COLLATION);

-- Expect SYNTAX error
prepare s1 from SELECT COLUMN COLUMN from (values(0)) COLUMN(COLUMN);

-- Expect SYNTAX error
prepare s1 from SELECT CONSTRAINT CONSTRAINT from (values(0)) CONSTRAINT(CONSTRAINT);

-- Expect SYNTAX error
prepare s1 from SELECT CONSTRAINTS CONSTRAINTS from (values(0)) CONSTRAINTS(CONSTRAINTS);

-- Expect SYNTAX error
prepare s1 from SELECT CONTINUE CONTINUE from (values(0)) CONTINUE(CONTINUE);

-- Expect SYNTAX error
prepare s1 from SELECT CONVERT CONVERT from (values(0)) CONVERT(CONVERT);

-- Expect SYNTAX error
prepare s1 from SELECT CORRESPONDING CORRESPONDING from (values(0)) CORRESPONDING(CORRESPONDING);

-- Expect SYNTAX error
prepare s1 from SELECT CREATE CREATE from (values(0)) CREATE(CREATE);

-- Expect SYNTAX error
prepare s1 from SELECT CROSS CROSS from (values(0)) CROSS(CROSS);

-- Expect SYNTAX error
prepare s1 from SELECT DEALLOCATE DEALLOCATE from (values(0)) DEALLOCATE(DEALLOCATE);

-- Expect SYNTAX error
prepare s1 from SELECT DESCRIBE DESCRIBE from (values(0)) DESCRIBE(DESCRIBE);

-- Expect SYNTAX error
prepare s1 from SELECT DESCRIPTOR DESCRIPTOR from (values(0)) DESCRIPTOR(DESCRIPTOR);

-- Expect SYNTAX error
prepare s1 from SELECT DIAGNOSTICS DIAGNOSTICS from (values(0)) DIAGNOSTICS(DIAGNOSTICS);

-- Expect SYNTAX error
prepare s1 from SELECT DROP DROP from (values(0)) DROP(DROP);

-- Expect SYNTAX error
prepare s1 from SELECT ELSEIF ELSEIF from (values(0)) ELSEIF(ELSEIF);

-- Expect SYNTAX error
prepare s1 from SELECT EXCEPT EXCEPT from (values(0)) EXCEPT(EXCEPT);

-- Expect SYNTAX error
prepare s1 from SELECT EXCEPTION EXCEPTION from (values(0)) EXCEPTION(EXCEPTION);

-- Expect SYNTAX error
prepare s1 from SELECT EXECUTE EXECUTE from (values(0)) EXECUTE(EXECUTE);

-- Expect SYNTAX error
prepare s1 from SELECT EXTERNAL EXTERNAL from (values(0)) EXTERNAL(EXTERNAL);

-- Expect SYNTAX error
prepare s1 from SELECT EXTRACT EXTRACT from (values(0)) EXTRACT(EXTRACT);

-- Expect SYNTAX error
prepare s1 from SELECT FALSE FALSE from (values(0)) FALSE(FALSE);

-- Expect SYNTAX error
prepare s1 from SELECT FIRST FIRST from (values(0)) FIRST(FIRST);

-- Expect SYNTAX error
prepare s1 from SELECT FOREIGN FOREIGN from (values(0)) FOREIGN(FOREIGN);

-- Expect SYNTAX error
prepare s1 from SELECT FOUND FOUND from (values(0)) FOUND(FOUND);

-- Expect SYNTAX error
prepare s1 from SELECT FULL FULL from (values(0)) FULL(FULL);

-- Expect SYNTAX error
prepare s1 from SELECT GET GET from (values(0)) GET(GET);

-- Expect SYNTAX error
prepare s1 from SELECT GLOBAL GLOBAL from (values(0)) GLOBAL(GLOBAL);

-- Expect SYNTAX error
prepare s1 from SELECT GO GO from (values(0)) GO(GO);

-- Expect SYNTAX error
prepare s1 from SELECT GOTO GOTO from (values(0)) GOTO(GOTO);

-- Expect SYNTAX error
prepare s1 from SELECT GRANT GRANT from (values(0)) GRANT(GRANT);

-- Expect SYNTAX error
prepare s1 from SELECT IF IF from (values(0)) IF(IF);

-- Expect SYNTAX error
prepare s1 from SELECT IGNORE IGNORE from (values(0)) IGNORE(IGNORE);

-- Expect SYNTAX error
prepare s1 from SELECT IMMEDIATE IMMEDIATE from (values(0)) IMMEDIATE(IMMEDIATE);

-- Expect SYNTAX error
prepare s1 from SELECT INDICATOR INDICATOR from (values(0)) INDICATOR(INDICATOR);

-- Expect SYNTAX error
prepare s1 from SELECT INTERSECT INTERSECT from (values(0)) INTERSECT(INTERSECT);

-- Expect SYNTAX error
prepare s1 from SELECT ISOLATION ISOLATION from (values(0)) ISOLATION(ISOLATION);

-- Expect SYNTAX error
prepare s1 from SELECT LANGUAGE LANGUAGE from (values(0)) LANGUAGE(LANGUAGE);

-- Expect SYNTAX error
prepare s1 from SELECT LAST LAST from (values(0)) LAST(LAST);

-- Expect SYNTAX error
prepare s1 from SELECT LEVEL LEVEL from (values(0)) LEVEL(LEVEL);

-- Expect SYNTAX error
prepare s1 from SELECT LOCAL LOCAL from (values(0)) LOCAL(LOCAL);

-- Expect SYNTAX error
prepare s1 from SELECT MATCH MATCH from (values(0)) MATCH(MATCH);

-- Expect SYNTAX error
prepare s1 from SELECT MODULE MODULE from (values(0)) MODULE(MODULE);

-- Expect SYNTAX error
prepare s1 from SELECT NAMES NAMES from (values(0)) NAMES(NAMES);

-- Expect SYNTAX error
prepare s1 from SELECT NATURAL NATURAL from (values(0)) NATURAL(NATURAL);

-- Expect SYNTAX error
prepare s1 from SELECT NO NO from (values(0)) NO(NO);

-- Expect SYNTAX error
prepare s1 from SELECT NULLIF NULLIF from (values(0)) NULLIF(NULLIF);

-- Expect SYNTAX error
prepare s1 from SELECT OFF OFF from (values(0)) OFF(OFF);

-- Expect SYNTAX error
prepare s1 from SELECT ONLY ONLY from (values(0)) ONLY(ONLY);

-- Expect SYNTAX error
prepare s1 from SELECT OUTER OUTER from (values(0)) OUTER(OUTER);

-- Expect SYNTAX error
prepare s1 from SELECT OUTPUT OUTPUT from (values(0)) OUTPUT(OUTPUT);

-- Expect SYNTAX error
prepare s1 from SELECT OVERLAPS OVERLAPS from (values(0)) OVERLAPS(OVERLAPS);

-- Expect SYNTAX error
prepare s1 from SELECT PARTIAL PARTIAL from (values(0)) PARTIAL(PARTIAL);

-- Expect SYNTAX error
prepare s1 from SELECT PREPARE PREPARE from (values(0)) PREPARE(PREPARE);

-- Expect SYNTAX error
prepare s1 from SELECT PRIMARY PRIMARY from (values(0)) PRIMARY(PRIMARY);

-- Expect SYNTAX error
prepare s1 from SELECT PRIVILEGES PRIVILEGES from (values(0)) PRIVILEGES(PRIVILEGES);

-- Expect SYNTAX error
prepare s1 from SELECT PROCEDURE PROCEDURE from (values(0)) PROCEDURE(PROCEDURE);

-- Expect SYNTAX error
prepare s1 from SELECT PROTOTYPE PROTOTYPE from (values(0)) PROTOTYPE(PROTOTYPE);

-- Expect SYNTAX error
prepare s1 from SELECT PUBLIC PUBLIC from (values(0)) PUBLIC(PUBLIC);

-- Expect SYNTAX error
prepare s1 from SELECT READ READ from (values(0)) READ(READ);

-- Expect SYNTAX error
prepare s1 from SELECT REFERENCES REFERENCES from (values(0)) REFERENCES(REFERENCES);

-- Expect SYNTAX error
prepare s1 from SELECT REPLACE REPLACE from (values(0)) REPLACE(REPLACE);

-- Expect SYNTAX error
prepare s1 from SELECT RESTRICT RESTRICT from (values(0)) RESTRICT(RESTRICT);

-- Expect SYNTAX error
prepare s1 from SELECT RETURN RETURN from (values(0)) RETURN(RETURN);

-- Expect SYNTAX error
prepare s1 from SELECT REVOKE REVOKE from (values(0)) REVOKE(REVOKE);

-- Expect SYNTAX error
prepare s1 from SELECT ROWS ROWS from (values(0)) ROWS(ROWS);

-- Expect SYNTAX error
prepare s1 from SELECT SCHEMA SCHEMA from (values(0)) SCHEMA(SCHEMA);

-- Expect SYNTAX error
prepare s1 from SELECT SECTION SECTION from (values(0)) SECTION(SECTION);

-- Expect SYNTAX error
prepare s1 from SELECT SESSION SESSION from (values(0)) SESSION(SESSION);

-- Expect SYNTAX error
prepare s1 from SELECT SESSION_USER SESSION_USER from (values(0)) SESSION_USER(SESSION_USER);

-- Expect SYNTAX error
prepare s1 from SELECT SIZE SIZE from (values(0)) SIZE(SIZE);

-- Expect SYNTAX error
prepare s1 from SELECT SPACE SPACE from (values(0)) SPACE(SPACE);

-- Expect SYNTAX error
prepare s1 from SELECT SQL SQL from (values(0)) SQL(SQL);

-- Expect SYNTAX error
prepare s1 from SELECT SQLCODE SQLCODE from (values(0)) SQLCODE(SQLCODE);

-- Expect SYNTAX error
prepare s1 from SELECT SQLERROR SQLERROR from (values(0)) SQLERROR(SQLERROR);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_CHAR SQL_CHAR from (values(0)) SQL_CHAR(SQL_CHAR);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_DATE SQL_DATE from (values(0)) SQL_DATE(SQL_DATE);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_DECIMAL SQL_DECIMAL from (values(0)) SQL_DECIMAL(SQL_DECIMAL);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_DOUBLE SQL_DOUBLE from (values(0)) SQL_DOUBLE(SQL_DOUBLE);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_INT SQL_INT from (values(0)) SQL_INT(SQL_INT);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_INTEGER SQL_INTEGER from (values(0)) SQL_INTEGER(SQL_INTEGER);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_SMALLINT SQL_SMALLINT from (values(0)) SQL_SMALLINT(SQL_SMALLINT);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_TIME SQL_TIME from (values(0)) SQL_TIME(SQL_TIME);

-- Expect SYNTAX error
prepare s1 from SELECT SQL_TIMESTAMP SQL_TIMESTAMP from (values(0)) SQL_TIMESTAMP(SQL_TIMESTAMP);

-- Expect SYNTAX error
prepare s1 from SELECT TRANSACTION TRANSACTION from (values(0)) TRANSACTION(TRANSACTION);

-- Expect SYNTAX error
prepare s1 from SELECT TRANSLATE TRANSLATE from (values(0)) TRANSLATE(TRANSLATE);

-- Expect SYNTAX error
prepare s1 from SELECT TRANSPOSE TRANSPOSE from (values(0)) TRANSPOSE(TRANSPOSE);

-- Expect SYNTAX error
prepare s1 from SELECT TRUE TRUE from (values(0)) TRUE(TRUE);

-- Expect SYNTAX error
prepare s1 from SELECT UNKNOWN UNKNOWN from (values(0)) UNKNOWN(UNKNOWN);

-- Expect SYNTAX error
prepare s1 from SELECT USER USER from (values(0)) USER(USER);

-- Expect SYNTAX error
prepare s1 from SELECT USING USING from (values(0)) USING(USING);

-- Expect SYNTAX error
prepare s1 from SELECT VALUE VALUE from (values(0)) VALUE(VALUE);

-- Expect SYNTAX error
prepare s1 from SELECT WHENEVER WHENEVER from (values(0)) WHENEVER(WHENEVER);

-- Expect SYNTAX error
prepare s1 from SELECT WITHOUT WITHOUT from (values(0)) WITHOUT(WITHOUT);

-- Expect SYNTAX error
prepare s1 from SELECT WRITE WRITE from (values(0)) WRITE(WRITE);

-- Expect SYNTAX error
prepare s1 from SELECT ALL ALL from (values(0)) ALL(ALL);

-- Expect SYNTAX error
prepare s1 from SELECT AND AND from (values(0)) AND(AND);

-- Expect SYNTAX error
prepare s1 from SELECT ANY ANY from (values(0)) ANY(ANY);

-- Expect SYNTAX error
prepare s1 from SELECT AS AS from (values(0)) AS(AS);

-- Expect SYNTAX error
prepare s1 from SELECT ASC ASC from (values(0)) ASC(ASC);

-- Expect SYNTAX error
prepare s1 from SELECT AVG AVG from (values(0)) AVG(AVG);

-- Expect SYNTAX error
prepare s1 from SELECT BEGIN BEGIN from (values(0)) BEGIN(BEGIN);

-- Expect SYNTAX error
prepare s1 from SELECT BETWEEN BETWEEN from (values(0)) BETWEEN(BETWEEN);

-- Expect SYNTAX error
prepare s1 from SELECT BOTH BOTH from (values(0)) BOTH(BOTH);

-- Expect SYNTAX error
prepare s1 from SELECT BY BY from (values(0)) BY(BY);

-- Expect SYNTAX error
prepare s1 from SELECT CASE CASE from (values(0)) CASE(CASE);

-- Expect SYNTAX error
prepare s1 from SELECT CATALOG CATALOG from (values(0)) CATALOG(CATALOG);

-- Expect SYNTAX error
prepare s1 from SELECT CHAR CHAR from (values(0)) CHAR(CHAR);

-- Expect SYNTAX error
prepare s1 from SELECT CHARACTER CHARACTER from (values(0)) CHARACTER(CHARACTER);

-- Expect SYNTAX error
prepare s1 from SELECT CHECK CHECK from (values(0)) CHECK(CHECK);

-- Expect SYNTAX error
prepare s1 from SELECT CLOSE CLOSE from (values(0)) CLOSE(CLOSE);

-- Expect SYNTAX error
prepare s1 from SELECT COMMIT COMMIT from (values(0)) COMMIT(COMMIT);

-- Expect SYNTAX error
prepare s1 from SELECT COUNT COUNT from (values(0)) COUNT(COUNT);

-- Expect SYNTAX error
prepare s1 from SELECT CURRENT CURRENT from (values(0)) CURRENT(CURRENT);

-- Expect SYNTAX error
prepare s1 from SELECT CURRENT_DATE CURRENT_DATE from (values(0)) CURRENT_DATE(CURRENT_DATE);

-- Expect SYNTAX error
prepare s1 from SELECT CURRENT_TIME CURRENT_TIME from (values(0)) CURRENT_TIME(CURRENT_TIME);

-- Expect SYNTAX error
prepare s1 from SELECT CURRENT_TIMESTAMP CURRENT_TIMESTAMP from (values(0)) CURRENT_TIMESTAMP(CURRENT_TIMESTAMP);

-- Expect SYNTAX error
prepare s1 from SELECT CURRENT_USER CURRENT_USER from (values(0)) CURRENT_USER(CURRENT_USER);

-- Expect SYNTAX error
prepare s1 from SELECT CURSOR CURSOR from (values(0)) CURSOR(CURSOR);

-- Expect SYNTAX error
prepare s1 from SELECT DATETIME DATETIME from (values(0)) DATETIME(DATETIME);

-- Expect SYNTAX error
prepare s1 from SELECT DEC DEC from (values(0)) DEC(DEC);

-- Expect SYNTAX error
prepare s1 from SELECT DECIMAL DECIMAL from (values(0)) DECIMAL(DECIMAL);

-- Expect SYNTAX error
prepare s1 from SELECT DECLARE DECLARE from (values(0)) DECLARE(DECLARE);

-- Expect SYNTAX error
prepare s1 from SELECT DELETE DELETE from (values(0)) DELETE(DELETE);

-- Expect SYNTAX error
prepare s1 from SELECT DESC DESC from (values(0)) DESC(DESC);

-- Expect SYNTAX error
prepare s1 from SELECT DISTINCT DISTINCT from (values(0)) DISTINCT(DISTINCT);

-- Expect SYNTAX error
prepare s1 from SELECT ESCAPE ESCAPE from (values(0)) ESCAPE(ESCAPE);

-- Expect SYNTAX error
prepare s1 from SELECT EXISTS EXISTS from (values(0)) EXISTS(EXISTS);

-- Expect SYNTAX error
prepare s1 from SELECT FETCH FETCH from (values(0)) FETCH(FETCH);

-- Expect SYNTAX error
prepare s1 from SELECT FOR FOR from (values(0)) FOR(FOR);

-- Expect SYNTAX error
prepare s1 from SELECT FRACTION FRACTION from (values(0)) FRACTION(FRACTION);

-- Expect SYNTAX error
prepare s1 from SELECT FROM FROM from (values(0)) FROM(FROM);

-- Expect SYNTAX error
prepare s1 from SELECT GROUP GROUP from (values(0)) GROUP(GROUP);

-- Expect SYNTAX error
prepare s1 from SELECT HAVING HAVING from (values(0)) HAVING(HAVING);

-- Expect SYNTAX error
prepare s1 from SELECT IN IN from (values(0)) IN(IN);

-- Expect SYNTAX error
prepare s1 from SELECT INNER INNER from (values(0)) INNER(INNER);

-- Expect SYNTAX error
prepare s1 from SELECT INPUT INPUT from (values(0)) INPUT(INPUT);

-- Expect SYNTAX error
prepare s1 from SELECT INSERT INSERT from (values(0)) INSERT(INSERT);

-- Expect SYNTAX error
prepare s1 from SELECT INT INT from (values(0)) INT(INT);

-- Expect SYNTAX error
prepare s1 from SELECT INTEGER INTEGER from (values(0)) INTEGER(INTEGER);

-- Expect SYNTAX error
prepare s1 from SELECT INTO INTO from (values(0)) INTO(INTO);

-- Expect SYNTAX error
prepare s1 from SELECT IS IS from (values(0)) IS(IS);

-- Expect SYNTAX error
prepare s1 from SELECT JOIN JOIN from (values(0)) JOIN(JOIN);

-- Expect SYNTAX error
prepare s1 from SELECT KEY KEY from (values(0)) KEY(KEY);

-- Expect SYNTAX error
prepare s1 from SELECT LEADING LEADING from (values(0)) LEADING(LEADING);

-- Expect SYNTAX error
prepare s1 from SELECT LEFT LEFT from (values(0)) LEFT(LEFT);

-- Expect SYNTAX error
prepare s1 from SELECT LIKE LIKE from (values(0)) LIKE(LIKE);

-- Expect SYNTAX error
prepare s1 from SELECT MAX MAX from (values(0)) MAX(MAX);

-- Expect SYNTAX error
prepare s1 from SELECT NOT NOT from (values(0)) NOT(NOT);

-- Expect SYNTAX error
prepare s1 from SELECT NULL NULL from (values(0)) NULL(NULL);

-- Expect SYNTAX error
prepare s1 from SELECT NUMERIC NUMERIC from (values(0)) NUMERIC(NUMERIC);

-- Expect SYNTAX error
prepare s1 from SELECT OF OF from (values(0)) OF(OF);

-- Expect SYNTAX error
prepare s1 from SELECT ON ON from (values(0)) ON(ON);

-- Expect SYNTAX error
prepare s1 from SELECT OPEN OPEN from (values(0)) OPEN(OPEN);

-- Expect SYNTAX error
prepare s1 from SELECT OPTION OPTION from (values(0)) OPTION(OPTION);

-- Expect SYNTAX error
prepare s1 from SELECT OR OR from (values(0)) OR(OR);

-- Expect SYNTAX error
prepare s1 from SELECT ORDER ORDER from (values(0)) ORDER(ORDER);

-- Expect SYNTAX error
prepare s1 from SELECT ROLLBACK ROLLBACK from (values(0)) ROLLBACK(ROLLBACK);

-- Expect SYNTAX error
prepare s1 from SELECT SELECT SELECT from (values(0)) SELECT(SELECT);

-- Expect SYNTAX error
prepare s1 from SELECT SET SET from (values(0)) SET(SET);

-- Expect SYNTAX error
prepare s1 from SELECT SMALLINT SMALLINT from (values(0)) SMALLINT(SMALLINT);

-- Expect SYNTAX error
prepare s1 from SELECT SOME SOME from (values(0)) SOME(SOME);

-- Expect SYNTAX error
prepare s1 from SELECT SUM SUM from (values(0)) SUM(SUM);

-- Expect SYNTAX error
prepare s1 from SELECT TABLE TABLE from (values(0)) TABLE(TABLE);

-- Expect SYNTAX error
prepare s1 from SELECT TO TO from (values(0)) TO(TO);

-- Expect SYNTAX error
prepare s1 from SELECT TRAILING TRAILING from (values(0)) TRAILING(TRAILING);

-- Expect SYNTAX error
prepare s1 from SELECT UNIQUE UNIQUE from (values(0)) UNIQUE(UNIQUE);

-- Expect SYNTAX error
prepare s1 from SELECT UPDATE UPDATE from (values(0)) UPDATE(UPDATE);

-- Expect SYNTAX error
prepare s1 from SELECT VALUES VALUES from (values(0)) VALUES(VALUES);

-- Expect SYNTAX error
prepare s1 from SELECT VIEW VIEW from (values(0)) VIEW(VIEW);

-- Expect SYNTAX error
prepare s1 from SELECT WHEN WHEN from (values(0)) WHEN(WHEN);

-- Expect SYNTAX error
prepare s1 from SELECT WHERE WHERE from (values(0)) WHERE(WHERE);

-- Expect SYNTAX error
prepare s1 from SELECT WITH WITH from (values(0)) WITH(WITH);

-- Expect SYNTAX error
prepare s1 from SELECT WORK WORK from (values(0)) WORK(WORK);

-- Expect success
prepare s1 from SELECT ABS ABS from (values(0)) ABS(ABS);

-- Expect success
prepare s1 from SELECT ACCESS ACCESS from (values(0)) ACCESS(ACCESS);

-- Expect success
prepare s1 from SELECT ACOS ACOS from (values(0)) ACOS(ACOS);

-- Expect success
prepare s1 from SELECT ANSIVARCHAR ANSIVARCHAR from (values(0)) ANSIVARCHAR(ANSIVARCHAR);

-- Expect success
prepare s1 from SELECT ASCENDING ASCENDING from (values(0)) ASCENDING(ASCENDING);

-- Expect success
prepare s1 from SELECT ASCII ASCII from (values(0)) ASCII(ASCII);

-- Expect success
prepare s1 from SELECT ASIN ASIN from (values(0)) ASIN(ASIN);

-- Expect success
prepare s1 from SELECT ATAN ATAN from (values(0)) ATAN(ATAN);

-- Expect success
prepare s1 from SELECT ATAN2 ATAN2 from (values(0)) ATAN2(ATAN2);

-- Expect success
prepare s1 from SELECT ATOMIC ATOMIC from (values(0)) ATOMIC(ATOMIC);

-- Expect success
prepare s1 from SELECT ATTRIBUTE ATTRIBUTE from (values(0)) ATTRIBUTE(ATTRIBUTE);

-- Expect success
prepare s1 from SELECT ATTRIBUTES ATTRIBUTES from (values(0)) ATTRIBUTES(ATTRIBUTES);

-- Expect success
prepare s1 from SELECT AUDIT AUDIT from (values(0)) AUDIT(AUDIT);

-- Expect success
prepare s1 from SELECT AUDITCOMPRESS AUDITCOMPRESS from (values(0)) AUDITCOMPRESS(AUDITCOMPRESS);

-- Expect success
prepare s1 from SELECT AUTOCOMMIT AUTOCOMMIT from (values(0)) AUTOCOMMIT(AUTOCOMMIT);

-- Expect success
prepare s1 from SELECT AVERAGE_STREAM_WAIT AVERAGE_STREAM_WAIT from (values(0)) AVERAGE_STREAM_WAIT(AVERAGE_STREAM_WAIT);

-- Expect success
prepare s1 from SELECT BALANCE BALANCE from (values(0)) BALANCE(BALANCE);

-- Expect success
prepare s1 from SELECT BIGINT BIGINT from (values(0)) BIGINT(BIGINT);

-- Expect success
prepare s1 from SELECT BLOCKS BLOCKS from (values(0)) BLOCKS(BLOCKS);

-- Expect success
prepare s1 from SELECT BLOCKSIZE BLOCKSIZE from (values(0)) BLOCKSIZE(BLOCKSIZE);

-- Expect success
prepare s1 from SELECT BROWSE BROWSE from (values(0)) BROWSE(BROWSE);

-- Expect success
prepare s1 from SELECT BUFFERED BUFFERED from (values(0)) BUFFERED(BUFFERED);

-- Expect success
prepare s1 from SELECT BYTE BYTE from (values(0)) BYTE(BYTE);

-- Expect success
prepare s1 from SELECT BYTEINT BYTEINT from (values(0)) BYTEINT(BYTEINT);

-- Expect success
prepare s1 from SELECT BYTES BYTES from (values(0)) BYTES(BYTES);

-- Expect success
prepare s1 from SELECT CASESPECIFIC CASESPECIFIC from (values(0)) CASESPECIFIC(CASESPECIFIC);

-- Expect success
prepare s1 from SELECT CATALOG_NAME CATALOG_NAME from (values(0)) CATALOG_NAME(CATALOG_NAME);

-- Expect success
prepare s1 from SELECT CEILING CEILING from (values(0)) CEILING(CEILING);

-- Expect success
prepare s1 from SELECT CHARACTER_SET_CATALOG CHARACTER_SET_CATALOG from (values(0)) CHARACTER_SET_CATALOG(CHARACTER_SET_CATALOG);

-- Expect success
prepare s1 from SELECT CHARACTER_SET_NAME CHARACTER_SET_NAME from (values(0)) CHARACTER_SET_NAME(CHARACTER_SET_NAME);

-- Expect success
prepare s1 from SELECT CHARACTER_SET_SCHEMA CHARACTER_SET_SCHEMA from (values(0)) CHARACTER_SET_SCHEMA(CHARACTER_SET_SCHEMA);

-- Expect success
prepare s1 from SELECT CHECKSUM CHECKSUM from (values(0)) CHECKSUM(CHECKSUM);

-- Expect success
prepare s1 from SELECT CLASS_ORIGIN CLASS_ORIGIN from (values(0)) CLASS_ORIGIN(CLASS_ORIGIN);

-- Expect success
prepare s1 from SELECT CLEAR CLEAR from (values(0)) CLEAR(CLEAR);

-- Expect success
prepare s1 from SELECT CLEARONPURGE CLEARONPURGE from (values(0)) CLEARONPURGE(CLEARONPURGE);

-- Expect success
prepare s1 from SELECT CLUSTERS CLUSTERS from (values(0)) CLUSTERS(CLUSTERS);

-- Expect success
prepare s1 from SELECT CMP CMP from (values(0)) CMP(CMP);

-- Expect success
prepare s1 from SELECT COLLATION_CATALOG COLLATION_CATALOG from (values(0)) COLLATION_CATALOG(COLLATION_CATALOG);

-- Expect success
prepare s1 from SELECT COLLATION_NAME COLLATION_NAME from (values(0)) COLLATION_NAME(COLLATION_NAME);

-- Expect success
prepare s1 from SELECT COLLATION_SCHEMA COLLATION_SCHEMA from (values(0)) COLLATION_SCHEMA(COLLATION_SCHEMA);

-- Expect success
prepare s1 from SELECT COLUMN_NAME COLUMN_NAME from (values(0)) COLUMN_NAME(COLUMN_NAME);

-- Expect success
prepare s1 from SELECT COLUMN_NUMBER COLUMN_NUMBER from (values(0)) COLUMN_NUMBER(COLUMN_NUMBER);

-- Expect success
prepare s1 from SELECT COMMAND_FUNCTION COMMAND_FUNCTION from (values(0)) COMMAND_FUNCTION(COMMAND_FUNCTION);

-- Expect success
prepare s1 from SELECT COMMITTED COMMITTED from (values(0)) COMMITTED(COMMITTED);

-- Expect success
prepare s1 from SELECT COMP COMP from (values(0)) COMP(COMP);

-- Expect success
prepare s1 from SELECT COMPRESS COMPRESS from (values(0)) COMPRESS(COMPRESS);

-- Expect success
prepare s1 from SELECT CONCAT CONCAT from (values(0)) CONCAT(CONCAT);

-- Expect success
prepare s1 from SELECT CONDITION_NUMBER CONDITION_NUMBER from (values(0)) CONDITION_NUMBER(CONDITION_NUMBER);

-- Expect success
prepare s1 from SELECT CONFIG CONFIG from (values(0)) CONFIG(CONFIG);

-- Expect success
prepare s1 from SELECT CONFLICT CONFLICT from (values(0)) CONFLICT(CONFLICT);

-- Expect success
prepare s1 from SELECT CONNECTION_NAME CONNECTION_NAME from (values(0)) CONNECTION_NAME(CONNECTION_NAME);

-- Expect success
prepare s1 from SELECT CONSTRAINT_CATALOG CONSTRAINT_CATALOG from (values(0)) CONSTRAINT_CATALOG(CONSTRAINT_CATALOG);

-- Expect success
prepare s1 from SELECT CONSTRAINT_NAME CONSTRAINT_NAME from (values(0)) CONSTRAINT_NAME(CONSTRAINT_NAME);

-- Expect success
prepare s1 from SELECT CONSTRAINT_SCHEMA CONSTRAINT_SCHEMA from (values(0)) CONSTRAINT_SCHEMA(CONSTRAINT_SCHEMA);

-- Expect success
prepare s1 from SELECT CONTROL CONTROL from (values(0)) CONTROL(CONTROL);

-- Expect success
prepare s1 from SELECT CONVERTFROMHEX CONVERTFROMHEX from (values(0)) CONVERTFROMHEX(CONVERTFROMHEX);

-- Expect success
prepare s1 from SELECT CONVERTTIMESTAMP CONVERTTIMESTAMP from (values(0)) CONVERTTIMESTAMP(CONVERTTIMESTAMP);

-- Expect success
prepare s1 from SELECT CONVERTTOHEX CONVERTTOHEX from (values(0)) CONVERTTOHEX(CONVERTTOHEX);

-- Expect success
prepare s1 from SELECT COS COS from (values(0)) COS(COS);

-- Expect success
prepare s1 from SELECT COSH COSH from (values(0)) COSH(COSH);

-- Expect success
prepare s1 from SELECT COST COST from (values(0)) COST(COST);

-- Expect success
prepare s1 from SELECT CURDATE CURDATE from (values(0)) CURDATE(CURDATE);

-- Expect success
prepare s1 from SELECT CURSOR_NAME CURSOR_NAME from (values(0)) CURSOR_NAME(CURSOR_NAME);

-- Expect success
prepare s1 from SELECT CURTIME CURTIME from (values(0)) CURTIME(CURTIME);

-- Expect success
prepare s1 from SELECT D D from (values(0)) D(D);

-- Expect success
prepare s1 from SELECT DATA DATA from (values(0)) DATA(DATA);

-- Expect success
prepare s1 from SELECT DATEFORMAT DATEFORMAT from (values(0)) DATEFORMAT(DATEFORMAT);

-- Expect success
prepare s1 from SELECT DATETIME_CODE DATETIME_CODE from (values(0)) DATETIME_CODE(DATETIME_CODE);

-- Expect success
prepare s1 from SELECT DAYNAME DAYNAME from (values(0)) DAYNAME(DAYNAME);

-- Expect success
prepare s1 from SELECT DAYOFMONTH DAYOFMONTH from (values(0)) DAYOFMONTH(DAYOFMONTH);

-- Expect success
prepare s1 from SELECT DAYOFWEEK DAYOFWEEK from (values(0)) DAYOFWEEK(DAYOFWEEK);

-- Expect success
prepare s1 from SELECT DAYOFYEAR DAYOFYEAR from (values(0)) DAYOFYEAR(DAYOFYEAR);

-- Expect success
prepare s1 from SELECT DCOMPRESS DCOMPRESS from (values(0)) DCOMPRESS(DCOMPRESS);

-- Expect success
prepare s1 from SELECT DEFAULTS DEFAULTS from (values(0)) DEFAULTS(DEFAULTS);

-- Expect success
prepare s1 from SELECT DEFINITION DEFINITION from (values(0)) DEFINITION(DEFINITION);

-- Expect success
prepare s1 from SELECT DEGREES DEGREES from (values(0)) DEGREES(DEGREES);

-- Expect success
prepare s1 from SELECT DESCENDING DESCENDING from (values(0)) DESCENDING(DESCENDING);

-- Expect success
prepare s1 from SELECT DETAIL DETAIL from (values(0)) DETAIL(DETAIL);

-- Expect success
prepare s1 from SELECT DIFF1 DIFF1 from (values(0)) DIFF1(DIFF1);

-- Expect success
prepare s1 from SELECT DIFF2 DIFF2 from (values(0)) DIFF2(DIFF2);

-- Expect success
prepare s1 from SELECT DISPLAY DISPLAY from (values(0)) DISPLAY(DISPLAY);

-- Expect success
prepare s1 from SELECT DO DO from (values(0)) DO(DO);

-- Expect success
prepare s1 from SELECT DROPPABLE DROPPABLE from (values(0)) DROPPABLE(DROPPABLE);

-- Expect success
prepare s1 from SELECT DSLACK DSLACK from (values(0)) DSLACK(DSLACK);

-- Expect success
prepare s1 from SELECT DUAL DUAL from (values(0)) DUAL(DUAL);

-- Expect success
prepare s1 from SELECT DYNAMIC_FUNCTION DYNAMIC_FUNCTION from (values(0)) DYNAMIC_FUNCTION(DYNAMIC_FUNCTION);

-- Expect success
prepare s1 from SELECT ENCODE_KEY ENCODE_KEY from (values(0)) ENCODE_KEY(ENCODE_KEY);

-- Expect success
prepare s1 from SELECT ENTRY ENTRY from (values(0)) ENTRY(ENTRY);

-- Expect success
prepare s1 from SELECT EUROPEAN EUROPEAN from (values(0)) EUROPEAN(EUROPEAN);

-- Expect success
prepare s1 from SELECT EVERY EVERY from (values(0)) EVERY(EVERY);

-- Expect success
prepare s1 from SELECT EXCLUSIVE EXCLUSIVE from (values(0)) EXCLUSIVE(EXCLUSIVE);

-- Expect success
prepare s1 from SELECT EXECUTION EXECUTION from (values(0)) EXECUTION(EXECUTION);

-- Expect success
prepare s1 from SELECT EXIT EXIT from (values(0)) EXIT(EXIT);

-- Expect success
prepare s1 from SELECT EXP EXP from (values(0)) EXP(EXP);

-- Expect success
prepare s1 from SELECT EXPLAIN EXPLAIN from (values(0)) EXPLAIN(EXPLAIN);

-- Expect success
prepare s1 from SELECT FALLBACK FALLBACK from (values(0)) FALLBACK(FALLBACK);

-- Expect success
prepare s1 from SELECT FIRSTDAYOFYEAR FIRSTDAYOFYEAR from (values(0)) FIRSTDAYOFYEAR(FIRSTDAYOFYEAR);

-- Expect success
prepare s1 from SELECT FIRST_FSCODE FIRST_FSCODE from (values(0)) FIRST_FSCODE(FIRST_FSCODE);

-- Expect success
prepare s1 from SELECT FLOOR FLOOR from (values(0)) FLOOR(FLOOR);

-- Expect success
prepare s1 from SELECT FN FN from (values(0)) FN(FN);

-- Expect success
prepare s1 from SELECT FORMAT FORMAT from (values(0)) FORMAT(FORMAT);

-- Expect success
prepare s1 from SELECT FREESPACE FREESPACE from (values(0)) FREESPACE(FREESPACE);

-- Expect success
prepare s1 from SELECT G G from (values(0)) G(G);

-- Expect success
prepare s1 from SELECT GENERATE GENERATE from (values(0)) GENERATE(GENERATE);

-- Expect success
prepare s1 from SELECT HASH HASH from (values(0)) HASH(HASH);

-- Expect success
prepare s1 from SELECT HASHPARTFUNC HASHPARTFUNC from (values(0)) HASHPARTFUNC(HASHPARTFUNC);

-- Expect success
prepare s1 from SELECT HEADING HEADING from (values(0)) HEADING(HEADING);

-- Expect success
prepare s1 from SELECT HEADINGS HEADINGS from (values(0)) HEADINGS(HEADINGS);

-- Expect success
prepare s1 from SELECT HIGH_VALUE HIGH_VALUE from (values(0)) HIGH_VALUE(HIGH_VALUE);

-- Expect success
prepare s1 from SELECT HOLD HOLD from (values(0)) HOLD(HOLD);

-- Expect success
prepare s1 from SELECT HORIZONTAL HORIZONTAL from (values(0)) HORIZONTAL(HORIZONTAL);

-- Expect success
prepare s1 from SELECT ICOMPRESS ICOMPRESS from (values(0)) ICOMPRESS(ICOMPRESS);

-- Expect success
prepare s1 from SELECT INCLUSIVE INCLUSIVE from (values(0)) INCLUSIVE(INCLUSIVE);

-- Expect success
prepare s1 from SELECT INDEX INDEX from (values(0)) INDEX(INDEX);

-- Expect success
prepare s1 from SELECT INDEX_TABLE INDEX_TABLE from (values(0)) INDEX_TABLE(INDEX_TABLE);

-- Expect success
prepare s1 from SELECT INDICATOR_DATA INDICATOR_DATA from (values(0)) INDICATOR_DATA(INDICATOR_DATA);

-- Expect success
prepare s1 from SELECT INDICATOR_POINTER INDICATOR_POINTER from (values(0)) INDICATOR_POINTER(INDICATOR_POINTER);

-- Expect success
prepare s1 from SELECT INDICATOR_TYPE INDICATOR_TYPE from (values(0)) INDICATOR_TYPE(INDICATOR_TYPE);

-- Expect success
prepare s1 from SELECT INITIALIZE INITIALIZE from (values(0)) INITIALIZE(INITIALIZE);

-- Expect success
prepare s1 from SELECT INTERVALS INTERVALS from (values(0)) INTERVALS(INTERVALS);

-- Expect success
prepare s1 from SELECT INVOKE INVOKE from (values(0)) INVOKE(INVOKE);

-- Expect success
prepare s1 from SELECT ISLACK ISLACK from (values(0)) ISLACK(ISLACK);

-- Expect success
prepare s1 from SELECT JOURNAL JOURNAL from (values(0)) JOURNAL(JOURNAL);

-- Expect success
prepare s1 from SELECT JULIANTIMESTAMP JULIANTIMESTAMP from (values(0)) JULIANTIMESTAMP(JULIANTIMESTAMP);

-- Expect success
prepare s1 from SELECT K K from (values(0)) K(K);

-- Expect success
prepare s1 from SELECT LARGEINT LARGEINT from (values(0)) LARGEINT(LARGEINT);

-- Expect success
prepare s1 from SELECT LASTNOTNULL LASTNOTNULL from (values(0)) LASTNOTNULL(LASTNOTNULL);

-- Expect success
prepare s1 from SELECT LAST_FSCODE LAST_FSCODE from (values(0)) LAST_FSCODE(LAST_FSCODE);

-- Expect success
prepare s1 from SELECT LAST_SYSKEY LAST_SYSKEY from (values(0)) LAST_SYSKEY(LAST_SYSKEY);

-- Expect success
prepare s1 from SELECT LCASE LCASE from (values(0)) LCASE(LCASE);

-- Expect success
prepare s1 from SELECT LEADING_PRECISION LEADING_PRECISION from (values(0)) LEADING_PRECISION(LEADING_PRECISION);

-- Expect success
prepare s1 from SELECT LENGTH LENGTH from (values(0)) LENGTH(LENGTH);

-- Expect success
prepare s1 from SELECT LINE_NUMBER LINE_NUMBER from (values(0)) LINE_NUMBER(LINE_NUMBER);

-- Expect success
prepare s1 from SELECT LOCATE LOCATE from (values(0)) LOCATE(LOCATE);

-- Expect success
prepare s1 from SELECT LOCATION LOCATION from (values(0)) LOCATION(LOCATION);

-- Expect success
prepare s1 from SELECT LOCK LOCK from (values(0)) LOCK(LOCK);

-- Expect success
prepare s1 from SELECT LOCKING LOCKING from (values(0)) LOCKING(LOCKING);

-- Expect success
prepare s1 from SELECT LOCKLENGTH LOCKLENGTH from (values(0)) LOCKLENGTH(LOCKLENGTH);

-- Expect success
prepare s1 from SELECT LOG LOG from (values(0)) LOG(LOG);

-- Expect success
prepare s1 from SELECT LOG10 LOG10 from (values(0)) LOG10(LOG10);

-- Expect success
prepare s1 from SELECT LONG LONG from (values(0)) LONG(LONG);

-- Expect success
prepare s1 from SELECT LOW_VALUE LOW_VALUE from (values(0)) LOW_VALUE(LOW_VALUE);

-- Expect success
prepare s1 from SELECT LPAD LPAD from (values(0)) LPAD(LPAD);

-- Expect success
prepare s1 from SELECT LSDEC LSDEC from (values(0)) LSDEC(LSDEC);

-- Expect success
prepare s1 from SELECT LSDECIMAL LSDECIMAL from (values(0)) LSDECIMAL(LSDECIMAL);

-- Expect success
prepare s1 from SELECT LTRIM LTRIM from (values(0)) LTRIM(LTRIM);

-- Expect success
prepare s1 from SELECT M M from (values(0)) M(M);

-- Expect success
prepare s1 from SELECT MAXSIZE MAXSIZE from (values(0)) MAXSIZE(MAXSIZE);

-- Expect success
prepare s1 from SELECT MESSAGE_LENGTH MESSAGE_LENGTH from (values(0)) MESSAGE_LENGTH(MESSAGE_LENGTH);

-- Expect success
prepare s1 from SELECT MESSAGE_OCTET_LENGTH MESSAGE_OCTET_LENGTH from (values(0)) MESSAGE_OCTET_LENGTH(MESSAGE_OCTET_LENGTH);

-- Expect success
prepare s1 from SELECT MESSAGE_TEXT MESSAGE_TEXT from (values(0)) MESSAGE_TEXT(MESSAGE_TEXT);

-- Expect success
prepare s1 from SELECT MOD MOD from (values(0)) MOD(MOD);

-- Expect success
prepare s1 from SELECT MODE MODE from (values(0)) MODE(MODE);

-- Expect success
prepare s1 from SELECT MONTHNAME MONTHNAME from (values(0)) MONTHNAME(MONTHNAME);

-- Expect success
prepare s1 from SELECT MORE MORE from (values(0)) MORE(MORE);

-- Expect success
prepare s1 from SELECT MOVE MOVE from (values(0)) MOVE(MOVE);

-- Expect success
prepare s1 from SELECT MOVEMENT MOVEMENT from (values(0)) MOVEMENT(MOVEMENT);

-- Expect success
prepare s1 from SELECT MOVINGAVG MOVINGAVG from (values(0)) MOVINGAVG(MOVINGAVG);

-- Expect success
prepare s1 from SELECT MOVINGCOUNT MOVINGCOUNT from (values(0)) MOVINGCOUNT(MOVINGCOUNT);

-- Expect success
prepare s1 from SELECT MOVINGMAX MOVINGMAX from (values(0)) MOVINGMAX(MOVINGMAX);

-- Expect success
prepare s1 from SELECT MOVINGMIN MOVINGMIN from (values(0)) MOVINGMIN(MOVINGMIN);

-- Expect success
prepare s1 from SELECT MOVINGSTDDEV MOVINGSTDDEV from (values(0)) MOVINGSTDDEV(MOVINGSTDDEV);

-- Expect success
prepare s1 from SELECT MOVINGSUM MOVINGSUM from (values(0)) MOVINGSUM(MOVINGSUM);

-- Expect success
prepare s1 from SELECT MOVINGVARIANCE MOVINGVARIANCE from (values(0)) MOVINGVARIANCE(MOVINGVARIANCE);

-- Expect success
prepare s1 from SELECT MPLOC MPLOC from (values(0)) MPLOC(MPLOC);

-- Expect success
prepare s1 from SELECT MULTISET MULTISET from (values(0)) MULTISET(MULTISET);

-- Expect success
prepare s1 from SELECT NAME NAME from (values(0)) NAME(NAME);

-- Expect success
prepare s1 from SELECT NAMETYPE NAMETYPE from (values(0)) NAMETYPE(NAMETYPE);

-- Expect success
prepare s1 from SELECT NATIVE NATIVE from (values(0)) NATIVE(NATIVE);

-- Expect success
prepare s1 from SELECT NOW NOW from (values(0)) NOW(NOW);

-- Expect success
prepare s1 from SELECT NULLABLE NULLABLE from (values(0)) NULLABLE(NULLABLE);

-- Expect success
prepare s1 from SELECT NUMBER NUMBER from (values(0)) NUMBER(NUMBER);

-- Expect success
prepare s1 from SELECT OFFSET OFFSET from (values(0)) OFFSET(OFFSET);

-- Expect success
prepare s1 from SELECT OJ OJ from (values(0)) OJ(OJ);

-- Expect success
prepare s1 from SELECT OS_USERID OS_USERID from (values(0)) OS_USERID(OS_USERID);

-- Expect success
prepare s1 from SELECT PARALLEL PARALLEL from (values(0)) PARALLEL(PARALLEL);

-- Expect success
prepare s1 from SELECT PARTITION PARTITION from (values(0)) PARTITION(PARTITION);

-- Expect success
prepare s1 from SELECT PARTITIONS PARTITIONS from (values(0)) PARTITIONS(PARTITIONS);

-- Expect success
prepare s1 from SELECT PERCENT PERCENT from (values(0)) PERCENT(PERCENT);

-- Expect success
prepare s1 from SELECT PERFORM PERFORM from (values(0)) PERFORM(PERFORM);

-- Expect success
prepare s1 from SELECT PERIODIC PERIODIC from (values(0)) PERIODIC(PERIODIC);

-- Expect success
prepare s1 from SELECT PI PI from (values(0)) PI(PI);

-- Expect success
prepare s1 from SELECT PIC PIC from (values(0)) PIC(PIC);

-- Expect success
prepare s1 from SELECT PICTURE PICTURE from (values(0)) PICTURE(PICTURE);

-- Expect success
prepare s1 from SELECT POPULATE POPULATE from (values(0)) POPULATE(POPULATE);

-- Expect success
prepare s1 from SELECT POWER POWER from (values(0)) POWER(POWER);

-- Expect success
prepare s1 from SELECT PROMPT PROMPT from (values(0)) PROMPT(PROMPT);

-- Expect success
prepare s1 from SELECT PROTECTION PROTECTION from (values(0)) PROTECTION(PROTECTION);

-- Expect success
prepare s1 from SELECT QUARTER QUARTER from (values(0)) QUARTER(QUARTER);

-- Expect success
prepare s1 from SELECT QUERY QUERY from (values(0)) QUERY(QUERY);

-- Expect success
prepare s1 from SELECT RADIANS RADIANS from (values(0)) RADIANS(RADIANS);

-- Expect success
prepare s1 from SELECT RAND RAND from (values(0)) RAND(RAND);

-- Expect success
prepare s1 from SELECT RANDOM RANDOM from (values(0)) RANDOM(RANDOM);

-- Expect success
prepare s1 from SELECT RANGE RANGE from (values(0)) RANGE(RANGE);

-- Expect success
prepare s1 from SELECT RANGE_N RANGE_N from (values(0)) RANGE_N(RANGE_N);

-- Expect success
prepare s1 from SELECT REINITIALIZE REINITIALIZE from (values(0)) REINITIALIZE(REINITIALIZE);

-- Expect success
prepare s1 from SELECT RENAME RENAME from (values(0)) RENAME(RENAME);

-- Expect success
prepare s1 from SELECT REPEAT REPEAT from (values(0)) REPEAT(REPEAT);

-- Expect success
prepare s1 from SELECT REPEATABLE REPEATABLE from (values(0)) REPEATABLE(REPEATABLE);

-- Expect success
prepare s1 from SELECT RESET RESET from (values(0)) RESET(RESET);

-- Expect success
prepare s1 from SELECT RESOURCE_FORK RESOURCE_FORK from (values(0)) RESOURCE_FORK(RESOURCE_FORK);

-- Expect success
prepare s1 from SELECT RETURNED_LENGTH RETURNED_LENGTH from (values(0)) RETURNED_LENGTH(RETURNED_LENGTH);

-- Expect success
prepare s1 from SELECT RETURNED_OCTET_LENGTH RETURNED_OCTET_LENGTH from (values(0)) RETURNED_OCTET_LENGTH(RETURNED_OCTET_LENGTH);

-- Expect success
prepare s1 from SELECT RETURNED_SQLSTATE RETURNED_SQLSTATE from (values(0)) RETURNED_SQLSTATE(RETURNED_SQLSTATE);

-- Expect success
prepare s1 from SELECT ROLE ROLE from (values(0)) ROLE(ROLE);

-- Expect success
prepare s1 from SELECT ROUND ROUND from (values(0)) ROUND(ROUND);

-- Expect success
prepare s1 from SELECT ROUNDROBINPARTFUNC ROUNDROBINPARTFUNC from (values(0)) ROUNDROBINPARTFUNC(ROUNDROBINPARTFUNC);

-- Expect success
prepare s1 from SELECT ROWSET ROWSET from (values(0)) ROWSET(ROWSET);

-- Expect success
prepare s1 from SELECT ROW_COUNT ROW_COUNT from (values(0)) ROW_COUNT(ROW_COUNT);

-- Expect success
prepare s1 from SELECT ROW_NUMBER ROW_NUMBER from (values(0)) ROW_NUMBER(ROW_NUMBER);

-- Expect success
prepare s1 from SELECT RPAD RPAD from (values(0)) RPAD(RPAD);

-- Expect success
prepare s1 from SELECT RTRIM RTRIM from (values(0)) RTRIM(RTRIM);

-- Expect success
prepare s1 from SELECT RUNNINGAVG RUNNINGAVG from (values(0)) RUNNINGAVG(RUNNINGAVG);

-- Expect success
prepare s1 from SELECT RUNNINGCOUNT RUNNINGCOUNT from (values(0)) RUNNINGCOUNT(RUNNINGCOUNT);

-- Expect success
prepare s1 from SELECT RUNNINGMAX RUNNINGMAX from (values(0)) RUNNINGMAX(RUNNINGMAX);

-- Expect success
prepare s1 from SELECT RUNNINGMIN RUNNINGMIN from (values(0)) RUNNINGMIN(RUNNINGMIN);

-- Expect success
prepare s1 from SELECT RUNNINGSTDDEV RUNNINGSTDDEV from (values(0)) RUNNINGSTDDEV(RUNNINGSTDDEV);

-- Expect success
prepare s1 from SELECT RUNNINGSUM RUNNINGSUM from (values(0)) RUNNINGSUM(RUNNINGSUM);

-- Expect success
prepare s1 from SELECT RUNNINGVARIANCE RUNNINGVARIANCE from (values(0)) RUNNINGVARIANCE(RUNNINGVARIANCE);

-- Expect success
prepare s1 from SELECT SAMPLE SAMPLE from (values(0)) SAMPLE(SAMPLE);

-- Expect success
prepare s1 from SELECT SCALE SCALE from (values(0)) SCALE(SCALE);

-- Expect success
prepare s1 from SELECT SCHEMA_NAME SCHEMA_NAME from (values(0)) SCHEMA_NAME(SCHEMA_NAME);

-- Expect success
prepare s1 from SELECT SEPARATE SEPARATE from (values(0)) SEPARATE(SEPARATE);

-- Expect success
prepare s1 from SELECT SEQUENCE SEQUENCE from (values(0)) SEQUENCE(SEQUENCE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE SERIALIZABLE from (values(0)) SERIALIZABLE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALWRITES SERIALWRITES from (values(0)) SERIALWRITES(SERIALWRITES);

-- Expect success
prepare s1 from SELECT SERVER_NAME SERVER_NAME from (values(0)) SERVER_NAME(SERVER_NAME);

-- Expect success
prepare s1 from SELECT SHAPE SHAPE from (values(0)) SHAPE(SHAPE);

-- Expect success
prepare s1 from SELECT SHARE SHARE from (values(0)) SHARE(SHARE);

-- Expect success
prepare s1 from SELECT SHOWCONTROL SHOWCONTROL from (values(0)) SHOWCONTROL(SHOWCONTROL);

-- Expect success
prepare s1 from SELECT SHOWDDL SHOWDDL from (values(0)) SHOWDDL(SHOWDDL);

-- Expect success
prepare s1 from SELECT SHOWLABEL SHOWLABEL from (values(0)) SHOWLABEL(SHOWLABEL);

-- Expect success
prepare s1 from SELECT SHOWLEAKS SHOWLEAKS from (values(0)) SHOWLEAKS(SHOWLEAKS);

-- Expect success
prepare s1 from SELECT SHOWPLAN SHOWPLAN from (values(0)) SHOWPLAN(SHOWPLAN);

-- Expect success
prepare s1 from SELECT SHOWSHAPE SHOWSHAPE from (values(0)) SHOWSHAPE(SHOWSHAPE);

-- Expect success
prepare s1 from SELECT SIDEINSERTS SIDEINSERTS from (values(0)) SIDEINSERTS(SIDEINSERTS);

-- Expect success
prepare s1 from SELECT SIGN SIGN from (values(0)) SIGN(SIGN);

-- Expect success
prepare s1 from SELECT SIGNED SIGNED from (values(0)) SIGNED(SIGNED);

-- Expect success
prepare s1 from SELECT SIN SIN from (values(0)) SIN(SIN);

-- Expect success
prepare s1 from SELECT SINCE SINCE from (values(0)) SINCE(SINCE);

-- Expect success
prepare s1 from SELECT SINH SINH from (values(0)) SINH(SINH);

-- Expect success
prepare s1 from SELECT SKIP SKIP from (values(0)) SKIP(SKIP);

-- Expect success
prepare s1 from SELECT SORT SORT from (values(0)) SORT(SORT);

-- Expect success
prepare s1 from SELECT SOURCE_FILE SOURCE_FILE from (values(0)) SOURCE_FILE(SOURCE_FILE);

-- Expect success
prepare s1 from SELECT SQLMP SQLMP from (values(0)) SQLMP(SQLMP);

-- Expect success
prepare s1 from SELECT SQL_BIGINT SQL_BIGINT from (values(0)) SQL_BIGINT(SQL_BIGINT);

-- Expect success
prepare s1 from SELECT SQL_WARNING SQL_WARNING from (values(0)) SQL_WARNING(SQL_WARNING);

-- Expect success
prepare s1 from SELECT SQRT SQRT from (values(0)) SQRT(SQRT);

-- Expect success
prepare s1 from SELECT STABLE STABLE from (values(0)) STABLE(STABLE);

-- Expect success
prepare s1 from SELECT STATEMENT STATEMENT from (values(0)) STATEMENT(STATEMENT);

-- Expect success
prepare s1 from SELECT STATIC STATIC from (values(0)) STATIC(STATIC);

-- Expect success
prepare s1 from SELECT STATISTICS STATISTICS from (values(0)) STATISTICS(STATISTICS);

-- Expect success
prepare s1 from SELECT STDDEV STDDEV from (values(0)) STDDEV(STDDEV);

-- Expect success
prepare s1 from SELECT STORE STORE from (values(0)) STORE(STORE);

-- Expect success
prepare s1 from SELECT STREAM STREAM from (values(0)) STREAM(STREAM);

-- Expect success
prepare s1 from SELECT SUBCLASS_ORIGIN SUBCLASS_ORIGIN from (values(0)) SUBCLASS_ORIGIN(SUBCLASS_ORIGIN);

-- Expect success
prepare s1 from SELECT SUBSYSTEM_ID SUBSYSTEM_ID from (values(0)) SUBSYSTEM_ID(SUBSYSTEM_ID);

-- Expect success
prepare s1 from SELECT SYS_GUID SYS_GUID from (values(0)) SYS_GUID (SYS_GUID);

-- Expect success
prepare s1 from SELECT T T from (values(0)) T(T);

-- Expect success
prepare s1 from SELECT TABLE_NAME TABLE_NAME from (values(0)) TABLE_NAME(TABLE_NAME);

-- Expect success
prepare s1 from SELECT TAN TAN from (values(0)) TAN(TAN);

-- Expect success
prepare s1 from SELECT TANH TANH from (values(0)) TANH(TANH);

-- Expect success
prepare s1 from SELECT TDMISP TDMISP from (values(0)) TDMISP(TDMISP);

-- Expect success
prepare s1 from SELECT THIS THIS from (values(0)) THIS(THIS);

-- Expect success
prepare s1 from SELECT TRUNCATE TRUNCATE from (values(0)) TRUNCATE(TRUNCATE);

-- Expect success
prepare s1 from SELECT TS TS from (values(0)) TS(TS);

-- Expect success
prepare s1 from SELECT TYPE TYPE from (values(0)) TYPE(TYPE);

-- Expect success
prepare s1 from SELECT TYPE_ANSI TYPE_ANSI from (values(0)) TYPE_ANSI(TYPE_ANSI);

-- Expect success
prepare s1 from SELECT TYPE_FS TYPE_FS from (values(0)) TYPE_FS(TYPE_FS);

-- Expect success
prepare s1 from SELECT UCASE UCASE from (values(0)) UCASE(UCASE);

-- Expect success
prepare s1 from SELECT UNBOUNDED UNBOUNDED from (values(0)) UNBOUNDED(UNBOUNDED);

-- Expect success
prepare s1 from SELECT UNCOMMITTED UNCOMMITTED from (values(0)) UNCOMMITTED(UNCOMMITTED);

-- Expect success
prepare s1 from SELECT UNICODE_CHAR UNICODE_CHAR from (values(0)) UNICODE_CHAR(UNICODE_CHAR);

-- Expect success
prepare s1 from SELECT UNICODE_VALUE UNICODE_VALUE from (values(0)) UNICODE_VALUE(UNICODE_VALUE);

-- Expect success
prepare s1 from SELECT UNLOCK UNLOCK from (values(0)) UNLOCK(UNLOCK);

-- Expect success
prepare s1 from SELECT UNNAMED UNNAMED from (values(0)) UNNAMED(UNNAMED);

-- Expect success
prepare s1 from SELECT UNSIGNED UNSIGNED from (values(0)) UNSIGNED(UNSIGNED);

-- Expect success
prepare s1 from SELECT UPPERCASE UPPERCASE from (values(0)) UPPERCASE(UPPERCASE);

-- Expect success
prepare s1 from SELECT USA USA from (values(0)) USA(USA);

-- Expect success
prepare s1 from SELECT VARIABLE_DATA VARIABLE_DATA from (values(0)) VARIABLE_DATA(VARIABLE_DATA);

-- Expect success
prepare s1 from SELECT VARIABLE_POINTER VARIABLE_POINTER from (values(0)) VARIABLE_POINTER(VARIABLE_POINTER);

-- Expect success
prepare s1 from SELECT VARIANCE VARIANCE from (values(0)) VARIANCE(VARIANCE);

-- Expect success
prepare s1 from SELECT VARNCHAR VARNCHAR from (values(0)) VARNCHAR(VARNCHAR);

-- Expect success
prepare s1 from SELECT VERTICAL VERTICAL from (values(0)) VERTICAL(VERTICAL);

-- Expect success
prepare s1 from SELECT VSBB VSBB from (values(0)) VSBB(VSBB);

-- Expect success
prepare s1 from SELECT WAITED WAITED from (values(0)) WAITED(WAITED);

-- Expect success
prepare s1 from SELECT WEEK WEEK from (values(0)) WEEK(WEEK);

-- Expect success
prepare s1 from SELECT ABSOLUTE ABSOLUTE from (values(0)) ABSOLUTE(ABSOLUTE);

-- Expect success
prepare s1 from SELECT OPERATION OPERATION from (values(0)) OPERATION(OPERATION);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT BROWSE ACCESS from (values(0)) ACCESS(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE BROWSE from (values(0)) BROWSE(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE CONFLICT from (values(0)) CONFLICT(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE DROPPABLE from (values(0)) DROPPABLE(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE PERIODIC from (values(0)) PERIODIC(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE RANDOM from (values(0)) RANDOM(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE REPEATABLE from (values(0)) REPEATABLE(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE SERIALIZABLE from (values(0)) SERIALIZABLE(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE SKIP from (values(0)) SKIP(BROWSE);

-- Expect success
prepare s1 from SELECT BROWSE STABLE from (values(0)) STABLE(BROWSE);

-- Expect success
prepare s1 from SELECT PERFORM ACCESS from (values(0)) ACCESS(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM BROWSE from (values(0)) BROWSE(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM CONFLICT from (values(0)) CONFLICT(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM DROPPABLE from (values(0)) DROPPABLE(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM PERIODIC from (values(0)) PERIODIC(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM RANDOM from (values(0)) RANDOM(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM REPEATABLE from (values(0)) REPEATABLE(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM SERIALIZABLE from (values(0)) SERIALIZABLE(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM SKIP from (values(0)) SKIP(PERFORM);

-- Expect success
prepare s1 from SELECT PERFORM STABLE from (values(0)) STABLE(PERFORM);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT REPEATABLE ACCESS from (values(0)) ACCESS(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE BROWSE from (values(0)) BROWSE(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE CONFLICT from (values(0)) CONFLICT(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE DROPPABLE from (values(0)) DROPPABLE(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE PERIODIC from (values(0)) PERIODIC(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE RANDOM from (values(0)) RANDOM(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE REPEATABLE from (values(0)) REPEATABLE(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE SERIALIZABLE from (values(0)) SERIALIZABLE(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE SKIP from (values(0)) SKIP(REPEATABLE);

-- Expect success
prepare s1 from SELECT REPEATABLE STABLE from (values(0)) STABLE(REPEATABLE);

-- Expect success
prepare s1 from SELECT SAMPLE ACCESS from (values(0)) ACCESS(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE BROWSE from (values(0)) BROWSE(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE CONFLICT from (values(0)) CONFLICT(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE DROPPABLE from (values(0)) DROPPABLE(SAMPLE);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT SAMPLE PERIODIC from (values(0)) PERIODIC(SAMPLE);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT SAMPLE RANDOM from (values(0)) RANDOM(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE REPEATABLE from (values(0)) REPEATABLE(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE SERIALIZABLE from (values(0)) SERIALIZABLE(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE SKIP from (values(0)) SKIP(SAMPLE);

-- Expect success
prepare s1 from SELECT SAMPLE STABLE from (values(0)) STABLE(SAMPLE);

-- Expect success
prepare s1 from SELECT SEQUENCE ACCESS from (values(0)) ACCESS(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE BROWSE from (values(0)) BROWSE(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE CONFLICT from (values(0)) CONFLICT(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE DROPPABLE from (values(0)) DROPPABLE(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE PERIODIC from (values(0)) PERIODIC(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE RANDOM from (values(0)) RANDOM(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE REPEATABLE from (values(0)) REPEATABLE(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE SERIALIZABLE from (values(0)) SERIALIZABLE(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE SKIP from (values(0)) SKIP(SEQUENCE);

-- Expect success
prepare s1 from SELECT SEQUENCE STABLE from (values(0)) STABLE(SEQUENCE);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT SERIALIZABLE ACCESS from (values(0)) ACCESS(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE BROWSE from (values(0)) BROWSE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE CONFLICT from (values(0)) CONFLICT(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE DROPPABLE from (values(0)) DROPPABLE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE PERIODIC from (values(0)) PERIODIC(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE RANDOM from (values(0)) RANDOM(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE REPEATABLE from (values(0)) REPEATABLE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE SERIALIZABLE from (values(0)) SERIALIZABLE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE SKIP from (values(0)) SKIP(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SERIALIZABLE STABLE from (values(0)) STABLE(SERIALIZABLE);

-- Expect success
prepare s1 from SELECT SKIP ACCESS from (values(0)) ACCESS(SKIP);

-- Expect success
prepare s1 from SELECT SKIP BROWSE from (values(0)) BROWSE(SKIP);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT SKIP CONFLICT from (values(0)) CONFLICT(SKIP);

-- Expect success
prepare s1 from SELECT SKIP DROPPABLE from (values(0)) DROPPABLE(SKIP);

-- Expect success
prepare s1 from SELECT SKIP PERIODIC from (values(0)) PERIODIC(SKIP);

-- Expect success
prepare s1 from SELECT SKIP RANDOM from (values(0)) RANDOM(SKIP);

-- Expect success
prepare s1 from SELECT SKIP REPEATABLE from (values(0)) REPEATABLE(SKIP);

-- Expect success
prepare s1 from SELECT SKIP SERIALIZABLE from (values(0)) SERIALIZABLE(SKIP);

-- Expect success
prepare s1 from SELECT SKIP SKIP from (values(0)) SKIP(SKIP);

-- Expect success
prepare s1 from SELECT SKIP STABLE from (values(0)) STABLE(SKIP);

-- Expect SYNTAX error - A matching pair
prepare s1 from SELECT STABLE ACCESS from (values(0)) ACCESS(STABLE);

-- Expect success
prepare s1 from SELECT STABLE BROWSE from (values(0)) BROWSE(STABLE);

-- Expect success
prepare s1 from SELECT STABLE CONFLICT from (values(0)) CONFLICT(STABLE);

-- Expect success
prepare s1 from SELECT STABLE DROPPABLE from (values(0)) DROPPABLE(STABLE);

-- Expect success
prepare s1 from SELECT STABLE PERIODIC from (values(0)) PERIODIC(STABLE);

-- Expect success
prepare s1 from SELECT STABLE RANDOM from (values(0)) RANDOM(STABLE);

-- Expect success
prepare s1 from SELECT STABLE REPEATABLE from (values(0)) REPEATABLE(STABLE);

-- Expect success
prepare s1 from SELECT STABLE SERIALIZABLE from (values(0)) SERIALIZABLE(STABLE);

-- Expect success
prepare s1 from SELECT STABLE SKIP from (values(0)) SKIP(STABLE);

-- Expect success
prepare s1 from SELECT STABLE STABLE from (values(0)) STABLE(STABLE);

-- Check various flavors of string literals.
--
-- Expect success
prepare s1 from SELECT 'abcd', 'a"cd', 'ab''d',
                       _ISO88591'abcd', _ISO88591'a"cd', _ISO88591'ab''d',
                       N'abcd', N'a"cd', N'ab''d'
                FROM (VALUES(0)) T;

-- Check in the context of special parser flags.
--
-- Set PARSER FLAG ALLOW_OLD_AND_NEW_KEYWORD
set parserflags 16;

-- Expect success
prepare s1 from SELECT OLD OLD from (values(0)) OLD(OLD);

-- Expect success
prepare s1 from SELECT NEW NEW from (values(0)) NEW(NEW);