github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/notice (about)

     1  # LogicTest: local
     2  
     3  # Test multiple notices all display at once.
     4  query T noticetrace
     5  SELECT crdb_internal.notice('hi'), crdb_internal.notice('i am....'), crdb_internal.notice('otan!!!')
     6  ----
     7  NOTICE: hi
     8  NOTICE: i am....
     9  NOTICE: otan!!!
    10  
    11  subtest test_notice_severity
    12  
    13  query T noticetrace
    14  SELECT crdb_internal.notice('debug1', 'do not see this'), crdb_internal.notice('warning', 'but you see this'), crdb_internal.notice('debug2', 'and never this')
    15  ----
    16  WARNING: but you see this
    17  
    18  statement ok
    19  SET client_min_messages = 'debug1'
    20  
    21  query T noticetrace
    22  SELECT crdb_internal.notice('debug1', 'now you see this'), crdb_internal.notice('warning', 'and you see this'), crdb_internal.notice('debug2', 'and never this')
    23  ----
    24  DEBUG1: now you see this
    25  WARNING: and you see this