)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":7419,"name":"Imre Farkas","email":"farkas.imre@gmail.com","username":"ifarkas"},"change_message_id":"8e6be73fd546d64ca8631d4ef197400904d437eb","unresolved":false,"context_lines":[{"line_number":4,"context_line":"Commit:     Teng Fei \u003cteng.fei@h3c.com\u003e"},{"line_number":5,"context_line":"CommitDate: 2016-07-27 19:48:33 +0800"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Fixes Bug1606534"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Change-Id: Id979043b1573bf2ea473e772c7ea7417c733d753"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"dada55a8_69844fd2","line":7,"range":{"start_line":7,"start_character":0,"end_line":7,"end_character":16},"updated":"2016-07-27 12:56:12.000000000","message":"Please update the commit message to adhere to guidelines: https://wiki.openstack.org/wiki/GitCommitMessages","commit_id":"c660dffd38e992260a6efd0d30fc4cf69e27e3d4"},{"author":{"_account_id":7419,"name":"Imre Farkas","email":"farkas.imre@gmail.com","username":"ifarkas"},"change_message_id":"fd65906385c1b9e7625e40bcb6df32c79ac986b4","unresolved":false,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Modify the SQL\u0027s string from double quote to single quote."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Single quotes are used to indicate the beginning and end of a string in"},{"line_number":10,"context_line":"SQL. Double quotes generally aren\u0027t used in SQL.When the SQL\u0027s column"},{"line_number":11,"context_line":"type is string and the quote is double quote,the SQL will execute failed"},{"line_number":12,"context_line":"in PostgreSQL.."},{"line_number":13,"context_line":"For example,select distinct uuid from attributes where name\u003d"},{"line_number":14,"context_line":"\"bmc_address\" will not work in PostgreSQL, but can work in MySQL."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This patch fixes crash when used with PostgreSQL."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Closes-Bug: #1606534"},{"line_number":19,"context_line":"Change-Id: Id979043b1573bf2ea473e772c7ea7417c733d753"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":7,"id":"3ac371cc_65af12e4","line":16,"range":{"start_line":9,"start_character":0,"end_line":16,"end_character":49},"updated":"2016-08-15 07:45:43.000000000","message":"Maybe simpler to say:\nUsing double quotes for strings does not conform to the ANSI standard. While MySQL accepts it, PostgreSQL raises an error.","commit_id":"ccd6a9685060f3f6a55481419b3007c9e388a796"}],"ironic_inspector/node_cache.py":[{"author":{"_account_id":7419,"name":"Imre Farkas","email":"farkas.imre@gmail.com","username":"ifarkas"},"change_message_id":"8e6be73fd546d64ca8631d4ef197400904d437eb","unresolved":false,"context_lines":[{"line_number":497,"context_line":"                  % (name, value))"},{"line_number":498,"context_line":"        value_list \u003d []"},{"line_number":499,"context_line":"        for v in value:"},{"line_number":500,"context_line":"            value_list.append(\"name\u003d\u0027%s\u0027 AND value\u003d\u0027%s\u0027\" % (name, v))"},{"line_number":501,"context_line":"        stmt \u003d (\u0027select distinct uuid from attributes where \u0027 +"},{"line_number":502,"context_line":"                \u0027 OR \u0027.join(value_list))"},{"line_number":503,"context_line":"        rows \u003d (db.model_query(db.Attribute.uuid).from_statement("}],"source_content_type":"text/x-python","patch_set":1,"id":"dada55a8_e9479fa0","line":500,"range":{"start_line":500,"start_character":30,"end_line":500,"end_character":56},"updated":"2016-07-27 12:56:12.000000000","message":"Could you please explain (maybe in the commit message also) why this change fixes the issue? I don\u0027t quite get it...","commit_id":"c660dffd38e992260a6efd0d30fc4cf69e27e3d4"}],"releasenotes/notes/fix-crash-when-use-postgresql-ac6c708f48f55c83.yaml":[{"author":{"_account_id":13636,"name":"aarefiev","display_name":"Anton","email":"arefyevanton@gmail.com","username":"aarefiev"},"change_message_id":"f318b9a707556072200daa19acd10e2eff442c89","unresolved":false,"context_lines":[{"line_number":1,"context_line":"---"},{"line_number":2,"context_line":"fixes:"},{"line_number":3,"context_line":"  - |"},{"line_number":4,"context_line":"    This patch fixes crash when used with postgresql.Modify the SQL\u0027s string from double quote to "},{"line_number":5,"context_line":"    single quote."},{"line_number":6,"context_line":"    "},{"line_number":7,"context_line":"    * https://bugs.launchpad.net/ironic-inspector/+bug/1606534"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"9ad45d7e_bd6a1c7f","line":6,"range":{"start_line":4,"start_character":96,"end_line":6,"end_character":4},"updated":"2016-08-11 09:26:58.000000000","message":"please remove extra spaces","commit_id":"c9064fe2b9d2a477fd0983464048a4692856e56a"},{"author":{"_account_id":13636,"name":"aarefiev","display_name":"Anton","email":"arefyevanton@gmail.com","username":"aarefiev"},"change_message_id":"f318b9a707556072200daa19acd10e2eff442c89","unresolved":false,"context_lines":[{"line_number":4,"context_line":"    This patch fixes crash when used with postgresql.Modify the SQL\u0027s string from double quote to "},{"line_number":5,"context_line":"    single quote."},{"line_number":6,"context_line":"    "},{"line_number":7,"context_line":"    * https://bugs.launchpad.net/ironic-inspector/+bug/1606534"}],"source_content_type":"text/x-yaml","patch_set":6,"id":"9ad45d7e_5d1fa007","line":7,"range":{"start_line":7,"start_character":0,"end_line":7,"end_character":62},"updated":"2016-08-11 09:26:58.000000000","message":"nit: we usually don\u0027t put bug link to release notes","commit_id":"c9064fe2b9d2a477fd0983464048a4692856e56a"},{"author":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"change_message_id":"051ddbeab0255bf1b9790ada59f0ca1040262962","unresolved":false,"context_lines":[{"line_number":1,"context_line":"---"},{"line_number":2,"context_line":"fixes:"},{"line_number":3,"context_line":"  - |"},{"line_number":4,"context_line":"    This patch fixes crash when used with postgresql.Modify the SQL\u0027s string from double quote to"},{"line_number":5,"context_line":"    single quote."}],"source_content_type":"text/x-yaml","patch_set":7,"id":"9ad45d7e_ede76f44","line":4,"updated":"2016-08-12 14:09:51.000000000","message":"s/This patch fixes/Fix/ as it won\u0027t be clear which patch on the final release notes page\n\nalso please wrap lines","commit_id":"ccd6a9685060f3f6a55481419b3007c9e388a796"}]}
