create schema column_quote_alias;
set current_schema to 'column_quote_alias';
DROP TABLE IF EXISTS t_alias_case0001_1;
CREATE TABLE t_alias_case0001_1 (a int);
INSERT INTO t_alias_case0001_1 SET a=1;
select character varying 'keyword_test' from t_alias_case0001_1;
select character 'keyword_test' from t_alias_case0001_1;
select nvarchar 'keyword_test' from t_alias_case0001_1;
select nvarchar2 'keyword_test' from t_alias_case0001_1;
select national varchar 'keyword_test' from t_alias_case0001_1;
select VARCHAR 'keyword_test' from t_alias_case0001_1;
select VARCHAR2 'keyword_test' from t_alias_case0001_1;
select NATIONAL CHARACTER 'keyword_test' from t_alias_case0001_1;
select NATIONAL CHAR 'keyword_test' from t_alias_case0001_1;
select NCHAR 'keyword_test' from t_alias_case0001_1;
select NCHAR VARYING 'keyword_test' from t_alias_case0001_1;
select CHAR 'keyword_test' from t_alias_case0001_1;
select CHAR VARYING 'keyword_test' from t_alias_case0001_1;
select TEXT 'keyword_test' from t_alias_case0001_1;
select character(2) 'keyword_test' from t_alias_case0001_1;
select text(2) 'keyword_test' from t_alias_case0001_1;
select char(1) 'keyword_test' from t_alias_case0001_1;
select char varying(1) 'keyword_test' from t_alias_case0001_1;
select timestamp(2) 'keyword_test' from t_alias_case0001_1;
select time(2) 'keyword_test' from t_alias_case0001_1;
select smalldatetime 'keyword_test' from t_alias_case0001_1;
select int 'keyword_test' from t_alias_case0001_1;
select tinyint 'keyword_test' from t_alias_case0001_1;
select smallint 'keyword_test' from t_alias_case0001_1;
select mediumint 'keyword_test' from t_alias_case0001_1;
select bigint 'keyword_test' from t_alias_case0001_1;
select real 'keyword_test' from t_alias_case0001_1;
select float 'keyword_test' from t_alias_case0001_1;
select BINARY_DOUBLE 'keyword_test' from t_alias_case0001_1;
select BINARY_INTEGER 'keyword_test' from t_alias_case0001_1;
select decimal 'keyword_test' from t_alias_case0001_1;
select number 'keyword_test' from t_alias_case0001_1;
select dec 'keyword_test' from t_alias_case0001_1;
select numeric 'keyword_test' from t_alias_case0001_1;
select fixed 'keyword_test' from t_alias_case0001_1;
select boolean 'keyword_test' from t_alias_case0001_1;
select bit(2) 'keyword_test' from t_alias_case0001_1;
select bit varying 'keyword_test' from t_alias_case0001_1;
select bit 'keyword_test' from t_alias_case0001_1;
SELECT a as ' ' from t_alias_case0001_1;
SELECT a ' ' from t_alias_case0001_1;
SELECT a as '(ss)' from t_alias_case0001_1;
SELECT a '(ss)' from t_alias_case0001_1;
SELECT a as '334ss' from t_alias_case0001_1;
SELECT a '334ss' from t_alias_case0001_1;
SELECT a as '#' from t_alias_case0001_1;
SELECT a '#' from t_alias_case0001_1;
SELECT a '$&%^@' from t_alias_case0001_1;
SELECT a as '$&%^@' from t_alias_case0001_1;
SELECT a as '!' from t_alias_case0001_1;
SELECT a as '@' from t_alias_case0001_1;
SELECT a as '$' from t_alias_case0001_1;
SELECT a as '&' from t_alias_case0001_1;
SELECT a '!' from t_alias_case0001_1;
SELECT a '@' from t_alias_case0001_1;
SELECT a '$' from t_alias_case0001_1;
SELECT a '&' from t_alias_case0001_1;
SELECT a as 'abort' from t_alias_case0001_1;
SELECT a 'abort' from t_alias_case0001_1;
SELECT a as 'as' from t_alias_case0001_1;
SELECT a 'as' from t_alias_case0001_1;
SELECT a as 'all' from t_alias_case0001_1;
SELECT a 'all' from t_alias_case0001_1;
SELECT a as 'cast' from t_alias_case0001_1;
SELECT a 'cast' from t_alias_case0001_1;
SELECT a as 'BIT' from t_alias_case0001_1;
SELECT a 'BIT' from t_alias_case0001_1;
SELECT a as 'BINARY_DOUBLE' from t_alias_case0001_1;
SELECT a 'BINARY_DOUBLE' from t_alias_case0001_1;
SELECT a as 'BINARY_INTEGER' from t_alias_case0001_1;
SELECT a 'BINARY_INTEGER' from t_alias_case0001_1;
SELECT a as 'BOOLEAN_P' from t_alias_case0001_1;
SELECT a 'BOOLEAN_P' from t_alias_case0001_1;
SELECT a as 'FIXED_P' from t_alias_case0001_1;
SELECT a 'FIXED_P' from t_alias_case0001_1;
SELECT a as 'NUMBER_P' from t_alias_case0001_1;
SELECT a 'NUMBER_P' from t_alias_case0001_1;
SELECT a as 'NCHAR' from t_alias_case0001_1;
SELECT a 'NCHAR' from t_alias_case0001_1;
SELECT a as 'NVARCHAR2' from t_alias_case0001_1;
SELECT a 'NVARCHAR2' from t_alias_case0001_1;
SELECT a as 'VARCHAR2' from t_alias_case0001_1;
SELECT a 'VARCHAR2' from t_alias_case0001_1;
SELECT a as 'NVARCHAR' from t_alias_case0001_1;
SELECT a 'NVARCHAR' from t_alias_case0001_1;
SELECT a 'NVARCHAR ' from t_alias_case0001_1;
SELECT a 'NVARCHAR@' from t_alias_case0001_1;
SELECT a as 'BINARY' from t_alias_case0001_1;
SELECT a 'BINARY' from t_alias_case0001_1;
SELECT a as 'BIGINT' from t_alias_case0001_1;
SELECT a 'BIGINT' from t_alias_case0001_1;
SELECT a as 'DEC' from t_alias_case0001_1;
SELECT a 'DEC' from t_alias_case0001_1;
SELECT a as 'DECIMAL_P' from t_alias_case0001_1;
SELECT a 'DECIMAL_P' from t_alias_case0001_1;
SELECT a as 'FLOAT_P' from t_alias_case0001_1;
SELECT a 'FLOAT_P' from t_alias_case0001_1;
SELECT a as 'INT_P' from t_alias_case0001_1;
SELECT a 'INT_P' from t_alias_case0001_1;
SELECT a as 'MEDIUMINT' from t_alias_case0001_1;
SELECT a 'MEDIUMINT' from t_alias_case0001_1;
SELECT a as 'INTEGER' from t_alias_case0001_1;
SELECT a 'INTEGER' from t_alias_case0001_1;
SELECT a as 'NUMERIC' from t_alias_case0001_1;
SELECT a 'NUMERIC' from t_alias_case0001_1;
SELECT a as 'REAL' from t_alias_case0001_1;
SELECT a 'REAL' from t_alias_case0001_1;
SELECT a as 'SMALLINT' from t_alias_case0001_1;
SELECT a 'SMALLINT' from t_alias_case0001_1;
SELECT a as 'TINYINT' from t_alias_case0001_1;
SELECT a 'TINYINT' from t_alias_case0001_1;
SELECT a as 'CHARACTER' from t_alias_case0001_1;
SELECT a 'CHARACTER' from t_alias_case0001_1;
SELECT a as 'VARCHAR' from t_alias_case0001_1;
SELECT a 'VARCHAR' from t_alias_case0001_1;
SELECT a as 'CHAR_P' from t_alias_case0001_1;
SELECT a 'CHAR_P' from t_alias_case0001_1;
SELECT a as '哈哈' from t_alias_case0001_1;
SELECT a '哈哈' from t_alias_case0001_1;
SELECT a as 'امروز' from t_alias_case0001_1;
SELECT a 'امروز' from t_alias_case0001_1;
SELECT a as 'waɗ' from t_alias_case0001_1;
SELECT a 'waɗ' from t_alias_case0001_1;
SELECT a as 'अद्यः' from t_alias_case0001_1;
SELECT a 'अद्यः' from t_alias_case0001_1;
SELECT a as 'ວັນນີ້' from t_alias_case0001_1;
SELECT a 'ວັນນີ້' from t_alias_case0001_1;
SELECT a as 'हदाद' from t_alias_case0001_1;
SELECT a 'हदाद' from t_alias_case0001_1;
SELECT a as 'kssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c ssss kssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c ssss' from t_alias_case0001_1;
SELECT a 'kssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c ssss kssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c sssskssdjskjcjdfkvndfkvndk ndkfn kldfvklx m dfjcvaldskcdlfk ndfvkaldierufq8239e0d98wjeca,s.c ssss' from t_alias_case0001_1;
SELECT a as 'ssss' from t_alias_case0001_1;
SELECT a 'ssss' from t_alias_case0001_1;
SELECT a as 'SSSS' from t_alias_case0001_1;
SELECT a 'SSSS' from t_alias_case0001_1;
select atan(point '(1,1)',point '(2,1)');
select hex(compress(point '(1,1)'));
select cidr'10.1.0.0/16';
select N'1234';
select n'abcd中文';
select hour(varchar'2001-06-28 17:00:00');
create table tb1 (id varchar);
insert into tb1 values('2001-06-28 17:00:00');
select * from tb1;
drop table tb1;
DROP TABLE t_alias_case0001_1;
drop schema column_quote_alias cascade;
reset current_schema;
