github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/floattable (about)

     1  exec
     2  CREATE TABLE `floattable` (
     3    `i` bigint NOT NULL,
     4    `f32` float NOT NULL,
     5    `f64` double NOT NULL,
     6    PRIMARY KEY (`i`)
     7  )
     8  ----
     9  
    10  exec
    11  insert into floattable values
    12      (1, 1.0, 1.0),
    13      (2, 1.5, 1.5),
    14      (3, 2.0, 2.0),
    15      (4, 2.5, 2.5),
    16      (-1, -1.0, -1.0),
    17      (-2, -1.5, -1.5)
    18  ----
    19  
    20  exec
    21  create index floattable_f on floattable (f64)
    22  ----