sqlite3_bug.rb

#!/usr/local/bin/ruby -w
#
# test creation of a new sqlite3 DB file

require 'sqlite3'

db = SQLite3::Database.open "/tmp/foo.db"

# execute contents of file
sql = IO.read 'sqlite3_bug.sql'
db.execute_batch sql
db.close

sqlite3_bug.sql

-- demonstrate bug in sqlite3 ruby gem

CREATE TABLE IF NOT EXISTS foo ( id int );
-- comment at the end causes problems