github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/annotate (about)

     1  # Type annotation expressions.
     2  
     3  eval
     4  ANNOTATE_TYPE('s', string)
     5  ----
     6  's'
     7  
     8  eval
     9  ANNOTATE_TYPE('s', bytes)
    10  ----
    11  '\x73'
    12  
    13  eval
    14  ANNOTATE_TYPE('2010-09-28', date)
    15  ----
    16  '2010-09-28'
    17  
    18  eval
    19  ANNOTATE_TYPE('12:00:00', time)
    20  ----
    21  '12:00:00'
    22  
    23  eval
    24  ANNOTATE_TYPE('PT12H2M', interval)
    25  ----
    26  '12:02:00'
    27  
    28  eval
    29  ANNOTATE_TYPE('2 02:12', interval)
    30  ----
    31  '2 days 02:12:00'
    32  
    33  eval
    34  ANNOTATE_TYPE('2 02:12:34', interval)
    35  ----
    36  '2 days 02:12:34'
    37  
    38  eval
    39  ANNOTATE_TYPE('1-2 02:12', interval)
    40  ----
    41  '1 year 2 mons 02:12:00'
    42  
    43  eval
    44  ANNOTATE_TYPE('2010-09-28', timestamp)
    45  ----
    46  '2010-09-28 00:00:00+00:00'
    47  
    48  eval
    49  ANNOTATE_TYPE('2010-09-28', timestamptz)
    50  ----
    51  '2010-09-28 00:00:00+00:00'
    52  
    53  eval
    54  ANNOTATE_TYPE(123, int) + 1
    55  ----
    56  124
    57  
    58  eval
    59  ANNOTATE_TYPE(123, float) + 1
    60  ----
    61  124.0
    62  
    63  eval
    64  ANNOTATE_TYPE(123, decimal) + 1
    65  ----
    66  124
    67  
    68  eval
    69  ANNOTATE_TYPE(123.5, float) + 1
    70  ----
    71  124.5
    72  
    73  eval
    74  ANNOTATE_TYPE(123.5, decimal) + 1
    75  ----
    76  124.5
    77  
    78  eval
    79  ANNOTATE_TYPE(NULL, int)
    80  ----
    81  NULL
    82  
    83  eval
    84  ANNOTATE_TYPE(NULL, string)
    85  ----
    86  NULL
    87  
    88  eval
    89  ANNOTATE_TYPE(NULL, timestamp)
    90  ----
    91  NULL
    92  
    93  # Shorthand type annotation notation.
    94  
    95  eval
    96  123:::int + 1
    97  ----
    98  124
    99  
   100  eval
   101  123:::float + 1
   102  ----
   103  124.0
   104  
   105  eval
   106  (123 + 1):::int
   107  ----
   108  124
   109  
   110  eval
   111  (123 + 1):::float
   112  ----
   113  124.0
   114  
   115  eval
   116  ANNOTATE_TYPE('12:00:00-01', timetz)
   117  ----
   118  '12:00:00-01:00:00'