I'm trying to run a sqlite query that includes a common table expression (see:
http://sqlite.org/lang_with.html), but it's failing to parse the query right away on the "with" keyword.
They have been supported since sqlite 3.8.3. I'm using sqlite 3.8.5 on my system.
I should say that I'm running this on a mac and I have two versions of sqlite. The apple-provided version in /usr/bin/sqlite3, and the homebrew version in /usr/local/Cellar/sqlite/3.8.5/bin/sqlite3.
I've tried three ways of installing the sqlite3-ruby gem:
1. gem install sqlite3
2. from source cloned from github's master branch (ruby setup.rb config; ruby setup.rb setup; ruby setup.rb install)
3. gem install sqlite3 -- --with-sqlite3-include=/usr/local/Cellar/sqlite/3.8.5/include --with-sqlite3-lib=/usr/local/Cellar/sqlite/3.8.5/lib
All three fail on parsing the "with" clause.
Any ideas?
Thanks!
Matt