Changeset: 82a9555b2ec6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/82a9555b2ec6
Modified Files:
sql/test/merge-partitions/Tests/mergepart03.test
sql/test/merge-partitions/Tests/mergepart04.test
sql/test/merge-partitions/Tests/mergepart05.test
sql/test/merge-partitions/Tests/mergepart06.test
sql/test/merge-partitions/Tests/mergepart07.test
sql/test/merge-partitions/Tests/mergepart08.test
sql/test/merge-partitions/Tests/mergepart09.test
sql/test/merge-partitions/Tests/mergepart10.test
sql/test/merge-partitions/Tests/mergepart11.test
sql/test/merge-partitions/Tests/mergepart12.test
sql/test/merge-partitions/Tests/mergepart13.test
sql/test/merge-partitions/Tests/mergepart15.test
sql/test/merge-partitions/Tests/mergepart16.test
sql/test/merge-partitions/Tests/mergepart17.test
sql/test/merge-partitions/Tests/mergepart18.test
sql/test/merge-partitions/Tests/mergepart19.test
sql/test/merge-partitions/Tests/mergepart20.test
sql/test/merge-partitions/Tests/mergepart21.test
sql/test/merge-partitions/Tests/mergepart22.test
sql/test/merge-partitions/Tests/mergepart25.test
sql/test/merge-partitions/Tests/mergepart26.test
sql/test/merge-partitions/Tests/mergepart27.test
sql/test/merge-partitions/Tests/mergepart28.test.in
sql/test/merge-partitions/Tests/mergepart30.test
sql/test/merge-partitions/Tests/mergepart31.test
sql/test/merge-partitions/Tests/mergepart32.test
Branch: default
Log Message:
I need the number of affected rows on update statements to test the code
generation changes on pushcands branch
diffs (truncated from 1014 to 300 lines):
diff --git a/sql/test/merge-partitions/Tests/mergepart03.test
b/sql/test/merge-partitions/Tests/mergepart03.test
--- a/sql/test/merge-partitions/Tests/mergepart03.test
+++ b/sql/test/merge-partitions/Tests/mergepart03.test
@@ -21,7 +21,7 @@ 1
statement ok
ROLLBACK
-statement ok
+statement ok rowcount 1
INSERT INTO subtable2 VALUES (1, 'hello')
query I rowsort
@@ -40,7 +40,7 @@ 1
statement ok
ALTER TABLE listparts DROP TABLE subtable2
-statement ok
+statement ok rowcount 1
INSERT INTO subtable2 VALUES (-5, 'oh no')
statement error
diff --git a/sql/test/merge-partitions/Tests/mergepart04.test
b/sql/test/merge-partitions/Tests/mergepart04.test
--- a/sql/test/merge-partitions/Tests/mergepart04.test
+++ b/sql/test/merge-partitions/Tests/mergepart04.test
@@ -24,7 +24,7 @@ INSERT INTO anothertest VALUES (4, 'wron
statement ok
ROLLBACK
-statement ok
+statement ok rowcount 1
INSERT INTO subtest2 VALUES (-1, 'hello')
query I rowsort
@@ -43,7 +43,7 @@ 3
statement ok
ALTER TABLE anothertest DROP TABLE subtest2
-statement ok
+statement ok rowcount 1
INSERT INTO subtest2 VALUES (-5, 'oh no')
statement error
diff --git a/sql/test/merge-partitions/Tests/mergepart05.test
b/sql/test/merge-partitions/Tests/mergepart05.test
--- a/sql/test/merge-partitions/Tests/mergepart05.test
+++ b/sql/test/merge-partitions/Tests/mergepart05.test
@@ -53,7 +53,7 @@ SELECT minimum, maximum FROM range_parti
statement error
ALTER TABLE listparts DROP TABLE subtable1
-statement ok
+statement ok rowcount 1
INSERT INTO subtable1 VALUES ('wrong')
statement error
@@ -84,7 +84,7 @@ ALTER TABLE testtimestamps ADD TABLE sub
statement ok
ALTER TABLE testtimestamps DROP TABLE subtime
-statement ok
+statement ok rowcount 1
INSERT INTO subtime VALUES (timestamp '2018-02-01 00:00')
statement ok
@@ -93,10 +93,10 @@ ALTER TABLE testtimestamps ADD TABLE sub
statement ok
ALTER TABLE testtimestamps DROP TABLE subtime
-statement ok
+statement ok rowcount 1
DELETE FROM subtime
-statement ok
+statement ok rowcount 1
INSERT INTO subtime VALUES (timestamp '2050-01-01 00:00')
statement error
@@ -120,7 +120,7 @@ ALTER TABLE testrangelimits ADD TABLE su
statement ok
ALTER TABLE testrangelimits DROP TABLE sublimits
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits VALUES (-1)
statement ok
@@ -129,7 +129,7 @@ ALTER TABLE testrangelimits ADD TABLE su
statement ok
ALTER TABLE testrangelimits DROP TABLE sublimits
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits VALUES (0)
statement error
diff --git a/sql/test/merge-partitions/Tests/mergepart06.test
b/sql/test/merge-partitions/Tests/mergepart06.test
--- a/sql/test/merge-partitions/Tests/mergepart06.test
+++ b/sql/test/merge-partitions/Tests/mergepart06.test
@@ -19,7 +19,7 @@ CREATE TABLE sublimits5 (a int, b varcha
statement ok
ALTER TABLE testrangelimits ADD TABLE sublimits1 AS PARTITION FROM 0 TO 100
-statement ok
+statement ok rowcount 1
INSERT INTO testrangelimits VALUES (1, 'first')
statement error
@@ -37,16 +37,16 @@ ALTER TABLE testrangelimits ADD TABLE su
statement error
ALTER TABLE testrangelimits ADD TABLE sublimits5 AS PARTITION FROM -1 TO 1
-statement ok
+statement ok rowcount 3
INSERT INTO testrangelimits VALUES (1, 'a'), (101, 'b'), (401, 'c')
-statement ok
+statement ok rowcount 1
INSERT INTO testrangelimits VALUES (50, 'more')
-statement ok
+statement ok rowcount 1
INSERT INTO testrangelimits VALUES (171, 'test')
-statement ok
+statement ok rowcount 4
INSERT INTO testrangelimits VALUES (401, 'another'), (NULL, 'test'), (450,
'to'), (499, 'pass')
statement error
@@ -55,13 +55,13 @@ INSERT INTO testrangelimits VALUES (201,
statement error
INSERT INTO testrangelimits VALUES (444, 'another'), (305, 'error'), (4,
'happening')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits1 VALUES (2, 'another')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits2 VALUES (102, 'successful')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits3 VALUES (NULL, 'attempt')
statement error
diff --git a/sql/test/merge-partitions/Tests/mergepart07.test
b/sql/test/merge-partitions/Tests/mergepart07.test
--- a/sql/test/merge-partitions/Tests/mergepart07.test
+++ b/sql/test/merge-partitions/Tests/mergepart07.test
@@ -7,10 +7,10 @@ CREATE TABLE subtable1 (a int, b varchar
statement ok
CREATE TABLE subtable2 (a int, b varchar(32))
-statement ok
+statement ok rowcount 1
INSERT INTO subtable1 VALUES (NULL, 'hello')
-statement ok
+statement ok rowcount 1
INSERT INTO subtable2 VALUES (102, 'hello')
statement ok
@@ -61,7 +61,7 @@ CREATE TABLE othersub1 (a int, b varchar
statement ok
CREATE TABLE othersub2 (a int, b varchar(32))
-statement ok
+statement ok rowcount 1
INSERT INTO othersub1 VALUES (1, NULL)
statement ok
diff --git a/sql/test/merge-partitions/Tests/mergepart08.test
b/sql/test/merge-partitions/Tests/mergepart08.test
--- a/sql/test/merge-partitions/Tests/mergepart08.test
+++ b/sql/test/merge-partitions/Tests/mergepart08.test
@@ -7,10 +7,10 @@ CREATE TABLE subtable1 (a int, b varchar
statement ok
CREATE TABLE subtable2 (a int, b varchar(32))
-statement ok
+statement ok rowcount 3
INSERT INTO subtable1 VALUES (1, 'one'), (2, 'two'), (3, 'three')
-statement ok
+statement ok rowcount 3
INSERT INTO subtable2 VALUES (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
statement ok
@@ -55,7 +55,7 @@ twelve
13
thirteen
-statement ok
+statement ok rowcount 6
DELETE FROM testme
query IT rowsort
@@ -70,13 +70,13 @@ query IT rowsort
SELECT a, b FROM subtable2
----
-statement ok
+statement ok rowcount 3
INSERT INTO subtable1 VALUES (1, 'one'), (5, 'five'), (9, 'fifteen')
-statement ok
+statement ok rowcount 3
INSERT INTO subtable2 VALUES (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
-statement ok
+statement ok rowcount 4
DELETE FROM testme where a > 5
query IT rowsort
@@ -99,10 +99,10 @@ query IT rowsort
SELECT a, b FROM subtable2
----
-statement ok
+statement ok rowcount 1
INSERT INTO subtable1 VALUES (6, 'six')
-statement ok
+statement ok rowcount 3
TRUNCATE testme
query IT rowsort
@@ -120,13 +120,13 @@ SELECT a, b FROM subtable2
statement ok
ALTER TABLE testme DROP TABLE subtable1
-statement ok
+statement ok rowcount 3
INSERT INTO subtable1 VALUES (1, 'one'), (2, 'two'), (3, 'three')
-statement ok
+statement ok rowcount 3
INSERT INTO subtable2 VALUES (11, 'eleven'), (12, 'twelve'), (13, 'thirteen')
-statement ok
+statement ok rowcount 3
TRUNCATE testme
query IT rowsort
diff --git a/sql/test/merge-partitions/Tests/mergepart09.test
b/sql/test/merge-partitions/Tests/mergepart09.test
--- a/sql/test/merge-partitions/Tests/mergepart09.test
+++ b/sql/test/merge-partitions/Tests/mergepart09.test
@@ -13,7 +13,7 @@ CREATE TABLE sublimits3 (a int, b varcha
statement ok
ALTER TABLE testvaluespartitions ADD TABLE sublimits1 AS PARTITION IN ('1',
'2', '3')
-statement ok
+statement ok rowcount 1
INSERT INTO testvaluespartitions VALUES (1, 'first')
statement error
@@ -34,28 +34,28 @@ ALTER TABLE testvaluespartitions ADD TAB
statement ok
ALTER TABLE testvaluespartitions ADD TABLE sublimits3 AS PARTITION IN ('7',
'8', '9')
-statement ok
+statement ok rowcount 3
INSERT INTO testvaluespartitions VALUES (1, 'a'), (5, 'b'), (7, 'c')
-statement ok
+statement ok rowcount 3
INSERT INTO testvaluespartitions VALUES (7, 'another'), (9, 'to'), (9, 'pass')
-statement ok
+statement ok rowcount 1
INSERT INTO testvaluespartitions VALUES (3, 'mmm')
-statement ok
+statement ok rowcount 2
INSERT INTO testvaluespartitions VALUES ('5', 'test'), (NULL, 'test')
statement error
INSERT INTO testvaluespartitions VALUES (100, 'I am going to no partition')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits1 VALUES (1, 'another')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits2 VALUES (NULL, 'successful')
-statement ok
+statement ok rowcount 1
INSERT INTO sublimits3 VALUES (8, 'attempt')
statement error
diff --git a/sql/test/merge-partitions/Tests/mergepart10.test
b/sql/test/merge-partitions/Tests/mergepart10.test
--- a/sql/test/merge-partitions/Tests/mergepart10.test
+++ b/sql/test/merge-partitions/Tests/mergepart10.test
@@ -22,37 +22,37 @@ UPDATE testsmallpartitions SET b = 'try
statement ok
ALTER TABLE testsmallpartitions ADD TABLE testingme AS PARTITION IN ('100',
300, '400')
-statement ok
+statement ok rowcount 0
DELETE FROM testsmallpartitions
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
