[sqlite] Bug in sqlite3_trace/trigger/delete

[sqlite-mail]

Hello !  

After waiting for any help on this issue I've tried to see what "explain
query plan delete from res_users where id=7" shows and found that on this
particular database because the res_users.id is a foreign key on almost all
other tables and sometimes on more than one field (most of then without an
index) deleting anything on res_users become a very costly operation.  

It also shows that sqlite is not capable to merge table scans for the same
value on more than one column and execute several table scans (optimization
opportunity), but I'm still not sure why it's calling sqlite3_trace with
empty values ? Would it be better if it shows "INTERNAL QUERY SCAN TABLE .."
?  

Cheers !  

-----  

0|0|0|SEARCH TABLE res_users USING INTEGER PRIMARY KEY (rowid=?)
0|0|0|SCAN TABLE ir_property
0|0|0|SCAN TABLE ir_property
0|0|0|SCAN TABLE res_lang
0|0|0|SCAN TABLE res_lang
0|0|0|SCAN TABLE ir_rule
0|0|0|SCAN TABLE ir_rule
0|0|0|SCAN TABLE sale_order
0|0|0|SEARCH TABLE sale_order USING COVERING INDEX sale_order_user_id_index
(user_id=?)
0|0|0|SCAN TABLE sale_order
0|0|0|SCAN TABLE stock_picking_type
0|0|0|SCAN TABLE stock_picking_type
0|0|0|SEARCH TABLE analytic_profit_emp_rel USING COVERING INDEX
analytic_profit_emp_rel_emp_id_index (emp_id=?)
0|0|0|SCAN TABLE calendar_event
0|0|0|SCAN TABLE calendar_event
0|0|0|SCAN TABLE calendar_event
0|0|0|SCAN TABLE fleet_vehicle_log_contract
0|0|0|SCAN TABLE fleet_vehicle_log_contract
0|0|0|SCAN TABLE fleet_vehicle_contract_state
0|0|0|SCAN TABLE fleet_vehicle_contract_state
0|0|0|SCAN TABLE fleet_vehicle_cost_frequency
0|0|0|SCAN TABLE fleet_vehicle_cost_frequency
0|0|0|SCAN TABLE fleet_vehicle_cost
0|0|0|SCAN TABLE fleet_vehicle_cost
0|0|0|SCAN TABLE purchase_order_line
0|0|0|SCAN TABLE purchase_order_line
0|0|0|SCAN TABLE purchase_order
0|0|0|SCAN TABLE purchase_order
0|0|0|SCAN TABLE purchase_order
0|0|0|SCAN TABLE purchase_order_method
0|0|0|SCAN TABLE purchase_order_method
0|0|0|SCAN TABLE purchase_order_state
0|0|0|SCAN TABLE purchase_order_state
0|0|0|SCAN TABLE sale_order_state
0|0|0|SCAN TABLE sale_order_state
0|0|0|SCAN TABLE crm_lead
0|0|0|SCAN TABLE crm_lead
0|0|0|SEARCH TABLE crm_lead USING COVERING INDEX crm_lead_user_id_index
(user_id=?)
0|0|0|SCAN TABLE hr_applicant
0|0|0|SCAN TABLE hr_applicant
0|0|0|SCAN TABLE hr_applicant
0|0|0|SCAN TABLE hr_applicant_appreciation
0|0|0|SCAN TABLE hr_applicant_appreciation
0|0|0|SCAN TABLE account_invoice
0|0|0|SCAN TABLE account_invoice
0|0|0|SCAN TABLE account_invoice
0|0|0|SCAN TABLE account_invoice_state
0|0|0|SCAN TABLE account_invoice_state
0|0|0|SCAN TABLE account_invoice_type
0|0|0|SCAN TABLE account_invoice_type
0|0|0|SCAN TABLE fleet_vehicle_cost_type
0|0|0|SCAN TABLE fleet_vehicle_cost_type
0|0|0|SCAN TABLE stock_location
0|0|0|SCAN TABLE stock_location
0|0|0|SCAN TABLE stock_location_usage
0|0|0|SCAN TABLE stock_location_usage
0|0|0|SCAN TABLE stock_picking_type_code
0|0|0|SCAN TABLE stock_picking_type_code
0|0|0|SEARCH TABLE share_wizard_res_user_rel USING COVERING INDEX
share_wizard_res_user_rel_user_id_index (user_id=?)
0|0|0|SEARCH TABLE sale_member_rel USING COVERING INDEX
sale_member_rel_member_id_index (member_id=?)
0|0|0|SEARCH TABLE res_groups_users_rel USING COVERING INDEX
res_groups_users_rel_uid_index (uid=?)
0|0|0|SEARCH TABLE res_company_users_rel USING COVERING INDEX
res_company_users_rel_user_id_index (user_id=?)
0|0|0|SEARCH TABLE project_user_rel USING COVERING INDEX
project_user_rel_uid_index (uid=?)
0|0|0|SEARCH TABLE pos_details_report_user_rel USING COVERING INDEX
pos_details_report_user_rel_wizard_id_index (wizard_id=?)
0|0|0|SEARCH TABLE gamification_invited_user_ids_rel USING COVERING INDEX
gamification_invited_user_ids_rel_res_users_id_index (res_users_id=?)
0|0|0|SEARCH TABLE gamification_challenge_users_rel USING COVERING INDEX
gamification_challenge_users_rel_res_users_id_index (res_users_id=?)
0|0|0|SEARCH TABLE forum_post_res_users_rel USING COVERING INDEX
forum_post_res_users_rel_res_users_id_index (res_users_id=?)
0|0|0|SEARCH TABLE crm_lead2opportunity_partner_mass_res_users_rel USING
COVERING INDEX
crm_lead2opportunity_partner_mass_res_users_rel_res_users_id_in
(res_users_id=?)
0|0|0|SCAN TABLE fleet_vehicle_transmission_type
0|0|0|SCAN TABLE fleet_vehicle_transmission_type
0|0|0|SCAN TABLE fleet_vehicle_fuel_type
0|0|0|SCAN TABLE fleet_vehicle_fuel_type
0|0|0|SCAN TABLE wkf_transition
0|0|0|SCAN TABLE wkf_transition
0|0|0|SCAN TABLE wkf_activity
0|0|0|SCAN TABLE wkf_activity
0|0|0|SCAN TABLE wkf
0|0|0|SCAN TABLE wkf
0|0|0|SCAN TABLE wizard_valuation_history
0|0|0|SCAN TABLE wizard_valuation_history
0|0|0|SCAN TABLE wizard_multi_charts_accounts
0|0|0|SCAN TABLE wizard_multi_charts_accounts
0|0|0|SCAN TABLE wizard_ir_model_menu_create
0|0|0|SCAN TABLE wizard_ir_model_menu_create
0|0|0|SCAN TABLE website_seo_metadata
0|0|0|SCAN TABLE website_seo_metadata
0|0|0|SCAN TABLE website_menu
0|0|0|SCAN TABLE website_menu
0|0|0|SCAN TABLE website_converter_test_sub
0|0|0|SCAN TABLE website_converter_test_sub
0|0|0|SCAN TABLE website_converter_test
0|0|0|SCAN TABLE website_converter_test
0|0|0|SCAN TABLE website_config_settings
0|0|0|SCAN TABLE website_config_settings
0|0|0|SCAN TABLE website
0|0|0|SCAN TABLE website
0|0|0|SCAN TABLE website
0|0|0|SCAN TABLE validate_account_move_lines
0|0|0|SCAN TABLE validate_account_move_lines
0|0|0|SCAN TABLE validate_account_move
0|0|0|SCAN TABLE validate_account_move
0|0|0|SCAN TABLE survey_user_input_line
0|0|0|SCAN TABLE survey_user_input_line
0|0|0|SCAN TABLE survey_user_input
0|0|0|SCAN TABLE survey_user_input
0|0|0|SCAN TABLE survey_survey
0|0|0|SCAN TABLE survey_survey
0|0|0|SCAN TABLE survey_stage
0|0|0|SCAN TABLE survey_stage
0|0|0|SCAN TABLE survey_question
0|0|0|SCAN TABLE survey_question
0|0|0|SCAN TABLE survey_page
0|0|0|SCAN TABLE survey_page
0|0|0|SCAN TABLE survey_mail_compose_message
0|0|0|SCAN TABLE survey_mail_compose_message
0|0|0|SCAN TABLE survey_label
0|0|0|SCAN TABLE survey_label
0|0|0|SCAN TABLE stock_warehouse_orderpoint
0|0|0|SCAN TABLE stock_warehouse_orderpoint
0|0|0|SCAN TABLE stock_warehouse
0|0|0|SCAN TABLE stock_warehouse
0|0|0|SCAN TABLE stock_transfer_details_items
0|0|0|SCAN TABLE stock_transfer_details_items
0|0|0|SCAN TABLE stock_transfer_details
0|0|0|SCAN TABLE stock_transfer_details
0|0|0|SCAN TABLE stock_return_picking_line
0|0|0|SCAN TABLE stock_return_picking_line
0|0|0|SCAN TABLE stock_return_picking
0|0|0|SCAN TABLE stock_return_picking
0|0|0|SCAN TABLE stock_quant_package
0|0|0|SCAN TABLE stock_quant_package
0|0|0|SCAN TABLE stock_production_lot
0|0|0|SCAN TABLE stock_production_lot
0|0|0|SCAN TABLE stock_picking
0|0|0|SCAN TABLE stock_picking
0|0|0|SCAN TABLE stock_pack_operation
0|0|0|SCAN TABLE stock_pack_operation
0|0|0|SCAN TABLE stock_move_scrap
0|0|0|SCAN TABLE stock_move_scrap
0|0|0|SCAN TABLE stock_move_operation_link
0|0|0|SCAN TABLE stock_move_operation_link
0|0|0|SCAN TABLE stock_move_consume
0|0|0|SCAN TABLE stock_move_consume
0|0|0|SCAN TABLE stock_location_route
0|0|0|SCAN TABLE stock_location_route
0|0|0|SCAN TABLE stock_location_path
0|0|0|SCAN TABLE stock_location_path
0|0|0|SCAN TABLE stock_invoice_onshipping
0|0|0|SCAN TABLE stock_invoice_onshipping
0|0|0|SCAN TABLE stock_inventory_line
0|0|0|SCAN TABLE stock_inventory_line
0|0|0|SCAN TABLE stock_inventory
0|0|0|SCAN TABLE stock_inventory
0|0|0|SCAN TABLE stock_incoterms
0|0|0|SCAN TABLE stock_incoterms
0|0|0|SCAN TABLE stock_quant
0|0|0|SCAN TABLE stock_quant
0|0|0|SCAN TABLE stock_fixed_putaway_strat
0|0|0|SCAN TABLE stock_fixed_putaway_strat
0|0|0|SCAN TABLE stock_config_settings
0|0|0|SCAN TABLE stock_config_settings
0|0|0|SCAN TABLE stock_change_standard_price
0|0|0|SCAN TABLE stock_change_standard_price
0|0|0|SCAN TABLE stock_change_product_qty
0|0|0|SCAN TABLE stock_change_product_qty
0|0|0|SCAN TABLE share_wizard_result_line
0|0|0|SCAN TABLE share_wizard_result_line
0|0|0|SCAN TABLE share_wizard_result_line
0|0|0|SCAN TABLE share_wizard
0|0|0|SCAN TABLE share_wizard
0|0|0|SCAN TABLE sale_quote_template
0|0|0|SCAN TABLE sale_quote_template
0|0|0|SCAN TABLE sale_quote_option
0|0|0|SCAN TABLE sale_quote_option
0|0|0|SCAN TABLE sale_quote_line
0|0|0|SCAN TABLE sale_quote_line
0|0|0|SCAN TABLE sale_order_option
0|0|0|SCAN TABLE sale_order_option
0|0|0|SCAN TABLE sale_order_line_make_invoice
0|0|0|SCAN TABLE sale_order_line_make_invoice
0|0|0|SCAN TABLE sale_order_line
0|0|0|SCAN TABLE sale_order_line
0|0|0|SCAN TABLE sale_order_line
0|0|0|SCAN TABLE sale_make_invoice
0|0|0|SCAN TABLE sale_make_invoice
0|0|0|SCAN TABLE sale_config_settings
0|0|0|SCAN TABLE sale_config_settings
0|0|0|SCAN TABLE sale_advance_payment_inv
0|0|0|SCAN TABLE sale_advance_payment_inv
0|0|0|SCAN TABLE resource_calendar_leaves
0|0|0|SCAN TABLE resource_calendar_leaves
0|0|0|SCAN TABLE resource_calendar_attendance
0|0|0|SCAN TABLE resource_calendar_attendance
0|0|0|SCAN TABLE resource_calendar
0|0|0|SCAN TABLE resource_calendar
0|0|0|SCAN TABLE resource_calendar
0|0|0|SCAN TABLE res_request_link
0|0|0|SCAN TABLE res_request_link
0|0|0|SCAN TABLE res_partner_title
0|0|0|SCAN TABLE res_partner_title
0|0|0|SCAN TABLE res_partner_category
0|0|0|SCAN TABLE res_partner_category
0|0|0|SCAN TABLE res_partner_bank_type_field
0|0|0|SCAN TABLE res_partner_bank_type_field
0|0|0|SCAN TABLE res_partner_bank_type
0|0|0|SCAN TABLE res_partner_bank_type
0|0|0|SCAN TABLE res_partner_bank
0|0|0|SCAN TABLE res_partner_bank
0|0|0|SCAN TABLE res_groups
0|0|0|SCAN TABLE res_groups
0|0|0|SCAN TABLE res_font
0|0|0|SCAN TABLE res_font
0|0|0|SCAN TABLE res_currency
0|0|0|SCAN TABLE res_currency
0|0|0|SCAN TABLE res_country_state
0|0|0|SCAN TABLE res_country_state
0|0|0|SCAN TABLE res_country_group
0|0|0|SCAN TABLE res_country_group
0|0|0|SCAN TABLE res_country
0|0|0|SCAN TABLE res_country
0|0|0|SCAN TABLE res_config_settings
0|0|0|SCAN TABLE res_config_settings
0|0|0|SCAN TABLE res_config_installer
0|0|0|SCAN TABLE res_config_installer
0|0|0|SCAN TABLE res_config
0|0|0|SCAN TABLE res_config
0|0|0|SCAN TABLE res_company
0|0|0|SCAN TABLE res_company
0|0|0|SCAN TABLE res_bank
0|0|0|SCAN TABLE res_bank
0|0|0|SCAN TABLE report_paperformat
0|0|0|SCAN TABLE report_paperformat
0|0|0|SCAN TABLE stock_move
0|0|0|SCAN TABLE stock_move
0|0|0|SCAN TABLE temp_range
0|0|0|SCAN TABLE temp_range
0|0|0|SCAN TABLE report
0|0|0|SCAN TABLE report
0|0|0|SEARCH TABLE rel_badge_auth_users USING COVERING INDEX
rel_badge_auth_users_res_users_id_index (res_users_id=?)
0|0|0|SCAN TABLE purchase_order_line_invoice
0|0|0|SCAN TABLE purchase_order_line_invoice
0|0|0|SCAN TABLE purchase_order_group
0|0|0|SCAN TABLE purchase_order_group
0|0|0|SCAN TABLE purchase_config_settings
0|0|0|SCAN TABLE purchase_config_settings
0|0|0|SCAN TABLE project_task_work
0|0|0|SEARCH TABLE project_task_work USING COVERING INDEX
project_task_work_user_id_index (user_id=?)
0|0|0|SCAN TABLE project_task_work
0|0|0|SCAN TABLE project_task_type
0|0|0|SCAN TABLE project_task_type
0|0|0|SCAN TABLE project_task_history
0|0|0|SCAN TABLE project_task_delegate
0|0|0|SCAN TABLE project_task_delegate
0|0|0|SCAN TABLE project_task_delegate
0|0|0|SCAN TABLE project_project
0|0|0|SCAN TABLE project_project
0|0|0|SCAN TABLE project_issue_version
0|0|0|SCAN TABLE project_issue_version
0|0|0|SEARCH TABLE project_task USING COVERING INDEX
project_task_user_id_index (user_id=?)
0|0|0|SCAN TABLE project_task
0|0|0|SEARCH TABLE project_task USING COVERING INDEX
project_task_reviewer_id_index (reviewer_id=?)
0|0|0|SCAN TABLE project_task
0|0|0|SEARCH TABLE project_issue USING COVERING INDEX
project_issue_user_id_index (user_id=?)
0|0|0|SCAN TABLE project_issue
0|0|0|SCAN TABLE project_issue
0|0|0|SCAN TABLE project_config_settings
0|0|0|SCAN TABLE project_config_settings
0|0|0|SCAN TABLE project_category
0|0|0|SCAN TABLE project_category
0|0|0|SCAN TABLE project_account_analytic_line
0|0|0|SCAN TABLE project_account_analytic_line
0|0|0|SCAN TABLE product_uom_categ
0|0|0|SCAN TABLE product_uom_categ
0|0|0|SCAN TABLE product_ul
0|0|0|SCAN TABLE product_ul
0|0|0|SCAN TABLE product_supplierinfo
0|0|0|SCAN TABLE product_supplierinfo
0|0|0|SCAN TABLE product_style
0|0|0|SCAN TABLE product_style
0|0|0|SCAN TABLE product_removal
0|0|0|SCAN TABLE product_removal
0|0|0|SCAN TABLE product_putaway
0|0|0|SCAN TABLE product_putaway
0|0|0|SCAN TABLE product_public_category
0|0|0|SCAN TABLE product_public_category
0|0|0|SCAN TABLE product_pricelist_version
0|0|0|SCAN TABLE product_pricelist_version
0|0|0|SCAN TABLE product_pricelist_type
0|0|0|SCAN TABLE product_pricelist_type
0|0|0|SCAN TABLE product_pricelist_item
0|0|0|SCAN TABLE product_pricelist_item
0|0|0|SCAN TABLE product_pricelist
0|0|0|SCAN TABLE product_pricelist
0|0|0|SCAN TABLE product_price_type
0|0|0|SCAN TABLE product_price_type
0|0|0|SCAN TABLE product_price_list
0|0|0|SCAN TABLE product_price_list
0|0|0|SCAN TABLE product_price_history
0|0|0|SCAN TABLE product_price_history
0|0|0|SCAN TABLE product_packaging
0|0|0|SCAN TABLE product_packaging
0|0|0|SCAN TABLE product_category
0|0|0|SCAN TABLE product_category
0|0|0|SCAN TABLE product_attribute_value
0|0|0|SCAN TABLE product_attribute_value
0|0|0|SCAN TABLE product_attribute_price
0|0|0|SCAN TABLE product_attribute_price
0|0|0|SCAN TABLE product_attribute_line
0|0|0|SCAN TABLE product_attribute_line
0|0|0|SCAN TABLE product_attribute
0|0|0|SCAN TABLE product_attribute
0|0|0|SCAN TABLE procurement_rule
0|0|0|SCAN TABLE procurement_rule
0|0|0|SCAN TABLE procurement_orderpoint_compute
0|0|0|SCAN TABLE procurement_orderpoint_compute
0|0|0|SCAN TABLE procurement_order_compute_all
0|0|0|SCAN TABLE procurement_order_compute_all
0|0|0|SCAN TABLE procurement_order
0|0|0|SCAN TABLE procurement_order
0|0|0|SCAN TABLE procurement_group
0|0|0|SCAN TABLE procurement_group
0|0|0|SCAN TABLE pricelist_partnerinfo
0|0|0|SCAN TABLE pricelist_partnerinfo
0|0|0|SCAN TABLE pos_session_opening
0|0|0|SCAN TABLE pos_session_opening
0|0|0|SCAN TABLE pos_session
0|0|0|SCAN TABLE pos_session
0|0|0|SEARCH TABLE pos_session USING COVERING INDEX pos_session_user_id_index
(user_id=?)
0|0|0|SCAN TABLE pos_order_line
0|0|0|SCAN TABLE pos_order_line
0|0|0|SCAN TABLE pos_order
0|0|0|SCAN TABLE pos_order
0|0|0|SCAN TABLE pos_order
0|0|0|SCAN TABLE pos_open_statement
0|0|0|SCAN TABLE pos_open_statement
0|0|0|SCAN TABLE pos_make_payment
0|0|0|SCAN TABLE pos_make_payment
0|0|0|SCAN TABLE pos_ean_wizard
0|0|0|SCAN TABLE pos_ean_wizard
0|0|0|SCAN TABLE pos_discount
0|0|0|SCAN TABLE pos_discount
0|0|0|SCAN TABLE pos_details
0|0|0|SCAN TABLE pos_details
0|0|0|SCAN TABLE pos_confirm
0|0|0|SCAN TABLE pos_confirm
0|0|0|SCAN TABLE pos_config
0|0|0|SCAN TABLE pos_config
0|0|0|SCAN TABLE pos_category
0|0|0|SCAN TABLE pos_category
0|0|0|SCAN TABLE portal_wizard_user
0|0|0|SCAN TABLE portal_wizard_user
0|0|0|SCAN TABLE portal_wizard
0|0|0|SCAN TABLE portal_wizard
0|0|0|SCAN TABLE payment_transaction
0|0|0|SCAN TABLE payment_transaction
0|0|0|SCAN TABLE payment_acquirer
0|0|0|SCAN TABLE payment_acquirer
0|0|0|SCAN TABLE osv_memory_autovacuum
0|0|0|SCAN TABLE osv_memory_autovacuum
0|0|0|SCAN TABLE note_tag
0|0|0|SCAN TABLE note_tag
0|0|0|SCAN TABLE note_stage
0|0|0|SCAN TABLE note_stage
0|0|0|SCAN TABLE note_stage
0|0|0|SCAN TABLE note_note
0|0|0|SCAN TABLE note_note
0|0|0|SCAN TABLE note_note
0|0|0|SCAN TABLE multi_company_default
0|0|0|SCAN TABLE multi_company_default
0|0|0|SCAN TABLE mrp_workcenter_load
0|0|0|SCAN TABLE mrp_workcenter_load
0|0|0|SCAN TABLE mrp_workcenter
0|0|0|SCAN TABLE mrp_workcenter
0|0|0|SCAN TABLE mrp_routing_workcenter
0|0|0|SCAN TABLE mrp_routing_workcenter
0|0|0|SCAN TABLE mrp_routing
0|0|0|SCAN TABLE mrp_routing
0|0|0|SCAN TABLE mrp_property_group
0|0|0|SCAN TABLE mrp_property_group
0|0|0|SCAN TABLE mrp_property
0|0|0|SCAN TABLE mrp_property
0|0|0|SCAN TABLE mrp_production_workcenter_line
0|0|0|SCAN TABLE mrp_production_workcenter_line
0|0|0|SCAN TABLE mrp_production_product_line
0|0|0|SCAN TABLE mrp_production_product_line
0|0|0|SCAN TABLE mrp_production
0|0|0|SCAN TABLE mrp_production
0|0|0|SCAN TABLE mrp_production
0|0|0|SCAN TABLE mrp_product_produce_line
0|0|0|SCAN TABLE mrp_product_produce_line
0|0|0|SCAN TABLE mrp_product_produce
0|0|0|SCAN TABLE mrp_product_produce
0|0|0|SCAN TABLE mrp_product_price
0|0|0|SCAN TABLE mrp_product_price
0|0|0|SCAN TABLE mrp_config_settings
0|0|0|SCAN TABLE mrp_config_settings
0|0|0|SCAN TABLE mrp_bom_line
0|0|0|SCAN TABLE mrp_bom_line
0|0|0|SCAN TABLE mrp_bom
0|0|0|SCAN TABLE mrp_bom
0|0|0|SCAN TABLE marketing_config_settings
0|0|0|SCAN TABLE marketing_config_settings
0|0|0|SCAN TABLE make_procurement
0|0|0|SCAN TABLE make_procurement
0|0|0|SCAN TABLE mail_wizard_invite
0|0|0|SCAN TABLE mail_wizard_invite
0|0|0|SEARCH TABLE mail_vote USING COVERING INDEX mail_vote_user_id_index
(user_id=?)
0|0|0|SCAN TABLE mail_message_subtype
0|0|0|SCAN TABLE mail_message_subtype
0|0|0|SCAN TABLE mail_message
0|0|0|SCAN TABLE mail_message
0|0|0|SCAN TABLE mail_mail
0|0|0|SCAN TABLE mail_mail
0|0|0|SCAN TABLE mail_group
0|0|0|SCAN TABLE mail_group
0|0|0|SCAN TABLE mail_compose_message
0|0|0|SCAN TABLE mail_compose_message
0|0|0|SCAN TABLE mail_alias
0|0|0|SCAN TABLE mail_alias
0|0|0|SCAN TABLE mail_alias
0|0|0|SCAN TABLE lunch_validation
0|0|0|SCAN TABLE lunch_validation
0|0|0|SCAN TABLE lunch_product_category
0|0|0|SCAN TABLE lunch_product_category
0|0|0|SCAN TABLE lunch_product
0|0|0|SCAN TABLE lunch_product
0|0|0|SCAN TABLE lunch_order_order
0|0|0|SCAN TABLE lunch_order_order
0|0|0|SCAN TABLE lunch_order_line
0|0|0|SCAN TABLE lunch_order_line
0|0|0|SCAN TABLE lunch_order_line
0|0|0|SCAN TABLE lunch_order
0|0|0|SCAN TABLE lunch_order
0|0|0|SCAN TABLE lunch_order
0|0|0|SCAN TABLE lunch_cashmove
0|0|0|SCAN TABLE lunch_cashmove
0|0|0|SCAN TABLE lunch_cashmove
0|0|0|SCAN TABLE lunch_cancel
0|0|0|SCAN TABLE lunch_cancel
0|0|0|SCAN TABLE lunch_alert
0|0|0|SCAN TABLE lunch_alert
0|0|0|SCAN TABLE knowledge_config_settings
0|0|0|SCAN TABLE knowledge_config_settings
0|0|0|SEARCH TABLE ir_values USING COVERING INDEX ir_values_user_id_index
(user_id=?)
0|0|0|SCAN TABLE ir_values
0|0|0|SCAN TABLE ir_values
0|0|0|SEARCH TABLE ir_ui_view_custom USING COVERING INDEX
ir_ui_view_custom_user_id_ref_id (user_id=?)
0|0|0|SCAN TABLE ir_ui_view_custom
0|0|0|SCAN TABLE ir_ui_view_custom
0|0|0|SCAN TABLE ir_ui_view
0|0|0|SCAN TABLE ir_ui_view
0|0|0|SCAN TABLE ir_ui_menu
0|0|0|SCAN TABLE ir_ui_menu
0|0|0|SCAN TABLE ir_server_object_lines
0|0|0|SCAN TABLE ir_server_object_lines
0|0|0|SCAN TABLE ir_sequence_type
0|0|0|SCAN TABLE ir_sequence_type
0|0|0|SCAN TABLE ir_sequence
0|0|0|SCAN TABLE ir_sequence
0|0|0|SCAN TABLE ir_module_module_dependency
0|0|0|SCAN TABLE ir_module_module_dependency
0|0|0|SCAN TABLE ir_module_module
0|0|0|SCAN TABLE ir_module_module
0|0|0|SCAN TABLE ir_module_category
0|0|0|SCAN TABLE ir_module_category
0|0|0|SCAN TABLE ir_model_relation
0|0|0|SCAN TABLE ir_model_relation
0|0|0|SCAN TABLE ir_model_fields
0|0|0|SCAN TABLE ir_model_fields
0|0|0|SCAN TABLE ir_model_data
0|0|0|SCAN TABLE ir_model_data
0|0|0|SCAN TABLE ir_model_constraint
0|0|0|SCAN TABLE ir_model_constraint
0|0|0|SCAN TABLE ir_model_access
0|0|0|SCAN TABLE ir_model_access
0|0|0|SCAN TABLE ir_model
0|0|0|SCAN TABLE ir_model
0|0|0|SCAN TABLE ir_mail_server
0|0|0|SCAN TABLE ir_mail_server
0|0|0|SCAN TABLE ir_logging
0|0|0|SCAN TABLE ir_filters
0|0|0|SCAN TABLE ir_filters USING COVERING INDEX
sqlite_autoindex_ir_filters_1
0|0|0|SCAN TABLE ir_filters
0|0|0|SCAN TABLE ir_fields_converter
0|0|0|SCAN TABLE ir_fields_converter
0|0|0|SCAN TABLE ir_exports_line
0|0|0|SCAN TABLE ir_exports_line
0|0|0|SCAN TABLE ir_exports
0|0|0|SCAN TABLE ir_exports
0|0|0|SCAN TABLE ir_default
0|0|0|SCAN TABLE ir_default
0|0|0|SCAN TABLE ir_default
0|0|0|SCAN TABLE ir_cron
0|0|0|SCAN TABLE ir_cron
0|0|0|SCAN TABLE ir_cron
0|0|0|SCAN TABLE ir_config_parameter
0|0|0|SCAN TABLE ir_config_parameter
0|0|0|SCAN TABLE ir_attachment
0|0|0|SCAN TABLE ir_attachment
0|0|0|SCAN TABLE ir_actions_todo
0|0|0|SCAN TABLE ir_actions_todo
0|0|0|SCAN TABLE ir_act_window_view
0|0|0|SCAN TABLE ir_act_window_view
0|0|0|SCAN TABLE ir_act_window
0|0|0|SCAN TABLE ir_act_window
0|0|0|SCAN TABLE ir_act_url
0|0|0|SCAN TABLE ir_act_url
0|0|0|SCAN TABLE ir_act_server
0|0|0|SCAN TABLE ir_act_server
0|0|0|SCAN TABLE ir_act_report_xml
0|0|0|SCAN TABLE ir_act_report_xml
0|0|0|SCAN TABLE ir_act_client
0|0|0|SCAN TABLE ir_act_client
0|0|0|SCAN TABLE ir_actions
0|0|0|SCAN TABLE ir_actions
0|0|0|SCAN TABLE ir_actions
0|0|0|SCAN TABLE ir_actions
0|0|0|SEARCH TABLE im_livechat_channel_im_user USING COVERING INDEX
im_livechat_channel_im_user_user_id_index (user_id=?)
0|0|0|SCAN TABLE im_livechat_channel
0|0|0|SCAN TABLE im_livechat_channel
0|0|0|SCAN TABLE im_chat_session_res_users_rel
0|0|0|SCAN TABLE im_chat_session_res_users_rel
0|0|0|SCAN TABLE im_chat_session_res_users_rel
0|0|0|SCAN TABLE im_chat_session
0|0|0|SCAN TABLE im_chat_session
0|0|0|SEARCH TABLE im_chat_presence USING COVERING INDEX
sqlite_autoindex_im_chat_presence_1 (user_id=?)
0|0|0|SCAN TABLE im_chat_presence
0|0|0|SCAN TABLE im_chat_presence
0|0|0|SCAN TABLE im_chat_message
0|0|0|SCAN TABLE im_chat_message
0|0|0|SCAN TABLE im_chat_message
0|0|0|SCAN TABLE res_users
0|0|0|SCAN TABLE res_users
0|0|0|SCAN TABLE hr_timesheet_sheet_sheet
0|0|0|SCAN TABLE hr_timesheet_sheet_sheet
0|0|0|SCAN TABLE hr_timesheet_sheet_sheet
0|0|0|SCAN TABLE hr_timesheet_invoice_factor
0|0|0|SCAN TABLE hr_timesheet_invoice_factor
0|0|0|SCAN TABLE hr_timesheet_invoice_create_final
0|0|0|SCAN TABLE hr_timesheet_invoice_create_final
0|0|0|SCAN TABLE hr_timesheet_invoice_create
0|0|0|SCAN TABLE hr_timesheet_invoice_create
0|0|0|SCAN TABLE hr_timesheet_current_open
0|0|0|SCAN TABLE hr_timesheet_current_open
0|0|0|SCAN TABLE hr_timesheet_analytic_profit
0|0|0|SCAN TABLE hr_timesheet_analytic_profit
0|0|0|SCAN TABLE hr_sign_out_project
0|0|0|SCAN TABLE hr_sign_out_project
0|0|0|SCAN TABLE hr_sign_in_project
0|0|0|SCAN TABLE hr_sign_in_project
0|0|0|SCAN TABLE hr_recruitment_stage
0|0|0|SCAN TABLE hr_recruitment_stage
0|0|0|SCAN TABLE hr_recruitment_source
0|0|0|SCAN TABLE hr_recruitment_source
0|0|0|SCAN TABLE hr_recruitment_partner_create
0|0|0|SCAN TABLE hr_recruitment_partner_create
0|0|0|SCAN TABLE hr_recruitment_degree
0|0|0|SCAN TABLE hr_recruitment_degree
0|0|0|SCAN TABLE hr_job
0|0|0|SCAN TABLE hr_job
0|0|0|SCAN TABLE hr_job
0|0|0|SCAN TABLE hr_holidays_summary_employee
0|0|0|SCAN TABLE hr_holidays_summary_employee
0|0|0|SCAN TABLE hr_holidays_summary_dept
0|0|0|SCAN TABLE hr_holidays_summary_dept
0|0|0|SCAN TABLE resource_resource
0|0|0|SCAN TABLE resource_resource
0|0|0|SCAN TABLE resource_resource
0|0|0|SCAN TABLE hr_holidays_status
0|0|0|SCAN TABLE hr_holidays_status
0|0|0|SCAN TABLE hr_holidays
0|0|0|SCAN TABLE hr_holidays
0|0|0|SCAN TABLE hr_holidays
0|0|0|SCAN TABLE hr_expense_line
0|0|0|SCAN TABLE hr_expense_line
0|0|0|SCAN TABLE hr_expense_expense
0|0|0|SCAN TABLE hr_expense_expense
0|0|0|SCAN TABLE hr_expense_expense
0|0|0|SCAN TABLE hr_expense_expense
0|0|0|SCAN TABLE hr_evaluation_plan_phase
0|0|0|SCAN TABLE hr_evaluation_plan_phase
0|0|0|SCAN TABLE hr_evaluation_plan
0|0|0|SCAN TABLE hr_evaluation_plan
0|0|0|SCAN TABLE hr_evaluation_interview
0|0|0|SCAN TABLE hr_evaluation_interview
0|0|0|SCAN TABLE hr_evaluation_interview
0|0|0|SCAN TABLE hr_evaluation_evaluation
0|0|0|SCAN TABLE hr_evaluation_evaluation
0|0|0|SCAN TABLE hr_employee_category
0|0|0|SCAN TABLE hr_employee_category
0|0|0|SCAN TABLE hr_employee
0|0|0|SCAN TABLE hr_employee
0|0|0|SCAN TABLE hr_department
0|0|0|SCAN TABLE hr_department
0|0|0|SCAN TABLE hr_config_settings
0|0|0|SCAN TABLE hr_config_settings
0|0|0|SCAN TABLE hr_attendance_error
0|0|0|SCAN TABLE hr_attendance_error
0|0|0|SCAN TABLE hr_attendance
0|0|0|SCAN TABLE hr_attendance
0|0|0|SCAN TABLE hr_applicant_category
0|0|0|SCAN TABLE hr_applicant_category
0|0|0|SCAN TABLE hr_analytic_timesheet
0|0|0|SCAN TABLE hr_analytic_timesheet
0|0|0|SCAN TABLE hr_action_reason
0|0|0|SCAN TABLE hr_action_reason
0|0|0|SCAN TABLE gamification_goal_wizard
0|0|0|SCAN TABLE gamification_goal_wizard
0|0|0|SCAN TABLE gamification_goal_definition
0|0|0|SCAN TABLE gamification_goal_definition
0|0|0|SCAN TABLE gamification_goal
0|0|0|SCAN TABLE gamification_goal
0|0|0|SCAN TABLE gamification_goal
0|0|0|SCAN TABLE gamification_challenge_line
0|0|0|SCAN TABLE gamification_challenge_line
0|0|0|SCAN TABLE gamification_challenge
0|0|0|SCAN TABLE gamification_challenge
0|0|0|SCAN TABLE gamification_challenge
0|0|0|SCAN TABLE gamification_badge_user_wizard
0|0|0|SCAN TABLE gamification_badge_user_wizard
0|0|0|SCAN TABLE gamification_badge_user_wizard
0|0|0|SCAN TABLE gamification_badge_user
0|0|0|SCAN TABLE gamification_badge_user
0|0|0|SCAN TABLE gamification_badge_user
0|0|0|SCAN TABLE gamification_badge_user
0|0|0|SCAN TABLE gamification_badge
0|0|0|SCAN TABLE gamification_badge
0|0|0|SCAN TABLE forum_tag
0|0|0|SCAN TABLE forum_tag
0|0|0|SCAN TABLE forum_post_vote
0|0|0|SCAN TABLE forum_post_vote
0|0|0|SCAN TABLE forum_post_vote
0|0|0|SCAN TABLE forum_post_reason
0|0|0|SCAN TABLE forum_post_reason
0|0|0|SEARCH TABLE forum_post USING COVERING INDEX forum_post_write_uid_index
(write_uid=?)
0|0|0|SEARCH TABLE forum_post USING COVERING INDEX
forum_post_create_uid_index (create_uid=?)
0|0|0|SEARCH TABLE forum_post USING COVERING INDEX
forum_post_closed_uid_index (closed_uid=?)
0|0|0|SCAN TABLE forum_forum
0|0|0|SCAN TABLE forum_forum
0|0|0|SCAN TABLE fleet_vehicle_tag
0|0|0|SCAN TABLE fleet_vehicle_tag
0|0|0|SCAN TABLE fleet_vehicle_state
0|0|0|SCAN TABLE fleet_vehicle_state
0|0|0|SCAN TABLE fleet_vehicle_odometer
0|0|0|SCAN TABLE fleet_vehicle_odometer
0|0|0|SCAN TABLE fleet_vehicle_model_brand
0|0|0|SCAN TABLE fleet_vehicle_model_brand
0|0|0|SCAN TABLE fleet_vehicle_model
0|0|0|SCAN TABLE fleet_vehicle_model
0|0|0|SCAN TABLE fleet_vehicle_log_services
0|0|0|SCAN TABLE fleet_vehicle_log_services
0|0|0|SCAN TABLE fleet_vehicle_log_fuel
0|0|0|SCAN TABLE fleet_vehicle_log_fuel
0|0|0|SCAN TABLE fleet_vehicle
0|0|0|SCAN TABLE fleet_vehicle
0|0|0|SCAN TABLE fleet_service_type
0|0|0|SCAN TABLE fleet_service_type
0|0|0|SCAN TABLE fleet_contract_state
0|0|0|SCAN TABLE fleet_contract_state
0|0|0|SCAN TABLE fetchmail_server
0|0|0|SCAN TABLE fetchmail_server
0|0|0|SCAN TABLE fetchmail_config_settings
0|0|0|SCAN TABLE fetchmail_config_settings
0|0|0|SCAN TABLE event_type
0|0|0|SCAN TABLE event_type
0|0|0|SCAN TABLE event_registration
0|0|0|SCAN TABLE event_registration
0|0|0|SCAN TABLE event_registration
0|0|0|SCAN TABLE event_event_ticket
0|0|0|SCAN TABLE event_event_ticket
0|0|0|SCAN TABLE event_event
0|0|0|SCAN TABLE event_event
0|0|0|SCAN TABLE event_event
0|0|0|SCAN TABLE event_confirm
0|0|0|SCAN TABLE event_confirm
0|0|0|SCAN TABLE email_template_preview
0|0|0|SCAN TABLE email_template_preview
0|0|0|SCAN TABLE email_template
0|0|0|SCAN TABLE email_template
0|0|0|SCAN TABLE decimal_precision_test
0|0|0|SCAN TABLE decimal_precision_test
0|0|0|SCAN TABLE decimal_precision
0|0|0|SCAN TABLE decimal_precision
0|0|0|SCAN TABLE crm_tracking_source
0|0|0|SCAN TABLE crm_tracking_source
0|0|0|SCAN TABLE crm_tracking_medium
0|0|0|SCAN TABLE crm_tracking_medium
0|0|0|SCAN TABLE crm_tracking_campaign
0|0|0|SCAN TABLE crm_tracking_campaign
0|0|0|SCAN TABLE crm_segmentation_line
0|0|0|SCAN TABLE crm_segmentation_line
0|0|0|SCAN TABLE crm_segmentation
0|0|0|SCAN TABLE crm_segmentation
0|0|0|SCAN TABLE crm_phonecall2phonecall
0|0|0|SCAN TABLE crm_phonecall2phonecall
0|0|0|SCAN TABLE crm_phonecall2phonecall
0|0|0|SCAN TABLE crm_phonecall
0|0|0|SCAN TABLE crm_phonecall
0|0|0|SCAN TABLE crm_phonecall
0|0|0|SCAN TABLE crm_payment_mode
0|0|0|SCAN TABLE crm_payment_mode
0|0|0|SCAN TABLE crm_partner_binding
0|0|0|SCAN TABLE crm_partner_binding
0|0|0|SCAN TABLE crm_merge_opportunity
0|0|0|SEARCH TABLE crm_merge_opportunity USING COVERING INDEX
crm_merge_opportunity_user_id_index (user_id=?)
0|0|0|SCAN TABLE crm_merge_opportunity
0|0|0|SCAN TABLE crm_make_sale
0|0|0|SCAN TABLE crm_make_sale
0|0|0|SCAN TABLE crm_lead2opportunity_partner_mass
0|0|0|SEARCH TABLE crm_lead2opportunity_partner_mass USING COVERING INDEX
crm_lead2opportunity_partner_mass_user_id_index (user_id=?)
0|0|0|SCAN TABLE crm_lead2opportunity_partner_mass
0|0|0|SEARCH TABLE crm_lead2opportunity_partner USING COVERING INDEX
crm_lead2opportunity_partner_user_id_index (user_id=?)
0|0|0|SCAN TABLE crm_lead2opportunity_partner
0|0|0|SCAN TABLE crm_lead2opportunity_partner
0|0|0|SCAN TABLE crm_case_stage
0|0|0|SCAN TABLE crm_case_stage
0|0|0|SCAN TABLE crm_case_section
0|0|0|SCAN TABLE crm_case_section
0|0|0|SCAN TABLE crm_case_section
0|0|0|SCAN TABLE crm_case_categ
0|0|0|SCAN TABLE crm_case_categ
0|0|0|SCAN TABLE change_production_qty
0|0|0|SCAN TABLE change_production_qty
0|0|0|SCAN TABLE change_password_wizard
0|0|0|SCAN TABLE change_password_wizard
0|0|0|SCAN TABLE change_password_user
0|0|0|SCAN TABLE change_password_user
0|0|0|SCAN TABLE change_password_user
0|0|0|SCAN TABLE cash_box_out
0|0|0|SCAN TABLE cash_box_out
0|0|0|SCAN TABLE cash_box_in
0|0|0|SCAN TABLE cash_box_in
0|0|0|SCAN TABLE calendar_event_type
0|0|0|SCAN TABLE calendar_event_type
0|0|0|SCAN TABLE calendar_contacts
0|0|0|SCAN TABLE calendar_contacts
0|0|0|SCAN TABLE calendar_contacts
0|0|0|SCAN TABLE calendar_attendee
0|0|0|SCAN TABLE calendar_attendee
0|0|0|SCAN TABLE calendar_alarm
0|0|0|SCAN TABLE calendar_alarm
0|0|0|SCAN TABLE bus_bus
0|0|0|SCAN TABLE bus_bus
0|0|0|SCAN TABLE board_create
0|0|0|SCAN TABLE board_create
0|0|0|SCAN TABLE blog_tag
0|0|0|SCAN TABLE blog_tag
0|0|0|SCAN TABLE blog_post_history_show_diff
0|0|0|SCAN TABLE blog_post_history_show_diff
0|0|0|SCAN TABLE blog_post_history
0|0|0|SCAN TABLE blog_post_history
0|0|0|SEARCH TABLE blog_post USING COVERING INDEX blog_post_write_uid_index
(write_uid=?)
0|0|0|SEARCH TABLE blog_post USING COVERING INDEX blog_post_create_uid_index
(create_uid=?)
0|0|0|SCAN TABLE blog_blog
0|0|0|SCAN TABLE blog_blog
0|0|0|SCAN TABLE base_update_translations
0|0|0|SCAN TABLE base_update_translations
0|0|0|SCAN TABLE base_setup_terminology
0|0|0|SCAN TABLE base_setup_terminology
0|0|0|SCAN TABLE base_partner_merge_line
0|0|0|SCAN TABLE base_partner_merge_line
0|0|0|SCAN TABLE base_partner_merge_automatic_wizard
0|0|0|SCAN TABLE base_partner_merge_automatic_wizard
0|0|0|SCAN TABLE base_module_upgrade
0|0|0|SCAN TABLE base_module_upgrade
0|0|0|SCAN TABLE base_module_update
0|0|0|SCAN TABLE base_module_update
0|0|0|SCAN TABLE base_module_configuration
0|0|0|SCAN TABLE base_module_configuration
0|0|0|SCAN TABLE base_language_install
0|0|0|SCAN TABLE base_language_install
0|0|0|SCAN TABLE base_language_import
0|0|0|SCAN TABLE base_language_import
0|0|0|SCAN TABLE base_language_export
0|0|0|SCAN TABLE base_language_export
0|0|0|SCAN TABLE base_import_tests_models_preview
0|0|0|SCAN TABLE base_import_tests_models_preview
0|0|0|SCAN TABLE base_import_tests_models_o2m_child
0|0|0|SCAN TABLE base_import_tests_models_o2m_child
0|0|0|SCAN TABLE base_import_tests_models_o2m
0|0|0|SCAN TABLE base_import_tests_models_o2m
0|0|0|SCAN TABLE base_import_tests_models_m2o_required_related
0|0|0|SCAN TABLE base_import_tests_models_m2o_required_related
0|0|0|SCAN TABLE base_import_tests_models_m2o_required
0|0|0|SCAN TABLE base_import_tests_models_m2o_required
0|0|0|SCAN TABLE base_import_tests_models_m2o_related
0|0|0|SCAN TABLE base_import_tests_models_m2o_related
0|0|0|SCAN TABLE base_import_tests_models_m2o
0|0|0|SCAN TABLE base_import_tests_models_m2o
0|0|0|SCAN TABLE base_import_tests_models_char_stillreadonly
0|0|0|SCAN TABLE base_import_tests_models_char_stillreadonly
0|0|0|SCAN TABLE base_import_tests_models_char_states
0|0|0|SCAN TABLE base_import_tests_models_char_states
0|0|0|SCAN TABLE base_import_tests_models_char_required
0|0|0|SCAN TABLE base_import_tests_models_char_required
0|0|0|SCAN TABLE base_import_tests_models_char_readonly
0|0|0|SCAN TABLE base_import_tests_models_char_readonly
0|0|0|SCAN TABLE base_import_tests_models_char_noreadonly
0|0|0|SCAN TABLE base_import_tests_models_char_noreadonly
0|0|0|SCAN TABLE base_import_tests_models_char
0|0|0|SCAN TABLE base_import_tests_models_char
0|0|0|SCAN TABLE base_import_import
0|0|0|SCAN TABLE base_import_import
0|0|0|SCAN TABLE base_config_settings
0|0|0|SCAN TABLE base_config_settings
0|0|0|SCAN TABLE base_config_settings
0|0|0|SCAN TABLE base_action_rule_lead_test
0|0|0|SCAN TABLE base_action_rule_lead_test
0|0|0|SCAN TABLE base_action_rule_lead_test
0|0|0|SCAN TABLE base_action_rule
0|0|0|SCAN TABLE base_action_rule
0|0|0|SCAN TABLE base_action_rule
0|0|0|SCAN TABLE accounting_report
0|0|0|SCAN TABLE accounting_report
0|0|0|SCAN TABLE account_voucher_line
0|0|0|SCAN TABLE account_voucher_line
0|0|0|SCAN TABLE account_voucher
0|0|0|SCAN TABLE account_voucher
0|0|0|SCAN TABLE account_vat_declaration
0|0|0|SCAN TABLE account_vat_declaration
0|0|0|SCAN TABLE account_use_model
0|0|0|SCAN TABLE account_use_model
0|0|0|SCAN TABLE account_unreconcile_reconcile
0|0|0|SCAN TABLE account_unreconcile_reconcile
0|0|0|SCAN TABLE account_unreconcile
0|0|0|SCAN TABLE account_unreconcile
0|0|0|SCAN TABLE account_tax_template
0|0|0|SCAN TABLE account_tax_template
0|0|0|SCAN TABLE account_tax_code_template
0|0|0|SCAN TABLE account_tax_code_template
0|0|0|SCAN TABLE account_tax_code
0|0|0|SCAN TABLE account_tax_code
0|0|0|SCAN TABLE account_tax_chart
0|0|0|SCAN TABLE account_tax_chart
0|0|0|SCAN TABLE account_tax
0|0|0|SCAN TABLE account_tax
0|0|0|SCAN TABLE account_subscription_line
0|0|0|SCAN TABLE account_subscription_line
0|0|0|SCAN TABLE account_subscription_generate
0|0|0|SCAN TABLE account_subscription_generate
0|0|0|SCAN TABLE account_subscription
0|0|0|SCAN TABLE account_subscription
0|0|0|SCAN TABLE account_statement_operation_template
0|0|0|SCAN TABLE account_statement_operation_template
0|0|0|SCAN TABLE account_statement_from_invoice_lines
0|0|0|SCAN TABLE account_statement_from_invoice_lines
0|0|0|SCAN TABLE account_state_open
0|0|0|SCAN TABLE account_state_open
0|0|0|SCAN TABLE account_sequence_fiscalyear
0|0|0|SCAN TABLE account_sequence_fiscalyear
0|0|0|SCAN TABLE account_report_general_ledger
0|0|0|SCAN TABLE account_report_general_ledger
0|0|0|SCAN TABLE account_print_journal
0|0|0|SCAN TABLE account_print_journal
0|0|0|SCAN TABLE account_period_close
0|0|0|SCAN TABLE account_period_close
0|0|0|SCAN TABLE account_payment_term_line
0|0|0|SCAN TABLE account_payment_term_line
0|0|0|SCAN TABLE account_payment_term
0|0|0|SCAN TABLE account_payment_term
0|0|0|SCAN TABLE account_partner_reconcile_process
0|0|0|SCAN TABLE account_partner_reconcile_process
0|0|0|SCAN TABLE account_partner_ledger
0|0|0|SCAN TABLE account_partner_ledger
0|0|0|SCAN TABLE account_partner_balance
0|0|0|SCAN TABLE account_partner_balance
0|0|0|SCAN TABLE account_open_closed_fiscalyear
0|0|0|SCAN TABLE account_open_closed_fiscalyear
0|0|0|SCAN TABLE account_move_reconcile
0|0|0|SCAN TABLE account_move_reconcile
0|0|0|SCAN TABLE account_move_line_unreconcile_select
0|0|0|SCAN TABLE account_move_line_unreconcile_select
0|0|0|SCAN TABLE account_move_line_reconcile_writeoff
0|0|0|SCAN TABLE account_move_line_reconcile_writeoff
0|0|0|SCAN TABLE account_move_line_reconcile_select
0|0|0|SCAN TABLE account_move_line_reconcile_select
0|0|0|SCAN TABLE account_move_line_reconcile
0|0|0|SCAN TABLE account_move_line_reconcile
0|0|0|SCAN TABLE account_move_bank_reconcile
0|0|0|SCAN TABLE account_move_bank_reconcile
0|0|0|SCAN TABLE account_model_line
0|0|0|SCAN TABLE account_model_line
0|0|0|SCAN TABLE account_model
0|0|0|SCAN TABLE account_model
0|0|0|SCAN TABLE account_journal_select
0|0|0|SCAN TABLE account_journal_select
0|0|0|SCAN TABLE account_journal_period
0|0|0|SCAN TABLE account_journal_period
0|0|0|SCAN TABLE account_journal_cashbox_line
0|0|0|SCAN TABLE account_journal_cashbox_line
0|0|0|SCAN TABLE account_journal
0|0|0|SCAN TABLE account_journal
0|0|0|SCAN TABLE account_journal
0|0|0|SCAN TABLE account_invoice_tax
0|0|0|SCAN TABLE account_invoice_tax
0|0|0|SCAN TABLE res_partner
0|0|0|SCAN TABLE res_partner
0|0|0|SCAN TABLE res_partner
0|0|0|SCAN TABLE res_currency_rate
0|0|0|SCAN TABLE res_currency_rate
0|0|0|SCAN TABLE product_uom
0|0|0|SCAN TABLE product_uom
0|0|0|SCAN TABLE product_template
0|0|0|SCAN TABLE product_template
0|0|0|SCAN TABLE product_template
0|0|0|SCAN TABLE product_product
0|0|0|SCAN TABLE product_product
0|0|0|SCAN TABLE account_invoice_refund
0|0|0|SCAN TABLE account_invoice_refund
0|0|0|SCAN TABLE account_invoice_line
0|0|0|SCAN TABLE account_invoice_line
0|0|0|SCAN TABLE account_invoice_confirm
0|0|0|SCAN TABLE account_invoice_confirm
0|0|0|SCAN TABLE account_invoice_cancel
0|0|0|SCAN TABLE account_invoice_cancel
0|0|0|SCAN TABLE account_installer
0|0|0|SCAN TABLE account_installer
0|0|0|SCAN TABLE account_general_journal
0|0|0|SCAN TABLE account_general_journal
0|0|0|SCAN TABLE account_fiscalyear_close_state
0|0|0|SCAN TABLE account_fiscalyear_close_state
0|0|0|SCAN TABLE account_fiscalyear_close
0|0|0|SCAN TABLE account_fiscalyear_close
0|0|0|SCAN TABLE account_fiscalyear
0|0|0|SCAN TABLE account_fiscalyear
0|0|0|SCAN TABLE account_fiscal_position_template
0|0|0|SCAN TABLE account_fiscal_position_template
0|0|0|SCAN TABLE account_fiscal_position_tax_template
0|0|0|SCAN TABLE account_fiscal_position_tax_template
0|0|0|SCAN TABLE account_fiscal_position_tax
0|0|0|SCAN TABLE account_fiscal_position_tax
0|0|0|SCAN TABLE account_fiscal_position_account_template
0|0|0|SCAN TABLE account_fiscal_position_account_template
0|0|0|SCAN TABLE account_fiscal_position_account
0|0|0|SCAN TABLE account_fiscal_position_account
0|0|0|SCAN TABLE account_fiscal_position
0|0|0|SCAN TABLE account_fiscal_position
0|0|0|SCAN TABLE account_financial_report
0|0|0|SCAN TABLE account_financial_report
0|0|0|SCAN TABLE account_period
0|0|0|SCAN TABLE account_period
0|0|0|SCAN TABLE account_move_line
0|0|0|SCAN TABLE account_move_line
0|0|0|SCAN TABLE account_move
0|0|0|SCAN TABLE account_move
0|0|0|SCAN TABLE account_config_settings
0|0|0|SCAN TABLE account_config_settings
0|0|0|SCAN TABLE account_common_report
0|0|0|SCAN TABLE account_common_report
0|0|0|SCAN TABLE account_common_partner_report
0|0|0|SCAN TABLE account_common_partner_report
0|0|0|SCAN TABLE account_common_journal_report
0|0|0|SCAN TABLE account_common_journal_report
0|0|0|SCAN TABLE account_common_account_report
0|0|0|SCAN TABLE account_common_account_report
0|0|0|SCAN TABLE account_chart_template
0|0|0|SCAN TABLE account_chart_template
0|0|0|SCAN TABLE account_chart
0|0|0|SCAN TABLE account_chart
0|0|0|SCAN TABLE account_change_currency
0|0|0|SCAN TABLE account_change_currency
0|0|0|SCAN TABLE account_central_journal
0|0|0|SCAN TABLE account_central_journal
0|0|0|SCAN TABLE account_cashbox_line
0|0|0|SCAN TABLE account_cashbox_line
0|0|0|SCAN TABLE account_bank_statement_line
0|0|0|SCAN TABLE account_bank_statement_line
0|0|0|SCAN TABLE account_bank_statement
0|0|0|SCAN TABLE account_bank_statement
0|0|0|SCAN TABLE account_bank_statement
0|0|0|SCAN TABLE account_bank_accounts_wizard
0|0|0|SCAN TABLE account_bank_accounts_wizard
0|0|0|SCAN TABLE account_balance_report
0|0|0|SCAN TABLE account_balance_report
0|0|0|SCAN TABLE account_automatic_reconcile
0|0|0|SCAN TABLE account_automatic_reconcile
0|0|0|SCAN TABLE account_analytic_line
0|0|0|SCAN TABLE account_analytic_line
0|0|0|SCAN TABLE account_analytic_line
0|0|0|SCAN TABLE account_analytic_journal_report
0|0|0|SCAN TABLE account_analytic_journal_report
0|0|0|SCAN TABLE account_analytic_journal
0|0|0|SCAN TABLE account_analytic_journal
0|0|0|SCAN TABLE account_analytic_inverted_balance
0|0|0|SCAN TABLE account_analytic_inverted_balance
0|0|0|SCAN TABLE account_analytic_cost_ledger_journal_report
0|0|0|SCAN TABLE account_analytic_cost_ledger_journal_report
0|0|0|SCAN TABLE account_analytic_cost_ledger
0|0|0|SCAN TABLE account_analytic_cost_ledger
0|0|0|SCAN TABLE account_analytic_chart
0|0|0|SCAN TABLE account_analytic_chart
0|0|0|SCAN TABLE account_analytic_balance
0|0|0|SCAN TABLE account_analytic_balance
0|0|0|SCAN TABLE account_analytic_account
0|0|0|SCAN TABLE account_analytic_account
0|0|0|SCAN TABLE account_analytic_account
0|0|0|SCAN TABLE account_analytic_account
0|0|0|SCAN TABLE account_aged_trial_balance
0|0|0|SCAN TABLE account_aged_trial_balance
0|0|0|SCAN TABLE account_addtmpl_wizard
0|0|0|SCAN TABLE account_addtmpl_wizard
0|0|0|SCAN TABLE account_account_type
0|0|0|SCAN TABLE account_account_type
0|0|0|SCAN TABLE account_account_template
0|0|0|SCAN TABLE account_account_template
0|0|0|SCAN TABLE account_account
0|0|0|SCAN TABLE account_account  

