Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fixes to evidence marks. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | b1158b0afff23c5e62ba8de8a34b73f7 |
| User & Date: | drh 2011-06-23 17:33:19 |
Context
|
2011-06-23
| ||
| 18:46 | Update the SQLite sources to the version 3.7.7 release candidate. check-in: a0ab881592 user: drh tags: trunk | |
| 17:33 | Fixes to evidence marks. check-in: b1158b0aff user: drh tags: trunk | |
|
2011-05-26
| ||
| 01:15 | Updates makefiles to work with a standard amalgamation. Update the built-in SQLite to be the latest 3.7.7 alpha. check-in: 5a2901cd3d user: drh tags: trunk | |
Changes
Changes to test/evidence/slt_lang_update.test.
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
...
188
189
190
191
192
193
194
195
|
UPDATE t1 SET x=3+1 query I rowsort SELECT count(*) FROM t1 WHERE x=4 ---- 3 # EVIDENCE-OF: R-09060-20018 If a single column-name appears more than # once in the list of assignment expressions, all but the rightmost # occurence is ignored. statement ok UPDATE t1 SET x=3, x=4, x=5 query I rowsort SELECT count(*) FROM t1 WHERE x=3 ---- ................................................................................ # LIMIT clause are assembled in an arbitrary order before applying the # LIMIT and OFFSET clauses to determine which are actually updated. # TBD-EVIDENCE-OF: R-10927-26133 The ORDER BY clause on an UPDATE statement # is used only to determine which rows fall within the LIMIT. The order # in which rows are modified is arbitrary and is not influenced by the # ORDER BY clause. |
|
|
|
<
|
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
...
188
189
190
191
192
193
194
|
UPDATE t1 SET x=3+1 query I rowsort SELECT count(*) FROM t1 WHERE x=4 ---- 3 # EVIDENCE-OF: R-34751-18293 If a single column-name appears more than # once in the list of assignment expressions, all but the rightmost # occurrence is ignored. statement ok UPDATE t1 SET x=3, x=4, x=5 query I rowsort SELECT count(*) FROM t1 WHERE x=3 ---- ................................................................................ # LIMIT clause are assembled in an arbitrary order before applying the # LIMIT and OFFSET clauses to determine which are actually updated. # TBD-EVIDENCE-OF: R-10927-26133 The ORDER BY clause on an UPDATE statement # is used only to determine which rows fall within the LIMIT. The order # in which rows are modified is arbitrary and is not influenced by the # ORDER BY clause. |