Google Git
Sign in
apache / trafodion / 68414916218c9714d7c4b9207cadef1264ebf3e9 / . / core / sql / regress / fullstack2 / EXPECTED062.RELEASE
blob: 4f9349d7c1b5390fca1e44e0a165c632cfecf75d [file] [log] [blame]
>>
>>?section ABC
>>?section def;
>>?section ghi ;
>>?section jkl + foo
>>?section mno+foo
>>?section pqr_stu
>>?section
>>?section;
>>?section ;
>>?section1 bad
*** ERROR[15001] A syntax error occurred at or before:
?section1 bad
^ (11 characters from start of SQL statement)
>>?sectiona bad
*** ERROR[15001] A syntax error occurred at or before:
?sectiona bad
^ (11 characters from start of SQL statement)
>>?ignoreb bad
*** ERROR[15001] A syntax error occurred at or before:
?ignoreb bad
^ (10 characters from start of SQL statement)
>>?ignore_2 bad
*** ERROR[15001] A syntax error occurred at or before:
?ignore_2 bad
^ (11 characters from start of SQL statement)
>>?ignore not ok!
*** ERROR[15001] A syntax error occurred at or before:
?ignore not ok!
^ (9 characters from start of SQL statement)
>>abc"bad
*** ERROR[15005] Unmatched quote in input (unterminated string):
abc"bad
^ (4 characters from start of SQL statement)
>>?ignore off (this is a syntax error)
*** ERROR[15001] A syntax error occurred at or before:
?ignore off (this is a syntax error)
^ (9 characters from start of SQL statement)
>>obey TEST062(abc);
>>obey TEST062(DEF);
>>obey TEST062(ghi);
>>obey TEST062(jkl);
>>obey TEST062(mno);
>>obey TEST062(pqr);
*** ERROR[15014] Section pqr was not found in file TEST062.
>>obey TEST062(pqr_stu);
>>
>>env;
----------------------------------
Current Environment
----------------------------------
AUTHENTICATION disabled
AUTHORIZATION enabled
CURRENT DIRECTORY /home/centos/regr_results/regress/fullstack2
LIST_COUNT 4294967295
LOG FILE LOG062
MESSAGEFILE /home/centos/esgyndb/core/sqf/export/bin64/mxcierrors.cat
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2019-09-18 08:01 LINUX:GSELVA-ESGYN-RH6-1.NOVALOCAL/centos}
SQL CATALOG TRAFODION
SQL SCHEMA SCH
SQL USER CONNECTED user not connected
SQL USER DB NAME DB__ROOT
SQL USER ID 33333
TERMINAL CHARSET ISO88591
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>>
>>set catalog '';
*** ERROR[8008] Catalog name is not valid.
*** ERROR[15001] A syntax error occurred at or before:
SET CATALOG ;
^ (13 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>> -- 8008
>>set catalog 'c.s';
*** ERROR[8008] Catalog name C.S is not valid.
*** ERROR[15001] A syntax error occurred at or before:
SET CATALOG C.S;
^ (14 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>> -- 8008
>>set schema 's.t.u';
*** ERROR[8009] Schema name s.t.u is not valid.
*** ERROR[8822] The statement was not prepared.
>> -- 8009
>>showcontrol query default showcontrol;
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL OFF
No externalized DEFAULTS attribute SHOWCONTROL exists.
--- SQL operation complete.
>> -- no settings in effect; no extlzd attr
>>showcontrol all zzfoo;
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION ZZFOO settings are in effect.
No CONTROL TABLE ZZFOO settings are in effect.
No CONTROL QUERY DEFAULT ZZFOO settings are in effect.
No externalized DEFAULTS attribute ZZFOO exists.
--- SQL operation complete.
>> -- no settings in effect; no extlzd attr
>>control query shape cut;
--- SQL operation complete.
>>control table schema_x.t timeout '10';
--- SQL operation complete.
>>control query default SHOWCONTROL_SHOW_ALL 'on';
--- SQL operation complete.
>>showcontrol default catalog, match full;
No CONTROL QUERY DEFAULT CATALOG settings are in effect.
Current DEFAULTS
CATALOG TRAFODION
--- SQL operation complete.
>> -- CAT
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA TRAFODION.SCH
Current DEFAULTS
SCHEMA SCH
--- SQL operation complete.
>> -- SCH
>>set catalog ' a ';
--- SQL operation complete.
>>showcontrol default catalog, match full;
CONTROL QUERY DEFAULT
CATALOG A
Current DEFAULTS
CATALOG A
--- SQL operation complete.
>> -- A
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA TRAFODION.SCH
Current DEFAULTS
SCHEMA SCH
--- SQL operation complete.
>> -- SCH
>>set schema 'x.y';
--- SQL operation complete.
>>showcontrol default catalog, match full;
No CONTROL QUERY DEFAULT CATALOG settings are in effect.
Current DEFAULTS
CATALOG X
--- SQL operation complete.
>> -- X
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA X.Y
Current DEFAULTS
SCHEMA Y
--- SQL operation complete.
>> -- Y
>>set schema ' " z " ';
--- SQL operation complete.
>>showcontrol default catalog, match full;
No CONTROL QUERY DEFAULT CATALOG settings are in effect.
Current DEFAULTS
CATALOG X
--- SQL operation complete.
>> -- X
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA " z "
Current DEFAULTS
SCHEMA " z"
--- SQL operation complete.
>> -- " z"
>>set catalog 'c';
--- SQL operation complete.
>>showcontrol default catalog, match full;
CONTROL QUERY DEFAULT
CATALOG C
Current DEFAULTS
CATALOG C
--- SQL operation complete.
>> -- C
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA " z "
Current DEFAULTS
SCHEMA " z"
--- SQL operation complete.
>> -- " z"
>>set schema ' z';
--- SQL operation complete.
>>showcontrol default catalog, match full;
CONTROL QUERY DEFAULT
CATALOG C
Current DEFAULTS
CATALOG C
--- SQL operation complete.
>> -- C
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA Z
Current DEFAULTS
SCHEMA Z
--- SQL operation complete.
>> -- Z
>>set schema ' aaa . bbb ';
--- SQL operation complete.
>>showcontrol default catalog, match full;
No CONTROL QUERY DEFAULT CATALOG settings are in effect.
Current DEFAULTS
CATALOG AAA
--- SQL operation complete.
>> -- AAA
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA AAA.BBB
Current DEFAULTS
SCHEMA BBB
--- SQL operation complete.
>> -- BBB
>>set catalog 'ccc';
--- SQL operation complete.
>>--showcontrol default sch, match partial;-- CCC + BBB
>>--showcontrol default sch, match full; -- empty
>>showcontrol default schema, match full;
CONTROL QUERY DEFAULT
SCHEMA AAA.BBB
Current DEFAULTS
SCHEMA BBB
--- SQL operation complete.
>> -- BBB
>>showcontrol default catalog,match full;
CONTROL QUERY DEFAULT
CATALOG CCC
Current DEFAULTS
CATALOG CCC
--- SQL operation complete.
>> -- CCC
>>showcontrol default catalog, match full, no header;
CCC
--- SQL operation complete.
>> --- CCC (no header)
>>showcontrol all schema, match full;
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION SCHEMA settings are in effect.
No CONTROL TABLE SCHEMA settings are in effect.
CONTROL QUERY DEFAULT
SCHEMA AAA.BBB
Current DEFAULTS
SCHEMA BBB
--- SQL operation complete.
>> -- BBB
>>showcontrol all sch, match full;
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION SCH settings are in effect.
No CONTROL TABLE SCH settings are in effect.
No CONTROL QUERY DEFAULT SCH settings are in effect.
No DEFAULTS attribute SCH exists.
--- SQL operation complete.
>> -- empty
>>showcontrol all showcontrol;
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION SHOWCONTROL settings are in effect.
No CONTROL TABLE SHOWCONTROL settings are in effect.
CONTROL QUERY DEFAULT
SHOWCONTROL_SHOW_ALL ON
Current DEFAULTS
SHOWCONTROL_SHOW_ALL ON
SHOWCONTROL_SHOW_SUPPORT OFF
--- SQL operation complete.
>> -- unext. + support
>>control query default aafoo 'z';
*** ERROR[2050] AAFOO is not the name of any DEFAULTS table attribute.
*** ERROR[8822] The statement was not prepared.
>> -- 2050
>>control query default zzfoo 'z';
*** ERROR[2050] ZZFOO is not the name of any DEFAULTS table attribute.
*** ERROR[8822] The statement was not prepared.
>> -- 2050
>>control query default def_chunk_size 'z';
*** ERROR[2055] The specified value 'Z' for DEFAULTS attribute DEF_CHUNK_SIZE is not valid.
*** ERROR[2056] The value must be a number in the range [1,2147483584].
*** ERROR[2057] The value must be a multiple of 2.
*** ERROR[8822] The statement was not prepared.
>> -- 2055
>>control query default def_chunk_size '0';
*** ERROR[2055] The specified value '0' for DEFAULTS attribute DEF_CHUNK_SIZE is not valid.
*** ERROR[2056] The value must be a number in the range [1,2147483584].
*** ERROR[2057] The value must be a multiple of 2.
*** ERROR[8822] The statement was not prepared.
>> -- 2055
>>control query default def_chunk_size '';
--- SQL operation complete.
>> -- 2055
>>control query default def_chunk_size '1000';
--- SQL operation complete.
>>control query default def_chunk_size '-1000';
*** ERROR[2055] The specified value '-1000' for DEFAULTS attribute DEF_CHUNK_SIZE is not valid.
*** ERROR[2056] The value must be a number in the range [1,2147483584].
*** ERROR[2057] The value must be a multiple of 2.
*** ERROR[8822] The statement was not prepared.
>> -- 2055
>>control query default def_chunk_size '1.5e+12';
*** ERROR[2055] The specified value '1.5E+12' for DEFAULTS attribute DEF_CHUNK_SIZE is not valid.
*** ERROR[2056] The value must be a number in the range [1,2147483584].
*** ERROR[2057] The value must be a multiple of 2.
*** ERROR[8822] The statement was not prepared.
>> -- 2055
>>showcontrol query default def_chunk;
CONTROL QUERY DEFAULT
DEF_CHUNK_SIZE 1000
Current DEFAULTS
DEF_CHUNK_SIZE 1000
--- SQL operation complete.
>>showcontrol all zzfoo;
No CONTROL QUERY SHAPE settings are in effect.
No CONTROL SESSION ZZFOO settings are in effect.
No CONTROL TABLE ZZFOO settings are in effect.
No CONTROL QUERY DEFAULT ZZFOO settings are in effect.
No DEFAULTS attribute ZZFOO exists.
--- SQL operation complete.
>> -- no settings in effect; no attr
>>showcontrol query default def_chunk;
CONTROL QUERY DEFAULT
DEF_CHUNK_SIZE 1000
Current DEFAULTS
DEF_CHUNK_SIZE 1000
--- SQL operation complete.
>>showcontrol query default;
CONTROL QUERY DEFAULT
SEABASE_VOLATILE_TABLES ON
HBASE_ASYNC_DROP_TABLE OFF
HBASE_SERIALIZATION ON
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
SHOWCONTROL_SHOW_ALL ON
SCHEMA AAA.BBB
CATALOG CCC
DEF_CHUNK_SIZE 1000
--- SQL operation complete.
>>set schema $$TEST_SCHEMA$$;
--- SQL operation complete.
>> -- revert to original regress setting
>>
>>control query default timeout '144';
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SEABASE_VOLATILE_TABLES ON
HBASE_ASYNC_DROP_TABLE OFF
HBASE_SERIALIZATION ON
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
SCHEMA TRAFODION.SCH
TIMEOUT 144
--- SQL operation complete.
>>control query default timeout reset;
--- SQL operation complete.
>>showcontrol default;
CONTROL QUERY DEFAULT
SEABASE_VOLATILE_TABLES ON
HBASE_ASYNC_DROP_TABLE OFF
HBASE_SERIALIZATION ON
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
SCHEMA TRAFODION.SCH
TIMEOUT 6000
--- SQL operation complete.
>>showcontrol defaults readonly_cursor;
No CONTROL QUERY DEFAULT READONLY_CURSOR settings are in effect.
Current DEFAULTS
READONLY_CURSOR TRUE
--- SQL operation complete.
>> -- TRUE
>>
>>control query default * reset;
--- SQL operation complete.
>>
>>showcontrol default;
No CONTROL QUERY DEFAULT settings are in effect.
--- SQL operation complete.
>>showcontrol default timeout, match full;
No CONTROL QUERY DEFAULT TIMEOUT settings are in effect.
Current DEFAULTS
TIMEOUT 6000
--- SQL operation complete.
>>showcontrol defaults REFERENCE_CODE;
No CONTROL QUERY DEFAULT REFERENCE_CODE settings are in effect.
No externalized DEFAULTS attribute REFERENCE_CODE exists.
--- SQL operation complete.
>>showcontrol defaults readonly_cursor;
No CONTROL QUERY DEFAULT READONLY_CURSOR settings are in effect.
No externalized DEFAULTS attribute READONLY_CURSOR exists.
--- SQL operation complete.
>> -- none in effect
>>
>>control table * reset;
--- SQL operation complete.
>>control table a timeout ' 123 ';
--- SQL operation complete.
>>control table b timeout '345';
--- SQL operation complete.
>>control table b mdam ' off ';
--- SQL operation complete.
>>control table c timeout '567';
--- SQL operation complete.
>>control table b timeout reset;
--- SQL operation complete.
>>control table "*" timeout '789';
--- SQL operation complete.
>>showcontrol table;
CONTROL TABLE A
TIMEOUT 123
CONTROL TABLE B
MDAM OFF
CONTROL TABLE C
TIMEOUT 567
CONTROL TABLE "*"
TIMEOUT 789
--- SQL operation complete.
>>control table * reset;
--- SQL operation complete.
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>
>>control table a timeout ' 123 ';
--- SQL operation complete.
>>control table b timeout '345';
--- SQL operation complete.
>>control table b mdam ' off ';
--- SQL operation complete.
>>control table * timeout '777';
--- SQL operation complete.
>>control table c timeout '567';
--- SQL operation complete.
>>showcontrol table;
CONTROL TABLE B
MDAM OFF
CONTROL TABLE *
TIMEOUT 777
CONTROL TABLE C
TIMEOUT 567
--- SQL operation complete.
>>
>>control table a timeout ' 123 ';
--- SQL operation complete.
>>control table b timeout '345';
--- SQL operation complete.
>>control table * timeout reset;
--- SQL operation complete.
>>showcontrol table;
CONTROL TABLE B
MDAM OFF
--- SQL operation complete.
>>
>>control table b timeout '345';
--- SQL operation complete.
>>control table b mdam 'off';
--- SQL operation complete.
>>control table b * reset;
--- SQL operation complete.
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>control table b timeout '345';
--- SQL operation complete.
>>control table b mdam 'off';
--- SQL operation complete.
>>control table b reset;
--- SQL operation complete.
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>
>>control table a mdam 'on';
--- SQL operation complete.
>>control table b timeout '3';
--- SQL operation complete.
>>showcontrol table;
CONTROL TABLE A
MDAM ON
CONTROL TABLE B
TIMEOUT 3
--- SQL operation complete.
>>control table * * reset;
--- SQL operation complete.
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>control table b timeout '4';
--- SQL operation complete.
>>control table b timeout '';
--- SQL operation complete.
>> -- equiv to reset
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>control table b timeout '5';
--- SQL operation complete.
>>control table b timeout ' reset ';
--- SQL operation complete.
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>control table b timeout '6';
--- SQL operation complete.
>>control table b * '7';
*** ERROR[2051] Either CONTROL TABLE option * or value '7' is not valid.
--- SQL operation failed with errors.
>> -- syntax error
>>control table * * '8';
*** ERROR[2051] Either CONTROL TABLE option * or value '8' is not valid.
--- SQL operation failed with errors.
>> -- syntax error
>>control table * * ' ';
--- SQL operation complete.
>> -- equiv to reset
>>showcontrol table;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
>>
>>control session ' abc ' ' xy ';
--- SQL operation complete.
>>showcontrol session;
CONTROL SESSION
ABC xy
--- SQL operation complete.
>>control session 'abc' ' ';
--- SQL operation complete.
>>showcontrol session;
No CONTROL SESSION settings are in effect.
--- SQL operation complete.
>>control session 'abc' 'xy Z';
--- SQL operation complete.
>>control session ' ' '';
--- SQL operation complete.
>>showcontrol session;
No CONTROL SESSION settings are in effect.
--- SQL operation complete.
>>control session ' ' 'x';
*** ERROR[2051] Either CONTROL SESSION option '' or value 'x' is not valid.
*** ERROR[8822] The statement was not prepared.
>>
>>control session 'abc' 'xy Z';
--- SQL operation complete.
>>control session 'eee' reset;
--- SQL operation complete.
>>showcontrol session;
CONTROL SESSION
ABC xy Z
--- SQL operation complete.
>>control session 'abc' reset;
--- SQL operation complete.
>>showcontrol session;
No CONTROL SESSION settings are in effect.
--- SQL operation complete.
>>
>>control session '_bc' 'xy';
--- SQL operation complete.
>>control session '' reset;
--- SQL operation complete.
>>showcontrol session;
No CONTROL SESSION settings are in effect.
--- SQL operation complete.
>>control session '_a.b$c9' 'xy';
--- SQL operation complete.
>>control session ' a b c' 'xy';
*** ERROR[2051] Either CONTROL SESSION option 'A B C' or value 'xy' is not valid.
*** ERROR[8822] The statement was not prepared.
>> -- syn err
>>control session * reset;
--- SQL operation complete.
>>showcontrol session;
No CONTROL SESSION settings are in effect.
--- SQL operation complete.
>>
>>-- Genesis 10-981211-5986 and 10-981217-9085
>>control query default timeout '4567';
--- SQL operation complete.
>>#ifndef SEABASE_REGRESS
>>set schema HP_SYSTEM_CATALOG.SYSTEM_DEFAULTS_SCHEMA;
>>delete from SYSTEM_DEFAULTS where ATTRIBUTE = 'OPTIMIZATION_LEVEL';
>>insert into SYSTEM_DEFAULTS (ATTRIBUTE, ATTR_VALUE, ATTR_COMMENT)
+> values('OPTIMIZATION_LEVEL', 'FULL', 'in middle of TEST062...');
>>delete from SYSTEM_DEFAULTS where ATTRIBUTE = 'OPTIMIZATION_LEVEL';
>>insert into SYSTEM_DEFAULTS (ATTRIBUTE, ATTR_VALUE, ATTR_COMMENT) values ('OPTIMIZATION_LEVEL', '3 ', '${NEO_COMMENT}');
>>#else
>>set schema $$TEST_SCHEMA$$;
--- SQL operation complete.
>>#endif
>>
>>env;
----------------------------------
Current Environment
----------------------------------
AUTHENTICATION disabled
AUTHORIZATION enabled
CURRENT DIRECTORY /home/centos/regr_results/regress/fullstack2
LIST_COUNT 4294967295
LOG FILE LOG062
MESSAGEFILE /home/centos/esgyndb/core/sqf/export/bin64/mxcierrors.cat
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2019-09-18 08:01 LINUX:GSELVA-ESGYN-RH6-1.NOVALOCAL/centos}
SQL CATALOG TRAFODION
SQL SCHEMA SCH
SQL USER CONNECTED user not connected
SQL USER DB NAME DB__ROOT
SQL USER ID 33333
TERMINAL CHARSET ISO88591
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>> -- *not* $$TEST_SCHEMA$$
>>showcontrol default OPTIMIZATION_LEVEL, match full;
No CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL settings are in effect.
Current DEFAULTS
OPTIMIZATION_LEVEL 3
--- SQL operation complete.
>> -- 3 (*not* FULL!)
>>showcontrol default timeout;
CONTROL QUERY DEFAULT
TIMEOUT 4567
Current DEFAULTS
STREAM_TIMEOUT -1
TIMEOUT 4567
UDR_JVM_DEBUG_TIMEOUT 0
--- SQL operation complete.
>> -- 4567
>>#ifLINUX
>>sh mkdir temp062;
>>sh mv core.* temp062;
>>#ifLINUX
>>select TESTABORT;
*** ERROR[15001] A syntax error occurred at or before:
select TESTABORT;
^ (17 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>>#ifLINUX
>>sh rm core.*;
>>sh mv temp062/core.* .;
>>sh rmdir temp062;
>>#ifLINUX
>>table mxreborn;
*** ERROR[4082] Object TRAFODION.SCH.MXREBORN does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
>>env;
----------------------------------
Current Environment
----------------------------------
AUTHENTICATION disabled
AUTHORIZATION enabled
CURRENT DIRECTORY /home/centos/regr_results/regress/fullstack2
LIST_COUNT 4294967295
LOG FILE LOG062
MESSAGEFILE /home/centos/esgyndb/core/sqf/export/bin64/mxcierrors.cat
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2019-09-18 08:01 LINUX:GSELVA-ESGYN-RH6-1.NOVALOCAL/centos}
SQL CATALOG TRAFODION
SQL SCHEMA SCH
SQL USER CONNECTED user not connected
SQL USER DB NAME DB__ROOT
SQL USER ID 33333
TERMINAL CHARSET ISO88591
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>> -- still not $$TEST_SCHEMA$$
>>showcontrol default OPTIMIZATION_LEVEL, match full;
No CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL settings are in effect.
Current DEFAULTS
OPTIMIZATION_LEVEL 3
--- SQL operation complete.
>> -- still 3
>>showcontrol default timeout;
CONTROL QUERY DEFAULT
TIMEOUT 4567
Current DEFAULTS
STREAM_TIMEOUT -1
TIMEOUT 4567
UDR_JVM_DEBUG_TIMEOUT 0
--- SQL operation complete.
>> -- still 4567
>>--
>>control query default * reset;
--- SQL operation complete.
>>set schema $$TEST_SCHEMA$$;
--- SQL operation complete.
>>env;
----------------------------------
Current Environment
----------------------------------
AUTHENTICATION disabled
AUTHORIZATION enabled
CURRENT DIRECTORY /home/centos/regr_results/regress/fullstack2
LIST_COUNT 4294967295
LOG FILE LOG062
MESSAGEFILE /home/centos/esgyndb/core/sqf/export/bin64/mxcierrors.cat
MESSAGEFILE LANG US English
MESSAGEFILE VRSN {2019-09-18 08:01 LINUX:GSELVA-ESGYN-RH6-1.NOVALOCAL/centos}
SQL CATALOG TRAFODION
SQL SCHEMA SCH
SQL USER CONNECTED user not connected
SQL USER DB NAME DB__ROOT
SQL USER ID 33333
TERMINAL CHARSET ISO88591
TRANSACTION ID
TRANSACTION STATE not in progress
WARNINGS on
>> -- back to $$TEST_SCHEMA$$
>>set schema $$TEST_SCHEMA$$;
--- SQL operation complete.
>> -- back to $$TEST_SCHEMA$$
>>showcontrol default OPTIMIZATION_LEVEL, match full;
No CONTROL QUERY DEFAULT OPTIMIZATION_LEVEL settings are in effect.
Current DEFAULTS
OPTIMIZATION_LEVEL 3
--- SQL operation complete.
>> -- 3
>>showcontrol default timeout;
No CONTROL QUERY DEFAULT TIMEOUT settings are in effect.
Current DEFAULTS
STREAM_TIMEOUT -1
TIMEOUT 6000
UDR_JVM_DEBUG_TIMEOUT 0
--- SQL operation complete.
>> -- back to 6000
>>
>>?section eof
>>-- firstline cmt
>>select * from -- another firstline cmt
+>
+>-- embedded cmt
+>tazfoo -- another embedded cmt
+>;
*** ERROR[4082] Object TRAFODION.SCH.TAZFOO does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
>> -- post-; cmt
>>
>> -- tab cmt
>>
>>invoke tazfoo
+>select * from tazfoo;
*** ERROR[15001] A syntax error occurred at or before:
invoke tazfoo select * from tazfoo;
^ (20 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>>select * from tazfoo;
*** ERROR[4082] Object TRAFODION.SCH.TAZFOO does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
>>invoke tazfoo
+>
+>
*** ERROR[15003] An incomplete statement was found in input:
invoke tazfoo !EOF!
>>exit;
End of MXCI Session