sqllogictest

Check-in [9b2ad097cb]
Login

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

Overview
Comment:Basic evidence tests for REPLACE.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9b2ad097cb4eb2aa8f9e17b5a1c3405975e22b15
User & Date: shaneh 2010-09-01 18:52:06.000
Context
2010-09-24
18:59
Update to SLT evidence marks. check-in: 04ea7ef2df user: shaneh tags: trunk
2010-09-01
18:52
Basic evidence tests for REPLACE. check-in: 9b2ad097cb user: shaneh tags: trunk
2010-08-10
04:29
Some evidence testing for views; check-in: eaf2c620e1 user: shaneh tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Added test/evidence/slt_lang_replace.test.






















































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
# skip this file if ms sql server
onlyif mssql
halt

# skip this file if oracle
onlyif oracle
halt

hash-threshold 8

statement ok
CREATE TABLE t1( x INTEGER PRIMARY KEY, y VARCHAR(16) )

statement ok
INSERT INTO t1 VALUES(1, 'true')

statement ok
INSERT INTO t1 VALUES(0, 'false')


# EVIDENCE-OF: R-03421-22330 The REPLACE command is an alias for the
# "INSERT OR REPLACE" variant of the INSERT command.

query IT rowsort
SELECT x, y FROM t1 WHERE x=2
----

statement ok
INSERT INTO t1 VALUES(2, 'insert')

query IT rowsort
SELECT x, y FROM t1 WHERE x=2
----
2
insert

skipif mysql
statement ok
INSERT OR REPLACE INTO t1 VALUES(2, 'insert or replace')

skipif mysql
query IT rowsort
SELECT x, y FROM t1 WHERE x=2
----
2
insert or replace

statement ok
REPLACE INTO t1 VALUES(2, 'replace')

query IT rowsort
SELECT x, y FROM t1 WHERE x=2
----
2
replace

skipif mysql
statement ok
INSERT OR REPLACE INTO t1 VALUES(3, 'insert or replace (new)')

skipif mysql
query IT rowsort
SELECT x, y FROM t1 WHERE x=3
----
3
insert or replace (new)

statement ok
REPLACE INTO t1 VALUES(4, 'replace (new)')

query IT rowsort
SELECT x, y FROM t1 WHERE x=4
----
4
replace (new)