{"action":"created","issue":{"url":"https://api.github.com/repos/scylladb/scylla/issues/584","repository_url":"https://api.github.com/repos/scylladb/scylla","labels_url":"https://api.github.com/repos/scylladb/scylla/issues/584/labels{/name}","comments_url":"https://api.github.com/repos/scylladb/scylla/issues/584/comments","events_url":"https://api.github.com/repos/scylladb/scylla/issues/584/events","html_url":"https://github.com/scylladb/scylla/issues/584","id":117538038,"number":584,"title":"Support for CQL V2, V1 Binary protocol","user":{"login":"slivne","id":3465480,"avatar_url":"https://avatars.githubusercontent.com/u/3465480?v=3","gravatar_id":"","url":"https://api.github.com/users/slivne","html_url":"https://github.com/slivne","followers_url":"https://api.github.com/users/slivne/followers","following_url":"https://api.github.com/users/slivne/following{/other_user}","gists_url":"https://api.github.com/users/slivne/gists{/gist_id}","starred_url":"https://api.github.com/users/slivne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slivne/subscriptions","organizations_url":"https://api.github.com/users/slivne/orgs","repos_url":"https://api.github.com/users/slivne/repos","events_url":"https://api.github.com/users/slivne/events{/privacy}","received_events_url":"https://api.github.com/users/slivne/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/scylladb/scylla/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/scylladb/scylla/labels/high","name":"high","color":"d4c5f9"}],"state":"open","locked":false,"assignee":{"login":"elcallio","id":7113590,"avatar_url":"https://avatars.githubusercontent.com/u/7113590?v=3","gravatar_id":"","url":"https://api.github.com/users/elcallio","html_url":"https://github.com/elcallio","followers_url":"https://api.github.com/users/elcallio/followers","following_url":"https://api.github.com/users/elcallio/following{/other_user}","gists_url":"https://api.github.com/users/elcallio/gists{/gist_id}","starred_url":"https://api.github.com/users/elcallio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elcallio/subscriptions","organizations_url":"https://api.github.com/users/elcallio/orgs","repos_url":"https://api.github.com/users/elcallio/repos","events_url":"https://api.github.com/users/elcallio/events{/privacy}","received_events_url":"https://api.github.com/users/elcallio/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/scylladb/scylla/milestones/1","html_url":"https://github.com/scylladb/scylla/milestones/GA","labels_url":"https://api.github.com/repos/scylladb/scylla/milestones/1/labels","id":1164307,"number":1,"title":"GA","description":null,"creator":{"login":"dorlaor","id":1735237,"avatar_url":"https://avatars.githubusercontent.com/u/1735237?v=3","gravatar_id":"","url":"https://api.github.com/users/dorlaor","html_url":"https://github.com/dorlaor","followers_url":"https://api.github.com/users/dorlaor/followers","following_url":"https://api.github.com/users/dorlaor/following{/other_user}","gists_url":"https://api.github.com/users/dorlaor/gists{/gist_id}","starred_url":"https://api.github.com/users/dorlaor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dorlaor/subscriptions","organizations_url":"https://api.github.com/users/dorlaor/orgs","repos_url":"https://api.github.com/users/dorlaor/repos","events_url":"https://api.github.com/users/dorlaor/events{/privacy}","received_events_url":"https://api.github.com/users/dorlaor/received_events","type":"User","site_admin":false},"open_issues":142,"closed_issues":125,"state":"open","created_at":"2015-06-15T06:37:52Z","updated_at":"2016-02-03T08:16:37Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2015-11-18T08:29:13Z","updated_at":"2016-02-03T08:32:41Z","closed_at":null,"body":"Scylla officially support only V3 protocol currently\r\n\r\nNeed to decide if we are going to support V2, V1 - if not need to enforce this\r\n\r\nDelta between V3, V2 (copied from doc/native_protocol_v3.spec)\r\n```\r\n10. Changes from v2\r\n  * stream id is now 2 bytes long (a [short] value), so the header is now 1 byte longer (9 bytes total).\r\n  * BATCH messages now have <flags> (like QUERY and EXECUTE) and a corresponding optional\r\n    <serial_consistency> parameters (see Section 4.1.7).\r\n  * User Defined Types and tuple types have to added to ResultSet metadata (see 4.2.5.2) and a\r\n    new section on the serialization format of UDT and tuple values has been added to the documentation\r\n    (Section 7).\r\n  * The serialization format for collection has changed (both the collection size and\r\n    the length of each argument is now 4 bytes long). See Section 6.\r\n  * QUERY, EXECUTE and BATCH messages can now optionally provide the default timestamp for the query.\r\n    As this feature is optionally enabled by clients, implementing it is at the discretion of the\r\n    client.\r\n  * QUERY, EXECUTE and BATCH messages can now optionally provide the names for the values of the\r\n    query. As this feature is optionally enabled by clients, implementing it is at the discretion of the\r\n    client.\r\n  * The format of \"Schema_change\" results (Section 4.2.5.5) and \"SCHEMA_CHANGE\" events (Section 4.2.6)\r\n    has been modified, and now includes changes related to user types.\r\n```\r\n\r\nDelta between V2, V1  (copied from doc/native_protocol_v2.spec)\r\n\r\n```\r\n9. Changes from v1\r\n  * Protocol is versioned to allow old client connects to a newer server, if a\r\n    newer client connects to an older server, it needs to check if it gets a\r\n    ProtocolException on connection and try connecting with a lower version.\r\n  * A query can now have bind variables even though the statement is not\r\n    prepared; see Section 4.1.4.\r\n  * A new BATCH message allows to batch a set of queries (prepared or not); see \r\n    Section 4.1.7.\r\n  * Authentication now uses SASL. Concretely, the CREDENTIALS message has been\r\n    removed and replaced by a server/client challenges/responses exchanges (done\r\n    through the new AUTH_RESPONSE/AUTH_CHALLENGE messages). See Section 4.2.3 for\r\n    details.\r\n  * Query paging has been added (Section 7): QUERY and EXECUTE message have an\r\n    additional <result_page_size> [int] and <paging_state> [bytes], and\r\n    the Rows kind of RESULT message has an additional flag and <paging_state> \r\n    value. Note that paging is optional, and a client that do not want to handle\r\n    can simply avoid including the Page_size flag and parameter in QUERY and\r\n    EXECUTE.\r\n  * QUERY and EXECUTE statements can request for the metadata to be skipped in\r\n    the result set returned (for efficiency reasons) if said metadata are known\r\n    in advance. Furthermore, the result to a PREPARE (section 4.2.5.4) now\r\n    includes the metadata for the result of executing the statement just\r\n    prepared (though those metadata will be empty for non SELECT statements).\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/scylladb/scylla/issues/comments/179088518","html_url":"https://github.com/scylladb/scylla/issues/584#issuecomment-179088518","issue_url":"https://api.github.com/repos/scylladb/scylla/issues/584","id":179088518,"user":{"login":"slivne","id":3465480,"avatar_url":"https://avatars.githubusercontent.com/u/3465480?v=3","gravatar_id":"","url":"https://api.github.com/users/slivne","html_url":"https://github.com/slivne","followers_url":"https://api.github.com/users/slivne/followers","following_url":"https://api.github.com/users/slivne/following{/other_user}","gists_url":"https://api.github.com/users/slivne/gists{/gist_id}","starred_url":"https://api.github.com/users/slivne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slivne/subscriptions","organizations_url":"https://api.github.com/users/slivne/orgs","repos_url":"https://api.github.com/users/slivne/repos","events_url":"https://api.github.com/users/slivne/events{/privacy}","received_events_url":"https://api.github.com/users/slivne/received_events","type":"User","site_admin":false},"created_at":"2016-02-03T08:32:41Z","updated_at":"2016-02-03T08:32:41Z","body":"With regards to #563 can you validate that by running cassandra-stress  from cassandra 2.1.8 and using the profile specified in #563."}}