default value caused data missing

[elvizlai]

sorry，the title should be default value caused data missing

1、using goleveldb
2、a column name Pv defined as ``pv BIGINT(20) NULL DEFAULT 1
3、it insert succeed
4、restart db，all data inserted are missing

[ngaut]

Thanks for your report, @elvizlai
Any more details ?

[elvizlai]

@ngaut sorry, i mis-touched my ''Enter" key.

testing code:

package main
import (
    _ "github.com/pingcap/tidb"
    _ "github.com/go-xorm/tidb"
    "github.com/go-xorm/xorm"
    "fmt"
)

type A struct {
    Id   int
    Name string
    Pv   int `xorm:"default 1"`
}

type B struct {
    Id   int
    Name string
    Pv   int64 `xorm:"default 1"`
}

func main() {
    engine, err := xorm.NewEngine("tidb", "goleveldb://test/tidb")
    if err != nil {
        panic(err)
    }
    //create table
    engine.Sync2(new(A),new(B))

    //query data
    fmt.Println("-------begin query------")
    //should be 0 if the first run---but every time you run the code, it all 0 or 1(very strange)
    fmt.Println(engine.Count(new(A)))
    fmt.Println(engine.Count(new(B)))
    //adding data

    fmt.Println("-------adding data------")
    a := &A{Name:"ElvizLai"}
    b := &B{Name:"ElvizLai"}
    fmt.Println(engine.InsertOne(a))
    fmt.Println(engine.InsertOne(b))
}

[ngaut]

Have you commit your transaction ?

[elvizlai]

@ngaut @disksing am i missed something？

reading tidb log and found out engine.InsertOne can only autocommit when db created. It will not autocommit when the table already exist. Should use session to commit instead. It is not a TiDB bug, so I'll close this iuuse.

[shenli]

@elvizlai I tested your code with and then check the db with interpreter tool(mv data dir to interpreter dir and start interpreter).
The data is ready in the db.
tidb> select * from a;
+----+----------+----+
| id | name | pv |
+----+----------+----+
| 0 | ElvizLai | 0 |
+----+----------+----+
1 row in set (0.00 sec)
tidb> select * from b;
+----+----------+----+
| id | name | pv |
+----+----------+----+
| 0 | ElvizLai | 0 |
+----+----------+----+
1 row in set (0.00 sec)

[elvizlai]

@shenli you are right. It seems that engine.InsertOne autocommit not work when db already exist.(U can run that code twice, but only one line data inserted). I tried using session to commit, and it succeed. I not very sure what caused this issue.