ORMLite uniqueCombo with null-value

Question

Can a uniqueCombo identify a field when one or more fields of this combo are null?

class Entity {
    @DatabaseField(columnName = "fieldA", canBeNull = true, uniqueCombo = true)
    private String fieldA;

    @DatabaseField(columnName = "fieldB", canBeNull = true, uniqueCombo = true)
    private String fieldB;
}

If there was a record in table Entity where fieldA is 'John'and fieldB is null, would querying this result in 1 record?

dao.queryForFirst(
    dao.queryBuilder().
        where().
            eq("fieldA", "John").
        and().
            eq("fieldB", null).
        prepare());

score 0 · Accepted Answer · edited May 23 '17 at 10:26

0

Ok, this seems to be tied to the DB engine. When using MySQL, it is handeled by the rules the selected MySQL engine dicates.

This answer was very helpful

edited May 23 '17 at 10:26

Community

1
1

answered May 09 '14 at 05:39

John Smith

752
9
35

ORMLite uniqueCombo with null-value

1 Answers1