Ondřej Černoš created CASSANDRA-5485: ----------------------------------------
Summary: Cannot set varchar column to null when using cql3/thrift and prepared statements Key: CASSANDRA-5485 URL: https://issues.apache.org/jira/browse/CASSANDRA-5485 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.2.4 Reporter: Ondřej Černoš We use cql3 over thrift (there is no native driver for Erlang now) and prepared statements. There is no way to set null to a varchar column in insert statement created from prepared statement (as Thrift doesn't support null representation afaik). Empty byte array (empty binary in Erlang) is translated to empty string. There are two workarounds for this: * don't use prepared statements * pass empty strings to null columns and delete these columns afterwards in a batch Both are inferior solutions however. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira