aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordrh <>2021-08-24 17:07:44 +0000
committerdrh <>2021-08-24 17:07:44 +0000
commit5ced0a914e1701bf92c860d9f55e8f0a72d353e2 (patch)
tree49de55d2e2624d8ff87a088b16330bdbeffe3216 /src
parent0ccda5294fee4e27461f03eef6447bb1fcf9ef65 (diff)
downloadsqlite-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.c2
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);
}