[CASSANDRA-5413] cqlsh returns map entries in wrong order

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.2.4
• Component/s: Legacy/CQL, Legacy/Tools
• Labels: cql3 cqlsh

Environment

Cassandra 1.2.3 on Ubuntu 12.04, Java(TM) SE Runtime Environment (build 1.6.0_43-b01), running in VMWare player 5.0.0 build-812388 on Windows 7 Professional 32bit

• Assignee: Aleksey Yeschenko
• Reporter: Swav Swiac

Authors

Aleksey Yeschenko

Reviewers

Brandon Williams

• Created: 02/Apr/13 09:47
• Updated: 16/Apr/19 09:32
• Resolved: 02/Apr/13 19:12

Description

The elements in the map <timeuuid,decimal> are returned in cqlsh in an order that is neither sorted by name, value or timestamp.
Below is output from cqlsh and cassandra cli. (looks a bit messy here, I have attached a text file without word wrapping)

cqlsh:iBidTest> select * from lots ;

event_id | lot_id | bids_accepted | bids_details | bids_temp | minimum | number | title
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------
a4a70900-24e1-11df-8924-001ff3591711 | 1 | null | null | null | 200 | 2 | New lot 2
a4a70900-24e1-11df-8924-001ff3591711 | 3 | null | null |

{8b457e90-9ae2-11e2-9bcb-a1f164a2d4a3: 1000, 9606ca50-9ae2-11e2-9bcb-a1f164a2d4a3: 650, 908fb640-9ae2-11e2-9bcb-a1f164a2d4a3: 600, 7d930650-9ae2-11e2-9bcb-a1f164a2d4a3: 500, a1ef7f10-9ae2-11e2-9bcb-a1f164a2d4a3: 1250, 9aedd360-9ae2-11e2-9bcb-a1f164a2d4a3: 950}

| 100 | 1 | New lot 1

[default@ibidtest] get lots[a4a70900-24e1-11df-8924-001ff3591711];
=> (column=1:, value=, timestamp=1364829909818000)
=> (column=1:minimum, value=0000000000c8, timestamp=1364829397026000)
=> (column=1:number, value=32, timestamp=1364829909818000)
=> (column=1:title, value=4e6577206c6f742032, timestamp=1364829397026000)
=> (column=3:, value=, timestamp=1364830894466000)
=> (column=3:bids_temp:7d9306509ae211e29bcba1f164a2d4a3, value=0000000001f4, timestamp=1364830833463000)
=> (column=3:bids_temp:8b457e909ae211e29bcba1f164a2d4a3, value=0000000003e8, timestamp=1364830856441000)
=> (column=3:bids_temp:908fb6409ae211e29bcba1f164a2d4a3, value=000000000258, timestamp=1364830865317000)
=> (column=3:bids_temp:9606ca509ae211e29bcba1f164a2d4a3, value=00000000028a, timestamp=1364830874485000)
=> (column=3:bids_temp:9aedd3609ae211e29bcba1f164a2d4a3, value=0000000003b6, timestamp=1364830882711000)
=> (column=3:bids_temp:a1ef7f109ae211e29bcba1f164a2d4a3, value=0000000004e2, timestamp=1364830894466000)
=> (column=3:minimum, value=0000000064, timestamp=1364829412417000)
=> (column=3:number, value=31, timestamp=1364829852020000)
=> (column=3:title, value=4e6577206c6f742031, timestamp=1364829412417000)
Returned 14 results.
Elapsed time: 130 msec(s).