1 files changed, 6 insertions, 0 deletions
diff --git a/src/expr.c b/src/expr.c
index 31df95c05..76f0d4908 100644
--- a/src/expr.c
+++ b/src/expr.c
@@ -61,6 +61,12 @@ char sqlite3ExprAffinity(Expr *pExpr){
   if( op==TK_AGG_COLUMN || op==TK_COLUMN ){
     return sqlite3TableColumnAffinity(pExpr->pTab, pExpr->iColumn);
   }
+  if( op==TK_SELECT_COLUMN ){
+    assert( pExpr->pLeft->flags&EP_xIsSelect );
+    return sqlite3ExprAffinity(
+        pExpr->pLeft->x.pSelect->pEList->a[pExpr->iColumn].pExpr
+    );
+  }
   return pExpr->affinity;
 }