-----  
>  Fri Jul 31 2015 15:34:56 CEST from "sqlite-mail"
><sqlite-mail at dev.dadbiz.es>  Subject: [sqlite] Bug in
>sqlite3_trace/trigger/delete
>
>  Hello? ! 
> ?
> I'm using sqlite for a project and with this specific database
> https://dev.dadbiz.es/tmp/odoo.db.zip (12MB compressed / 38MB uncompressed)
> this is happening: 
> ?
> -1 Registering an sqlite3_trace function when trying to delete a record
>just
> inserted on the table "res_users" the registered sqlite3_trace function is
> called lots of times and sometimes it segfaults (I think stack overflow), I
> think it enters in a unintended loop. 
> ?
> -2 If we do a dump "sqlite3 odoo.db .dump > odoo.db.sql" and try to
>recreate
> the database with "sqlite3 new-odoo.db < odoo.db.sql" we get errors for
> tables/views declarations out of order (trying to create a view
> https://www.endad.eu/tmp/odoo.db.zipthat refer to other views not yet
> created). 
> ?
> Attached there is the simple "C" test file with a shell file to make it
>with
> the flags I use on this project. 
> ?
> This database uses a lot of foreign keys. 
> ?
> The trigger on the "res_users" table is very simple: 
> ----- 
> BEFORE DELETE ON "res_users" 
> BEGIN 
> ??? SELECT RAISE(ABORT, 'Can not remove root/admin user!') 
> ??? WHERE OLD.id = 1; 
> END; 
> ----- 
> ?
> I've also tested with a fresh sqlite3.c/h from
> https://www.sqlite.org/snapshot/sqlite-amalgamation-201507231639.zip. 
> ?
> When tested with a single table with the above trigger with a fresh
>database
> the test program behaves as expected. 
> ----- 
> CREATE TABLE IF NOT EXISTS tbl(id? INTEGER PRIMARY KEY, name varchar); 
> INSERT OR IGNORE INTO tbl(id, name) VALUES 
> (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'); 
> CREATE TRIGGER IF NOT EXISTS tbl_delete_trigger BEFORE DELETE ON tbl 
> BEGIN 
> ??? SELECT RAISE(ABORT, 'Can not remove root/admin user!') WHERE OLD.id
>=
> 1; 
> END; 
> ----- 
> ?
> ?
> I found a small test that shows how to create a database that after ".dump"
> will not properly be restored. 
> ?
> After writing to you about this bug with sqlite3_trace/trigger I start
> thinking what I did with this database (odoo.db) that could possibly make
> it's ".dump" not usable to restore and I found the reason. 
> ?
> On that database I was constantly droping and recreating tables/views with
> slight different fields and that seems what makes sqlite3 get lost. 
> ?
> Example that creates a database not correctly restorable: 
> -------- 
> begin; 
> create table if not exists tbl(id integer primary key, name varchar); 
> insert or ignore into tbl(id, name) values (1,'a'), (2, 'b'); 
> create view if not exists tbl_view as select * from tbl; 
> create view if not exists tbl_view_view as select * from tbl_view; 
> drop view if exists tbl_view; 
> create view if not exists tbl_view as select * from tbl; 
> end; 
> -------- 
> ?
> After creating a database with the above sql we get the following from
> ".dump": 
> -------- 
> PRAGMA foreign_keys=OFF; 
> BEGIN TRANSACTION; 
> CREATE TABLE tbl(id integer primary key, name varchar); 
> INSERT INTO "tbl" VALUES(1,'a'); 
> INSERT INTO "tbl" VALUES(2,'b'); 
> CREATE VIEW tbl_view_view as select * from tbl_view;??? --<<<<<< here we
> are trying to create a view on another view not yet created 
> CREATE VIEW tbl_view as select * from tbl; 
> COMMIT; 
> -------- 
> ?
> On the ".dump"/".restore" problem it seems that sqlite3 shell rely on
> sqlite3_master rowid order to perform the ".dump" and when we drop/recreate
>a
> table/view that other tables/views depends sqlite3 do not detect it and
> simply add a new entry at the end of sqlite3_master. 
> ?
> ?
> -------- shell script to make the bug test program 
> MYINC=$HOME/dev/sqlite3 
> #MYINC=. 
> ?
> gcc \ 
> ??? -DTHREADSAFE=1 \ 
> ??? -DSQLITE_DEFAULT_FILE_FORMAT=4 \ 
> ??? -DSQLITE_DEFAULT_AUTOVACUUM=1 \ 
> ??? -DSQLITE_DEFAULT_FOREIGN_KEYS= 1 \ 
> ??? -DSQLITE_ENABLE_COLUMN_METADATA=1 \ 
> ??? -DSQLITE_ENABLE_FTS4=1 \ 
> ??? -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 \ 
> ??? -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ 
> ??? -DSQLITE_ENABLE_RTREE=1 \ 
> ??? -DSQLITE_ENABLE_STAT4=1 \ 
> ??? -DSQLITE_OMIT_TCL_VARIABLE=1 \ 
> ??? -DSQLITE_USE_URI=1 \ 
> ??? -DSQLITE_SOUNDEX=1\ 
> ??? -o test-sqlite-bug test-sqlite-bug.c -I $MYINC $MYINC/sqlite3.c
> -lpthread -lm -ldl 
> --------- 
> --------- test-sqlite-bug.c 
> #include <stdio.h> 
> #include "sqlite3.h" 
> ?
> static const char test_sql[] =? 
> ??? "CREATE TABLE IF NOT EXISTS tbl(id? INTEGER PRIMARY KEY, name
> varchar);" 
> ??? "INSERT OR IGNORE INTO tbl(id, name) VALUES " 
> ??? "(1, 'a'), (2, 'b'), (3, 'c'), (4, 'd');" 
> ??? "CREATE TRIGGER IF NOT EXISTS tbl_delete_trigger BEFORE DELETE ON
>tbl
> " 
> ??? "BEGIN" 
> ??? " ??? SELECT RAISE(ABORT, 'Can not remove root/admin user!')
>WHERE
> OLD.id = 1;" 
> ??? "END;"; 
> ?
> static void db_trace_callback(void *user, const char *sql) 
> { 
> ??? printf("SQL: %s\n", sql ? sql : "??"); 
> } 
> ?
> static void insertRecord(sqlite3 *db) 
> { 
> ??? char *errmsg; 
> ??? const char szSQL[] = "INSERT INTO
>
>\"res_users\"(\"alias_id\",\"company_id\",\"create_uid\",\"login\",\"partner_i
>
> d\") VALUES('10','3',4,'daddad','12')"; 
> ??? sqlite3_trace(db, db_trace_callback, NULL); 
> ??? int rc = sqlite3_exec(db, szSQL, NULL, NULL, &errmsg); 
> } 
> ?
> int main(int argc, char *argv[]) 
> { 
> ??? sqlite3 *db; 
> ??? int rc = sqlite3_open("../odoo.db", &db); 
> ??? if(rc == SQLITE_OK) 
> ??? { 
> ??? ??? char *errmsg; 
> ??? ??? const char szSQL[] = "DELETE FROM res_users WHERE id=7"; 
> ??? ??? sqlite3_trace(db, db_trace_callback, NULL); 
> ??? ??? insertRecord(db); 
> ??? ??? //rc = sqlite3_exec(db, test_sql, NULL, NULL, &errmsg); 
> ??? ??? rc = sqlite3_exec(db, szSQL, NULL, NULL, &errmsg); 
> ??? ??? sqlite3_close(db); 
> ??? } 
> ??? return 0; 
> } 
> ------- 
> ------- output of test-sqlite-bug 
> SQL: INSERT INTO
> "res_users"("alias_id","company_id","create_uid","login","partner_id")
> VALUES('10','3',4,'daddad','12') 
> SQL: DELETE FROM res_users WHERE id=7 
> SQL: -- TRIGGER res_users_admin_trigger 
> SQL: -- TRIGGER 
> .. <<<<<< the above line repeated 1000 times 
> ------- 
> ?
> Thanks in advance for your time, attention and great work ! 
> Cheers !
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> 
>
>  



?