diff options
Diffstat (limited to 'src/select.c')
| -rw-r--r-- | src/select.c | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/src/select.c b/src/select.c index b4d57f489..336d1503a 100644 --- a/src/select.c +++ b/src/select.c @@ -2358,11 +2358,15 @@ void sqlite3SubqueryColumnTypes( pCol->affinity = SQLITE_AFF_BLOB; } } - zType = 0; - for(j=0; j<SQLITE_N_STDTYPE; j++){ - if( sqlite3StdTypeAffinity[j]==pCol->affinity ){ - zType = sqlite3StdType[j]; - break; + if( pCol->affinity==SQLITE_AFF_NUMERIC ){ + zType = "NUM"; + }else{ + zType = 0; + for(j=1; j<SQLITE_N_STDTYPE; j++){ + if( sqlite3StdTypeAffinity[j]==pCol->affinity ){ + zType = sqlite3StdType[j]; + break; + } } } if( zType ){ |