github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/niltable (about) 1 exec 2 CREATE TABLE `niltable` ( 3 `i` bigint NOT NULL, 4 `i2` bigint, 5 `b` tinyint, 6 `f` double, 7 PRIMARY KEY (`i`) 8 ) 9 ---- 10 11 exec 12 insert into niltable values 13 (1,null,null,null), 14 (2,2,1,null), 15 (3,null,0,null), 16 (4,4,null,4.0), 17 (5,null,1,5.0), 18 (6,6,0,6.0) 19 ---- 20 21 exec 22 create index niltable_i2 on niltable (i2) 23 ----