codeshare update query is splited into codeshare change