[V4RB 0000103]: length()=0 does not work

[Ruslan Zasukhin]

On 11/13/04 9:05 PM, "vbt at paradigma.ukrcom.kherson.ua"
<vbt at paradigma.ukrcom.kherson.ua> wrote:

> 
> A NOTE has been added to this issue.
> ======================================================================
> <http://paradigma.ukrcom.kherson.ua/bt/view.php?id=103>
> ======================================================================
> Reported By:                Jon Ashwell
> Assigned To:     
> ======================================================================
> Project:                    V4RB
> Issue ID:                   103
> Category:                   SQL
> Reproducibility:            always
> Severity:                   major
> Priority:                   normal
> Status:                     new
> ======================================================================
> Date Submitted:             11-13-2004 20:41 EET
> Last Modified:              11-13-2004 21:05 EET
> ======================================================================
> Summary:                    length()=0 does not work
> Description: 
> 1. Run my project
> 2. New database
> 3. Refs -> SQL/Regex search
> 4. Enter length(title) = 0 -> no matches
> 
> (Note: if the length of the field is non-zero and you do the search for
> that non-zero number, it does find the match correctly).
> ======================================================================
> 
> ----------------------------------------------------------------------
>  Ruslan Zasukhin - 11-13-04 20:55
> ----------------------------------------------------------------------
> It and must not work!
> 
> because if value is NULL then only fld IS NULL can find that record!!!
> 
> ----------------------------------------------------------------------
>  Jon Ashwell - 11-13-04 21:05
> ----------------------------------------------------------------------
> That may be logical to a computer, but not a human. A NULL field is empty,
> right? 

NOT RIGHT, Jon.

NULL is not the same as EMPTY STRING!

NULL is not the same as ZERO for numeric fields!

This is why exists NULL


> But the field exists, right? It's length is 0. If that's a "rule",
> I can live with it of course. But it makes sense to me that Valentina
> should interpret NULL as empty (0) in the appropriate circumstance. Kind
> of like 0 = false and non-zero = true if you apply boolean logic.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------