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