[34m# scan=duckdb host=unsb-vm-7426-470734 date=2026-03-23T22:10:48Z
Updating files:  20% (2962/14507)
Updating files:  21% (3047/14507)
Updating files:  22% (3192/14507)
Updating files:  23% (3337/14507)
Updating files:  24% (3482/14507)
Updating files:  25% (3627/14507)
Updating files:  26% (3772/14507)
Updating files:  27% (3917/14507)
Updating files:  28% (4062/14507)
Updating files:  29% (4208/14507)
Updating files:  30% (4353/14507)
Updating files:  31% (4498/14507)
Updating files:  32% (4643/14507)
Updating files:  33% (4788/14507)
Updating files:  34% (4933/14507)
Updating files:  35% (5078/14507)
Updating files:  36% (5223/14507)
Updating files:  37% (5368/14507)
Updating files:  38% (5513/14507)
Updating files:  39% (5658/14507)
Updating files:  40% (5803/14507)
Updating files:  41% (5948/14507)
Updating files:  42% (6093/14507)
Updating files:  43% (6239/14507)
Updating files:  44% (6384/14507)
Updating files:  45% (6529/14507)
Updating files:  46% (6674/14507)
Updating files:  47% (6819/14507)
Updating files:  48% (6964/14507)
Updating files:  49% (7109/14507)
Updating files:  50% (7254/14507)
Updating files:  51% (7399/14507)
Updating files:  52% (7544/14507)
Updating files:  53% (7689/14507)
Updating files:  54% (7834/14507)
Updating files:  55% (7979/14507)
Updating files:  56% (8124/14507)
Updating files:  57% (8269/14507)
Updating files:  58% (8415/14507)
Updating files:  59% (8560/14507)
Updating files:  60% (8705/14507)
Updating files:  61% (8850/14507)
Updating files:  62% (8995/14507)
Updating files:  63% (9140/14507)
Updating files:  64% (9285/14507)
Updating files:  65% (9430/14507)
Updating files:  65% (9511/14507)
Updating files:  66% (9575/14507)
Updating files:  67% (9720/14507)
Updating files:  68% (9865/14507)
Updating files:  69% (10010/14507)
Updating files:  70% (10155/14507)
Updating files:  71% (10300/14507)
Updating files:  72% (10446/14507)
Updating files:  73% (10591/14507)
Updating files:  74% (10736/14507)
Updating files:  75% (10881/14507)
Updating files:  76% (11026/14507)
Updating files:  77% (11171/14507)
Updating files:  78% (11316/14507)
Updating files:  79% (11461/14507)
Updating files:  80% (11606/14507)
Updating files:  81% (11751/14507)
Updating files:  82% (11896/14507)
Updating files:  83% (12041/14507)
Updating files:  84% (12186/14507)
Updating files:  85% (12331/14507)
Updating files:  86% (12477/14507)
Updating files:  87% (12622/14507)
Updating files:  88% (12767/14507)
Updating files:  89% (12912/14507)
Updating files:  90% (13057/14507)
Updating files:  91% (13202/14507)
Updating files:  92% (13347/14507)
Updating files:  93% (13492/14507)
Updating files:  94% (13637/14507)
Updating files:  95% (13782/14507)
Updating files:  96% (13927/14507)
Updating files:  97% (14072/14507)
Updating files:  98% (14217/14507)
Updating files:  99% (14362/14507)
Updating files: 100% (14507/14507)
Updating files: 100% (14507/14507), done.
# roots: /tmp/duckdb/src/optimizer
CANDIDATE\t/tmp/duckdb/src/optimizer/build_probe_side_optimizer.cpp:94\tif (std::find(haystack.begin(), haystack.end(), needle) != haystack.end()) {  [loop: for (auto &needle : needles) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/column_lifetime_analyzer.cpp:23\tif (column_references.find(bindings[i]) == column_references.end()) {  [loop: for (idx_t i = 0; i < bindings.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/column_lifetime_analyzer.cpp:39\tif (unused_bindings.find(bindings[i]) == unused_bindings.end()) {  [loop: for (idx_t i = 0; i < bindings.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/column_lifetime_analyzer.cpp:262\tif (column_references.find(replacement_binding.old_binding) != column_references.end()) {  [loop: for (const auto &replacement_binding : replacer.replacement_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:231\tD_ASSERT(table_index_map.find(table_index) == table_index_map.end());  [loop: for (idx_t col_idx = 0; col_idx < get.names.size(); col_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:651\tD_ASSERT(operator_infos.find(current.op) != operator_infos.end());  [loop: while (!stack.empty()) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:665\tD_ASSERT(to_canonical_table_index.find(table_index) == to_canonical_table_index.end());  [loop: for (auto &table_index : current_op_table_index) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:710\tD_ASSERT(operator_infos.find(subplan_info.subplans[0].op) != operator_infos.end());  [loop: for (auto &entry : subplans) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:712\tD_ASSERT(operator_infos.find(parent_op) != operator_infos.end());  [loop: for (auto &entry : subplans) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:746\tif (max_subplan_column_binding_set.find(cb) != max_subplan_column_binding_set.end()) {  [loop: for (idx_t subplan_idx = 0; subplan_idx < subplan_info.subplans.size(); subplan_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/common_subplan_optimizer.cpp:757\tif (max_subplan_column_binding_set.find(cb) == max_subplan_column_binding_set.end()) {  [loop: for (auto &cb : subplan_info.subplans[0].canonical_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/compressed_materialization/compress_aggregate.cpp:20\tif (group_binding_set.find(colref.binding) != group_binding_set.end()) {  [loop: for (const auto &group : groups) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/compressed_materialization/compress_comparison_join.cpp:122\tif (probe_compress_bindings.find(binding) == probe_compress_bindings.end()) {  [loop: for (auto &dec : join.duplicate_eliminated_columns) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/deliminator.cpp:441\tif (std::find(join_bindings.begin(), join_bindings.end(),  [loop: for (idx_t group_idx = 0; group_idx < aggr.groups.size(); group_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/filter_combiner.cpp:361\tD_ASSERT(constant_values.find(equiv_set) != constant_values.end());  [loop: for (auto &constant_cmp : constant_list) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/filter_combiner.cpp:1185\tD_ASSERT(constant_values.find(left_equivalence_set) != constant_values.end());  [loop: } while (false);]
CANDIDATE\t/tmp/duckdb/src/optimizer/filter_combiner.cpp:1186\tD_ASSERT(constant_values.find(right_equivalence_set) != constant_values.end());  [loop: } while (false);]
CANDIDATE\t/tmp/duckdb/src/optimizer/filter_pushdown.cpp:28\tif (table_bindings.find(join.mark_index) != table_bindings.end()) {  [loop: for (auto &binding : proj_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/filter_pushdown.cpp:302\tif (child_bindings_table.find(binding) == child_bindings_table.end()) {  [loop: for (idx_t i = 0; i < filters.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_elimination.cpp:154\tif (ref_table_columns.find(col_ref.binding.table_index) == ref_table_columns.end()) {  [loop: for (idx_t proj_idx = 0; proj_idx < projection.expressions.size(); proj_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_elimination.cpp:242\tif (pipe_info.ref_table_ids.find(binding.table_index) != pipe_info.ref_table_ids.end()) {  [loop: for (auto &binding : inner_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_elimination.cpp:304\tif (it->second.find(binding) == it->second.end()) {  [loop: for (auto &binding : column_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/cardinality_estimator.cpp:29\tif (i_set.find(filter_info.left_binding) != i_set.end()) {  [loop: for (const RelationsSetToStats &r2tdom : relation_set_stats) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/cardinality_estimator.cpp:61\tif (i_set.find(filter_info->left_binding) != i_set.end()) {  [loop: for (const RelationsSetToStats &r2tdom : relation_set_stats) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/cardinality_estimator.cpp:63\t} else if (i_set.find(filter_info->right_binding) != i_set.end()) {  [loop: for (const RelationsSetToStats &r2tdom : relation_set_stats) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/cardinality_estimator.cpp:478\tif (i_set.find(key) == i_set.end()) {  [loop: for (idx_t i = 0; i < stats.column_distinct_count.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/plan_enumerator.cpp:212\tD_ASSERT(new_exclusion_set.find(neighbors[i]) == new_exclusion_set.end());  [loop: for (idx_t i = 0; i < neighbors.size() - 1; i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/plan_enumerator.cpp:254\tif (plans.find(combined_set) != plans.end()) {  [loop: for (const auto &rel_set : all_subset) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/plan_enumerator.cpp:295\tif (plans.find(new_set) != plans.end()) {  [loop: for (const auto &rel_set : all_subset) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/query_graph.cpp:110\treturn exclusion_set.find(node->relations[0]) != exclusion_set.end();  [loop: for (idx_t j = 0; j < node.count; j++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:38\tif (relation_mapping.find(binding.table_index) == relation_mapping.end()) {  [loop: for (auto &binding : op_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:70\tD_ASSERT(relation_mapping.find(reference) == relation_mapping.end());  [loop: for (auto &reference : table_references) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:84\tD_ASSERT(relation_mapping.find(table_index) == relation_mapping.end());  [loop: for (auto &reference : table_references) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:93\treturn no_cross_product_relations.find(relation_id) == no_cross_product_relations.end();  [loop: for (auto &binding : bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:652\tif (filter_set.find(*expr) == filter_set.end()) {  [loop: for (auto &cond : join.conditions) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/join_order/relation_manager.cpp:669\tif (filter_set.find(*expression) == filter_set.end()) {  [loop: for (auto &expression : f_op.expressions) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/optimizer.cpp:94\treturn config.options.disabled_optimizers.find(type) != config.options.disabled_optimizers.end();  [loop: for (auto &rule : rewriter.rules) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/outer_join_simplification.cpp:52\tif (null_filtered_columns.find(binding) != null_filtered_columns.end()) {  [loop: for (idx_t child_idx = 0; child_idx < 2; child_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/outer_join_simplification.cpp:95\tif (null_filtered_columns.find(binding) == null_filtered_columns.end()) {  [loop: for (idx_t col_idx = 0; col_idx < projection.expressions.size(); col_idx++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/pushdown/pushdown_aggregate.cpp:36\tif (f.bindings.find(aggr.aggregate_index) != f.bindings.end()) {  [loop: for (idx_t i = 0; i < filters.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/pushdown/pushdown_aggregate.cpp:40\tif (f.bindings.find(aggr.groupings_index) != f.bindings.end()) {  [loop: for (idx_t i = 0; i < filters.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/pushdown/pushdown_left_join.cpp:37\tif (right_bindings.find(bound_colref.binding.table_index) != right_bindings.end()) {  [loop: for (idx_t i = 0; i < column_bindings.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/pushdown/pushdown_window.cpp:19\tif (partition_binding_set.find(binding) == partition_binding_set.end()) {  [loop: for (auto &partition_binding_set : window_exprs_partition_bindings) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/remove_unused_columns.cpp:388\tif (referenced_columns_in_rhs.find(ProjectionIndex(i)) != referenced_columns_in_rhs.end()) {  [loop: for (idx_t i = 0; i < bindings.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/remove_unused_columns.cpp:917\tif (referenced_columns.find(ProjectionIndex(i)) != referenced_columns.end()) {  [loop: for (idx_t i = 0; i < cte_ref.chunk_types.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/topn_window_elimination.cpp:624\tstatic_cast<idx_t>(std::find(window_child_bindings.begin(), window_child_bindings.end(), binding) -  [loop: for (idx_t i = 0; i < bindings.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/optimizer/topn_window_elimination.cpp:712\tif (group_idxs.find(i) != group_idxs.end()) {  [loop: for (idx_t i = 0; i < new_bindings.size(); i++) {]
# roots: /tmp/duckdb/src/planner
CANDIDATE\t/tmp/duckdb/src/planner/bind_context.cpp:511\tif (handled_using_columns.find(using_binding) != handled_using_columns.end()) {  [loop: for (auto &entry : bindings_list) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder.cpp:227\tif (current->bound_views.find(view) != current->bound_views.end()) {  [loop: while (current) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/query_node/bind_recursive_cte_node.cpp:101\tif (key_references.find(column_index) != key_references.end()) {  [loop: for (idx_t expr_idx = 0; expr_idx < statement.key_targets.size(); expr_idx++) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/query_node/bind_recursive_cte_node.cpp:218\tif (key_references.find(ProjectionIndex(i)) == key_references.end()) {  [loop: for (idx_t i = 0; i < left.types.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/query_node/bind_setop_node.cpp:128\tif (node_name_map.find(col_name) != node_name_map.end()) {  [loop: for (idx_t i = 0; i < root.names.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/query_node/bind_setop_node.cpp:134\tif (global_name_set.find(col_name) == global_name_set.end()) {  [loop: for (auto &child : result.bound_children) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/query_node/plan_setop.cpp:39\tif (new_column_types.find(column_id) != new_column_types.end()) {  [loop: for (idx_t i = 0; i < op->expressions.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_export.cpp:283\tif (options.find("header") == options.end()) {  [loop: for (auto &entry : options) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_export.cpp:286\tif (options.find("delimiter") == options.end() && options.find("sep") == options.end() &&  [loop: for (auto &entry : options) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_export.cpp:287\toptions.find("delim") == options.end()) {  [loop: for (auto &entry : options) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_export.cpp:302\tif (copy_options.find(entry.first) == copy_options.end()) {  [loop: for (auto &entry : options) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_insert.cpp:424\tif (set_columns.find(name) == set_columns.end()) {  [loop: for (auto &set_col : stmt.columns) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/statement/bind_update.cpp:52\tif (std::find(columns.begin(), columns.end(), column.Physical()) != columns.end()) {  [loop: for (idx_t i = 0; i < set_info.columns.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/tableref/bind_joinref.cpp:117\tif (handled_columns.find(using_column) == handled_columns.end()) {  [loop: for (auto &using_column : using_columns) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/tableref/bind_pivot.cpp:146\tif (handled_columns.find(columnref.GetColumnName()) == handled_columns.end()) {  [loop: for (auto &entry : all_columns) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/tableref/bind_pivot.cpp:435\tif (seen.find(name) == seen.end()) {  [loop: for (auto &name : ref.bound_aggregate_names) {]
CANDIDATE\t/tmp/duckdb/src/planner/binder/tableref/bind_table_function.cpp:252\twhile (ci_return_names.find(ordinality_column_name) != ci_return_names.end()) {  [loop: for (auto &n : return_names) {]
CANDIDATE\t/tmp/duckdb/src/planner/bound_result_modifier.cpp:118\tif (seen_expressions.find(*order_node.expression) != seen_expressions.end()) {  [loop: for (auto &target : groups) {]
CANDIDATE\t/tmp/duckdb/src/planner/bound_result_modifier.cpp:127\tif (grouping_set.find(group_idx) == grouping_set.end()) {  [loop: for (auto &target : groups) {]
CANDIDATE\t/tmp/duckdb/src/planner/joinside.cpp:76\tD_ASSERT(right_bindings.find(table_binding) != right_bindings.end());  [loop: for (auto &child : subquery.children) {]
CANDIDATE\t/tmp/duckdb/src/planner/operator/logical_copy_to_file.cpp:19\tif (part_col_set.find(col_idx) == part_col_set.end()) {  [loop: for (idx_t col_idx = 0; col_idx < col_types.size(); col_idx++) {]
CANDIDATE\t/tmp/duckdb/src/planner/operator/logical_recursive_cte.cpp:55\tif (key_idx.find(ProjectionIndex(i)) != key_idx.end()) {  [loop: for (auto &key_target : key_targets) {]
CANDIDATE\t/tmp/duckdb/src/planner/subquery/has_correlated_expressions.cpp:57\tif (std::find(expr.binder->correlated_columns.begin(), expr.binder->correlated_columns.end(),  [loop: for (idx_t i = 0; i < correlated_columns.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/table_binding.cpp:30\tif (name_map.find(name) != name_map.end()) {  [loop: for (idx_t i = 0; i < names.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/planner/table_binding.cpp:164\tif (name_map.find(name) == name_map.end()) {  [loop: for (auto &ventry : virtual_columns) {]
CANDIDATE\t/tmp/duckdb/src/planner/table_binding.cpp:225\tauto it = std::find_if(name_map.begin(), name_map.end(),  [loop: for (auto &entry : name_map) {]
# roots: /tmp/duckdb/src/execution
CANDIDATE\t/tmp/duckdb/src/execution/column_binding_resolver.cpp:230\tif (result.find(index) != result.end()) {  [loop: for (auto &child : op.children) {]
CANDIDATE\t/tmp/duckdb/src/execution/column_binding_resolver.cpp:239\tif (result.find(index) != result.end()) {  [loop: for (auto &child : op.children) {]
CANDIDATE\t/tmp/duckdb/src/execution/index/bound_index.cpp:158\tif (column_id_set.find(column.index) != column_id_set.end()) {  [loop: for (auto &column : column_ids_p) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/aggregate/distinct_aggregate_data.cpp:152\tstd::find_if(table_inputs.begin(), table_inputs.end(), FindMatchingAggregate(std::ref(aggregate)));  [loop: for (auto &agg_idx : indices) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/csv_scanner/scanner/csv_schema.cpp:160\tif (current_schema.find(column.name) == current_schema.end()) {  [loop: for (idx_t i = 0; i < sniffer_result.names.size(); i++) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/csv_scanner/state_machine/csv_state_machine_cache.cpp:20\tD_ASSERT(state_machine_cache.find(state_machine_options) == state_machine_cache.end());  [loop: for (uint32_t i = 0; i < StateMachine::NUM_TRANSITIONS; i++) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/csv_scanner/state_machine/csv_state_machine_cache.cpp:490\tif (state_machine_cache.find(state_machine_options) == state_machine_cache.end()) {  [loop: for (auto quote_escape : default_quote_escape) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/csv_scanner/table_function/csv_multi_file_info.cpp:224\tif (column_names.find(force_name) == column_names.end()) {  [loop: for (auto &name : names) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/csv_scanner/table_function/csv_multi_file_info.cpp:231\tif (options.force_not_null_names.find(names[i]) != options.force_not_null_names.end()) {  [loop: for (auto &name : names) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/join/physical_range_join.cpp:341\tif (inverse.find(idx) != inverse.end()) {  [loop: for (idx_t i = 0; i < conditions.size(); ++i) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/persistent/physical_update.cpp:38\tif (index_columns.find(col.Logical().index) == index_columns.end()) {  [loop: for (const auto col : this->columns) {]
CANDIDATE\t/tmp/duckdb/src/execution/operator/persistent/physical_update.cpp:41\tif (update_columns.find(col.Physical().index) == update_columns.end()) {  [loop: for (const auto col : this->columns) {]
CANDIDATE\t/tmp/duckdb/src/execution/radix_partitioned_hashtable.cpp:21\tif (grouping_set.find(group_idx) == grouping_set.end()) {  [loop: for (auto group_idx : ProjectionIndex::GetIndexes(groups_count)) {]
CANDIDATE\t/tmp/duckdb/src/execution/radix_partitioned_hashtable.cpp:53\tif (grouping_set.find(grouping[i]) == grouping_set.end()) {  [loop: for (auto &grouping : grouping_functions) {]
CANDIDATE\t/tmp/duckdb/src/execution/sample/reservoir_sample.cpp:807\tif (index_count.find(pair.second) == index_count.end()) {  [loop: while (!base_reservoir_copy->reservoir_weights.empty()) {]
# scan complete
[0m