[CASSANDRA-8638] CQLSH -f option should ignore BOM in files

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.3
• Component/s: Legacy/Tools
• Labels: cqlsh lhf

Environment

Red Hat linux

• Assignee: Abhishek Gupta
• Reporter: Sotirios Delimanolis

Authors

Abhishek Gupta

Reviewers

Tom Hobbs

• Created: 16/Jan/15 18:30
• Updated: 16/Apr/19 09:31
• Resolved: 29/Jan/15 20:44

Description

I fell in byte order mark trap trying to execute a CQL script through CQLSH.

The file contained the simple (plus BOM)

CREATE KEYSPACE IF NOT EXISTS xobni WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true; 

-- and another "CREATE TABLE bucket_flags" query

I executed the script

[~]$ cqlsh --file /home/selimanolis/Schema/patches/setup.cql 
/home/selimanolis/Schema/patches/setup.cql:2:Invalid syntax at char 1
/home/selimanolis/Schema/patches/setup.cql:2:  CREATE KEYSPACE IF NOT EXISTS test WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true; 
/home/selimanolis/Schema/patches/setup.cql:2:  ^
/home/selimanolis/Schema/patches/setup.cql:22:ConfigurationException: <ErrorMessage code=2300 [Query invalid because of configuration issue] message="Cannot add column family 'bucket_flags' to non existing keyspace 'test'.">

I realized much later that the file had a BOM which was seemingly screwing with how CQLSH parsed the file.

It would be nice to have CQLSH ignore the BOM when processing files.