Index: src/select.c
==================================================================
--- src/select.c
+++ src/select.c
@@ -3473,10 +3473,13 @@
           ExprSetProperty(pNew, EP_CanBeNull);
         }
         if( pNew && ExprHasProperty(pExpr,EP_FromJoin) ){
           pNew->iRightJoinTable = pExpr->iRightJoinTable;
           ExprSetProperty(pNew, EP_FromJoin);
+        }
+        if( pNew && ExprHasProperty(pExpr,EP_Generic) ){
+          ExprSetProperty(pNew, EP_Generic);
         }
         sqlite3ExprDelete(db, pExpr);
         pExpr = pNew;
       }
     }

Index: test/view.test
==================================================================
--- test/view.test
+++ test/view.test
@@ -758,7 +758,21 @@
   SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c1<c0
 } {}
 do_execsql_test view-27.9 {
   SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c0<c1
 } {1}
+
+#-------------------------------------------------------------------------
+reset_db
+do_execsql_test view-28.0 {
+  CREATE TABLE t0(c0 TEXT);
+  CREATE VIEW v0(c0) AS SELECT t0.c0 FROM t0;
+  INSERT INTO t0(c0) VALUES ('0');
+}
+do_execsql_test view-28.1 {
+  SELECT 0 IN (c0) FROM t0;
+} {0}
+do_execsql_test view-28.2 {
+  SELECT 0 IN (c0) FROM (SELECT c0 FROM t0);
+} {0}
 
 finish_test