)s) Internals for Android 1.6+ version 2010.7.11b will now also display the source_id when running on android v. 2.2+.
On my N1, it showed 2010-03-22 followed by a time and a long generated unique id. serge On Jul 11, 1:44 pm, sm1 <sergemas...@gmail.com> wrote: > got it. Thanks Mark. > > On Jul 11, 12:38 pm, Mark Carter <mjc1...@googlemail.com> wrote: > > > > > That function is only in SQLite 3.6.18+ (see link in my last comment), so > > will only work on 2.2+. > > > On 11 July 2010 18:31, sm1 <sergemas...@gmail.com> wrote: > > > > 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><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><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><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 -- 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