incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From exxos <hat...@gmail.com>
Subject Unconsistent SQL generation ?
Date Mon, 16 Aug 2010 12:23:52 GMT
Hello,

I noticed something probably not correct:

When you execute the following:

DBCommand cmd = db.createCommand();
cmd.set(db.tab.col.to(""));

You get the SQL below

INSERT INTO tab (col) VALUES (null);

whereas it is expected

INSERT INTO tab (col) VALUES ("");

In the table defintion there is:
col = addColumn("col", DataType.TEXT, 80, true);

Could you please advise why  you get "null" instead of empty "" ?

Regards,
exxos.

Mime
View raw message