Mismatched values in File records vs corresponding Dataset records #63
Description
I believe there are File entries where equivalent fields in the associated Dataset entry have different, non-null values:
Row 1000:
─────────
remote_files_id: cmip5.output1.NCAR.CCSM4.decadal1980.mon.ocean.Omon.r8i1p1.v20130423.so_Omon_CCSM4_decadal1980_r8i1p1_199001-199912.nc|esgf-node.ornl.gov
remote_datasets_id: cmip5.output1.NCAR.CCSM4.decadal1980.mon.ocean.Omon.r8i1p1.v20130423|esgf-node.ornl.gov
......
remote_files_cf_standard_name: sea_water_salinity
remote_datasets_cf_standard_name: surface_downward_sensible_heat_flux
......
remote_files_variable: so
remote_datasets_variable: hfss
......
remote_files_variable_long_name: Sea Water Salinity
remote_datasets_variable_long_name: Surface Downward Sensible Heat Flux
remote_files_variable_units: psu
remote_datasets_variable_units: W m-2
......
remote_files_retracted: false
remote_datasets_retracted: false
Showed first 1000.
1886927 rows in set. Elapsed: 16.223 sec. Processed 23.43 million rows, 23.53 GB (1.44 million rows/s., 1.45 GB/s.)
Peak memory usage: 14.65 GiB.
As a note though, this query was rather complicated so it's entirely possible I missed something to cause these results.
Click to expand Query
SELECT
rf.id AS remote_files_id,
rd.id AS remote_datasets_id,
rf.campaign AS remote_files_campaign,
rd.campaign AS remote_datasets_campaign,
rf.Conventions AS remote_files_Conventions,
rd.Conventions AS remote_datasets_Conventions,
rf.period_ AS remote_files_period_,
rd.period_ AS remote_datasets_period_,
rf.science_driver_ AS remote_files_science_driver_,
rd.science_driver_ AS remote_datasets_science_driver_,
rf.activity AS remote_files_activity,
rd.activity AS remote_datasets_activity,
rf.activity_drs AS remote_files_activity_drs,
rd.activity_drs AS remote_datasets_activity_drs,
rf.activity_id AS remote_files_activity_id,
rd.activity_id AS remote_datasets_activity_id,
rf.atmos_grid_resolution AS remote_files_atmos_grid_resolution,
rd.atmos_grid_resolution AS remote_datasets_atmos_grid_resolution,
rf.branch_method AS remote_files_branch_method,
rd.branch_method AS remote_datasets_branch_method,
rf.campaign AS remote_files_campaign,
rd.campaign AS remote_datasets_campaign,
rf.catalog_version AS remote_files_catalog_version,
rd.catalog_version AS remote_datasets_catalog_version,
rf.cf_standard_name AS remote_files_cf_standard_name,
rd.cf_standard_name AS remote_datasets_cf_standard_name,
rf.cmor_table AS remote_files_cmor_table,
rd.cmor_table AS remote_datasets_cmor_table,
rf.contact AS remote_files_contact,
rd.contact AS remote_datasets_contact,
rf.data_node AS remote_files_data_node,
rd.data_node AS remote_datasets_data_node,
rf.data_specs_version AS remote_files_data_specs_version,
rd.data_specs_version AS remote_datasets_data_specs_version,
rf.data_structure AS remote_files_data_structure,
rd.data_structure AS remote_datasets_data_structure,
rf.data_type AS remote_files_data_type,
rd.data_type AS remote_datasets_data_type,
rf.dataset_category AS remote_files_dataset_category,
rd.dataset_category AS remote_datasets_dataset_category,
rf.dataset_id_template_ AS remote_files_dataset_id_template_,
rd.dataset_id_template_ AS remote_datasets_dataset_id_template_,
rf.dataset_status AS remote_files_dataset_status,
rd.dataset_status AS remote_datasets_dataset_status,
rf.dataset_version_number AS remote_files_dataset_version_number,
rd.dataset_version_number AS remote_datasets_dataset_version_number,
rf.description AS remote_files_description,
rd.description AS remote_datasets_description,
rf.directory_format_template_ AS remote_files_directory_format_template_,
rd.directory_format_template_ AS remote_datasets_directory_format_template_,
rf.drs_id AS remote_files_drs_id,
rd.drs_id AS remote_datasets_drs_id,
rf.ensemble AS remote_files_ensemble,
rd.ensemble AS remote_datasets_ensemble,
rf.ensemble_member AS remote_files_ensemble_member,
rd.ensemble_member AS remote_datasets_ensemble_member,
rf.experiment AS remote_files_experiment,
rd.experiment AS remote_datasets_experiment,
rf.experiment_family AS remote_files_experiment_family,
rd.experiment_family AS remote_datasets_experiment_family,
rf.experiment_id AS remote_files_experiment_id,
rd.experiment_id AS remote_datasets_experiment_id,
rf.experiment_title AS remote_files_experiment_title,
rd.experiment_title AS remote_datasets_experiment_title,
rf.forcing AS remote_files_forcing,
rd.forcing AS remote_datasets_forcing,
rf.format AS remote_files_format,
rd.format AS remote_datasets_format,
rf.frequency AS remote_files_frequency,
rd.frequency AS remote_datasets_frequency,
rf.further_info_url AS remote_files_further_info_url,
rd.further_info_url AS remote_datasets_further_info_url,
rf.geo_units AS remote_files_geo_units,
rd.geo_units AS remote_datasets_geo_units,
rf.grid AS remote_files_grid,
rd.grid AS remote_datasets_grid,
rf.grid_label AS remote_files_grid_label,
rd.grid_label AS remote_datasets_grid_label,
rf.grid_resolution AS remote_files_grid_resolution,
rd.grid_resolution AS remote_datasets_grid_resolution,
rf.height_units AS remote_files_height_units,
rd.height_units AS remote_datasets_height_units,
rf.index_node AS remote_files_index_node,
rd.index_node AS remote_datasets_index_node,
rf.institute AS remote_files_institute,
rd.institute AS remote_datasets_institute,
rf.institution AS remote_files_institution,
rd.institution AS remote_datasets_institution,
rf.institution_id AS remote_files_institution_id,
rd.institution_id AS remote_datasets_institution_id,
rf.land_grid_resolution AS remote_files_land_grid_resolution,
rd.land_grid_resolution AS remote_datasets_land_grid_resolution,
rf.master_gateway AS remote_files_master_gateway,
rd.master_gateway AS remote_datasets_master_gateway,
rf.member_id AS remote_files_member_id,
rd.member_id AS remote_datasets_member_id,
rf.metadata_format AS remote_files_metadata_format,
rd.metadata_format AS remote_datasets_metadata_format,
rf.mip_era AS remote_files_mip_era,
rd.mip_era AS remote_datasets_mip_era,
rf.model AS remote_files_model,
rd.model AS remote_datasets_model,
rf.model_cohort AS remote_files_model_cohort,
rd.model_cohort AS remote_datasets_model_cohort,
rf.model_version AS remote_files_model_version,
rd.model_version AS remote_datasets_model_version,
rf.nominal_resolution AS remote_files_nominal_resolution,
rd.nominal_resolution AS remote_datasets_nominal_resolution,
rf.ocean_grid_resolution AS remote_files_ocean_grid_resolution,
rd.ocean_grid_resolution AS remote_datasets_ocean_grid_resolution,
rf.period AS remote_files_period,
rd.period AS remote_datasets_period,
rf.pid AS remote_files_pid,
rd.pid AS remote_datasets_pid,
rf.processing_level AS remote_files_processing_level,
rd.processing_level AS remote_datasets_processing_level,
rf.product AS remote_files_product,
rd.product AS remote_datasets_product,
rf.project AS remote_files_project,
rd.project AS remote_datasets_project,
rf.range AS remote_files_range,
rd.range AS remote_datasets_range,
rf.realm AS remote_files_realm,
rd.realm AS remote_datasets_realm,
rf.realm_drs AS remote_files_realm_drs,
rd.realm_drs AS remote_datasets_realm_drs,
rf.region AS remote_files_region,
rd.region AS remote_datasets_region,
rf.regridding AS remote_files_regridding,
rd.regridding AS remote_datasets_regridding,
rf.run_category AS remote_files_run_category,
rd.run_category AS remote_datasets_run_category,
rf.science_driver AS remote_files_science_driver,
rd.science_driver AS remote_datasets_science_driver,
rf.score AS remote_files_score,
rd.score AS remote_datasets_score,
rf.seaice_grid_resolution AS remote_files_seaice_grid_resolution,
rd.seaice_grid_resolution AS remote_datasets_seaice_grid_resolution,
rf.set_name AS remote_files_set_name,
rd.set_name AS remote_datasets_set_name,
rf.short_description AS remote_files_short_description,
rd.short_description AS remote_datasets_short_description,
rf.source AS remote_files_source,
rd.source AS remote_datasets_source,
rf.source_id AS remote_files_source_id,
rd.source_id AS remote_datasets_source_id,
rf.source_type AS remote_files_source_type,
rd.source_type AS remote_datasets_source_type,
rf.source_version AS remote_files_source_version,
rd.source_version AS remote_datasets_source_version,
rf.source_version_number AS remote_files_source_version_number,
rd.source_version_number AS remote_datasets_source_version_number,
rf.sub_experiment_id AS remote_files_sub_experiment_id,
rd.sub_experiment_id AS remote_datasets_sub_experiment_id,
rf.table AS remote_files_table,
rd.table AS remote_datasets_table,
rf.table_id AS remote_files_table_id,
rd.table_id AS remote_datasets_table_id,
rf.target_mip AS remote_files_target_mip,
rd.target_mip AS remote_datasets_target_mip,
rf.target_mip_list AS remote_files_target_mip_list,
rd.target_mip_list AS remote_datasets_target_mip_list,
rf.target_mip_listsource AS remote_files_target_mip_listsource,
rd.target_mip_listsource AS remote_datasets_target_mip_listsource,
rf.target_mip_single AS remote_files_target_mip_single,
rd.target_mip_single AS remote_datasets_target_mip_single,
rf.text AS remote_files_text,
rd.text AS remote_datasets_text,
rf.time_frequency AS remote_files_time_frequency,
rd.time_frequency AS remote_datasets_time_frequency,
rf.tracking_id AS remote_files_tracking_id,
rd.tracking_id AS remote_datasets_tracking_id,
rf.tuning AS remote_files_tuning,
rd.tuning AS remote_datasets_tuning,
rf.variable AS remote_files_variable,
rd.variable AS remote_datasets_variable,
rf.variable_id AS remote_files_variable_id,
rd.variable_id AS remote_datasets_variable_id,
rf.variable_long_name AS remote_files_variable_long_name,
rd.variable_long_name AS remote_datasets_variable_long_name,
rf.variable_units AS remote_files_variable_units,
rd.variable_units AS remote_datasets_variable_units,
rf.variant_label AS remote_files_variant_label,
rd.variant_label AS remote_datasets_variant_label,
rf.versionnum AS remote_files_versionnum,
rd.versionnum AS remote_datasets_versionnum,
rf.xlink AS remote_files_xlink,
rd.xlink AS remote_datasets_xlink,
rf.east_degrees AS remote_files_east_degrees,
rd.east_degrees AS remote_datasets_east_degrees,
rf.height_bottom AS remote_files_height_bottom,
rd.height_bottom AS remote_datasets_height_bottom,
rf.height_top AS remote_files_height_top,
rd.height_top AS remote_datasets_height_top,
rf.north_degrees AS remote_files_north_degrees,
rd.north_degrees AS remote_datasets_north_degrees,
rf.south_degrees AS remote_files_south_degrees,
rd.south_degrees AS remote_datasets_south_degrees,
rf.west_degrees AS remote_files_west_degrees,
rd.west_degrees AS remote_datasets_west_degrees,
rf.deprecated AS remote_files_deprecated,
rd.deprecated AS remote_datasets_deprecated,
rf.latest AS remote_files_latest,
rd.latest AS remote_datasets_latest,
rf.replica AS remote_files_replica,
rd.replica AS remote_datasets_replica,
rf.retracted AS remote_files_retracted,
rd.retracted AS remote_datasets_retracted
FROM
remote_files AS rf
JOIN
remote_datasets AS rd
ON
rf.dataset_id = rd.id
WHERE
(rf.campaign_ <> rd.campaign_ AND rf.campaign_ IS NOT NULL AND rd.campaign_ IS NOT NULL) OR
(rf.Conventions <> rd.Conventions AND rf.Conventions IS NOT NULL AND rd.Conventions IS NOT NULL) OR
(rf.period_ <> rd.period_ AND rf.period_ IS NOT NULL AND rd.period_ IS NOT NULL) OR
(rf.science_driver_ <> rd.science_driver_ AND rf.science_driver_ IS NOT NULL AND rd.science_driver_ IS NOT NULL) OR
(rf.activity <> rd.activity AND rf.activity IS NOT NULL AND rd.activity IS NOT NULL) OR
(rf.activity_drs <> rd.activity_drs AND rf.activity_drs IS NOT NULL AND rd.activity_drs IS NOT NULL) OR
(rf.activity_id <> rd.activity_id AND rf.activity_id IS NOT NULL AND rd.activity_id IS NOT NULL) OR
(rf.atmos_grid_resolution <> rd.atmos_grid_resolution AND rf.atmos_grid_resolution IS NOT NULL AND rd.atmos_grid_resolution IS NOT NULL) OR
(rf.branch_method <> rd.branch_method AND rf.branch_method IS NOT NULL AND rd.branch_method IS NOT NULL) OR
(rf.campaign <> rd.campaign AND rf.campaign IS NOT NULL AND rd.campaign IS NOT NULL) OR
(rf.catalog_version <> rd.catalog_version AND rf.catalog_version IS NOT NULL AND rd.catalog_version IS NOT NULL) OR
(rf.cf_standard_name <> rd.cf_standard_name AND rf.cf_standard_name IS NOT NULL AND rd.cf_standard_name IS NOT NULL) OR
(rf.cmor_table <> rd.cmor_table AND rf.cmor_table IS NOT NULL AND rd.cmor_table IS NOT NULL) OR
(rf.contact <> rd.contact AND rf.contact IS NOT NULL AND rd.contact IS NOT NULL) OR
(rf.data_node <> rd.data_node AND rf.data_node IS NOT NULL AND rd.data_node IS NOT NULL) OR
(rf.data_specs_version <> rd.data_specs_version AND rf.data_specs_version IS NOT NULL AND rd.data_specs_version IS NOT NULL) OR
(rf.data_structure <> rd.data_structure AND rf.data_structure IS NOT NULL AND rd.data_structure IS NOT NULL) OR
(rf.data_type <> rd.data_type AND rf.data_type IS NOT NULL AND rd.data_type IS NOT NULL) OR
(rf.dataset_category <> rd.dataset_category AND rf.dataset_category IS NOT NULL AND rd.dataset_category IS NOT NULL) OR
(rf.dataset_id_template_ <> rd.dataset_id_template_ AND rf.dataset_id_template_ IS NOT NULL AND rd.dataset_id_template_ IS NOT NULL) OR
(rf.dataset_status <> rd.dataset_status AND rf.dataset_status IS NOT NULL AND rd.dataset_status IS NOT NULL) OR
(rf.dataset_version_number <> rd.dataset_version_number AND rf.dataset_version_number IS NOT NULL AND rd.dataset_version_number IS NOT NULL) OR
(rf.description <> rd.description AND rf.description IS NOT NULL AND rd.description IS NOT NULL) OR
(rf.directory_format_template_ <> rd.directory_format_template_ AND rf.directory_format_template_ IS NOT NULL AND rd.directory_format_template_ IS NOT NULL) OR
(rf.drs_id <> rd.drs_id AND rf.drs_id IS NOT NULL AND rd.drs_id IS NOT NULL) OR
(rf.ensemble <> rd.ensemble AND rf.ensemble IS NOT NULL AND rd.ensemble IS NOT NULL) OR
(rf.ensemble_member <> rd.ensemble_member AND rf.ensemble_member IS NOT NULL AND rd.ensemble_member IS NOT NULL) OR
(rf.experiment <> rd.experiment AND rf.experiment IS NOT NULL AND rd.experiment IS NOT NULL) OR
(rf.experiment_family <> rd.experiment_family AND rf.experiment_family IS NOT NULL AND rd.experiment_family IS NOT NULL) OR
(rf.experiment_id <> rd.experiment_id AND rf.experiment_id IS NOT NULL AND rd.experiment_id IS NOT NULL) OR
(rf.experiment_title <> rd.experiment_title AND rf.experiment_title IS NOT NULL AND rd.experiment_title IS NOT NULL) OR
(rf.forcing <> rd.forcing AND rf.forcing IS NOT NULL AND rd.forcing IS NOT NULL) OR
(rf.format <> rd.format AND rf.format IS NOT NULL AND rd.format IS NOT NULL) OR
(rf.frequency <> rd.frequency AND rf.frequency IS NOT NULL AND rd.frequency IS NOT NULL) OR
(rf.further_info_url <> rd.further_info_url AND rf.further_info_url IS NOT NULL AND rd.further_info_url IS NOT NULL) OR
(rf.geo_units <> rd.geo_units AND rf.geo_units IS NOT NULL AND rd.geo_units IS NOT NULL) OR
(rf.grid <> rd.grid AND rf.grid IS NOT NULL AND rd.grid IS NOT NULL) OR
(rf.grid_label <> rd.grid_label AND rf.grid_label IS NOT NULL AND rd.grid_label IS NOT NULL) OR
(rf.grid_resolution <> rd.grid_resolution AND rf.grid_resolution IS NOT NULL AND rd.grid_resolution IS NOT NULL) OR
(rf.height_units <> rd.height_units AND rf.height_units IS NOT NULL AND rd.height_units IS NOT NULL) OR
(rf.index_node <> rd.index_node AND rf.index_node IS NOT NULL AND rd.index_node IS NOT NULL) OR
(rf.institute <> rd.institute AND rf.institute IS NOT NULL AND rd.institute IS NOT NULL) OR
(rf.institution <> rd.institution AND rf.institution IS NOT NULL AND rd.institution IS NOT NULL) OR
(rf.institution_id <> rd.institution_id AND rf.institution_id IS NOT NULL AND rd.institution_id IS NOT NULL) OR
(rf.land_grid_resolution <> rd.land_grid_resolution AND rf.land_grid_resolution IS NOT NULL AND rd.land_grid_resolution IS NOT NULL) OR
(rf.master_gateway <> rd.master_gateway AND rf.master_gateway IS NOT NULL AND rd.master_gateway IS NOT NULL) OR
(rf.member_id <> rd.member_id AND rf.member_id IS NOT NULL AND rd.member_id IS NOT NULL) OR
(rf.metadata_format <> rd.metadata_format AND rf.metadata_format IS NOT NULL AND rd.metadata_format IS NOT NULL) OR
(rf.mip_era <> rd.mip_era AND rf.mip_era IS NOT NULL AND rd.mip_era IS NOT NULL) OR
(rf.model <> rd.model AND rf.model IS NOT NULL AND rd.model IS NOT NULL) OR
(rf.model_cohort <> rd.model_cohort AND rf.model_cohort IS NOT NULL AND rd.model_cohort IS NOT NULL) OR
(rf.model_version <> rd.model_version AND rf.model_version IS NOT NULL AND rd.model_version IS NOT NULL) OR
(rf.nominal_resolution <> rd.nominal_resolution AND rf.nominal_resolution IS NOT NULL AND rd.nominal_resolution IS NOT NULL) OR
(rf.ocean_grid_resolution <> rd.ocean_grid_resolution AND rf.ocean_grid_resolution IS NOT NULL AND rd.ocean_grid_resolution IS NOT NULL) OR
(rf.period <> rd.period AND rf.period IS NOT NULL AND rd.period IS NOT NULL) OR
(rf.pid <> rd.pid AND rf.pid IS NOT NULL AND rd.pid IS NOT NULL) OR
(rf.processing_level <> rd.processing_level AND rf.processing_level IS NOT NULL AND rd.processing_level IS NOT NULL) OR
(rf.product <> rd.product AND rf.product IS NOT NULL AND rd.product IS NOT NULL) OR
(rf.project <> rd.project AND rf.project IS NOT NULL AND rd.project IS NOT NULL) OR
(rf.range <> rd.range AND rf.range IS NOT NULL AND rd.range IS NOT NULL) OR
(rf.realm <> rd.realm AND rf.realm IS NOT NULL AND rd.realm IS NOT NULL) OR
(rf.realm_drs <> rd.realm_drs AND rf.realm_drs IS NOT NULL AND rd.realm_drs IS NOT NULL) OR
(rf.region <> rd.region AND rf.region IS NOT NULL AND rd.region IS NOT NULL) OR
(rf.regridding <> rd.regridding AND rf.regridding IS NOT NULL AND rd.regridding IS NOT NULL) OR
(rf.run_category <> rd.run_category AND rf.run_category IS NOT NULL AND rd.run_category IS NOT NULL) OR
(rf.science_driver <> rd.science_driver AND rf.science_driver IS NOT NULL AND rd.science_driver IS NOT NULL) OR
(rf.score <> rd.score AND rf.score IS NOT NULL AND rd.score IS NOT NULL) OR
(rf.seaice_grid_resolution <> rd.seaice_grid_resolution AND rf.seaice_grid_resolution IS NOT NULL AND rd.seaice_grid_resolution IS NOT NULL) OR
(rf.set_name <> rd.set_name AND rf.set_name IS NOT NULL AND rd.set_name IS NOT NULL) OR
(rf.short_description <> rd.short_description AND rf.short_description IS NOT NULL AND rd.short_description IS NOT NULL) OR
(rf.source <> rd.source AND rf.source IS NOT NULL AND rd.source IS NOT NULL) OR
(rf.source_id <> rd.source_id AND rf.source_id IS NOT NULL AND rd.source_id IS NOT NULL) OR
(rf.source_type <> rd.source_type AND rf.source_type IS NOT NULL AND rd.source_type IS NOT NULL) OR
(rf.source_version <> rd.source_version AND rf.source_version IS NOT NULL AND rd.source_version IS NOT NULL) OR
(rf.source_version_number <> rd.source_version_number AND rf.source_version_number IS NOT NULL AND rd.source_version_number IS NOT NULL) OR
(rf.sub_experiment_id <> rd.sub_experiment_id AND rf.sub_experiment_id IS NOT NULL AND rd.sub_experiment_id IS NOT NULL) OR
(rf.table <> rd.table AND rf.table IS NOT NULL AND rd.table IS NOT NULL) OR
(rf.table_id <> rd.table_id AND rf.table_id IS NOT NULL AND rd.table_id IS NOT NULL) OR
(rf.target_mip <> rd.target_mip AND rf.target_mip IS NOT NULL AND rd.target_mip IS NOT NULL) OR
(rf.target_mip_list <> rd.target_mip_list AND rf.target_mip_list IS NOT NULL AND rd.target_mip_list IS NOT NULL) OR
(rf.target_mip_listsource <> rd.target_mip_listsource AND rf.target_mip_listsource IS NOT NULL AND rd.target_mip_listsource IS NOT NULL) OR
(rf.target_mip_single <> rd.target_mip_single AND rf.target_mip_single IS NOT NULL AND rd.target_mip_single IS NOT NULL) OR
(rf.text <> rd.text AND rf.text IS NOT NULL AND rd.text IS NOT NULL) OR
(rf.time_frequency <> rd.time_frequency AND rf.time_frequency IS NOT NULL AND rd.time_frequency IS NOT NULL) OR
(rf.tracking_id <> rd.tracking_id AND rf.tracking_id IS NOT NULL AND rd.tracking_id IS NOT NULL) OR
(rf.tuning <> rd.tuning AND rf.tuning IS NOT NULL AND rd.tuning IS NOT NULL) OR
(rf.variable <> rd.variable AND rf.variable IS NOT NULL AND rd.variable IS NOT NULL) OR
(rf.variable_id <> rd.variable_id AND rf.variable_id IS NOT NULL AND rd.variable_id IS NOT NULL) OR
(rf.variable_long_name <> rd.variable_long_name AND rf.variable_long_name IS NOT NULL AND rd.variable_long_name IS NOT NULL) OR
(rf.variable_units <> rd.variable_units AND rf.variable_units IS NOT NULL AND rd.variable_units IS NOT NULL) OR
(rf.variant_label <> rd.variant_label AND rf.variant_label IS NOT NULL AND rd.variant_label IS NOT NULL) OR
(rf.versionnum <> rd.versionnum AND rf.versionnum IS NOT NULL AND rd.versionnum IS NOT NULL) OR
(rf.xlink <> rd.xlink AND rf.xlink IS NOT NULL AND rd.xlink IS NOT NULL) OR
(rf.east_degrees <> rd.east_degrees AND rf.east_degrees IS NOT NULL AND rd.east_degrees IS NOT NULL) OR
(rf.height_bottom <> rd.height_bottom AND rf.height_bottom IS NOT NULL AND rd.height_bottom IS NOT NULL) OR
(rf.height_top <> rd.height_top AND rf.height_top IS NOT NULL AND rd.height_top IS NOT NULL) OR
(rf.north_degrees <> rd.north_degrees AND rf.north_degrees IS NOT NULL AND rd.north_degrees IS NOT NULL) OR
(rf.south_degrees <> rd.south_degrees AND rf.south_degrees IS NOT NULL AND rd.south_degrees IS NOT NULL) OR
(rf.west_degrees <> rd.west_degrees AND rf.west_degrees IS NOT NULL AND rd.west_degrees IS NOT NULL) OR
(rf.deprecated <> rd.deprecated AND rf.deprecated IS NOT NULL AND rd.deprecated IS NOT NULL) OR
(rf.latest <> rd.latest AND rf.latest IS NOT NULL AND rd.latest IS NOT NULL) OR
(rf.replica <> rd.replica AND rf.replica IS NOT NULL AND rd.replica IS NOT NULL) OR
(rf.retracted <> rd.retracted AND rf.retracted IS NOT NULL AND rd.retracted IS NOT NULL)
format vertical;