Incorrect SQL when item load clause contains NULL

2 views
Skip to first unread message

Alexander Obuhovich

unread,
Nov 27, 2011, 2:13:20 PM11/27/11
to In-Portal Bugs
There are multiple ways to load record information from database:
  1. by specifying Primary Keys value
  2. by specifying value of a given field
  3. by specifying a hash of field-value pairs that all must match for a loaded item
It all works until the value, used to load an item is set to NULL instead of string or number as usual.



Ready for testing.


--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com
null_dbitem_load_fix.patch

Dmitry A.

unread,
Dec 1, 2011, 10:54:06 PM12/1/11
to in-port...@googlegroups.com
Is there really a case when we need that to be NULL?


DA

Alexander Obuhovich

unread,
Dec 2, 2011, 3:21:28 AM12/2/11
to in-port...@googlegroups.com
Nope.


On Fri, Dec 2, 2011 at 5:54 AM, Dmitry A. <dand...@gmail.com> wrote:
Is there really a case when we need that to be NULL?


DA

--
You received this message because you are subscribed to the Google Groups "In-Portal Bugs Team" group.
To view this discussion on the web visit https://groups.google.com/d/msg/in-portal-bugs/-/Bt8kZyMlCEAJ.
To post to this group, send email to in-port...@googlegroups.com.
To unsubscribe from this group, send email to in-portal-bug...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/in-portal-bugs?hl=en.
Reply all
Reply to author
Forward
0 new messages