[CASSANDRA-5341] Select writetime Exception when data doesn't exist

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.2.4
• Component/s: Legacy/CQL
• Severity: Low
• Assignee: Sylvain Lebresne
• Reporter: julien campan

Authors

Sylvain Lebresne

Reviewers

Aleksey Yeschenko

• Created: 13/Mar/13 15:15
• Updated: 16/Apr/19 09:32
• Resolved: 02/Apr/13 09:40

Description

Hi,

When I try do to a “select writetime” on a empty column, I have an Exception.
For example :
Create table test (id int, value int, value2 int, primary key (id));
INSERT INTO test (id, value ) VALUES ( 1,100) ;

select * from test where id =1;
==>
id | value | value2
---------------
1 | 100 | null

It’s working.

select WRITETIME(value) from test where id =1;
==>
writetime(value)
------------------
1363184789539000
It’s working

select WRITETIME(value2) from test where id =1;

==>TSocket read 0 bytes

I have an Exception.