[jira] [Created] (CASSANDRA-14126) don't wokr udf javascripts

["Denis Pershin (JIRA)" <ji...@apache.org>]

Denis Pershin created CASSANDRA-14126:
-----------------------------------------

             Summary: don't wokr udf javascripts
                 Key: CASSANDRA-14126
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14126
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
            Reporter: Denis Pershin
            Priority: Minor
             Fix For: 3.11.x


* create keyspace:
{code}
CREATE KEYSPACE testkeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
{code}

* in testkeyspace create function:
{code}
CREATE OR REPLACE FUNCTION first_int(input set<int>) RETURNS NULL ON NULL INPUT RETURNS int LANGUAGE javascript AS '(function(){var result = 2;return result;})();';
{code}

* create table and insert:
{code}
create table A (id int primary key, val set<int>);
insert into A  (id, val) values (1, {3,5,7,1});
{code}

* select:
{code}
select first_int(val) from A where id = 1;
Traceback (most recent call last):
  File "/usr/bin/cqlsh.py", line 1044, in perform_simple_statement
    result = future.result()
  File "/usr/share/cassandra/lib/cassandra-driver-internal-only-3.10.zip/cassandra-driver-3.10/cassandra/cluster.py", line 3826, in result
    raise self._final_exception
FunctionFailure: Error from server: code=1400 [User Defined Function failure] message="execution of 'testkeyspace.first_int[set<int>]' failed: java.security.AccessControlException: access denied: ("java.lang.RuntimePermission" "accessClassInPackage.java.io")"
{code}


raw log:
{code}
root@001b19bd3cc6:/# cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.1 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh> CREATE KEYSPACE testkeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
cqlsh> USE testkeyspace ;
cqlsh:testkeyspace> CREATE OR REPLACE FUNCTION first_int(input set<int>) RETURNS NULL ON NULL INPUT RETURNS int LANGUAGE javascript AS '(function(){var result = 2;return result;})();';
cqlsh:testkeyspace> create table A (id int primary key, val set<int>);
cqlsh:testkeyspace> insert into A  (id, val) values (1, {3,5,7,1});
cqlsh:testkeyspace> select first_int(val) from A where id = 1;
Traceback (most recent call last):
  File "/usr/bin/cqlsh.py", line 1044, in perform_simple_statement
    result = future.result()
  File "/usr/share/cassandra/lib/cassandra-driver-internal-only-3.10.zip/cassandra-driver-3.10/cassandra/cluster.py", line 3826, in result
    raise self._final_exception
FunctionFailure: Error from server: code=1400 [User Defined Function failure] message="execution of 'testkeyspace.first_int[set<int>]' failed: java.security.AccessControlException: access denied: ("java.lang.RuntimePermission" "accessClassInPackage.java.io")"
{code}




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org