sqllogictest

Check-in [62245fe6d0]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix evidence marks due to wording changes.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 62245fe6d0241b000845695a2f202d064f68c9f0
User & Date: drh 2015-09-11 20:54:19.989
Context
2015-09-28
11:00
Update built-in SQLite to 3.8.12 alpha. Allow two prefix dashes on command-line options. Omit run-all.sh and rely on run-all.tcl for testing. Use all optimizer bits for the optimizer off tests in run-all.tcl. check-in: fcd2cc6991 user: drh tags: trunk
2015-09-11
20:54
Fix evidence marks due to wording changes. check-in: 62245fe6d0 user: drh tags: trunk
2015-07-24
00:37
Add the "run-all.tcl" script that runs all --verify tests and summarizes the output, and that works on both unix and windows. check-in: a9ccd7d797 user: drh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/evidence/slt_lang_dropview.test.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
statement ok
CREATE INDEX t1i1 ON t1(x)


# EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
# created by the CREATE VIEW statement.

# EVIDENCE-OF: R-27882-59129 The view to drop is identified by the
# view-name and optional database-name specified as part of the DROP
# VIEW statement. This reference is resolved using the standard
# procedure for object resolution.

statement ok
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

statement ok
DROP VIEW view1








|
|
|
|







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
statement ok
CREATE INDEX t1i1 ON t1(x)


# EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
# created by the CREATE VIEW statement.

# EVIDENCE-OF: R-18673-21346 The view to drop is identified by the
# view-name and optional schema-name specified as part of the DROP VIEW
# statement. This reference is resolved using the standard procedure for
# object resolution.

statement ok
CREATE VIEW view1 AS SELECT x FROM t1 WHERE x>0

statement ok
DROP VIEW view1

Changes to test/evidence/slt_lang_update.test.
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
UPDATE t1 SET x=3

query I rowsort
SELECT count(*) FROM t1 WHERE x=3
----
3

# EVIDENCE-OF: R-42117-40023 Otherwise, the UPDATE affects only those
# rows for which the result of evaluating the WHERE clause expression as
# a boolean expression is true.

statement ok
UPDATE t1 SET x=1 WHERE y='unknown'

query I rowsort
SELECT count(*) FROM t1 WHERE x=1
----







|
<
|







46
47
48
49
50
51
52
53

54
55
56
57
58
59
60
61
UPDATE t1 SET x=3

query I rowsort
SELECT count(*) FROM t1 WHERE x=3
----
3

# EVIDENCE-OF: R-58095-46013 Otherwise, the UPDATE affects only those

# rows for which the WHERE clause boolean expression is true.

statement ok
UPDATE t1 SET x=1 WHERE y='unknown'

query I rowsort
SELECT count(*) FROM t1 WHERE x=1
----