| Index: third_party/sqlite/src/test/e_select2.test
|
| diff --git a/third_party/sqlite/src/test/e_select2.test b/third_party/sqlite/src/test/e_select2.test
|
| index b338d4f3e4da8e4650453b78098c1690971658b6..8330894428e4fa90dba3195dbfbac21c1ea6575a 100644
|
| --- a/third_party/sqlite/src/test/e_select2.test
|
| +++ b/third_party/sqlite/src/test/e_select2.test
|
| @@ -344,16 +344,16 @@ foreach {tn indexes} {
|
| catchsql { DROP INDEX i3 }
|
| execsql $indexes
|
|
|
| - # EVIDENCE-OF: R-46122-14930 If the join-op is "CROSS JOIN", "INNER
|
| - # JOIN", "JOIN" or a comma (",") and there is no ON or USING clause,
|
| - # then the result of the join is simply the cartesian product of the
|
| - # left and right-hand datasets.
|
| + # EVIDENCE-OF: R-49872-03192 If the join-operator is "CROSS JOIN",
|
| + # "INNER JOIN", "JOIN" or a comma (",") and there is no ON or USING
|
| + # clause, then the result of the join is simply the cartesian product of
|
| + # the left and right-hand datasets.
|
| #
|
| # EVIDENCE-OF: R-46256-57243 There is no difference between the "INNER
|
| # JOIN", "JOIN" and "," join operators.
|
| #
|
| - # EVIDENCE-OF: R-07544-24155 The "CROSS JOIN" join operator produces the
|
| - # same data as the "INNER JOIN", "JOIN" and "," operators
|
| + # EVIDENCE-OF: R-25071-21202 The "CROSS JOIN" join operator produces the
|
| + # same result as the "INNER JOIN", "JOIN" and "," operators
|
| #
|
| test_join $tn.1.1 "t1, t2" {t1 t2}
|
| test_join $tn.1.2 "t1 INNER JOIN t2" {t1 t2}
|
| @@ -368,10 +368,10 @@ foreach {tn indexes} {
|
| test_join $tn.1.11 "t2 CROSS JOIN t2 AS x" {t2 t2}
|
| test_join $tn.1.12 "t2 JOIN t2 AS x" {t2 t2}
|
|
|
| - # EVIDENCE-OF: R-22775-56496 If there is an ON clause specified, then
|
| - # the ON expression is evaluated for each row of the cartesian product
|
| - # as a boolean expression. All rows for which the expression evaluates
|
| - # to false are excluded from the dataset.
|
| + # EVIDENCE-OF: R-38465-03616 If there is an ON clause then the ON
|
| + # expression is evaluated for each row of the cartesian product as a
|
| + # boolean expression. Only rows for which the expression evaluates to
|
| + # true are included from the dataset.
|
| #
|
| test_join $tn.2.1 "t1, t2 ON (t1.a=t2.a)" {t1 t2 -on {te_equals a a}}
|
| test_join $tn.2.2 "t2, t1 ON (t1.a=t2.a)" {t2 t1 -on {te_equals a a}}
|
| @@ -504,14 +504,14 @@ do_execsql_test e_select-2.2.0 {
|
| INSERT INTO t5 VALUES(2, 'two');
|
| } {}
|
|
|
| -# EVIDENCE-OF: R-55824-40976 A sub-select specified in the join-source
|
| -# following the FROM clause in a simple SELECT statement is handled as
|
| -# if it was a table containing the data returned by executing the
|
| -# sub-select statement.
|
| +# EVIDENCE-OF: R-59237-46742 A subquery specified in the
|
| +# table-or-subquery following the FROM clause in a simple SELECT
|
| +# statement is handled as if it was a table containing the data returned
|
| +# by executing the subquery statement.
|
| #
|
| -# EVIDENCE-OF: R-42612-06757 Each column of the sub-select dataset
|
| -# inherits the collation sequence and affinity of the corresponding
|
| -# expression in the sub-select statement.
|
| +# EVIDENCE-OF: R-27438-53558 Each column of the subquery has the
|
| +# collation sequence and affinity of the corresponding expression in the
|
| +# subquery statement.
|
| #
|
| foreach {tn subselect select spec} {
|
| 1 "SELECT * FROM t2" "SELECT * FROM t1 JOIN %ss%"
|
|
|