sqllogictest

Check-in [b1158b0aff]
Login

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: b1158b0afff23c5e62ba8de8a34b73f7495ba1da
User & Date: drh 2011-06-23 17:33:19.319
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
Unified Diff Ignore Whitespace Patch
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
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
----







|

|







77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
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
----
188
189
190
191
192
193
194
195
# 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.








<
188
189
190
191
192
193
194

# 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.