github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/cmd/smithcmp/vec.toml (about)

     1  # This test compares vectorized execution on vs off results.
     2  
     3  initsql = """
     4  DROP TABLE IF EXISTS tab_orig;
     5  
     6  CREATE TABLE IF NOT EXISTS tab_orig AS
     7  	SELECT
     8  		g::INT8 AS _int8,
     9  		g::FLOAT8 AS _float8,
    10  		'2001-01-01'::DATE + g AS _date,
    11  		g % 2 = 1 AS _bool,
    12  		g::DECIMAL AS _decimal,
    13  		g::STRING AS _string,
    14  		g::STRING::BYTES AS _bytes
    15  	FROM
    16  		generate_series(1, 5) AS g;
    17  
    18  SET statement_timeout = '9s';
    19  """
    20  smither = "cockroach"
    21  seed = 0
    22  #postgres = true
    23  
    24  [databases.cockroach]
    25  addr = "postgresql://root@localhost:26257?sslmode=disable"
    26  allowmutations = true
    27  initsql = """
    28  set vectorize=off;
    29  """
    30  
    31  [databases.vec]
    32  addr = "postgresql://root@localhost:26257?sslmode=disable"
    33  allowmutations = true
    34  initsql = """
    35  set vectorize=on;
    36  """