Lines Matching refs:R

87 # X-EVIDENCE-OF: R-15514-65163 SQLite understands the following binary
92 # X-EVIDENCE-OF: R-38759-38789 Operators IS and IS NOT have the same
183 # X-EVIDENCE-OF: R-13958-53419 Supported unary prefix operators are these:
194 # EVIDENCE-OF: R-53670-03373 The unary operator + is a no-op.
196 # EVIDENCE-OF: R-19480-30968 It can be applied to strings, numbers,
216 # EVIDENCE-OF: R-03679-60639 Equals can be either = or ==.
218 # EVIDENCE-OF: R-30082-38996 The non-equals operator can be either != or
241 # EVIDENCE-OF: R-44409-62641 The || operator is "concatenate" - it joins
257 # EVIDENCE-OF: R-53431-59159 The % operator casts both of its operands
268 # EVIDENCE-OF: R-15904-00746 The result of any binary operator is either
298 # EVIDENCE-OF: R-24731-45773 The IS and IS NOT operators work like = and
301 # EVIDENCE-OF: R-06325-15315 In this case, if both operands are NULL,
305 # EVIDENCE-OF: R-19812-36779 If one operand is NULL and the other is
309 # EVIDENCE-OF: R-61975-13410 It is not possible for an IS or IS NOT
365 # EVIDENCE-OF: R-59577-33471 The COLLATE operator is a unary postfix
368 # X-EVIDENCE-OF: R-36231-30731 The COLLATE operator has a higher
403 # EVIDENCE-OF: R-58731-25439 The collating sequence set by the COLLATE
421 # EVIDENCE-OF: R-31536-32008 Literal values may be integers, floating
437 # EVIDENCE-OF: R-35229-17830 A string constant is formed by enclosing
440 # EVIDENCE-OF: R-07100-06606 A single quote within the string can be
448 # EVIDENCE-OF: R-09593-03321 BLOB literals are string literals
452 # EVIDENCE-OF: R-19836-11244 Example: X'53514C697465'
460 # EVIDENCE-OF: R-23914-51476 A literal value can also be the token
491 # EVIDENCE-OF: R-33509-39458 A question mark followed by a number NNN
518 # EVIDENCE-OF: R-33670-36097 A question mark that is not followed by a
522 # EVIDENCE-OF: R-42938-07030 If this means the parameter number is
543 # EVIDENCE-OF: R-11620-22743 A colon followed by an identifier name
559 # EVIDENCE-OF: R-49783-61279 An "at" sign works exactly like a colon,
571 # EVIDENCE-OF: R-62610-51329 A dollar-sign followed by an identifier
574 # EVIDENCE-OF: R-55025-21042 The identifier name in this case can
595 # EVIDENCE-OF: R-11370-04520 Named parameters are also numbered. The
599 # EVIDENCE-OF: R-42620-22184 If this means the parameter would be
616 # EVIDENCE-OF: R-14068-49671 Parameters that are not assigned values
836 # EVIDENCE-OF: R-40079-54503 The BETWEEN operator is logically
860 # X-EVIDENCE-OF: R-05155-34454 The precedence of the BETWEEN operator is
905 # EVIDENCE-OF: R-16584-60189 The LIKE operator does a pattern matching
908 # EVIDENCE-OF: R-11295-04657 The operand to the right of the LIKE
915 # EVIDENCE-OF: R-55406-38524 A percent symbol ("%") in the LIKE pattern
922 # EVIDENCE-OF: R-30433-25443 An underscore ("_") in the LIKE pattern
929 # EVIDENCE-OF: R-59007-20454 Any other character matches itself or its
936 # EVIDENCE-OF: R-23648-58527 SQLite only understands upper/lower case
939 # EVIDENCE-OF: R-04532-11527 The LIKE operator is case sensitive by
942 # EVIDENCE-OF: R-44381-11669 the expression
955 # EVIDENCE-OF: R-56683-13731 If the optional ESCAPE clause is present,
968 # EVIDENCE-OF: R-02045-23762 This character may be used in the LIKE
971 # EVIDENCE-OF: R-13345-31830 The escape character followed by a percent
993 # EVIDENCE-OF: R-51359-17496 The infix LIKE operator is implemented by
1011 # EVIDENCE-OF: R-22868-25880 The LIKE operator can be made case
1027 # EVIDENCE-OF: R-52087-12043 The GLOB operator is similar to LIKE but
1030 # EVIDENCE-OF: R-09813-17279 Also, GLOB is case sensitive, unlike LIKE.
1041 # EVIDENCE-OF: R-39616-20555 Both GLOB and LIKE may be preceded by the
1057 # EVIDENCE-OF: R-39414-35489 The infix GLOB operator is implemented by
1073 # EVIDENCE-OF: R-41650-20872 No regexp() user function is defined by
1088 # EVIDENCE-OF: R-33693-50180 The REGEXP operator is a special syntax for
1091 # EVIDENCE-OF: R-65524-61849 If an application-defined SQL function
1108 # EVIDENCE-OF: R-42037-37826 The default match() function implementation
1118 # EVIDENCE-OF: R-37916-47407 The MATCH operator is a special syntax for
1121 # EVIDENCE-OF: R-06021-09373 But extensions can override the match()
1140 # EVIDENCE-OF: R-57495-24088 There are two fundamental forms of the CASE
1156 # EVIDENCE-OF: R-30638-59954 In a CASE without a base expression, each
1178 # EVIDENCE-OF: R-39009-25596 The result of the CASE expression is the
1207 # EVIDENCE-OF: R-24227-04807 Or, if none of the WHEN expressions
1220 # EVIDENCE-OF: R-14168-07579 If there is no ELSE expression and none of
1232 # EVIDENCE-OF: R-13943-13592 A NULL result is considered untrue when
1242 # EVIDENCE-OF: R-38620-19499 In a CASE with a base expression, the base
1257 # EVIDENCE-OF: R-07667-49537 The result of the CASE expression is the
1268 # EVIDENCE-OF: R-47543-32145 Or, if none of the WHEN expressions
1276 # EVIDENCE-OF: R-54721-48557 If there is no ELSE expression and none of
1289 # EVIDENCE-OF: R-11479-62774 When comparing a base expression against a
1341 # EVIDENCE-OF: R-37304-39405 If the base expression is NULL then the
1352 # EVIDENCE-OF: R-56280-17369 Both forms of the CASE expression use lazy,
1373 # EVIDENCE-OF: R-34773-62253 The only difference between the following
1417 # EVIDENCE-OF: R-20854-17109 A CAST conversion is similar to the
1436 # EVIDENCE-OF: R-32434-09092 If the value of expr is NULL, then the
1444 # EVIDENCE-OF: R-29283-15561 Otherwise, the storage class of the result
1448 # The R-29283-15561 requirement above is demonstrated by all of the 
1451 # EVIDENCE-OF: R-43522-35548 Casting a value to a type-name with no
1458 # EVIDENCE-OF: R-22956-37754 Casting to a BLOB consists of first casting
1484 # EVIDENCE-OF: R-04207-37981 To cast a BLOB value to TEXT, the sequence
1500 # EVIDENCE-OF: R-22235-47006 Casting an INTEGER or REAL value into TEXT
1513 # EVIDENCE-OF: R-26346-36443 When casting a BLOB value to a REAL, the
1536 # EVIDENCE-OF: R-54898-34554 When casting a TEXT value to REAL, the
1545 # EVIDENCE-OF: R-11321-47427 Any leading spaces in the TEXT value are
1553 # EVIDENCE-OF: R-22662-28218 If there is no prefix that can be
1560 # EVIDENCE-OF: R-21829-14563 When casting a BLOB value to INTEGER, the
1588 # EVIDENCE-OF: R-47612-45842 When casting a TEXT value to INTEGER, the
1598 # EVIDENCE-OF: R-34400-33772 Any leading spaces in the TEXT value when
1606 # EVIDENCE-OF: R-43164-44276 If there is no prefix that can be
1613 # EVIDENCE-OF: R-08980-53124 The CAST operator understands decimal
1620 # EVIDENCE-OF: R-02752-50091 A cast of a REAL value into an INTEGER
1629 # EVIDENCE-OF: R-51517-40824 If a REAL is greater than the greatest
1645 # EVIDENCE-OF: R-55084-10555 Casting a TEXT or BLOB value into NUMERIC
1648 # EVIDENCE-OF: R-48945-04866 If the input text looks like an integer
1652 # EVIDENCE-OF: R-47045-23194 Input text that looks like floating point
1675 # EVIDENCE-OF: R-50300-26941 Any text input that describes a value
1687 # EVIDENCE-OF: R-30347-18702 Casting a REAL or INTEGER value to NUMERIC
1745 # EVIDENCE-OF: R-64550-29191 Note that the result from casting any
1794 # EVIDENCE-OF: R-25588-27181 The EXISTS operator always evaluates to one
1802 # EVIDENCE-OF: R-58553-63740 If executing the SELECT statement specified
1816 # EVIDENCE-OF: R-19673-40972 If executing the SELECT would return no
1828 # EVIDENCE-OF: R-35109-49139 The number of columns in each row returned
1847 # EVIDENCE-OF: R-10645-12439 In particular, rows containing NULL values
1875 # EVIDENCE-OF: R-43573-23448 A SELECT statement enclosed in parentheses
1878 # EVIDENCE-OF: R-56294-03966 All types of SELECT statement, including
1895 # EVIDENCE-OF: R-22239-33740 A subquery that returns two or more columns
1914 # EVIDENCE-OF: R-18318-14995 The value of a subquery expression is the
1939 # EVIDENCE-OF: R-52325-25449 The value of a subquery expression is NULL
1949 # EVIDENCE-OF: R-62477-06476 For example, the values NULL, 0.0, 0,
1968 # EVIDENCE-OF: R-55532-10108 Values 1, 1.0, 0.1, -0.1 and '1english' are