diff options
author | drh <> | 2021-08-24 17:07:44 +0000 |
---|---|---|
committer | drh <> | 2021-08-24 17:07:44 +0000 |
commit | 5ced0a914e1701bf92c860d9f55e8f0a72d353e2 (patch) | |
tree | 49de55d2e2624d8ff87a088b16330bdbeffe3216 /src | |
parent | 0ccda5294fee4e27461f03eef6447bb1fcf9ef65 (diff) | |
download | sqlite-5ced0a914e1701bf92c860d9f55e8f0a72d353e2.tar.gz sqlite-5ced0a914e1701bf92c860d9f55e8f0a72d353e2.zip |
Correctly preserve the collating sequence for a column when changing
its datatype. Fix for the problem reported by
[forum:/forumpost/e5c76b738e|forum post e5c76b738e]. Test cases
in TH3.
FossilOrigin-Name: c7f0813cabf9d8ab367bead5ba8cf20132b8bb9274d8e47b76ad66a10517dd2a
Diffstat (limited to 'src')
-rw-r--r-- | src/select.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/select.c b/src/select.c index 1045c8f1d..78e5f5cf0 100644 --- a/src/select.c +++ b/src/select.c @@ -2193,7 +2193,7 @@ void sqlite3SelectAddColumnTypeAndCollation( } if( pCol->affinity<=SQLITE_AFF_NONE ) pCol->affinity = aff; pColl = sqlite3ExprCollSeq(pParse, p); - if( pColl && (pCol->colFlags & COLFLAG_HASCOLL)==0 ){ + if( pColl ){ assert( pTab->pIndex==0 ); sqlite3ColumnSetColl(db, pCol, pColl->zName); } |