Thanks for the tip Richard. I added SQLite version display in the two apps:
)s) Internals for Android 1.5+ )s) Internals for Android 1.6+ They show SQLite 3.6.22 on my 2.2 N1. The info is about 1/4 down the text view. Btw, I also tried to select sqlite_source_id() but this returned an exception saying that the function was not there. Would someone know where this is documented for Android? I got the idea for the source_id from: http://www.sqlite.org/lang_corefunc.html#sqlite_source_id regards, Serge On Jul 11, 9:34 am, RichardC <richard.crit...@googlemail.com> wrote: > I have written a quick and dirty test program (see below) and tested > it using different build options against 4 different emulator > versions. > > The tests were repeated building different build options of the same > program: > build 1 > android:minSdkVersion="3" > android:targetSdkVersion="4" > build target 4 > > build 2 > android:minSdkVersion="3" > android:targetSdkVersion="4" > build target 8 > > build 3 > android:minSdkVersion="3" > android:targetSdkVersion="8" > build target 8 > > All 3 build of the test program returned the same result on each > platform > Emulator running 1.5 returned 3.5.9 for every build > Emulator running 1.6 returned 3.5.9 for every build > Emulator running 2.1 returned 3.5.9 for every build > Emulator running 2.2 returned 3.6.22 for every build > > Source code (quick and dirty) will clean up later: > > public void onCreate(Bundle savedInstanceState) > { > super.onCreate(savedInstanceState); > setContentView(R.layout.device_info); > > final String databaseName = ":memory:"; > final String query = "SELECTsqlite_version() ASsqlite_version"; > SQLiteDatabase db = > SQLiteDatabase.openOrCreateDatabase(databaseName, null); > Cursor cursor = db.rawQuery(query, null); > > String report = "Querying SQLite for it's version using\n" + query > +"\nreturned\n\n"; > while (cursor.moveToNext()) > { > report += cursor.getString(0) + "\n"; > } > > final TextView reportTextView = > (TextView)findViewById(R.id.ReportTextView); > reportTextView.setText(report); > > } > > On Jul 11, 1:32 pm, RichardC <richard.crit...@googlemail.com> wrote: > > > > > Think I have found one ... will upload a test app (if it works) later > > this afternoon and post here when it is available. > > > -- > > Richard > > > On Jul 11, 9:21 am, Mark Carter <mjc1...@googlemail.com> wrote: > > > > Is there any way to (programmatically) check what version of SQLite is > > > installed? > > > > On Jun 24, 1:09 pm, Mark Carter <mjc1...@googlemail.com> wrote: > > > > > Hmmm - this is a bit worrying, isn't it? How to possibly test SQL which > > > > can > > > > potentially run so differently on different devices? > > > > > One starting point would be get a list of SQLite version numbers on each > > > > device available... > > > > > 2010/6/24 Tomáš Hubálek <tom.huba...@gmail.com> > > > > > > SQL Lite is definitely simpler but in Oracle it sometimes happens > > > > > that the > > > > > same SQL has very different performance on different versions because > > > > > of > > > > > different explain plan. > > > > > > Tom > > > > > > On Thu, Jun 24, 2010 at 12:48 PM, Mark Carter > > > > > <mjc1...@googlemail.com>wrote: > > > > > >> True - though the SQL is a little complex and I'd like to simplify it > > > > >> before posting. > > > > > >> However, whatever the SQL is, there has to be an explanation for the > > > > >> different outcome. > > > > > >> 2010/6/24 Tomáš Hubálek <tom.huba...@gmail.com> > > > > > >> Maybe full SQL would give more clue... > > > > > >>> Tom > > > > > >>> On 24 čvn, 10:13, Mark Carter <mjc1...@googlemail.com> wrote: > > > > >>> > Same data, same code, but different results on these two devices. > > > > > >>> > On the Nexus One, the (INNER JOIN) query runs (first call to > > > > >>> > Cursor.moveToNext()) after a fraction of a second but on the Hero > > > > >>> > it > > > > >>> > just hangs. > > > > > >>> > I haven't been able to reduce the scenario to something simple > > > > >>> > yet, > > > > >>> > but it seems to involve using OR within an ON clause. > > > > > >>> > Anyone know why there might be a difference on these two devices? > > > > > >>> -- > > > > >>> You received this message because you are subscribed to the Google > > > > >>> Groups "Android Developers" group. > > > > >>> To post to this group, send email to > > > > >>> android-developers@googlegroups.com > > > > >>> To unsubscribe from this group, send email to > > > > >>> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > > > >>> cr...@googlegroups.com> > > > > >>> For more options, visit this group at > > > > >>>http://groups.google.com/group/android-developers?hl=en > > > > > >> -- > > > > >> You received this message because you are subscribed to the Google > > > > >> Groups "Android Developers" group. > > > > >> To post to this group, send email to > > > > >> android-developers@googlegroups.com > > > > >> To unsubscribe from this group, send email to > > > > >> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > > > >> cr...@googlegroups.com> > > > > >> For more options, visit this group at > > > > >>http://groups.google.com/group/android-developers?hl=en > > > > > > -- > > > > > > --------------------------------------------------------------------------- > > > > > -------------------- > > > > > Tom Hubalek (tom.huba...@gmail.com), > > > > >http://android.hubalek.net,http://blog.hubalek.net/ > > > > >http://facebook.com/thubalek,http://www.linkedin.com/in/thubalek > > > > >http://twitter.com/thubalek,http://twitter.com/android_dev_tom > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > > > Groups "Android Developers" group. > > > > > To post to this group, send email to > > > > > android-developers@googlegroups.com > > > > > To unsubscribe from this group, send email to > > > > > android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > > > > cr...@googlegroups.com> > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
