The current version of the 4.6.0 code passes an integer value to a boolean comparison, which isn't valid. MySQL will ignore that and automatically cast to bool, but Postgres will not. The attached patch fixes this.

CommentFileSizeAuthor
#2 taxonomy_dhtml_bool.patch1.32 KBZed Pobre
taxonomy_dhtml_boolean.patch773 bytesZed Pobre

Comments

moshe weitzman’s picture

moshe weitzman commented

can anyone confirm that mysql doesn't compain about this?

Zed Pobre’s picture

Zed Pobre commented
Version: 4.6.x-1.x-dev » 4.7.x-1.x-dev
StatusFileSize
new taxonomy_dhtml_bool.patch1.32 KB

Well, this bug is still there, and I found a new location as well which actually has to be solved by an explicit cast. New patch attached which corrects both.

meba’s picture

meba commented
Status: Needs review » Fixed

That CAST() is not working in MySQL. But "WHERE true" works everywhere i think. However, this will be fixed in 5.x-2.x release

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)