Abstract
This section details the public types belonging to the
NdbScanFilter class.
Description.
This type represents a condition based on the comparison of a
column value with some arbitrary value—that is, a bound
condition. A value of this type is used as the first argument
to NdbScanFilter::cmp().
Enumeration values. Possible values are shown, along with descriptions, in the following table:
| Enumeration value | Description | Type of column values compared |
|---|---|---|
COND_EQ |
Equality (=) |
any |
COND_NE |
Inequality (<> or !=) |
any |
COND_LE |
Lower bound (<=) |
any |
COND_LT |
Strict lower bound (<) |
any |
COND_GE |
Upper bound (>=) |
any |
COND_GT |
Strict upper bound (>) | any |
COND_LIKE |
LIKE condition |
string or binary |
COND_NOTLIKE |
NOT LIKE condition |
string or binary |
COL_AND_MASK_EQ_MASK |
Column value ANDed with bitmask is equal to bitmask |
BIT |
COL_AND_MASK_NE_MASK |
Column value ANDed with bitmask is not equal to
bitmask |
BIT |
COL_AND_MASK_EQ_ZERO |
Column value ANDed with bitmask is equal to zero |
BIT |
COL_AND_MASK_NE_ZERO |
Column value ANDed with bitmask is not equal to zero |
BIT |
When used in comparisons with COND_EQ,
COND_NE, COND_LT,
COND_LE, COND_GT, or
COND_GE, fixed-length character and binary
column values must be prefixed with the column size, and must be
padded to length. This is not necessary for such values when
used in COND_LIKE,
COND_NOTLIKE,
COL_AND_MASK_EQ_MASK,
COL_AND_MASK_NE_MASK,
COL_AND_MASK_EQ_ZERO, or
COL_AND_MASK_NE_ZERO comparisons.
String comparisons.
Strings compared using COND_LIKE and
COND_NOTLIKE can use the pattern
metacharacters % and _.
See Section 2.3.25.2.3, “NdbScanFilter::cmp()”, for more
information.
BIT comparisons.
The BIT comparison operators
COL_AND_MASK_EQ_MASK,
COL_AND_MASK_NE_MASK,
COL_AND_MASK_EQ_ZERO, and
COL_AND_MASK_NE_ZERO were added in MySQL
Cluster NDB 6.3.20. Corresponding methods are also available
for NdbInterpretedCode and
NdbOperation beginning with
MySQL Cluster NDB 6.3.20; for more information about these
methods, see
Section 2.3.21.1.8, “NdbInterpretedCode Bitwise Comparison Operations”.
Description.
This type is used to describe logical (grouping) operators,
and is used with the begin() method. (See
Section 2.3.25.2.2, “NdbScanFilter::begin()”.)
Enumeration values. Possible values are shown, along with descriptions, in the following table:
| Value | Description |
|---|---|
AND |
Logical AND:
|
OR |
Logical OR:
|
NAND |
Logical NOT AND: NOT
(
|
NOR |
Logical NOT OR: NOT
(
|
