Assert that legacy alter table behaviour is the default.

Bug: 147928666
Test: atest SQLiteDatabaseTest
Change-Id: I67a2dedfbe20641459e8796627d1fd39e7d6fbc0
(cherry picked from commit b12e2c7711f3b25eea20d64876cdf3e712ef285c)

1 files changed, 13 insertions, 0 deletions

diff --git a/tests/tests/database/src/android/database/sqlite/cts/SQLiteDatabaseTest.java b/tests/tests/database/src/android/database/sqlite/cts/SQLiteDatabaseTest.java
index 32609e97d37..3856d1d95dc 100644
--- a/tests/tests/database/src/android/database/sqlite/cts/SQLiteDatabaseTest.java
+++ b/tests/tests/database/src/android/database/sqlite/cts/SQLiteDatabaseTest.java
@@ -1948,4 +1948,17 @@ public class SQLiteDatabaseTest extends AndroidTestCase {
                 + patchLevel, patchLevel >= EXPECTED_MIN_PATCH_LEVEL);
     }
 
+    // http://b/147928666
+    public void testDefaultLegacyAlterTableEnabled() {
+        mDatabase.beginTransaction();
+        mDatabase.execSQL("CREATE TABLE \"t1\" (\"c1\" INTEGER, PRIMARY KEY(\"c1\"));");
+        mDatabase.execSQL("CREATE TABLE \"t2\" (\"c1\" INTEGER);");
+        mDatabase.execSQL("CREATE VIEW \"v1\" AS SELECT c1 from t1;");
+        mDatabase.execSQL("DROP TABLE t1;");
+        // The following statement will fail to execute without the legacy flag because
+        // we have a view in the schema with a dangling reference to a table that doesn't
+        // exist any more.
+        mDatabase.execSQL("ALTER TABLE \"t2\" RENAME TO \"t1\";");
+        mDatabase.endTransaction();
+    }
 }