DatabaseGeneralTest.java 文件源码

@MediumTest
public void testUnionsWithBindArgs() {
    /* make sure unions with bindargs work http://b/issue?id=1061291 */
    mDatabase.execSQL("CREATE TABLE A (i int);");
    mDatabase.execSQL("create table B (k int);");
    mDatabase.execSQL("create table C (n int);");
    mDatabase.execSQL("insert into A values(1);");
    mDatabase.execSQL("insert into A values(2);");
    mDatabase.execSQL("insert into A values(3);");
    mDatabase.execSQL("insert into B values(201);");
    mDatabase.execSQL("insert into B values(202);");
    mDatabase.execSQL("insert into B values(203);");
    mDatabase.execSQL("insert into C values(901);");
    mDatabase.execSQL("insert into C values(902);");
    String s = "select i from A where i > 2 " +
            "UNION select k from B where k > 201 " +
            "UNION select n from C where n !=900;";
    Cursor c = mDatabase.rawQuery(s, null);
    int n = c.getCount();
    c.close();
    String s1 = "select i from A where i > ? " +
            "UNION select k from B where k > ? " +
            "UNION select n from C where n != ?;";
    Cursor c1 = mDatabase.rawQuery(s1, new String[]{"2", "201", "900"});
    assertEquals(n, c1.getCount());
    c1.close();
}