core/sql/regress/newregr/triggers/cidefs

-- @@@ 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 @@@
--	This is the sqlci analogue of the shell-script "setupenv".

set SCHEMA $$TEST_SCHEMA$$;
-- control query default HIST_USE_SAMPLE_FOR_CARDINALITY_ESTIMATION  'ON';
-- control query default HIST_ON_DEMAND_STATS_SIZE '10000';

-- Define a standard physical environment for the compiler:
control query default TARGET_CODE 'DEBUG';
control query default TARGET_CPU_FREQUENCY '199.';
control query default TARGET_IO_SEEK_TIME '0.020147';
control query default TARGET_IO_SEQ_READ_RATE '2.5';
control query default TARGET_MSG_LOCAL_RATE '10.';
control query default TARGET_MSG_LOCAL_TIME '0.000125';
control query default TARGET_MSG_REMOTE_RATE '100.';
control query default TARGET_MSG_REMOTE_TIME  '0.00125';

control query default ARKCMP_FAKE_HW 'ON';

control query default SKIP_METADATA_VIEWS 'ON';

#ifMX
control query default REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT 'ON';
#ifMX

control query default DEF_NUM_SMP_CPUS 
#ifMX
'2'
#ifMX
#ifMP
'1'
#ifMP
;

control query default MAX_ESPS_PER_CPU_PER_OP '1';

control query default DEF_NUM_NODES_IN_ACTIVE_CLUSTERS
#ifMX
'1'
#ifMX
#ifMP
'2'
#ifMP
;

-- Suppress the Row Format information from the SHOWDDL output so
-- we don't have to update hundreds of existing Expected Results
-- files in our regression test suites.  'OFF' is the default.
control query default SQLMX_SHOWDDL_SUPPRESS_ROW_FORMAT 'ON';

-- this is the datavol location of the second partition
-- for partitioned tables.
#ifNSK
set pattern $$partition$$  $DATA04;
set pattern $$partition1$$ $DATA01;
set pattern $$partition2$$ $DATA05;
set pattern $$partition3$$ $DATA03;

-- for triggers tests
set pattern $$TrigTempTablePartition$$  '''$DATA03:$DATA04,$DATA05:$DATA01''';
set pattern $$TrigTempTablePartition1$$ '''$DATA01:$DATA04''';
set pattern $$TrigTempTablePartition2$$ '''$DATA01''';
set pattern $$TrigTempTablePartition3$$ '''$DATA04''';
set pattern $$TrigTempTablePartition4$$ '''$DATA01,$DATA04,$NINEX:$DATA05''';
set pattern $$TrigTempTablePartition5$$ '''$DATA05,$DATA05,$DATA05:$DATA05,$DATA05''';
set pattern $$TrigTempTablePartition6$$ '''$DATA01,XXXX64 $DATA05''';


#ifNSK

#ifNT
set pattern $$partition$$ $DATA;
set pattern $$partition1$$ $DATA1;
set pattern $$partition2$$ $DATA2;
set pattern $$partition3$$ $SYSTEM;

-- for triggers tests
set pattern $$TrigTempTablePartition$$  '''$system:$data1,$data2:$data''';
set pattern $$TrigTempTablePartition1$$ '''$data:$data1''';
set pattern $$TrigTempTablePartition2$$ '''$data''';
set pattern $$TrigTempTablePartition3$$ '''$data1''';
set pattern $$TrigTempTablePartition4$$ '''$data,$data1,$nonex:$data2''';
set pattern $$TrigTempTablePartition5$$ '''$data2,$data2,$data2:$data2,$data2''';
set pattern $$TrigTempTablePartition6$$ '''$data,XXXX64 $data2''';

#ifNT

-- This pattern is needed for both NSK and NT to handle the quote in Metadata
-- queries
set pattern $$quote$$ '''';

-- This CQD is added for creating a table  with no 
-- partition or primary key when the POS is enabled.
control query default POS_ALLOW_NON_PK_TABLES 'ON';
--control query default detailed_statistics 'ALL';


-- Only on a Linux cluster
#ifdef CLUSTERNAME
set pattern $$partition$$  $DB0000;
set pattern $$partition0$$ $DB0000;
set pattern $$partition1$$ $DB0001;
set pattern $$partition2$$ $DB0002;
set pattern $$partition3$$ $DB0003;
set pattern $$partition4$$ $DB0004;
set pattern $$partition5$$ $DB0005;
set pattern $$partition6$$ $DB0006;
set pattern $$partition7$$ $DB0007;
set pattern $$partition8$$ $DB0008;
set pattern $$audit_vol$$  $AUD000;
set pattern $$PosTablePartition$$ '''$DB0000''';
set pattern $$PosTablePartitions2$$ '''$DB0001, $DB0002''';
set pattern $$PosTablePartitions3$$ '''$DB0003, $DB0004, $DB0005''';
set pattern $$PosTablePartitions4$$ '''$DB0006, $DB0007, $DB0008, $DB0009''';
set pattern $$TrigTempTablePartition$$ '''$DB0003:$DB0004,$DB0005:$DB0001''';
set pattern $$TrigTempTablePartition1$$ '''$DB0001: $DB0004''';
set pattern $$TrigTempTablePartition2$$ '''$DB0001''';
set pattern $$TrigTempTablePartition3$$ '''$DB0004''';
set pattern $$TrigTempTablePartition4$$ '''$DB0001, $DB0004,$NINEX: $DB0005''';
set pattern $$TrigTempTablePartition5$$ '''$DB0005, $DB0005, $DB0005: $DB0005, $DB0005''';
set pattern $$TrigTempTablePartition6$$ '''$DB0001,XXXX64 $DB0005''';
#endif
-- eof