diff options
| author | drh <> | 2022-12-15 20:03:08 +0000 |
|---|---|---|
| committer | drh <> | 2022-12-15 20:03:08 +0000 |
| commit | 00d6b2755fe197558019dc5ccf4e26740a7356a5 (patch) | |
| tree | 1e987cc476a88b49ec9614a277a20ac40272040d /src/expr.c | |
| parent | 118b53bd21d588441d7d4cb3b416d9c135a69bbd (diff) | |
| download | sqlite-00d6b2755fe197558019dc5ccf4e26740a7356a5.tar.gz sqlite-00d6b2755fe197558019dc5ccf4e26740a7356a5.zip | |
Create a new affinity called FLEXNUM that works like NUMERIC except that it
never tries to convert integer to real or real to integer. The affinity is
only used internally - it is not possible to create a table column with this
affinity. This affinity is used on subqueries and views that are built off
of a compound SELECT and where the datatype is controlled by a CAST expression.
dbsqlfuzz c9ee6f9a0a8b8fefb02cf69de2a8b67ca39525c8
FossilOrigin-Name: 44135d6ea84f7ba6b36549954b38a8bc048d5ffea5a9779e35950afa4eb2dfb2
Diffstat (limited to 'src/expr.c')
| -rw-r--r-- | src/expr.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/expr.c b/src/expr.c index fe316550a..b1ccde4af 100644 --- a/src/expr.c +++ b/src/expr.c @@ -4250,7 +4250,7 @@ expr_code_doover: assert( pExpr->y.pTab!=0 ); aff = sqlite3TableColumnAffinity(pExpr->y.pTab, pExpr->iColumn); if( aff>SQLITE_AFF_BLOB ){ - static const char zAff[] = "B\000C\000D\000E"; + static const char zAff[] = "B\000C\000D\000E\000F"; assert( SQLITE_AFF_BLOB=='A' ); assert( SQLITE_AFF_TEXT=='B' ); sqlite3VdbeAddOp4(v, OP_Affinity, iReg, 1, 0, |