{"meta":{"title":"bqrs diff","intro":"Compute the difference between two result sets.","product":"Security and code quality","breadcrumbs":[{"href":"/en/code-security","title":"Security and code quality"},{"href":"/en/code-security/reference","title":"Reference"},{"href":"/en/code-security/reference/code-scanning","title":"Code scanning"},{"href":"/en/code-security/reference/code-scanning/codeql","title":"CodeQL"},{"href":"/en/code-security/reference/code-scanning/codeql/codeql-cli-manual","title":"CodeQL CLI manual"},{"href":"/en/code-security/reference/code-scanning/codeql/codeql-cli-manual/bqrs-diff","title":"bqrs diff"}],"documentType":"article"},"body":"# bqrs diff\n\nCompute the difference between two result sets.\n\n> [!NOTE]\n> This content describes the most recent release of the CodeQL CLI. For more information about this release, see https://github.com/github/codeql-cli-binaries/releases.\n>\n> To see details of the options available for this command in an earlier release, run the command with the <span style=\"white-space: nowrap;\">`--help`</span> option in your terminal.\n\n## Synopsis\n\n```shell copy\ncodeql bqrs diff <options>... -- <file1> <file2>\n```\n\n## Description\n\nCompute the difference between two result sets.\n\n## Options\n\n### Primary Options\n\n#### `<file1>`\n\n\\[Mandatory] First BQRS file to compare.\n\n#### `<file2>`\n\n\\[Mandatory] Second BQRS file to compare.\n\n#### `--left=<file>`\n\nWrite rows only present in `file1` to this file.\n\n#### `--right=<file>`\n\nWrite rows only present in `file2` to this file.\n\n#### `--both=<file>`\n\nWrite rows present in both `file1` and `file2` to this file.\n\n#### `--retain-result-sets=<result-set>[,<result-set>...]`\n\nComma-separated list of result set names to copy directly to the\ncorresponding output instead of comparing. If --both is given, that\noutput is taken from `file1`. Defaults to 'nodes,edges,subpaths' to\nsimplify handling of path-problem results.\n\n#### `--result-sets=<name1>,<name2>`\n\nCompare only the specified result sets. The format is\n\\<name1>,\\<name2> where \\<name1> is the result set name in `file1`\nand \\<name2> is the result set name in `file2`. The two result sets\nmust be compatible. The option can be repeated.\n\n#### `--[no-]compare-internal-ids`\n\n\\[Advanced] Include internal entity IDs in the comparison. Entity IDs\nare not comparable across databases, but for result sets that originate\nfrom the same database this can help distinguish entities with the same\nlocation and label.\n\n### Common options\n\n#### `-h, --help`\n\nShow this help text.\n\n#### `-J=<opt>`\n\n\\[Advanced] Give option to the JVM running the command.\n\n(Beware that options containing spaces will not be handled correctly.)\n\n#### `-v, --verbose`\n\nIncrementally increase the number of progress messages printed.\n\n#### `-q, --quiet`\n\nIncrementally decrease the number of progress messages printed.\n\n#### `--verbosity=<level>`\n\n\\[Advanced] Explicitly set the verbosity level to one of errors,\nwarnings, progress, progress+, progress++, progress+++. Overrides `-v`\nand `-q`.\n\n#### `--logdir=<dir>`\n\n\\[Advanced] Write detailed logs to one or more files in the given\ndirectory, with generated names that include timestamps and the name of\nthe running subcommand.\n\n(To write a log file with a name you have full control over, instead\ngive `--log-to-stderr` and redirect stderr as desired.)\n\n#### `--common-caches=<dir>`\n\n\\[Advanced] Controls the location of cached data on disk that will\npersist between several runs of the CLI, such as downloaded QL packs and\ncompiled query plans. If not set explicitly, this defaults to a\ndirectory named `.codeql` in the user's home directory; it will be\ncreated if it doesn't already exist.\n\nAvailable since `v2.15.2`."}