From user-return-30568-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Tue Dec 11 22:12:37 2012 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A0A90D660 for ; Tue, 11 Dec 2012 22:12:37 +0000 (UTC) Received: (qmail 3087 invoked by uid 500); 11 Dec 2012 22:12:35 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 3056 invoked by uid 500); 11 Dec 2012 22:12:35 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 3048 invoked by uid 99); 11 Dec 2012 22:12:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 22:12:35 +0000 X-ASF-Spam-Status: No, hits=2.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLYTO_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.139.212.170] (HELO nm11.bullet.mail.bf1.yahoo.com) (98.139.212.170) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 22:12:25 +0000 Received: from [98.139.212.152] by nm11.bullet.mail.bf1.yahoo.com with NNFMP; 11 Dec 2012 22:12:03 -0000 Received: from [98.139.212.229] by tm9.bullet.mail.bf1.yahoo.com with NNFMP; 11 Dec 2012 22:12:02 -0000 Received: from [127.0.0.1] by omp1038.mail.bf1.yahoo.com with NNFMP; 11 Dec 2012 22:12:02 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 803606.25462.bm@omp1038.mail.bf1.yahoo.com Received: (qmail 62884 invoked by uid 60001); 11 Dec 2012 22:12:01 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1355263921; bh=TusMZNJZXZtKtnQg1fA8jCDOulW5Vf9I0amnDbLAlRI=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=DrZmI4NBiXdPT9eQZlHHb/ZVUoJFjzAn79uJT03/qD6hxCbP6OeTqWPdJZoBTiuZUasBYGbnionmjj+qLI1FCxbenSWzFKSVloDYvqpYZsN8OBMHPCiV6W9fWQJ74GU/7KlkLh4ZiucBNJChlQDt32PbtcLep0xiaua+f5z+Zmc= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=U+1RshjFx8Ebq3r/wIetvOGXve6up25jis5yCD55Gri++FbZEVNsRoke5FolA/nxQH8+++StDmVfpPK8VoJh7+yk9OGDSVQOGg1uC45T5tLB5a1VPa46z1nMzVr8nO9cu8g34jfEu6Do3EfyGpSOQpUclBrpFYJLPjpwPvxZTUk=; X-YMail-OSG: RF9HMgYVM1mqWkgXpPEHe3YCn7_WA54URLk_j9FoxvbE9iz BoT7eMPxsccBaQM_7HWuf1a13fV8jqKHCQvcZgTb6YVytR2lvb4ztJ06ZEIF wKQzVzUMgN0eLc2aCKT1dA8dWJ1SMxNt7m0bb.Ph8eS8TzgWNX1kXYnBXqyJ Uv6Zk5932lezXfCbseLY0bdqD_82RqF5qynPE8NZfxnx4aDsVcYOrX1EUm1h 5GKbeRUX4nnU6etl.A8yT32Tm.gYldxEqYcMl1R3t_Uc5htYitR4Il75LxH. yXZmkThfw0fh78KB408U5lK1gsDCwbaNPJfwy59GSd3D_YrVi4E_UA1O_D5l O5uIYC.t01jfDiFgZlKFiGPoF21yXtaqxoIUw33crCCXkZ1aOt0OlKqpTcUd Ciboix_Ys8oGZiIfo12JtvYNrzm3ZSjfszF_Dve4itUM5ipbmBRYVaCHWh46 jbdPakyFK44D4Wwx8.BjpmgFHrQ_9mvJRrRwYq.B2VCyEW0SFHZI- Received: from [199.21.86.226] by web160906.mail.bf1.yahoo.com via HTTP; Tue, 11 Dec 2012 14:12:01 PST X-Rocket-MIMEInfo: 001.001,SSBoYXZlIGEgY29sdW1uIGZhbWlseSB3aXRoIGNvbXBvc2l0ZSBjb2x1bW4KCkNvbXBvc2l0ZVR5cGUoVVRGOFR5cGUsIFVURjhUeXBlLCBMb25nVHlwZSwgVVRGOFR5cGUpCkl0IHN0b3JlcyAoZmlyc3ROYW1lLCBMYXN0TmFtZSwgdXNlcklELCBtZWFuaW5nZnVsQ29sdW1uTmFtZSksIGlmIEkgaW5zZXJ0IHRoZSByZWNvcmQgd2l0aCBmb3JlaWduIGNoYXJhY3RlcnMswqAKbG9va3MgbGlrZSB0aGF0IGNxbHNoIC0zIGludGVycHJldHMgdGhlIHZhbHVlcyB3cm9uZy4gSSBjYW4gZ2V0IHRoZSB2YWx1ZXMgYmEBMAEBAQE- X-Mailer: YahooMailWebService/0.8.128.478 Message-ID: <1355263921.59512.YahooMailNeo@web160906.mail.bf1.yahoo.com> Date: Tue, 11 Dec 2012 14:12:01 -0800 (PST) From: Wei Zhu Reply-To: Wei Zhu Subject: bug with cqlsh for foreign charater To: Cassandr usergroup MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="967773369-810980027-1355263921=:59512" X-Virus-Checked: Checked by ClamAV on apache.org --967773369-810980027-1355263921=:59512 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I have a column family with composite column=0A=0ACompositeType(UTF8Type, U= TF8Type, LongType, UTF8Type)=0AIt stores (firstName, LastName, userID, mean= ingfulColumnName), if I insert the record with foreign characters,=C2=A0=0A= looks like that cqlsh -3 interprets the values wrong. I can get the values = back from Hector correctly. =0A=0ALook at the highlighted row, the column2 = and column3 are reversed. =0A=0Acqlsh:XXX> select * from YYYYYY where key = =3D 100000000; key | column1 | column2 | column3 | colu= mn4 | value=0A-----------+---------------+---------------+-----------+-----= ----+----------------------------------------------------------------------= -------------------------- 100000000 | | friendlname4 | 1000= 00004 | v | 333030303034403440304= 030402d404040667269656e646c6e616d6534 100000000 | afriendfname2 | afriendln= ame2 | 100000002 | v | 3330303030324032403040304061667269656e= 64666e616d65322d40404061667269656e646c6e616d6532 100000000 | friendfname1 = | | 100000001 | v | = 33303030303140314030403040667269656e64666e616d65312d404040 100000000 | fr= iendfname4 | friendlname4 | 100000004 | v | 333030303034= 40344030403040667269656e64666e616d65342d404040667269656e646c6e616d6534 1000= 00000 | =E4=B8=AD=E5=9B=BD=E4=BA=BA | =D8=B5=D8=A8=D8=A7=D8=AD =D8= =A7=D9=84=D8=AE=D9=8A=D8=B1 | 100000003 | v | 33303030303340334030403040e4b8ade59bbde4baba2d40404020d8b5d8a8d8a7d8ad20d8= a7d984d8aed98ad8b120=0A=0A=0AThanks.=0A-Wei --967773369-810980027-1355263921=:59512 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I have a column family with= composite column

