Tyler Hobbs created CASSANDRA-8451:
--------------------------------------
Summary: NPE when writetime() or ttl() are nested inside function
call
Key: CASSANDRA-8451
URL: https://issues.apache.org/jira/browse/CASSANDRA-8451
Project: Cassandra
Issue Type: Bug
Components: Core
Reporter: Tyler Hobbs
Assignee: Tyler Hobbs
Priority: Minor
Fix For: 2.0.12, 2.1.3
When the {{writetime()}} or {{ttl()}} functions are nested inside another
function, the query will result in a NullPointerException:
{noformat}
cqlsh> select bigintAsBlob(writetime(durable_writes)) from
system.schema_keyspaces;
<ErrorMessage code=0000 [Server error] message="java.lang.NullPointerException">
{noformat}
Here's the stacktrace:
{noformat}
ERROR 00:14:56 Unexpected exception during request
java.lang.NullPointerException: null
at
org.apache.cassandra.cql3.statements.Selection$WritetimeOrTTLSelector.compute(Selection.java:538)
~[main/:na]
at
org.apache.cassandra.cql3.statements.Selection$FunctionSelector.compute(Selection.java:462)
~[main/:na]
at
org.apache.cassandra.cql3.statements.Selection$SelectionWithProcessing.handleRow(Selection.java:434)
~[main/:na]
at
org.apache.cassandra.cql3.statements.Selection$ResultSetBuilder.newRow(Selection.java:331)
~[main/:na]
at
org.apache.cassandra.cql3.statements.SelectStatement.processColumnFamily(SelectStatement.java:1243)
~[main/:na]
at
org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:1177)
~[main/:na]
at
org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:274)
~[main/:na]
at
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:213)
~[main/:na]
at
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:62)
~[main/:na]
at
org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:238)
~[main/:na]
at
org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:260)
~[main/:na]
at
org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119)
~[main/:na]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439)
[main/:na]
at
org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335)
[main/:na]
at
io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
at
io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
at
io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
at
io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[na:1.7.0_40]
at
org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164)
[main/:na]
at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105)
[main/:na]
at java.lang.Thread.run(Thread.java:724) [na:1.7.0_40]
{noformat}
Basically, it's failing to collect timestamps (or TTLs) when the function is
wrapped. A similar query that additionally selects {{writetime()}} directly
will succeed (because the timestamps will get collected):
{noformat}
cqlsh> select bigintAsBlob(writetime(durable_writes)),
writetime(durable_writes) from system.schema_keyspaces ;
bigintAsBlob(writetime(durable_writes)) | writetime(durable_writes)
-----------------------------------------+---------------------------
0x000509d1865c67f9 | 1418170390571001
0x0000000000000000 | 0
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
