title: Cassandra Clustering order not sorting list
body: <p>I have a patient table and treatment_patient where pat_id acts as foreign key. I want to execute a query such that the treatment_patient always returns values ordered by pat_id.
  I tried adding WITH CLUSTERING ORDER BY (patid ASC); at the end but didn't work.</p>
  
  <pre><code>CREATE TABLE patient(
  record_id uuid PRIMARY KEY,
  patid int,
  name text,
  dob timestamp
  );
  </code></pre>
  
  <p>Insert patients: </p>
  
  <pre><code>insert into patient (record_id, patid, name, dob) values (uuid(), 123, 'John Doe', '2015-01-01 22:00');
  insert into patient (record_id, patid, name, dob) values (uuid(), 456, 'Joy Smith', '2014-11-01 21:00');
  </code></pre>
  
  <p>Treatment_Patients table:</p>
  
  <pre><code>CREATE TABLE treatments_patients(
  treatpat_uuid int,
  patid int,
  diagnosis text,
  PRIMARY KEY(treatpat_uuid,patid)
  ) WITH CLUSTERING ORDER BY (patid ASC);
  </code></pre>
  
  <p>Insert treatment_patients;</p>
  
  <pre><code>insert into treatments_patients (treatpat_uuid, patid, diagnosis) values (123, 011, 'Cold');
  insert into treatments_patients (treatpat_uuid, patid, diagnosis) values (456, 006, 'Cough');
  insert into treatments_patients (treatpat_uuid, patid, diagnosis) values (789, 002, 'flu');
  insert into treatments_patients (treatpat_uuid, patid, diagnosis) values (12, 231, 'Acne');
  insert into treatments_patients (treatpat_uuid, patid, diagnosis) values (789, 001, 'Allergy');
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>treatpat_uuid | patid | diagnosis
  ---------------+-------+-----------
  123 |    11 |      Cold
  456 |     6 |     Cough
  789 |     1 |   Allergy
  789 |     2 |       flu
  12 |   231 |      Acne
  </code></pre>
  
  <p>(5 rows)</p>