{"action":"closed","issue":{"url":"https://api.github.com/repos/swcarpentry/bc/issues/925","labels_url":"https://api.github.com/repos/swcarpentry/bc/issues/925/labels{/name}","comments_url":"https://api.github.com/repos/swcarpentry/bc/issues/925/comments","events_url":"https://api.github.com/repos/swcarpentry/bc/issues/925/events","html_url":"https://github.com/swcarpentry/bc/issues/925","id":53307544,"number":925,"title":"instr function not available in SQLite 3.7.13 and older","user":{"login":"danabauer","id":751594,"avatar_url":"https://avatars.githubusercontent.com/u/751594?v=3","gravatar_id":"","url":"https://api.github.com/users/danabauer","html_url":"https://github.com/danabauer","followers_url":"https://api.github.com/users/danabauer/followers","following_url":"https://api.github.com/users/danabauer/following{/other_user}","gists_url":"https://api.github.com/users/danabauer/gists{/gist_id}","starred_url":"https://api.github.com/users/danabauer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danabauer/subscriptions","organizations_url":"https://api.github.com/users/danabauer/orgs","repos_url":"https://api.github.com/users/danabauer/repos","events_url":"https://api.github.com/users/danabauer/events{/privacy}","received_events_url":"https://api.github.com/users/danabauer/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/swcarpentry/bc/labels/SQL","name":"SQL","color":"A06b75"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-03T16:00:59Z","updated_at":"2015-01-03T18:29:47Z","closed_at":"2015-01-03T18:29:47Z","body":"One of the challenge questions in SQL lesson 04-calc requires students to use the instr function. This function wasn't introduced until 3.7.15 and it's likely students using the pre-installed version of SQLite on Mac OS X and Linux will have older versions. Perhaps add a note in the lesson? Or prompt students to check their version of SQLite in the installation instructions and upgrade?"}}