>>
>>?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  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
LIST_COUNT         4294967295
LOG FILE           LOG062
MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
MESSAGEFILE LANG   US English
MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
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
>>control query default CPUCOST_DM_GET '1.5e+12';

--- SQL operation complete.
>>	-- valid
>>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
  MODE_SEABASE                  	ON
  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
  CPUCOST_DM_GET                	1.5E+12

--- SQL operation complete.
>>control query default CPUCOST_DM_GET '';

--- SQL operation complete.
>>	-- valid (revert to orig deflt)
>>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
  MODE_SEABASE                  	ON
  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
  CPUCOST_DM_GET                	.001
  SCHEMA                        	TRAFODION.SCH
  TIMEOUT                       	144

--- SQL operation complete.
>>control query default timeout reset;

--- SQL operation complete.
>>showcontrol default;

CONTROL QUERY DEFAULT
  MODE_SEABASE                  	ON
  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
  CPUCOST_DM_GET                	.001
  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.
>>
>>#ifdef SEABASE_REGRESS
>>control query default mode_seabase 'ON';

--- SQL operation complete.
>>#endif
>>
>>
>>
>>showcontrol default;

CONTROL QUERY DEFAULT
  MODE_SEABASE                  	ON

--- 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  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
LIST_COUNT         4294967295
LOG FILE           LOG062
MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
MESSAGEFILE LANG   US English
MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
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[2005] Internal error: from compilation, no errors in diagnostics yet for statement: select TESTABORT;

*** 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  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
LIST_COUNT         4294967295
LOG FILE           LOG062
MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
MESSAGEFILE LANG   US English
MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
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
>>--
>>#ifndef SEABASE_REGRESS
>>-- restore persistent and session state
>>delete from HP_SYSTEM_CATALOG.SYSTEM_DEFAULTS_SCHEMA.SYSTEM_DEFAULTS
+>  where ATTRIBUTE = 'OPTIMIZATION_LEVEL';
>>control query default * reset;
>>#else
>>control query default * reset;

--- SQL operation complete.
>>control query default mode_seabase 'ON';

--- SQL operation complete.
>>set schema $$TEST_SCHEMA$$;

--- SQL operation complete.
>>#endif
>>env;
----------------------------------
Current Environment
----------------------------------
AUTHENTICATION     disabled
AUTHORIZATION      enabled
CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
LIST_COUNT         4294967295
LOG FILE           LOG062
MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
MESSAGEFILE LANG   US English
MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
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

