github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/bytes (about) 1 query T 2 SHOW bytea_output 3 ---- 4 hex 5 6 query T 7 SELECT 'non-escaped-string':::BYTES::STRING 8 ---- 9 \x6e6f6e2d657363617065642d737472696e67 10 11 query T 12 SELECT '\Xabcd':::BYTES::STRING 13 ---- 14 \xabcd 15 16 query T 17 SELECT b'\x5c\x78':::BYTES 18 ---- 19 \x 20 21 query T 22 SELECT b'\x5c\x78':::BYTES::STRING 23 ---- 24 \x5c78 25 26 query T 27 SELECT b'\x5c\x58':::BYTES::STRING 28 ---- 29 \x5c58 30 31 query T 32 SELECT e'\x5c\x78'::STRING 33 ---- 34 \x 35 36 query T 37 SELECT '\X':::BYTES::STRING 38 ---- 39 \x 40 41 query T 42 SELECT e'a\\134b\nc\'e'::STRING::BYTES::STRING 43 ---- 44 \x615c620a632765 45 46 47 query T 48 SELECT '日本語':::STRING::BYTES::STRING 49 ---- 50 \xe697a5e69cace8aa9e 51 52 query error invalid bytea escape sequence 53 SELECT '\400'::bytea 54 55 statement ok 56 SET bytea_output = escape 57 58 query T 59 SELECT 'non-escaped-string':::BYTES::STRING 60 ---- 61 non-escaped-string 62 63 query T 64 SELECT '\Xabcd':::BYTES::STRING 65 ---- 66 \253\315 67 68 query T 69 SELECT b'\x5c\x78':::BYTES 70 ---- 71 \x 72 73 query T 74 SELECT b'\x5c\x78':::BYTES::STRING 75 ---- 76 \\x 77 78 query T 79 SELECT b'\x5c\x58':::BYTES::STRING 80 ---- 81 \\X 82 83 query T 84 SELECT e'\x5c\x78'::STRING 85 ---- 86 \x 87 88 query T 89 SELECT '\X':::BYTES::STRING 90 ---- 91 · 92 93 query T 94 SELECT e'a\\134b\nc\'e'::STRING::BYTES::STRING 95 ---- 96 a\\b\012c'e 97 98 query T 99 SELECT '日本語':::STRING::BYTES::STRING 100 ---- 101 \346\227\245\346\234\254\350\252\236 102 103 subtest Regression_25841 104 105 statement ok 106 set bytea_output = hex 107 108 query T 109 SELECT e'a\\\\b'::STRING::BYTEA 110 ---- 111 a\b 112 113 query I 114 SELECT length(e'a\\\\b'::STRING::BYTEA) 115 ---- 116 3 117 118 query error invalid bytea escape sequence 119 SELECT e'a\\bcde'::STRING::BYTEA 120 121 query error bytea encoded value ends with incomplete escape sequence 122 SELECT e'a\\01'::STRING::BYTEA 123 124 subtest Regression_27950 125 126 statement ok 127 set bytea_output = hex 128 129 statement ok 130 CREATE TABLE t(b BYTES); INSERT INTO t(b) VALUES ('\xe697a5e69cace8aa9e'::BYTES) 131 132 query TT 133 SELECT b, b::STRING FROM t 134 ---- 135 日本語 \xe697a5e69cace8aa9e 136 137 statement ok 138 set bytea_output = escape 139 140 query TT 141 SELECT b, b::STRING FROM t 142 ---- 143 日本語 \346\227\245\346\234\254\350\252\236 144 145 statement ok 146 DROP TABLE t