CompositeType(UTF8Type, UTF8Type, LongType, UTF8Type)
It stores (firstName, LastName, user=
ID, meaningfulColumnName), if I insert the record with foreign characters,&=
nbsp;
looks like that c=
qlsh -3 interprets the values wrong. I can get the values back from Hector =
correctly. 

<= pre style=3D"background-color: transparent; ">Look at the highlighted row, = the column2 and column3 are reversed.

cqlsh:XXX> select * from YYYYYY where key =
=3D 100000000;=0A key       | column1       | column2       | column3   | c=
olumn4 | value=0A-----------+---------------+---------------+-----------+--=
-------+-------------------------------------------------------------------=
-----------------------------=0A 100000000 |               |  friendlname4 =
| 100000004 |       v |                                     333030303034403=
440304030402d404040667269656e646c6e616d6534=0A 100000000 | afriendfname2 | =
afriendlname2 | 100000002 |       v |         33303030303240324030403040616=
67269656e64666e616d65322d40404061667269656e646c6e616d6532=0A 100000000 |  f=
riendfname1 |               | 100000001 |       v |                        =
             33303030303140314030403040667269656e64666e616d65312d404040=0A =
100000000 |  friendfname4 |  friendlname4 | 100000004 |       v |          =
   33303030303440344030403040667269656e64666e616d65342d404040667269656e646c=
6e616d6534=0A 100000000 |        =E4=B8=AD=E5=9B=BD=E4=BA=BA |  =
 =D8=B5=D8=A8=D8=A7=D8=AD =D8=A7=D9=84=D8=AE=D9=8A=D8=B1  | 100000003 |       v | 33303030303340334030403040e4b8ade59bbde4baba2d40404020d8b5d8a8=
d8a7d8ad20d8a7d984d8aed98ad8b120

=
T=
hanks.
-Wei
--967773369-810980027-1355263921=:59512--