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
|
# name: test/sql/copy/copy_blob.test
# group: [copy]
statement error
COPY (select 'foo') TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
----
Binder Error: "COPY (FORMAT BLOB)" only supports a single BLOB column
statement error
COPY (select 'foo'::BLOB, 10) TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
----
Binder Error: "COPY (FORMAT BLOB)" only supports a single BLOB column
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob' (FORMAT BLOB);
query III
select filename LIKE '%test.blob', content, size from read_blob('__TEST_DIR__/test.blob');
----
true foo 3
statement error
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob.gz' (FORMAT BLOB, ASDFGH);
----
Binder Error: Unrecognized option for COPY (FORMAT BLOB): "ASDFGH"
# With compression
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test.blob.gz' (FORMAT BLOB);
query II
select filename LIKE '%test.blob.gz', size from read_blob('__TEST_DIR__/test.blob.gz');
----
true 26
# With explicit compression
statement ok
COPY (select 'foo'::BLOB) TO '__TEST_DIR__/test2.blob' (FORMAT BLOB, COMPRESSION 'GZIP');
query II
select filename LIKE '%test2.blob', size from read_blob('__TEST_DIR__/test2.blob');
----
true 26
|
