pingcap / go-randgen Goto Github PK

mysql> desc t1;
+-------+---------+------+------+---------+-------+
| Field | Type    | Null | Key  | Default | Extra |
+-------+---------+------+------+---------+-------+
| a     | int(11) | YES  |      | NULL    |       |
+-------+---------+------+------+---------+-------+
1 row in set (0.00 sec)

mysql> desc t2;
+-------+---------+------+------+---------+-------+
| Field | Type    | Null | Key  | Default | Extra |
+-------+---------+------+------+---------+-------+
| b     | int(11) | YES  |      | NULL    |       |
+-------+---------+------+------+---------+-------+
1 row in set (0.00 sec)

--- SELECT `a` FROM t2; // wrong
--- SELECT `a` FROM t1 WHERE `a` > 7; // correct

$ cd go-randgen && make all

gendata/generators/letter.go:7: conversion from int to string yields a string of one rune, not a string of digits (did you mean fmt.Sprint(x)?)

ubuntu@VM-0-15-ubuntu:~/go-randgen$ go version
go version go1.15 linux/amd64

go get -u  github.com/pingcap/go-randgen/cmd/go-randgen

# github.com/pingcap/go-randgen/grammar/sql_generator
../go/src/github.com/pingcap/go-randgen/grammar/sql_generator/sql_generator.go:330:86: undefined: io.StringWriter

update_select:{table = _table()}
    BEIGIN ; UPDATE {print(table)}  ; SELECT {print(table)} ; ROLLBACK

zhangys@xxx:~/go/bin$ ./go-randgen gensql -Y ../src/github.com/pingcap/go-randgen/examples/functions.yy   --dsn "root:@tcp(127.0.0.1:3000)/test" -Q 50
2020/07/08 07:07:50 Cache database meta info...
2020/07/08 07:07:50 Cache database meta info ok, start generate sqls by yy
2020/07/08 07:07:50 load yy from ../src/github.com/pingcap/go-randgen/examples/functions.yy
2020/07/08 07:07:50 Fatal Error: there is no int fields