Create table converts boolean into varchar

[vicenrico]

Hello, i get this problem in h2 database. When i use boolean field, It converts It to varchar. How can that be possible.?

I,.e. boolean SEEN
When i look generated table, i see it's varchar

Thanks in avance.

[ccleve]

I'm not sure -- haven't tested H2 in a while. But I've started to get away from using createTable() in my own code. It's better to just use straight sql: db.sql("CREATE TABLE foo (col1 boolean, col2 varchar)").execute();

[lululombard]

Just encountered this issue too

[lululombard]

This condition seems to be flipped, or is it me?

norm/src/main/java/com/dieselpoint/norm/sqlmakers/StandardSqlMaker.java

Line 208 in 1b21dbb

if (columnAnnot.columnDefinition() == null) {

If it wasn't, @Column(name = "my_bool_field", columnDefinition = "my_bool_field tinyint default 0") would probably work.