diff options
| author | drh <drh@noemail.net> | 2014-12-04 16:27:17 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2014-12-04 16:27:17 +0000 |
| commit | 72673a24e2d38c1699d911cfca0203f5e545f78c (patch) | |
| tree | 90f4ce666016c55d5f17f3b409f4c1240611e298 /src/sqliteInt.h | |
| parent | d8922052b27a3d2d62ccf3cf0ef1ea9b7272124d (diff) | |
| download | sqlite-72673a24e2d38c1699d911cfca0203f5e545f78c.tar.gz sqlite-72673a24e2d38c1699d911cfca0203f5e545f78c.zip | |
If a table is the right operand of a LEFT JOIN, then any column of that
table can be NULL even if that column as a NOT NULL constraint.
Fix for ticket [6f2222d550f5b0ee7ed].
FossilOrigin-Name: 6f6fcbe4736b9468a495c684d5eebc8bfe5c566a
Diffstat (limited to 'src/sqliteInt.h')
| -rw-r--r-- | src/sqliteInt.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/sqliteInt.h b/src/sqliteInt.h index f3d6ce015..3498517f2 100644 --- a/src/sqliteInt.h +++ b/src/sqliteInt.h @@ -2015,7 +2015,7 @@ struct Expr { /* ** The following are the meanings of bits in the Expr.flags field. */ -#define EP_FromJoin 0x000001 /* Originated in ON or USING clause of a join */ +#define EP_FromJoin 0x000001 /* Originates in ON/USING clause of outer join */ #define EP_Agg 0x000002 /* Contains one or more aggregate functions */ #define EP_Resolved 0x000004 /* IDs have been resolved to COLUMNs */ #define EP_Error 0x000008 /* Expression contains one or more errors */ @@ -2035,6 +2035,7 @@ struct Expr { #define EP_NoReduce 0x020000 /* Cannot EXPRDUP_REDUCE this Expr */ #define EP_Unlikely 0x040000 /* unlikely() or likelihood() function */ #define EP_Constant 0x080000 /* Node is a constant */ +#define EP_CanBeNull 0x100000 /* Can be null despite NOT NULL constraint */ /* ** These macros can be used to test, set, or clear bits in the |