create_data.stmts 778 字节
Newer Older
F
freemine 已提交
1 2 3
#P: positive sample
#N: negative sample

F
freemine 已提交
4 5 6 7 8
P:drop database if exists m;
P:create database m;
P:use m;

P:drop table if exists t;
F
freemine 已提交
9 10 11
P:create table t (ts timestamp, b bool, v1 tinyint, v2 smallint, v4 int, v8 bigint, f4 float, f8 double, blob binary(3), name nchar(1), ts2 nchar(148));
#P:insert into t (ts, blob, name) values('2020-10-10 00:00:00',     0,      1);
#P:insert into t (ts, blob, name) values('2020-10-10 00:00:00.001', 1,      2);
F
freemine 已提交
12 13 14
P:insert into t (ts, blob, name) values('2020-10-10 00:00:00.002', '你',   '好');
P:insert into t (ts, blob, name) values('2020-10-10 00:00:00.003', 'abc',  'd');
P:select * from t;
F
freemine 已提交
15 16
P:create table v (ts timestamp, b bool, v1 tinyint, v2 smallint, v4 int, v8 bigint, f4 float, f8 double, blob binary(3), name nchar(1), ts2 nchar(23));

F
freemine 已提交
17