{"push_id":642992892,"size":1,"distinct_size":1,"ref":"refs/heads/master","head":"a776a39295a695efbe7bee58cb0d1e214578b380","before":"aee228947436b4879bee9deb575e7b4a49481403","commits":[{"sha":"a776a39295a695efbe7bee58cb0d1e214578b380","author":{"email":"d95b56ce41a2e1ac4cecdd398defd7414407cc08@review.openstack.org","name":"Jenkins"},"message":"Updated openstack/openstack\nProject: openstack/neutron  62d0460eb96663693b56f27a51d126ec4b4d422b\n\nFix incorrect query for user ip allocations\n\nPreviously the query was fetching an IPAllocation object incorrectly\nrelying on the fact that it has port attribute that should be\njoin-loaded when it really is not.\n\nIncorrect query produced by previous code:\nSELECT ipallocations.port_id AS ipallocations_port_id,\n       ipallocations.ip_address AS ipallocations_ip_address,\n       ipallocations.subnet_id AS ipallocations_subnet_id,\n       ipallocations.network_id AS ipallocations_network_id\nFROM ipallocations, ports\nWHERE ipallocations.subnet_id = :subnet_id_1\n      AND ports.device_owner NOT IN (:device_owner_1)\n\nThe query then may have produced results that don't satisfy\nthe condition intended by the code.\n\nQuery produced by the fixed code:\nSELECT ipallocations.port_id AS ipallocations_port_id,\n       ipallocations.ip_address AS ipallocations_ip_address,\n       ipallocations.subnet_id AS ipallocations_subnet_id,\n       ipallocations.network_id AS ipallocations_network_id\nFROM ipallocations JOIN ports ON ports.id = ipallocations.port_id\nWHERE ipallocations.subnet_id = :subnet_id_1\n      AND ports.device_owner NOT IN (:device_owner_1)\n\nChange-Id: I34682df784e30e3ce49ee48c690f8b799ad58149\nCloses-Bug: #1357055","distinct":true,"url":"https://api.github.com/repos/openstack/openstack/commits/a776a39295a695efbe7bee58cb0d1e214578b380"}]}