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

     1  statement ok
     2  CREATE TABLE t (
     3    a INT PRIMARY KEY,
     4    b STRING COLLATE en
     5  )
     6  
     7  statement ok
     8  INSERT INTO t VALUES (1, 'foo' COLLATE en), (2, NULL), (3, 'bar' COLLATE en)
     9  
    10  statement ok
    11  CREATE INDEX ON t (b, a)
    12  
    13  # Test that unspecifying b is like specifying NULL.
    14  statement ok
    15  INSERT INTO t (a) VALUES(4)
    16  
    17  statement ok
    18  INSERT INTO t VALUES(5)
    19  
    20  query T
    21  SELECT b FROM t ORDER BY b
    22  ----
    23  NULL
    24  NULL
    25  NULL
    26  bar
    27  foo