23 lines
550 B
Text
23 lines
550 B
Text
# All SQL syntaxes that result in storing a variable-length binary.
|
|
|
|
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a BYTEA);
|
|
|
|
query TT rowsort
|
|
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto' ORDER BY column_name;
|
|
----
|
|
a BinaryView
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable VALUES (X'010203');
|
|
|
|
query ? rowsort
|
|
SELECT * FROM kanto.myschema.mytable;
|
|
----
|
|
X'010203'
|
|
|
|
# Verify that we didn't accidentally store the escaped string.
|
|
query I
|
|
SELECT length(a) FROM kanto.myschema.mytable;
|
|
----
|
|
3
|