diff options
| author | drh <> | 2025-06-02 18:34:17 +0000 |
|---|---|---|
| committer | drh <> | 2025-06-02 18:34:17 +0000 |
| commit | 342ef63e638e167ef16e8fff5bc109e2aa3de344 (patch) | |
| tree | 919267b137adde6511741fc14ed33399ce989216 /src/sqliteInt.h | |
| parent | d84bbac8be02e81c32a52765c02dd17996ac3841 (diff) | |
| download | sqlite-342ef63e638e167ef16e8fff5bc109e2aa3de344.tar.gz sqlite-342ef63e638e167ef16e8fff5bc109e2aa3de344.zip | |
Improve the accuracy of affinity and collating sequence analysis for
NATURAL JOINs to the left of RIGHT JOINs where source tables are views
or subqueries. Initial problem report in
[forum:/forumpost/829306db47|forum post 829306db47].
FossilOrigin-Name: f184d1d236e47962658a4639d9533f67a525b74cfe0f06c93e9b85fdcd02a15f
Diffstat (limited to 'src/sqliteInt.h')
| -rw-r--r-- | src/sqliteInt.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/sqliteInt.h b/src/sqliteInt.h index 951cd3d34..c65d159d1 100644 --- a/src/sqliteInt.h +++ b/src/sqliteInt.h @@ -2329,6 +2329,7 @@ struct CollSeq { #define SQLITE_AFF_INTEGER 0x44 /* 'D' */ #define SQLITE_AFF_REAL 0x45 /* 'E' */ #define SQLITE_AFF_FLEXNUM 0x46 /* 'F' */ +#define SQLITE_AFF_DEFER 0x58 /* 'X' - defer computation until later */ #define sqlite3IsNumericAffinity(X) ((X)>=SQLITE_AFF_NUMERIC) |