Why does MySQL report an error when using bool

[go-ltbf]

Your Question

// definition
// ...
Visible   bool `json:"visible" gorm:"column:visible"`
Shareable bool `json:"shareable" gorm:"column:shareable"`
// ...

problem, err := p.Where(p.Visible.Is(true)).Where(p.ID.Eq(id)).First()

err:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? AND `problem`.`id` = ? ORDER BY `problem`.`id` LIMIT 1' at line 1

debug sql:

SELECT * FROM `problem` WHERE `problem`.`visible` IS true AND `problem`.`id` = 1 ORDER BY `problem`.`id` LIMIT 1

I use this sql in cli is ok.

Expected answer

How to use bool type in query?

[go-ltbf]

If I delete p.Visible.Is(true), no error will be reported

[go-ltbf]

I found

var user User
db.Debug().Where("`users`.`status` IS true").First(&user, 1)

is ok.

but

var user User
db.Debug().Where("`users`.`status` IS ?", true).First(&user, 1)

will report err

[tr1v3r]

yeah,

Where("`users`.`status` = ?", true)

is ok, too. I will fix it ASAP

[tr1v3r]

fix commit: 84b7f5d