http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/core/TEST020 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/TEST020 b/core/sql/regress/core/TEST020 index be9f6f7..20c5388 100755 --- a/core/sql/regress/core/TEST020 +++ b/core/sql/regress/core/TEST020 @@ -408,12 +408,8 @@ operator --QUERY 19 -- Solution 10-060524-6738. Make sure "explain" with access options --- work. This also turns off the fast_dp2_subset_opt option so the --- plans are identical under Windows and NSK. This is only tested --- under MX because the output is easier to deal with, and this test --- is mainly to ensure that the parser deals with the syntax correctly. +-- work. #ifMX -control query default fast_dp2_subset_opt 'off'; explain options 'f' select * from TAB1 where col1 < 15 for serializable access; #ifMX
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/core/TESTRTS ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/TESTRTS b/core/sql/regress/core/TESTRTS index 7997941..59c4cd6 100755 --- a/core/sql/regress/core/TESTRTS +++ b/core/sql/regress/core/TESTRTS @@ -214,6 +214,7 @@ display qid for s1; log; sh $scriptsdir/tools/run_rts.ksh EXPLAIN; log LOGRTS; +control query default explain_in_rms reset; -- TEST for index name - Soln 10-090330-0390 create index tstati on tstat(d); http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/fullstack2/EXPECTED062 ---------------------------------------------------------------------- diff --git a/core/sql/regress/fullstack2/EXPECTED062 b/core/sql/regress/fullstack2/EXPECTED062 index 632a84d..9744343 100644 --- a/core/sql/regress/fullstack2/EXPECTED062 +++ b/core/sql/regress/fullstack2/EXPECTED062 @@ -440,10 +440,6 @@ Current DEFAULTS *** 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 @@ -490,13 +486,8 @@ CONTROL QUERY DEFAULT 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. @@ -517,7 +508,6 @@ CONTROL QUERY DEFAULT TRAF_INDEX_CREATE_OPT ON SHOWCONTROL_SHOW_ALL ON DEF_CHUNK_SIZE 1000 - CPUCOST_DM_GET .001 SCHEMA TRAFODION.SCH TIMEOUT 144 @@ -537,7 +527,6 @@ CONTROL QUERY DEFAULT TRAF_INDEX_CREATE_OPT ON SHOWCONTROL_SHOW_ALL ON DEF_CHUNK_SIZE 1000 - CPUCOST_DM_GET .001 SCHEMA TRAFODION.SCH TIMEOUT 6000 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/fullstack2/TEST062 ---------------------------------------------------------------------- diff --git a/core/sql/regress/fullstack2/TEST062 b/core/sql/regress/fullstack2/TEST062 index 4a56c13..353537f 100755 --- a/core/sql/regress/fullstack2/TEST062 +++ b/core/sql/regress/fullstack2/TEST062 @@ -100,12 +100,10 @@ control query default def_chunk_size ''; -- 2055 control query default def_chunk_size '1000'; control query default def_chunk_size '-1000'; -- 2055 control query default def_chunk_size '1.5e+12'; -- 2055 -control query default CPUCOST_DM_GET '1.5e+12'; -- valid showcontrol query default def_chunk; showcontrol all zzfoo; -- no settings in effect; no attr showcontrol query default def_chunk; showcontrol query default; -control query default CPUCOST_DM_GET ''; -- valid (revert to orig deflt) set schema $$TEST_SCHEMA$$; -- revert to original regress setting control query default timeout '144'; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/hive/EXPECTED002 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED002 b/core/sql/regress/hive/EXPECTED002 index e6dcd36..dffa70a 100644 --- a/core/sql/regress/hive/EXPECTED002 +++ b/core/sql/regress/hive/EXPECTED002 @@ -90,16 +90,16 @@ hdfsBufSize_ = 3072, rangeTailIOSize_ = 16636, hdfsSqlMaxRecLen_ = 8 >>prepare s1 from select count(*) from hive.store_sales; --- SQL command prepared. ->>explain options 'f' s1; +>>explain options 'fc' s1; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- -4 . 5 root 1.00E+000 -3 . 4 sort_partial_aggr_ro 1.00E+000 -2 . 3 esp_exchange 1:2(hash2) 1.00E+000 -1 . 2 sort_partial_aggr_le 1.00E+000 -. . 1 hive_scan STORE_SALES 2.92E+006 +4 . 5 root 1.00E+002 +3 . 4 sort_partial_aggr_ro 1.00E+002 +2 . 3 esp_exchange #:#(hash2) 1.00E+002 +1 . 2 sort_partial_aggr_le 1.00E+002 +. . 1 hive_scan STORE_SALES 1.00E+002 --- SQL operation complete. >>execute s1; @@ -213,16 +213,16 @@ hdfsBufSize_ = 32768, rangeTailIOSize_ = 16636, hdfsSqlMaxRecLen_ = 8 >>prepare s1 from select count(*) from hive.store_sales; --- SQL command prepared. ->>explain options 'f' s1; +>>explain options 'fc' s1; LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- -4 . 5 root 1.00E+000 -3 . 4 sort_partial_aggr_ro 1.00E+000 -2 . 3 esp_exchange 1:2(hash2) 1.00E+000 -1 . 2 sort_partial_aggr_le 1.00E+000 -. . 1 hive_scan STORE_SALES 2.92E+006 +4 . 5 root 1.00E+002 +3 . 4 sort_partial_aggr_ro 1.00E+002 +2 . 3 esp_exchange #:#(hash2) 1.00E+002 +1 . 2 sort_partial_aggr_le 1.00E+002 +. . 1 hive_scan STORE_SALES 1.00E+002 --- SQL operation complete. >>execute s1; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/hive/TEST002 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/TEST002 b/core/sql/regress/hive/TEST002 index 081d5e6..860f963 100644 --- a/core/sql/regress/hive/TEST002 +++ b/core/sql/regress/hive/TEST002 @@ -58,7 +58,7 @@ select count(*) from time_dim ; cqd hive_max_esps '2'; prepare s1 from select count(*) from hive.store_sales; -explain options 'f' s1; +explain options 'fc' s1; execute s1; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/udr/EXPECTED107.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED107.SB b/core/sql/regress/udr/EXPECTED107.SB index 57af4b6..03f5851 100644 --- a/core/sql/regress/udr/EXPECTED107.SB +++ b/core/sql/regress/udr/EXPECTED107.SB @@ -905,9 +905,6 @@ NUM_LOOKUPS NUM_CACHE_HITS NUM_ENTRIES MAX_CACHE_SIZE >>----------------------------------------------------------------------------- >>-- COLLATION >>----------------------------------------------------------------------------- ->>control query default COMP_BOOL_215 'ON'; - ---- SQL operation complete. >>control query default ROUTINE_CACHE_SIZE '0'; --- SQL operation complete. @@ -980,9 +977,6 @@ DEFAULT >>cqd query_cache 'reset'; --- SQL operation complete. ->>control query default COMP_BOOL_215 reset; - ---- SQL operation complete. >>control query default ROUTINE_CACHE_SIZE reset; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/udr/TEST107 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/TEST107 b/core/sql/regress/udr/TEST107 index 8b91277..c63440a 100644 --- a/core/sql/regress/udr/TEST107 +++ b/core/sql/regress/udr/TEST107 @@ -417,7 +417,6 @@ select num_lookups, num_cache_hits, num_entries, max_cache_size from table(narou ----------------------------------------------------------------------------- -- COLLATION ----------------------------------------------------------------------------- -control query default COMP_BOOL_215 'ON'; control query default ROUTINE_CACHE_SIZE '0'; control query default QUERY_CACHE '0'; @@ -449,7 +448,6 @@ deterministic no sql final call allow any parallelism state area size 1024 ; values(getCollation('ghi')); cqd query_cache 'reset'; -control query default COMP_BOOL_215 reset; control query default ROUTINE_CACHE_SIZE reset; control query default QUERY_CACHE reset; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/sqlcomp/DefaultConstants.h ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/DefaultConstants.h b/core/sql/sqlcomp/DefaultConstants.h index 9fb5d22..6293539 100644 --- a/core/sql/sqlcomp/DefaultConstants.h +++ b/core/sql/sqlcomp/DefaultConstants.h @@ -98,7 +98,6 @@ enum DefaultConstants CPUCOST_EXCHANGE_COST_PER_BYTE, CPUCOST_EXCHANGE_INTERNODE_COST_PER_BYTE, CPUCOST_EXCHANGE_REMOTENODE_COST_PER_BYTE, - CPUCOST_EXCHANGE_COST_PER_ROW, // Used in CostPrimitives::cpuCostForCopySet(). CPUCOST_COPY_SIMPLE_DATA_TYPE, @@ -110,7 +109,6 @@ enum DefaultConstants CPUCOST_EVAL_FUNC_DEFAULT, // Used in CostPrimitives::cpuCostForEvalPred(). - CPUCOST_EVAL_LOGICAL_OP, CPUCOST_EVAL_SIMPLE_PREDICATE, // Used in CostPrimitives::cpuCostForLikeCompare(). @@ -148,16 +146,11 @@ enum DefaultConstants // existed; although it's currently commented out, many have associated // comments (which I (Martin) can't decide if they're vital or not). // ----------------------------------------------------------------------- - CPUCOST_DM_GET, // Cost.h - CPUCOST_DM_UPDATE, // Cost.h CPUCOST_ESP_INITIALIZATION, // Cost.h - CPUCOST_EXCHANGE_MAPPING_FUNCTION, // Cost.h - CPUCOST_EXCHANGE_SPLIT_FUNCTION, // Cost.h CPUCOST_LOCK_ROW, // Cost.h CPUCOST_PREDICATE_COMPARISON, // Cost.h CPUCOST_SUBSET_OPEN, // Cost.h CPUCOST_SUBSET_OPEN_AFTER_FIRST, // Cost.h - CPUCOST_TUPLE_REFERENCE, // Cost.h DP2_MESSAGE_BUFFER_SIZE, // Cost.h LOCAL_MESSAGE_BUFFER_SIZE, // Cost.h OS_MESSAGE_BUFFER_SIZE, // Cost.h @@ -172,7 +165,6 @@ enum DefaultConstants DP2_CACHE_4096_BLOCKS, // The size of the DP2 cache in KB: - DP2_CACHE_SIZE_IN_KB, // Constants needed to estimate the cost of communication // between DP2 and exeInDp2: @@ -190,15 +182,10 @@ enum DefaultConstants // BASE is the memory used by tmf, nsk-l and NT // DAM is the memory used by each DP2 // MINIMUM_HASH is the least amount of memory we will use - CONFIGURED_MEMORY_FOR_BASE, - CONFIGURED_MEMORY_FOR_DAM, - CONFIGURED_MEMORY_FOR_MINIMUM_HASH, - CONFIGURED_MEMORY_FOR_MXESP, // This is an executor constant used in costing, // as of 3/23/98 it is 12 bytes. Change when executor // changes. - COST_TUPP_DESC_LENGTH_IN_KB, // Used in estimating blocks to read per scan access: COST_PROBE_DENSITY_THRESHOLD, @@ -224,12 +211,9 @@ enum DefaultConstants // less expensive. Take this into account using the // the IO_SEEKS_INORDER_FACTOR, a number greater // than zero and less than or equal to 1: - IO_SEEKS_INORDER_FACTOR, // Used in sqlcomp/NADefaults.cpp - DEFAULTS_TABLE_ACCESS_WARNINGS, - NEXT_DEFAULTS_TABLE, DEF_CHUNK_SIZE, DEF_CPU_ARCHITECTURE, @@ -249,18 +233,15 @@ enum DefaultConstants // to generate detailed executor statitics DETAILED_STATISTICS, - DP2_BLOCK_HEADER_SIZE, // Used in Exchange costing. DP2_END_OF_BUFFER_HEADER_SIZE, DP2_EXCHANGE_REQUEST_SIZE, - DP2_FRACTION_SEEK_FROM_RANDOM_TO_INORDER, DP2_MAX_READ_PER_ACCESS_IN_KB, DP2_MESSAGE_HEADER_SIZE, DP2_MESSAGE_HEADER_SIZE_BYTES, DP2_MINIMUM_FILE_SIZE_FOR_SEEK_IN_BLOCKS, - MAX_CHAR_PARAM_DEFAULT_SIZE, MAX_DEPTH_TO_CHECK_FOR_CYCLIC_PLAN, MAX_LONG_VARCHAR_DEFAULT_SIZE, @@ -274,20 +255,14 @@ enum DefaultConstants EX_OP_ALLOCATE_BUFFER_POOL, EX_OP_ALLOCATE_BUFFER, EX_OP_ALLOCATE_TUPLE, - EX_OP_ALLOCATE_ATP, EX_OP_COPY_ATP, - EX_OP_ENQUEUE, - EX_OP_DEQUEUE, // optimization of data movement in DP2 - FAST_DP2_SUBSET_OPT, - FAST_REPLYDATA_MOVE, FIND_COMMON_SUBEXPRS_IN_OR, FLOAT_ESP_RANDOM_NUM_SEED, - FFDC_DIALOUTS_FOR_MXCMP, // Special handling for forcing Bushy CQS, for shapes generated by the wizard FORCE_BUSHY_CQS, @@ -299,20 +274,12 @@ enum DefaultConstants // buffer size, number of buffers, and queue sizes (down, up). // -------------------------------------------------------------------------- // Create buf. - GEN_CBUF_BUFFER_SIZE, - GEN_CBUF_NUM_BUFFERS, - GEN_CBUF_SIZE_DOWN, - GEN_CBUF_SIZE_UP, // DDL. GEN_DDL_BUFFER_SIZE, GEN_DDL_NUM_BUFFERS, GEN_DDL_SIZE_DOWN, GEN_DDL_SIZE_UP, // Delete. - GEN_DEL_BUFFER_SIZE, - GEN_DEL_NUM_BUFFERS, - GEN_DEL_SIZE_DOWN, - GEN_DEL_SIZE_UP, // Describe. GEN_DESC_BUFFER_SIZE, GEN_DESC_NUM_BUFFERS, @@ -324,40 +291,16 @@ enum DefaultConstants GEN_DP2I_SIZE_DOWN, GEN_DP2I_SIZE_UP, // DP2 Delete Unique. - GEN_DPDU_BUFFER_SIZE, - GEN_DPDU_NUM_BUFFERS, - GEN_DPDU_SIZE_DOWN, - GEN_DPDU_SIZE_UP, // DP2 Range Operator. - GEN_DPRO_BUFFER_SIZE, - GEN_DPRO_NUM_BUFFERS, - GEN_DPRO_SIZE_DOWN, - GEN_DPRO_SIZE_UP, // DP2 Subset Operator. GEN_DPSO_BUFFER_SIZE, - GEN_DPSO_NUM_BUFFERS, GEN_DPSO_SIZE_DOWN, GEN_DPSO_SIZE_UP, // DP2 Unique Operator. - GEN_DPUO_BUFFER_SIZE, GEN_DPUO_NUM_BUFFERS, - GEN_DPUO_SIZE_DOWN, - GEN_DPUO_SIZE_UP, // DP2 VSBB Insert. - GEN_DPVI_BUFFER_SIZE, - GEN_DPVI_NUM_BUFFERS, - GEN_DPVI_SIZE_DOWN, - GEN_DPVI_SIZE_UP, // Executor in DP2. - GEN_EIDR_BUFFER_SIZE, - GEN_EIDR_NUM_BUFFERS, - GEN_EIDR_SIZE_DOWN, - GEN_EIDR_SIZE_UP, // Fast Sort. - GEN_FSRT_BUFFER_SIZE, - GEN_FSRT_NUM_BUFFERS, - GEN_FSRT_SIZE_DOWN, - GEN_FSRT_SIZE_UP, // Hash GroupBy. GEN_HGBY_BUFFER_SIZE, GEN_HGBY_NUM_BUFFERS, @@ -369,25 +312,9 @@ enum DefaultConstants GEN_HSHJ_SIZE_DOWN, GEN_HSHJ_SIZE_UP, // Index Maintenance. - GEN_IMDT_BUFFER_SIZE, - GEN_IMDT_NUM_BUFFERS, - GEN_IMDT_SIZE_DOWN, - GEN_IMDT_SIZE_UP, // Insert. - GEN_INS_BUFFER_SIZE, - GEN_INS_NUM_BUFFERS, - GEN_INS_SIZE_DOWN, - GEN_INS_SIZE_UP, // Lock. - GEN_LOCK_BUFFER_SIZE, - GEN_LOCK_NUM_BUFFERS, - GEN_LOCK_SIZE_DOWN, - GEN_LOCK_SIZE_UP, // Materialize. - GEN_MATR_BUFFER_SIZE, - GEN_MATR_NUM_BUFFERS, - GEN_MATR_SIZE_DOWN, - GEN_MATR_SIZE_UP, // Memory pressure Threshold GEN_MEM_PRESSURE_THRESHOLD, // Merge Join. @@ -403,46 +330,24 @@ enum DefaultConstants // Partition Access. GEN_PA_BUFFER_SIZE, GEN_PA_NUM_BUFFERS, - GEN_PA_SIZE_DOWN, - GEN_PA_SIZE_UP, // Recurse. - GEN_RCRS_BUFFER_SIZE, - GEN_RCRS_NUM_BUFFERS, - GEN_RCRS_SIZE_DOWN, - GEN_RCRS_SIZE_UP, // Root. - GEN_ROOT_BUFFER_SIZE, - GEN_ROOT_NUM_BUFFERS, - GEN_ROOT_SIZE_DOWN, - GEN_ROOT_SIZE_UP, // Sample node - GEN_SAMPLE_BUFFER_SIZE, - GEN_SAMPLE_NUM_BUFFERS, GEN_SAMPLE_SIZE_DOWN, GEN_SAMPLE_SIZE_UP, // Scan. - GEN_SCAN_BUFFER_SIZE, - GEN_SCAN_NUM_BUFFERS, - GEN_SCAN_SIZE_DOWN, - GEN_SCAN_SIZE_UP, // Sequence Functions GEN_SEQFUNC_BUFFER_SIZE, GEN_SEQFUNC_NUM_BUFFERS, GEN_SEQFUNC_SIZE_DOWN, GEN_SEQFUNC_SIZE_UP, - GEN_SEQFUNC_UNLIMITED_HISTORY, // Sequence. - GEN_SEQ_BUFFER_SIZE, - GEN_SEQ_NUM_BUFFERS, - GEN_SEQ_SIZE_DOWN, - GEN_SEQ_SIZE_UP, // Sort GroupBy. GEN_SGBY_BUFFER_SIZE, GEN_SGBY_NUM_BUFFERS, GEN_SGBY_SIZE_DOWN, GEN_SGBY_SIZE_UP, // Send Bottom. - GEN_SNDB_BUFFER_SIZE, GEN_SNDB_NUM_BUFFERS, GEN_SNDB_SIZE_DOWN, GEN_SNDB_SIZE_UP, @@ -455,25 +360,13 @@ enum DefaultConstants GEN_SNDT_SIZE_UP, // Sort. GEN_SORT_MAX_BUFFER_SIZE, - GEN_SORT_MIN_BUFFER_SIZE, GEN_SORT_NUM_BUFFERS, GEN_SORT_SIZE_DOWN, GEN_SORT_SIZE_UP, // Split Bottom. - GEN_SPLB_BUFFER_SIZE, - GEN_SPLB_NUM_BUFFERS, - GEN_SPLB_SIZE_DOWN, - GEN_SPLB_SIZE_UP, // Split Top. - GEN_SPLT_BUFFER_SIZE, - GEN_SPLT_NUM_BUFFERS, - GEN_SPLT_SIZE_DOWN, GEN_SPLT_SIZE_UP, // Stored Procedure. - GEN_STPR_BUFFER_SIZE, - GEN_STPR_NUM_BUFFERS, - GEN_STPR_SIZE_DOWN, - GEN_STPR_SIZE_UP, // Tuple Flow. GEN_TFLO_BUFFER_SIZE, GEN_TFLO_NUM_BUFFERS, @@ -503,25 +396,13 @@ enum DefaultConstants GEN_TUPL_SIZE_DOWN, GEN_TUPL_SIZE_UP, // Unordered NLJ. - GEN_UNLJ_BUFFER_SIZE, - GEN_UNLJ_NUM_BUFFERS, - GEN_UNLJ_SIZE_DOWN, - GEN_UNLJ_SIZE_UP, // Union. GEN_UN_BUFFER_SIZE, GEN_UN_NUM_BUFFERS, GEN_UN_SIZE_DOWN, GEN_UN_SIZE_UP, // Update. - GEN_UPD_BUFFER_SIZE, - GEN_UPD_NUM_BUFFERS, - GEN_UPD_SIZE_DOWN, - GEN_UPD_SIZE_UP, // Explain. - GEN_XPLN_BUFFER_SIZE, - GEN_XPLN_NUM_BUFFERS, - GEN_XPLN_SIZE_DOWN, - GEN_XPLN_SIZE_UP, // Compound Stmt. GEN_CS_BUFFER_SIZE, GEN_CS_NUM_BUFFERS, @@ -546,8 +427,6 @@ enum DefaultConstants // Enable 'ON' or disable 'OFF' considering hash joins of any form // ------------------------------------------------------------------------- HASH_JOINS, - HASH_JOINS_TYPE1_PLAN1, - HASH_JOINS_TYPE1_PLAN2, // ------------------------------------------------------------------------- // For HashGroupBy. @@ -627,7 +506,6 @@ enum DefaultConstants HIST_ROWCOUNT_REQUIRING_STATS, - HIST_SAME_TABLE_PRED_REDUCTION, //jbbsubset that specifies the root of the tree //for which we want to check the histograms @@ -655,7 +533,6 @@ enum DefaultConstants // HIST_PREFETCH controls if histograms are prefetched by ustat method FetchStatistics. // Valid values are 'ON' / 'OFF' DYNAMIC_HISTOGRAM_COMPRESSION, - HIST_BASE_REDUCTION, HIST_INTERMEDIATE_REDUCTION, HIST_BASE_REDUCTION_FUDGE_FACTOR, HIST_INTERMEDIATE_REDUCTION_FUDGE_FACTOR, @@ -669,9 +546,7 @@ enum DefaultConstants USTAT_ADD_SALTED_KEY_PREFIXES_FOR_MC, // Generate MCs for primary key prefixes as well as full key of // salted table when ON EVERY KEY or ON EVERY COLUMN is specified. USTAT_ATTEMPT_ESP_PARALLELISM, // use parallel plans for reading columns to form histograms - USTAT_CHECK_HIST_ACCURACY, // After stats collection, examine full table and calculate accuray of hists USTAT_COMPACT_VARCHARS, // For internal sort, store only the actual # chars used in each value - USTAT_CLUSTER_SAMPLE_BLOCKS, // number of blocks for cluster sampling USTAT_DELETE_NO_ROLLBACK, // If ON, use DELETE WITH NO ROLLBACK in incremental stats when updating sample table USTAT_ESTIMATE_HBASE_ROW_COUNT, // If ON, estimate row count of HBase table instead of count(*), subject // to USTAT_MIN_ESTIMATE_FOR_ROWCOUNT setting) @@ -679,7 +554,6 @@ enum DefaultConstants USTAT_HBASE_SAMPLE_RETURN_INTERVAL, // When sampling in HBase, adjust sampling rate to return once // on average once per this many rows USTAT_JIT_LOGGING, // Use just-in-time logging when error occurs - USTAT_LOCK_HIST_TABLES, // Force lock of hist tables during FlushStatistics() to // avoid deadlock for concurrent Update Stats on same table USTAT_LOG, // Generate USTAT log and write to file specified USTAT_MIN_ESTIMATE_FOR_ROWCOUNT, // Minimum estimated rowcount to be accepted @@ -691,11 +565,9 @@ enum DefaultConstants USTAT_UEC_LOW_RATIO, // between HI_RATIO and LOW_RATIO, we will avoid // calling xValue() to find the root value. USTAT_USE_BACKING_SAMPLE, // Use Hive persistent sample table instead of reading from full table. @ZXtemp - USTAT_USE_SIDETREE_INSERT, // Use sidetree insert when populating scratch table USTAT_USE_SLIDING_SAMPLE_RATIO, // Vary sampling rate according to table size USTAT_AUTOMATION_INTERVAL, // set the ustat automation interval USTAT_MAX_READ_AGE_IN_MIN, // criterion for 'recently read histogram' - USTAT_OBSOLETE_PERCENT_ROWCOUNT, // percentage change in rowcount constituting obsolescence USTAT_COLLECT_FILE_STATS, // do we collect file stats USTAT_USE_IS_WHEN_NO_STATS, // use IS when no histograms exist for the column USTAT_CQDS_ALLOWED_FOR_SPAWNED_COMPILERS, // list of CQDs that can be pushed to seconday compilers @@ -711,18 +583,13 @@ enum DefaultConstants HH_OP_ALLOCATE_HASH_TABLE, HH_OP_PROBE_HASH_TABLE, // ref head of hash chain given a hash value HH_OP_INSERT_ROW_TO_CHAIN, // insert a row in a hash chain - HH_OP_ALLOCATE_CLUSTERDB, // allocate a ClusterDB object - HH_OP_ALLOCATE_CLUSTER, // allocate a Cluster object - HH_OP_ALLOCATE_BUCKET_ARRAY, // allocate an array of Bucket objects - HH_OP_READ_HASH_BUFFER, // reading a hash buffer - HH_OP_WRITE_HASH_BUFFER, // writing a hash buffer HH_OP_HASHED_ROW_OVERHEAD, // no of bytes to store hash value and pointer // ------------------------------------------------------------------------- // For HashJoin. // ------------------------------------------------------------------------- HJ_CPUCOST_INITIALIZE, - HJ_BUFFER_SIZE, + // HJ_BUFFER_SIZE, HJ_INITIAL_BUCKETS_PER_CLUSTER, HJ_SCAN_TO_NJ_PROBE_SPEED_RATIO, HJ_TYPE, @@ -774,7 +641,6 @@ enum DefaultConstants // For MergeJoin. // ------------------------------------------------------------------------- MJ_CPUCOST_INITIALIZE, - MJ_CPUCOST_ALLOCATE_LIST, MJ_CPUCOST_INSERT_ROW_TO_LIST, MJ_CPUCOST_REWIND_LIST, MJ_CPUCOST_GET_NEXT_ROW_FROM_LIST, @@ -786,7 +652,6 @@ enum DefaultConstants // (Resource-to-time multipliers are environment dependant) // ------------------------------------------------------------------------- MSCF_ET_CPU, - MSCF_ET_NM_PAGE_FAULTS, // normal memory page faults MSCF_ET_NUM_IO_SEEKS, // count of Random I/Os MSCF_ET_IO_TRANSFER, // KB transfer MSCF_ET_NUM_LOCAL_MSGS, @@ -829,13 +694,7 @@ enum DefaultConstants // in the calculation for overlapped addition // ------------------------------------------------------------------------- MSCF_OV_IO, - MSCF_OV_IO_TRANSFER, // KB transfer - MSCF_OV_LOCAL_MSG_TRANSFER, // KB transfer MSCF_OV_MSG, - MSCF_OV_NUM_IO_SEEKS, // count of Random I/Os - MSCF_OV_NUM_LOCAL_MSGS, - MSCF_OV_NUM_REMOTE_MSGS, - MSCF_OV_REMOTE_MSG_TRANSFER, // KB transfer // ------------------------------------------------------------------------- // Factors used in determining how much concurrency occurs between @@ -844,8 +703,6 @@ enum DefaultConstants // another (whether parent, child, or sibling) operator that is // executing concurrently. // ------------------------------------------------------------------------- - MSCF_CONCURRENCY_IO, - MSCF_CONCURRENCY_MSG, // ------------------------------------------------------------------------- // Factors that describe the current hardware/system platform. To @@ -860,9 +717,6 @@ enum DefaultConstants // Do you have Any opinion regarding Which class should be used to // provide the needed information?? // ------------------------------------------------------------------------- - MSCF_SYS_MEMORY_PER_CPU, - MSCF_SYS_DISKS, - MSCF_SYS_TEMP_SPACE_PER_DISK, // ----------------------------------------------------------------------- // Big memory usage @@ -883,7 +737,6 @@ enum DefaultConstants MV_AGE, // timestamp default is 0 MV_ALLOW_SELECT_SYSTEM_ADDED_COLUMNS, // ON/OFF default is OFF MV_AS_ROW_TRIGGER, // YES/NO default is NO - MV_AUTOMATIC_LOGGABLE_COLUMN_MAINTENANCE, // ON/OFF default ON MV_ENABLE_INTERNAL_REFRESH_SHOWPLAN, // internal only - enable showplan for IR MV_LOG_PUSH_DOWN_DP2_INSERT, // push down mv logging tp dp2 for insert MV_LOG_PUSH_DOWN_DP2_DELETE, // push down mv logging tp dp2 for delete @@ -899,12 +752,9 @@ enum DefaultConstants MVQR_ALL_JBBS_IN_QD, // add JBBs to query descriptor even if criteria // not met. Used for testing descriptors. MVQR_ENABLE_LOGGING, // Use log files. Temporary until Log4CXX. - MVQR_FILENAME_PREFIX, // path/prefix of files to dump descriptors to MVQR_LOG_QUERY_DESCRIPTORS, // whether or not to log query descriptors - MVQR_MAX_MV_JOIN_SIZE, // max # joins for publishable MV MVQR_PARAMETERIZE_EQ_PRED, // whether or not to parameterize equality MVQR_PRIVATE_QMS_INIT, // how to init private qms: SMD, XML, NONE (default) - MVQR_PUBLISH_TABLE_LOCATION, // MV query rewrite publish table location MVQR_PUBLISH_TO, // PRIVATE(default) qms, PUBLIC qms, BOTH MVQR_REWRITE_CANDIDATES, // list of MVs by MV qualified names MVQR_REWRITE_ENABLED_OPTION, // establishes default for MVs that don't state @@ -995,12 +845,10 @@ enum DefaultConstants COMP_BOOL_3, COMP_BOOL_4, COMP_BOOL_5, - COMP_BOOL_6, COMP_BOOL_7, COMP_BOOL_8, COMP_BOOL_9, - COMP_INT_1, COMP_INT_2, COMP_INT_3, COMP_INT_4, @@ -1012,7 +860,6 @@ enum DefaultConstants COMP_STRING_1, COMP_STRING_2, - COMP_STRING_3, //------------------------------------------------------------------------ // Do the query analysis phase, building JBBs, TCG, QGs, and ASM. //------------------------------------------------------------------------ @@ -1038,12 +885,10 @@ enum DefaultConstants //------------------------------------------------------------------------ // MultiJoin complexity threshold //------------------------------------------------------------------------ - MULTI_JOIN_QUERY_COMPLEXITY_THRESHOLD, //------------------------------------------------------------------------ // MultiJoin work threshold //------------------------------------------------------------------------ - MULTI_JOIN_QUERY_WORK_THRESHOLD, //------------------------------------------------------------------------ // Specifies if ASM cache should be available. @@ -1192,8 +1037,6 @@ enum DefaultConstants // Partition Management. // Number of rows processed per transaction. // ----------------------------------------------------------------------- - PM_OFFLINE_TRANSACTION_GRANULARITY, - PM_ONLINE_TRANSACTION_GRANULARITY, //-------------------------------------------------------------------------- // The group by reduction for pushing a partial group by past the @@ -1236,9 +1079,7 @@ enum DefaultConstants //-------------------------------------------------------------------------- // Partition Overlay Support (POS) options //-------------------------------------------------------------------------- - POS_LOCATIONS, POS_NUM_OF_PARTNS, - POS_RAISE_ERROR, //-------------------------------------------------------------------------- // Query Caching options @@ -1263,12 +1104,10 @@ enum DefaultConstants // The default is FALSE. // ------------------------------------------------------------------------ READONLY_CURSOR, - REMOTE_ESP_ALLOCATION, // ------------------------------------------------------------------------- // Pass an indicator of stream's idleness in a diagnostics area. // ------------------------------------------------------------------------- - RETURN_AVG_STREAM_WAIT, // multiplicative factor used to inflate cost of risky operators. RISK_PREMIUM_MJ, @@ -1282,7 +1121,6 @@ enum DefaultConstants // ------------------------------------------------------------------------ // For Drop Table // ------------------------------------------------------------------------- - SAVE_DROPPED_TABLE_DDL, // ------------------------------------------------------------------------- // For Scratch files @@ -1310,7 +1148,6 @@ enum DefaultConstants // ------------------------------------------------------------------------- // For Triggers Temporary Table's LOCATION and PARTITIONS // ------------------------------------------------------------------------- - TEMPORARY_TABLE_HASH_PARTITIONS, // Hash partitions for the trig temp tables // ------------------------------------------------------------------------- // For Node Maps @@ -1367,7 +1204,6 @@ enum DefaultConstants // To decide whether we should optimize a VP Join during optimization or // just expand it during pre code generation. // ------------------------------------------------------------------------- - MAX_NUM_VERT_PARTS_FOR_OPT, CATALOG, SCHEMA, @@ -1402,7 +1238,6 @@ enum DefaultConstants //How many blocks do we read ahead for a sequential scan of a file. READ_AHEAD_MAX_BLOCKS, - SYNCDEPTH, TABLELOCK, TIMEOUT, STREAM_TIMEOUT, // BertBert VV @@ -1435,7 +1270,6 @@ enum DefaultConstants // to use dense sql buffers for communication between // FS and EID. Default is ON. // If turned off, sparse sql_buffers are used. - USE_DENSE_BUFFERS, //-------------------------------------------------------------------------- @@ -1460,11 +1294,9 @@ enum DefaultConstants NSK_DBG_SHOW_PLAN_LOG, NSK_DBG_SHOW_TREE_AFTER_PRE_CODEGEN, NSK_DBG_SHOW_TREE_AFTER_CODEGEN, - NSK_DBG_STRATEGIZER, // NSK_DBG_PRINT_COST, - NSK_DBG_PRINT_COST_LIMIT, NSK_DBG_PRINT_LOG_PROP, NSK_DBG_PRINT_PHYS_PROP, NSK_DBG_PRINT_CHAR_INPUT, @@ -1479,7 +1311,6 @@ enum DefaultConstants // -------------------------------------------------------------------------- // Index creation defaults. // -------------------------------------------------------------------------- - FORCE_PARALLEL_CREATE_INDEX, // ----------------------------------------------------------------------- // for IUD operations, this default, if set, indicates that the Xn needs @@ -1503,7 +1334,6 @@ enum DefaultConstants // this default indicates the max number of rows which will be locked // when stable access is being used. Default is 32. // ---------------------------------------------------------------------- - MAX_ROWS_LOCKED_FOR_STABLE_ACCESS, // ---------------------------------------------------------------------- // User-defined routines @@ -1529,14 +1359,10 @@ enum DefaultConstants OPTIMIZER_SYNTH_FUNC_DEPENDENCIES, - COMP_BOOL_10, COMP_BOOL_11, COMP_BOOL_12, COMP_BOOL_13, COMP_BOOL_14, - COMP_BOOL_15, - COMP_BOOL_16, - COMP_BOOL_17, COMP_BOOL_18, COMP_BOOL_19, COMP_BOOL_20, @@ -1545,7 +1371,6 @@ enum DefaultConstants COMP_BOOL_23, COMP_BOOL_24, // used by generator COMP_BOOL_25, // used by generator - COMP_BOOL_26, COMP_BOOL_27, COMP_BOOL_28, COMP_BOOL_29, @@ -1562,14 +1387,12 @@ enum DefaultConstants COMP_BOOL_40, COMP_BOOL_41, COMP_BOOL_42, - COMP_BOOL_43, COMP_BOOL_44, COMP_BOOL_45, COMP_BOOL_46, COMP_BOOL_47, COMP_BOOL_48, COMP_BOOL_49, - COMP_BOOL_50, COMP_BOOL_51, COMP_BOOL_52, COMP_BOOL_53, @@ -1577,7 +1400,6 @@ enum DefaultConstants COMP_BOOL_55, COMP_BOOL_56, COMP_BOOL_57, - COMP_BOOL_58, COMP_BOOL_59, COMP_BOOL_60, COMP_BOOL_61, @@ -1608,7 +1430,6 @@ enum DefaultConstants COMP_BOOL_86, COMP_BOOL_87, COMP_BOOL_88, - COMP_BOOL_89, COMP_BOOL_90, COMP_BOOL_91, // used by generator COMP_BOOL_92, @@ -1621,7 +1442,6 @@ enum DefaultConstants COMP_BOOL_99, COMP_INT_0, - COMP_INT_6, COMP_INT_7, COMP_INT_8, COMP_INT_9, @@ -1633,9 +1453,7 @@ enum DefaultConstants COMP_FLOAT_7, COMP_FLOAT_8, COMP_FLOAT_9, - COMP_STRING_4, COMP_STRING_5, - COMP_STRING_6, COSTING_SHORTCUT_GROUPBY_FIX, @@ -1666,20 +1484,17 @@ enum DefaultConstants // ------------------------------------------------------------------------- REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT, - DO_RUNTIME_SPACE_OPTIMIZATION, GEN_SORT_MAX_NUM_BUFFERS, GEN_SORT_TOPN, SORT_ALGO, // Sort algorithm choice // Not used anymore. OVERRIDE_SYSKEY takes its place. - PM_REGENERATE_SYSKEY_FOR_INSERT, // ---------------------------------------------------------------------- // If enabled (ON), indicates that it is OK to compile IUD queries // against ODBC metadata tables. // ---------------------------------------------------------------------- - ODBC_METADATA_PROCESS, // ------------------------------------------------------------------------- // Specifies what percentage of smaller table in join, should be used as @@ -1697,7 +1512,6 @@ enum DefaultConstants USE_CCMPASSERT_AS_CMPASSERT, // share opens if reference count of table is greater than 5. - SHAREOPENS_ON_REFCOUNT, NEW_OPT_DRIVER, FORCE_PASS_ONE, @@ -1764,7 +1578,6 @@ enum DefaultConstants // Specifies locations for CREATE statements that don't have a // LOCATION clause - DDL_DEFAULT_LOCATIONS, //Support transactions for DDL operations. DDL_TRANSACTIONS, @@ -1782,7 +1595,6 @@ enum DefaultConstants // turn on and off olt query optimizations. Default is ON. EID_SPACE_USAGE_OPT, - DO_RUNTIME_EID_SPACE_COMPUTATION, // partition threshold to control partition size when update statistics // temporary sample table is created @@ -1822,7 +1634,6 @@ enum DefaultConstants // POS POS, - POS_FILE_OPTIONS, // how many maximum groups dp2 hash group-by operator can handle? MAX_DP2_HASHBY_GROUPS, @@ -1842,12 +1653,10 @@ enum DefaultConstants // if set to ON, then dp2 splits blocks as if inserts are sequential. // if set to ENABLE, then blocks are split depending on whether // sequential inserts are detected. - SEQUENTIAL_BLOCKSPLIT, // EMS events USER_EXPERIENCE_LEVEL, - POS_TABLE_SIZE, // Starting size of Partition Access's parent queues. DYN_PA_QUEUE_RESIZE_INIT_DOWN, @@ -1855,7 +1664,6 @@ enum DefaultConstants // if set, DDL allows users to make tables audited or unaudited. // Used to enable user issued sidetree inserts. - ALLOW_AUDIT_ATTRIBUTE_CHANGE, // if this default is set to ON, then the max precision of a numeric // expression(arithmetic, aggregate) is limited to MAX_NUMERIC_PRECISION @@ -1884,8 +1692,6 @@ enum DefaultConstants MERGE_JOIN_WITH_POSSIBLE_DEADLOCK, // priority and delta of msgs sent by fs to dp2. - DP2_PRIORITY, - DP2_PRIORITY_DELTA, ALLOW_RANGE_PARTITIONING, @@ -1900,7 +1706,6 @@ enum DefaultConstants // If this CQD is set to TRUE, POS will create HASH2 tables when hash1 // syntax is used. - POS_MAP_HASH_TO_HASH2, // Allow RequireApproximatelyNPartitions::realize() to use one of three // hash partitioning schemes: 0 - HashPartitioningFunction, @@ -1910,12 +1715,9 @@ enum DefaultConstants // Use conservative hash2 grouping OLD_HASH2_GROUPING, - MAINTAIN_UPD_STATS_SAMPLE, COMP_INT_10, COMP_INT_11, - COMP_INT_12, - COMP_INT_13, COMP_INT_14, COMP_INT_15, COMP_INT_16, @@ -1927,79 +1729,41 @@ enum DefaultConstants COMP_INT_22, COMP_INT_23, COMP_INT_24, - COMP_INT_25, COMP_INT_26, - COMP_INT_27, - COMP_INT_28, - COMP_INT_29, COMP_INT_30, COMP_INT_31, COMP_INT_32, - COMP_INT_33, COMP_INT_34, COMP_INT_35, COMP_INT_36, - COMP_INT_37, COMP_INT_38, COMP_INT_39, COMP_INT_40, - COMP_INT_41, - COMP_INT_42, COMP_INT_43, COMP_INT_44, COMP_INT_45, COMP_INT_46, COMP_INT_47, COMP_INT_48, - COMP_INT_49, COMP_INT_50, COMP_INT_51, - COMP_INT_52, - COMP_INT_53, COMP_INT_54, - COMP_INT_55, - COMP_INT_56, - COMP_INT_57, - COMP_INT_58, - COMP_INT_59, COMP_INT_60, COMP_INT_61, COMP_INT_62, COMP_INT_63, - COMP_INT_64, - COMP_INT_65, COMP_INT_66, COMP_INT_67, - COMP_INT_68, - COMP_INT_69, COMP_INT_70, COMP_INT_71, - COMP_INT_72, COMP_INT_73, COMP_INT_74, - COMP_INT_75, - COMP_INT_76, COMP_INT_77, - COMP_INT_78, COMP_INT_79, COMP_INT_80, - COMP_INT_81, - COMP_INT_82, - COMP_INT_83, - COMP_INT_84, - COMP_INT_85, - COMP_INT_86, - COMP_INT_87, - COMP_INT_88, COMP_INT_89, COMP_INT_90, - COMP_INT_91, - COMP_INT_92, - COMP_INT_93, - COMP_INT_94, COMP_INT_95, - COMP_INT_96, - COMP_INT_97, COMP_INT_98, COMP_INT_99, @@ -2008,23 +1772,19 @@ enum DefaultConstants COMP_BOOL_102, COMP_BOOL_103, COMP_BOOL_104, - COMP_BOOL_105, COMP_BOOL_106, COMP_BOOL_107, COMP_BOOL_108, - COMP_BOOL_109, COMP_BOOL_110, COMP_BOOL_111, COMP_BOOL_112, COMP_BOOL_113, - COMP_BOOL_114, COMP_BOOL_115, COMP_BOOL_116, COMP_BOOL_117, COMP_BOOL_118, COMP_BOOL_119, COMP_BOOL_120, - COMP_BOOL_121, COMP_BOOL_122, COMP_BOOL_123, COMP_BOOL_124, @@ -2045,11 +1805,8 @@ enum DefaultConstants COMP_BOOL_139, COMP_BOOL_140, COMP_BOOL_141, - COMP_BOOL_142, - COMP_BOOL_143, COMP_BOOL_144, COMP_BOOL_145, - COMP_BOOL_146, COMP_BOOL_147, COMP_BOOL_148, COMP_BOOL_149, @@ -2060,7 +1817,6 @@ enum DefaultConstants COMP_BOOL_154, COMP_BOOL_155, COMP_BOOL_156, - COMP_BOOL_157, COMP_BOOL_158, COMP_BOOL_159, COMP_BOOL_160, @@ -2073,7 +1829,6 @@ enum DefaultConstants COMP_BOOL_167, COMP_BOOL_168, COMP_BOOL_169, - COMP_BOOL_170, COMP_BOOL_171, COMP_BOOL_172, COMP_BOOL_173, @@ -2082,10 +1837,6 @@ enum DefaultConstants COMP_BOOL_176, COMP_BOOL_177, COMP_BOOL_178, - COMP_BOOL_179, - COMP_BOOL_180, - COMP_BOOL_181, - COMP_BOOL_182, COMP_BOOL_183, COMP_BOOL_184, COMP_BOOL_185, @@ -2097,8 +1848,6 @@ enum DefaultConstants COMP_BOOL_191, COMP_BOOL_192, COMP_BOOL_193, - COMP_BOOL_194, - COMP_BOOL_195, COMP_BOOL_196, COMP_BOOL_197, COMP_BOOL_198, @@ -2108,24 +1857,15 @@ enum DefaultConstants COMP_BOOL_202, COMP_BOOL_203, - COMP_BOOL_205, COMP_BOOL_206, COMP_BOOL_207, - COMP_BOOL_208, - COMP_BOOL_209, COMP_BOOL_210, COMP_BOOL_211, - COMP_BOOL_215, COMP_BOOL_217, COMP_BOOL_219, - COMP_BOOL_220, HIST_OPTIMISTIC_CARD_OPTIMIZATION, - MAINTAIN_REORG_PRIORITY, - MAINTAIN_REORG_PRIORITY_DELTA, - MAINTAIN_REORG_RATE, - MAINTAIN_REORG_SLACK, // System IDentity buffer specification GEN_SID_BUFFER_SIZE, @@ -2136,29 +1876,21 @@ enum DefaultConstants GEN_HGBY_PARTIAL_GROUP_ROWS_PER_CLUSTER, // Controls for utility testware support (query plan logging and testpoints) - SQLMX_UTIL_EXPLAIN_PLAN, ALLOW_DP2_ROW_SAMPLING, - POS_ALLOW_NON_PK_TABLES, INCORPORATE_SKEW_IN_COSTING, TOTAL_RESOURCE_COSTING, - GEN_PAR_LAB_OP_NUM_BUFFERS, - GEN_PAR_LAB_OP_BUFFER_SIZE, - GEN_PAR_LAB_OP_SIZE_DOWN, - GEN_PAR_LAB_OP_SIZE_UP, USE_PARALLEL_FOR_NUM_PARTITIONS, // create table with filecode indicating it is a "temp" table so RDF // ignore it on the backup system - CREATE_FOR_NO_RDF_REPLICATE, // Force creation of definition schemas to be different than the current // schema version, e.g. version 1200 instead of version 2000 - CREATE_DEFINITION_SCHEMA_VERSION, EXE_DIAGNOSTIC_EVENTS, // Sends various executor diagnostics to EMS @@ -2186,14 +1918,12 @@ enum DefaultConstants // POS attributes for temporary/volatile tables POS_NUM_OF_TEMP_TABLE_PARTNS, - POS_TEMP_TABLE_LOCATIONS, POS_TEMP_TABLE_SIZE, HIST_DEFAULT_NUMBER_OF_INTERVALS, // ignore_duplicate_keys is no more valid. It is still // here as dummy for compatibility with existing scripts. - IGNORE_DUPLICATE_KEYS, // in mode_special1, duplicate rows are ignored if inserting a row in the // base table which has a user defined primary key. If this default is set @@ -2201,7 +1931,6 @@ enum DefaultConstants // // If not in mode_special_1, and this default is ON, then duplicate rows // are ignored. - IGNORE_DUPLICATE_ROWS, SESSION_USERNAME, @@ -2215,10 +1944,7 @@ enum DefaultConstants GEN_DBLIMITS_LARGER_BUFSIZE, - CAT_LARGE_BLOCKS_MAX_KEYSIZE, - CAT_LARGE_BLOCKS_MAX_ROWSIZE, - SQLMX_SHOWDDL_SUPPRESS_ROW_FORMAT, FORCE_PARALLEL_INSERT_SELECT, @@ -2234,7 +1960,6 @@ enum DefaultConstants // For OPI, this is the minimum number of seconds it will retry error 73 // that occurs in the commit phase; default is 120 seconds. - OPI_ERROR73_RETRIES, EXE_MEMORY_AVAILABLE_IN_MB, // Mem size (MB) in ESP available for BMOs @@ -2244,8 +1969,6 @@ enum DefaultConstants // The following were added as part of the Wal*Mart changes to improve concurrency // when DDL and DML operations are run concurrently - CAT_FS_TIMEOUT, - METADATA_STABLE_ACCESS, NAR_DEPOBJ_ENABLE , // For Adaptive Segmentation (aka Virtual Segmentation, Adaptive @@ -2266,7 +1989,6 @@ enum DefaultConstants // -1: max distribution, all partitions // <number>: num of partitions per segment - DISTRIBUTE_OPENS, MV_REFRESH_MDELTA_MAX_DELTAS_THRESHOLD, MV_REFRESH_MDELTA_MAX_JOIN_SIZE_FOR_SINGLE_PHASE, @@ -2314,7 +2036,6 @@ enum DefaultConstants CREATE_OBJECTS_IN_METADATA_ONLY, - DO_MINIMAL_RENAME, // ON/OFF flag to invoke ghost objects ALLOW_GHOST_OBJECTS, @@ -2393,10 +2114,8 @@ enum DefaultConstants SEMIJOIN_TO_INNERJOIN_TRANSFORMATION, // Enables or disables sending the plan fragment to DP2 nowaited. - NOWAITED_FIXUP_MESSAGE_TO_DP2, POS_NUM_DISK_POOLS, POS_DISKS_IN_SEGMENT, - POS_CPUS_PER_SEGMENT, // query complexity threshold for query caching to match constants // in parameterization of equality predicates @@ -2411,7 +2130,6 @@ enum DefaultConstants // During the creation of Schema Security this specifies if a schema label // (surrogate file) is created on all segments of a registered catalog. // CQD CAT_ENABLE_SCHEMA_SECURITY must be set to "ON" for this to take effect. - CAT_CREATE_SCHEMA_LABELS_ON_ALL_SEGMENTS, // Display only externalized information in SHOWDDL if set to EXTERNAL SHOWDDL_DISPLAY_FORMAT, @@ -2421,8 +2139,6 @@ enum DefaultConstants // see executor/ExDp2Trace.h for usage notes - EID_TRACE_STR, - EID_TRACE_STATES, POS_DISK_POOL, @@ -2456,7 +2172,6 @@ enum DefaultConstants EXE_MEM_LIMIT_PER_BMO_IN_MB, // Control how many times update statistics will retry the SECURITY checks. - USTAT_RETRY_SECURITY_COUNT, // Disables use of ProbeCache NESTED_JOIN_CACHE, @@ -2536,7 +2251,6 @@ enum DefaultConstants // if this is set, and there is no user specified primary key or // store by clause, then make the first column of the volatile table // to be the clustering key. - VOLATILE_TABLE_FIRST_COL_IS_CLUSTERING_KEY, // Allows pcodes for varchars VARCHAR_PCODE, @@ -2558,10 +2272,7 @@ enum DefaultConstants GEN_ONLJ_SET_QUEUE_RIGHT, GEN_ONLJ_SET_QUEUE_LEFT, - POS_PRI_EXT_SIZE, - POS_SEC_EXT_SIZE, - PURGEDATA_WITH_OFFLINE_TABLE, SORT_REC_THRESHOLD, SORT_MERGE_BUFFER_UNIT_56KB, @@ -2595,7 +2306,6 @@ enum DefaultConstants PCODE_OPT_FLAGS, USTAT_SAMPLE_PERCENT_DIFF, // percentage diff allowed to use old sample in FetchCount(). - USTAT_MAX_SAMPLE_AGE, // max days before a persistent sample is auto removed. USTAT_DEBUG_TEST, // settings for testing ustat, normally empty. // Disallow/Allow left joins in MultiJoin framework @@ -2613,29 +2323,19 @@ enum DefaultConstants // Disallow/Allow routine joins in MultiJoin framework ROUTINE_JOINS_SPOIL_JBB, - POS_TEMP_TABLE_FREESPACE_THRESHOLD_PERCENT, // Specifies whether sample tables should be created for fetch count - HIST_AUTO_GENERATION_OF_SAMPLE, - NEXT_VALUE_FOR_BUFFER_SIZE, - NEXT_VALUE_FOR_NUM_BUFFERS, - NEXT_VALUE_FOR_SIZE_DOWN, - NEXT_VALUE_FOR_SIZE_UP, // The following 3 CQDs are used when using POS in OSIM mode // Allow the use of POS with OSIM - OSIM_USE_POS, // Specify the disk size - OSIM_USE_POS_DISK_SIZE_GB, // Specify the names of the nodes in the cluster - OSIM_USE_POS_NODE_NAMES, // Priority of update stats when run by USAS (for automation). - USTAT_AUTO_PRIORITY, // Specify the node UNIQUE_HASH_JOINS, @@ -2646,7 +2346,6 @@ enum DefaultConstants // catalog where maintain database is maintained MAINTAIN_CATALOG, - GEN_ALIGNED_PA_DP2_BUFFER_SIZE, // turn on and off lean olt query optimizations. Default is OFF. @@ -2657,7 +2356,6 @@ enum DefaultConstants // an MJ query with a greater query // complexity will be considered complex - COMPLEX_MJ_QUERY_THRESHOLD, // override the source schema with the target schema // SOURCE_SCHEMA:TARGET_SCHEMA @@ -2685,7 +2383,6 @@ enum DefaultConstants DISABLE_READ_ONLY, // Allow drop and alter schema level privileges when ON - CAT_MORE_SCHEMA_PRIVS, // perform substring transformation (ICBC PoC) SUBSTRING_TRANSFORMATION, @@ -2700,7 +2397,6 @@ enum DefaultConstants // specified in a regular CREATE VIEW (not a create MV) statement. ALLOW_ORDER_BY_IN_CREATE_VIEW, - GEN_EIDR_STATS_REPLY_INTERVAL, EXE_LOG_RETRY_IPC, @@ -2737,11 +2433,9 @@ enum DefaultConstants // Skip version compatibility check in catman to allow ddl on lower version // schema. This is to allow problems to be fixed after UPGRADE failed // due to metadata corruption. - SKIP_VCC, // By default (ON), online populate index is performed. // OFF then means offline populate index - SQLMX_UTIL_ONLINE_POPINDEX, // Pubsub holdable cursor is not closed on rollback by default // But, ANSI standard expects the holdable cursor to be closed on rollback @@ -2752,28 +2446,17 @@ enum DefaultConstants PSHOLD_UPDATE_BEFORE_FETCH, // This will allow create operations on a catalog if set to 'ON' - CAT_OVERRIDE_CREATE_DISABLE, // This will make schema owner the default object owner if set to 'ON' - CAT_SCHEMA_OWNER_IS_OBJECT_OWNER, // Added to test lazy update issues - CAT_RCB_VERSION, - SHOWLABEL_LOCKMODE, - CAT_ERROR_ON_NOTNULL_STOREBY, // Update statistics automation CQDs to allow for automation settings. - USTAT_NECESSARY_SAMPLE_MAX, - USTAT_AUTO_CV_SAMPLE_SLOPE, USTAT_AUTO_READTIME_UPDATE_INTERVAL, USTAT_AUTO_FOR_VOLATILE_TABLES, // This allows us to skip metadata views creation during regression run // and avoid any possible delay due to views creation for every new catalog - SKIP_METADATA_VIEWS, - CREATE_METADATA_TABLE, - CREATE_EXTERNAL_USER_NAME_INDEX, - SKIP_TRANSLATE_SYSCAT_DEFSCH_NAMES, // Use a compressed data format internally rather than current // SQLARK_EXPLODED_FORMAT @@ -2785,7 +2468,6 @@ enum DefaultConstants BULK_MOVE_NULL_VARCHAR, // use variable sized rows in hash buffers - GEN_VARIABLE_LENGTH_BUFFERS, // display detailed MV information. Default is OFF MV_DUMP_DEBUG_INFO, @@ -2872,20 +2554,11 @@ enum DefaultConstants // Value of 5: return all dependent objects in 'original' format. SHOWDDL_FOR_REPLICATE, - REPLICATE_MANAGEABILITY_CATALOG, - REPLICATE_TEST_TARGET_CATALOG, - REPLICATE_TEST_TARGET_MANAGEABILITY_CATALOG, - REPLICATE_WARNINGS, - REPLICATE_NUM_RETRIES, REPLICATE_ALLOW_ROLES, - COMP_BOOL_222, // for replicate - COMP_BOOL_223, // for replicate - COMP_BOOL_224, // for replicate - COMP_BOOL_225, // for optimized esp allocation to get label stats COMP_BOOL_226, // enable UNLOAD feature OR_PRED_TO_JUMPTABLE, @@ -2911,19 +2584,14 @@ enum DefaultConstants QUERY_LIMIT_SQL_PROCESS_CPU, QUERY_LIMIT_SQL_PROCESS_CPU_DEBUG, QUERY_LIMIT_SQL_PROCESS_CPU_XPROD, - QUERY_LIMIT_SQL_PROCESS_CPU_DP2_FREQ, MV_LOG_CLEANUP_SAFETY_FACTOR, MV_LOG_CLEANUP_USE_MULTI_COMMIT, COMP_BOOL_221, OVERFLOW_MODE, - POS_ABSOLUTE_MAX_TABLE_SIZE, - POS_MAX_EXTENTS, - POS_TEST_MODE, // for testing POS POS_TEST_NUM_NODES, - POS_TEST_NUM_VOLUMES_PER_NODE, // for default/public schema settings PUBLIC_SCHEMA_NAME, @@ -2934,17 +2602,14 @@ enum DefaultConstants DEFAULT_SCHEMA_ACCESS_ONLY, // PUBLISH/UNPUBLISH command - PUBLISHING_ROLES, // default used to test catman features - CAT_TEST_BOOL, // To control ESP exchange memory usage GEN_EXCHANGE_MAX_MEM_IN_KB, GEN_EXCHANGE_MSG_COUNT, // Enable PA-DP2 affinity - EXE_PA_DP2_STATIC_AFFINITY, // enable explain for ddl and ctas DDL_EXPLAIN, @@ -2962,19 +2627,10 @@ enum DefaultConstants // QUERY STRATEGIZER RELATED QUERY_STRATEGIZER, - OPTIMIZATION_BUDGET_FACTOR, - OPTIMIZATION_TASK_CAP, EXPLAIN_STRATEGIZER_PARAMETERS, - QUERY_STRATEGIZER_N_COMPLEXITY_FACTOR, - QUERY_STRATEGIZER_2N_COMPLEXITY_FACTOR, - QUERY_STRATEGIZER_N2_COMPLEXITY_FACTOR, - QUERY_STRATEGIZER_N3_COMPLEXITY_FACTOR, - QUERY_STRATEGIZER_N4_COMPLEXITY_FACTOR, - QUERY_STRATEGIZER_EXHAUSTIVE_COMPLEXITY_FACTOR, // The system-wide schema containing the universal functions // SAS_PUT and SAS_SCORE and other functions set up for // system-wide use. - HP_ROUTINES_SCHEMA, CASCADED_GROUPBY_TRANSFORMATION, @@ -3042,9 +2698,6 @@ enum DefaultConstants // ****** END SET SESSION DEFAULTs *********************************** USTAT_AUTO_EMPTYHIST_TWO_TRANS, - USTAT_INSERT_TO_NONAUDITED_TABLE, - USTAT_MIN_ROWCOUNT_FOR_CTS_SAMPLE, - USTAT_AUTO_MAX_HIST_AGE, USTAT_AUTO_MISSING_STATS_LEVEL, MAX_EXPRS_USED_FOR_CONST_FOLDING, HIST_FETCHCOUNT_SCRATCH_VOL_THRESHOLD, @@ -3053,11 +2706,8 @@ enum DefaultConstants HIST_NUM_ADDITIONAL_DAYS_TO_EXTRAPOLATE, NCM_PAR_ADJ_FACTOR, - POS_DEFAULT_SMALLEST_DISK_SIZE_GB, - POS_DEFAULT_LARGEST_DISK_SIZE_GB, SAP_KEY_NJ_TABLE_SIZE_THRESHOLD, - SAP_PA_DP2_AFFINITY_FOR_INSERTS, SAP_PREFER_KEY_NESTED_JOIN, SAP_TUPLELIST_SIZE_THRESHOLD, @@ -3067,11 +2717,8 @@ enum DefaultConstants HIST_SKEW_COST_ADJUSTMENT, USTAT_AUTO_MC_MAX_WIDTH, USTAT_USE_INTERNAL_SORT_FOR_MC, - USTAT_USE_INTERNAL_SORT_FOR_MC_LOOP, - USTAT_USE_INTERNAL_SORT_FOR_MC_NEW_HIST, // TEMP SHOULD REMOVE USTAT_IS_IGNORE_UEC_FOR_MC, - CAT_TEST_STRING, NSK_DBG_QUERY_LOGGING_ONLY, RISK_PREMIUM_SERIAL_SCALEBACK_MAXCARD_THRESHOLD, @@ -3088,9 +2735,6 @@ enum DefaultConstants COMPRESSED_INTERNAL_FORMAT_ROOT_DOES_CONVERSION, COMPRESSED_INTERNAL_FORMAT_BULK_MOVE, - CAT_IGNORE_ALREADY_EXISTS_ERROR, - CAT_IGNORE_DOES_NOT_EXIST_ERROR, - CAT_IGNORE_EMPTY_CATALOGS, OR_PRED_ADD_BLOCK_TO_IN_LIST, OR_PRED_KEEP_CAST_VC_UCS2, @@ -3118,16 +2762,13 @@ enum DefaultConstants COMPRESSED_INTERNAL_FORMAT_EXPLAIN, COMPRESSED_INTERNAL_FORMAT_DEFRAG_RATIO, // access counter reset - GEN_RESET_ACCESS_COUNTER, // Control whether authorization caches immutable users - CAT_AUTHORIZATION_CACHE_IMMUTABLE_USERS, // Enable the query invalidation processing in catman CAT_ENABLE_QUERY_INVALIDATION, // Control creation of column privileges for object-level privileges - CAT_REDUNDANT_COLUMN_PRIVS, MC_SKEW_SENSITIVITY_THRESHOLD, // multi-column skew threshold value @@ -3168,18 +2809,14 @@ enum DefaultConstants MERGE_JOIN_ACCEPT_MULTIPLE_NJ_PROBES, // merge join accepts multiple NJ probes - CAT_TEST_POINT, // number of esps used to perform parallel ddl operation. // If set to SYSTEM (the default), compiler will choose a value. - PARALLEL_NUM_ESPS_DDL, // number of esps used to perform parallel purgedata operation. // If set to SYSTEM (the default), compiler will choose a value. - PARALLEL_NUM_ESPS_PD, // enable dp2 transactions for unique requests - ENABLE_DP2_XNS, // queries coming in from mariaDB interface MARIAQUEST_PROCESS, @@ -3189,13 +2826,9 @@ enum DefaultConstants FAST_EXTRACT_IO_BUFFERS, FAST_EXTRACT_IO_TIMEOUT_SEC, - CAT_IGNORE_REPL_AUTHIDS_ERROR, // CatMan internal support for REPLICATE AUTHORIZATION - REPLICATE_DISPLAY_INTERNAL_CMD, // Display a BDR-internally-generated command before executing it - REPLICATE_EXEC_INTERNAL_CMD, // Executing commands generated internally by BDR REPLICATE_COMPRESSION_TYPE, // Compression type to be used when replicating the DDL // only reorg if ReorgCheck indicates that a reorg is needed. - REORG_IF_NEEDED, // explore fully covered NJ plan NESTED_JOINS_FULL_INNER_KEY, NESTED_JOINS_CHECK_LEADING_KEY_SKEW, @@ -3284,7 +2917,6 @@ enum DefaultConstants // This cqd is added in case // one need to go back to the old behavior of no reorg stats, or if a problem // need to be debugged. - COLLECT_REORG_STATS, HIVE_MAX_STRING_LENGTH_IN_BYTES, HIVE_USE_FAKE_TABLE_DESC, @@ -3293,7 +2925,6 @@ enum DefaultConstants HIVE_MIN_BYTES_PER_ESP_PARTITION, HIVE_NUM_ESPS_PER_DATANODE, HIVE_MAX_ESPS, - HIVE_FILE_NAME, // buffer size to do hdfs io. In K bytes. 64M = 65536. HDFS_IO_BUFFERSIZE, @@ -3331,7 +2962,6 @@ enum DefaultConstants MODE_SEABASE, SEABASE_CATALOG, HBASE_CATALOG, - HBASE_SCHEMA, // HBASE_DEFAULT_CHARSET, HBASE_SERVER, @@ -3397,16 +3027,13 @@ enum DefaultConstants HBASE_SERIALIZATION, // for testing only. Creates metadata with old structures. Used to test upgrade. - HBASE_CREATE_OLD_MD_FOR_UPGRADE_TESTING, SQLMX_REGRESS, // For PCODE - Native Expressions work - PCODE_NE_LOG_PATH, PCODE_NE_DBG_LEVEL, // To set Reorg verify command for REORG CHECK command - REORG_VERIFY, HBASE_ZOOKEEPER_PORT, @@ -3443,23 +3070,19 @@ enum DefaultConstants // but can be enabled via this CQD. USE_MAINTAIN_CONTROL_TABLE, - GEN_EIDR_BROKEN_TREE_CHECK_INTERVAL, // if set, then constr validation is skipped during unique, ri or check constr // creation. Done if constraints are being created during CREATE TABLE time. TRAF_NO_CONSTR_VALIDATION, - NCM_USE_HBASE_REGIONS, HBASE_MIN_BYTES_PER_ESP_PARTITION, HBASE_MAX_ESPS, - SHOW_MEMO_STATS, // Default is ON. If ON will use JNI and the Java API provided // by Hive to access metadata for Hive which could be in any // DB that supports JDBC - HIVE_METADATA_JAVA_ACCESS, // for testing setjmp/longjmp compiler logic MEMORY_LIMIT_CMPCTXT_UPPER_KB, @@ -3486,7 +3109,6 @@ enum DefaultConstants TRAF_UPSERT_WRITE_TO_WAL, TRAF_LOAD_PREP_ADJUST_PART_FUNC, TRAF_LOAD_PREP_TMP_LOCATION, - TRAF_LOAD_PREP_PHASE_ONLY, TRAF_LOAD_USE_FOR_INDEXES, //log only the overall time of a compilation. COMPILE_TIME_MONITOR_LOG_ALLTIME_ONLY, @@ -3621,7 +3243,6 @@ enum DefaultConstants NCM_HBASE_COSTING, NCM_IND_JOIN_SELECTIVITY, NCM_IND_SCAN_SELECTIVITY, - NCM_OLTP_ET_THRESHOLD, NCM_SKEW_COST_ADJ_FOR_PROBES, PCODE_NE_IN_SHOWPLAN, TRAF_TABLE_SNAPSHOT_SCAN, @@ -3634,7 +3255,6 @@ enum DefaultConstants TRAF_USE_RWRS_FOR_MD_INSERT, - TRAF_ALIGNED_FORMAT_ADD_COL_METHOD, PCODE_DEBUG_LOGDIR, PCODE_EXPR_CACHE_CMP_ONLY,
