# SQLite2 version in CI?

**URL:** <https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771>\
**Category:** rubyonrails-core\
**Created:** [May 22, 2009, 11:24pm UTC](https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771 "2009-05-22T23:24:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jason\_King1](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@Jason\_King1](https://discuss.rubyonrails.org/u/Jason_King1)\
**Post date:** [May 22, 2009, 11:24pm UTC](https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771/1 "2009-05-22T23:24:31Z")

</div>

Can someone tell me which version of sqlite is used on the CI machine? (Or, even better, how to find out?)

I'm seeing what looks like a bug in my 2.8.17 for the last\_insert\_rowid() function with the high PKey IDs that the test fixtures receive.

Cheers, Jason

---

<div class="post-metadata">

**Author:** ![thewoolleyman](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/thewoolleyman/32/5346_2.png) [@thewoolleyman](https://discuss.rubyonrails.org/u/thewoolleyman)\
**Post date:** [May 22, 2009, 11:26pm UTC](https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771/2 "2009-05-22T23:26:14Z")

</div>

2 and 3. Look at the environment info output at the end of the build log.

---

<div class="post-metadata">

**Author:** ![Jason\_King1](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@Jason\_King1](https://discuss.rubyonrails.org/u/Jason_King1)\
**Post date:** [May 22, 2009, 11:37pm UTC](https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771/3 "2009-05-22T23:37:14Z")

</div>

Ah, the end of the build log. Thanks Chad!

So now I'm confused, because my test fails with the same versions of  
SQLite2 and same sqlite-ruby gem as the CI machine. I can reproduce  
the bug in last\_insert\_rowid() directly in SQLite2 (by using those  
large ids) so I have to conclude that the CI machine is not generating  
the same large ids.

Maybe this is a rake version issue, my rake is 0.8.4 and the CI's is  
0.8.3. Is rake the thing that generates those big fixture ids? More  
digging (unless someone who is still reading knows 🙂

---

<div class="post-metadata">

**Author:** ![thewoolleyman](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/thewoolleyman/32/5346_2.png) [@thewoolleyman](https://discuss.rubyonrails.org/u/thewoolleyman)\
**Post date:** [May 22, 2009, 11:50pm UTC](https://discuss.rubyonrails.org/t/sqlite2-version-in-ci/42771/4 "2009-05-22T23:50:16Z")

</div>

If you want to temporarily add a build pointing at your repo for debug purposes, I can do it. Contact me offline...

-- Chad
