ln80: START TRANSACTION;

CREATE TABLE foo(id INT NOT NULL, s TEXT);
COPY BINARY INTO foo(id, s) FROM R'/export/scratch1/home/monet/testing/1bf5d1ec834c-1-1-3/tests/sql/mTests/sql/test/bincopy/bincopy_ints.bin', R'/export/scratch1/home/monet/testing/1bf5d1ec834c-1-1-3/tests/sql/mTests/sql/test/bincopy/bincopy_large_strings.bin' ON SERVER;
SELECT COUNT(id) FROM foo
WHERE (id % 10000 <> 0 AND LENGTH(s) = 9)
OR    (id % 10000 = 0 AND LENGTH(s) = 280000 + 9);

ROLLBACK;
----
expected to succeed but didn't
MAPI  = monetdb@localhost:45519
QUERY = CREATE TABLE foo(id INT NOT NULL, s TEXT);
ERROR = !CREATE TABLE: 'foo' name conflicts
CODE  = 42000
MAPI  = monetdb@localhost:45519
QUERY = COPY BINARY INTO foo(id, s) FROM R'/export/scratch1/home/monet/testing/1bf5d1ec834c-1-1-3/tests/sql/mTests/sql/test/bincopy/bincopy_ints.bin', R'/export/scratch1/home/monet/testing/1bf5d1ec834c-1-1-3/tests/sql/mTests/sql/test/bincopy/bincopy_large_strings.bin' ON SERVER;
ERROR = !Current transaction is aborted (please ROLLBACK)
CODE  = 25005
MAPI  = monetdb@localhost:45519
QUERY = SELECT COUNT(id) FROM foo
        WHERE (id % 10000 <> 0 AND LENGTH(s) = 9)
        OR    (id % 10000 = 0 AND LENGTH(s) = 280000 + 9);
ERROR = !Current transaction is aborted (please ROLLBACK)
CODE  = 25005
Output didn't match.
Expected:
1000000 affected rows
1000000
Got:

Diff:
--- expected
+++ test
@@ -1,2 +0,0 @@
-1000000 affected rows
-1000000