[BUG, Ivan] Searching for an empty/non-empty field

[Ruslan Zasukhin]

On 11/11/04 9:30 PM, "jda" <jda at his.com> wrote:

> I tried this three times just now, each time it crashed:
> 
> 1. Make a new db
> 2. SELECT * from thereferences WHERE title = NULL

Jon,

Actually correct syntax is
    SELECT * from thereferences WHERE title IS NULL


Ivan, please add to our VSQL_Test_User_Errors group this query
    SELECT * from thereferences WHERE title = NULL

Make sure it not crashes but return error.
It will be cool if it will return

    "It is not correct to use = NULL. You must to use IS NULL."

:-)



> Crash log:
> 
> Thread 0 Crashed:
> 0   Kernel_Carbon_Debug.shlb       0x0206ffb8
> CastValueType__Q23fbl9Field_ImpCFQ23fbl26smart_ptr<CQ23fbl7I_Value> +
> 0x48
> 1   Kernel_Carbon_Debug.shlb       0x02069584
> Find__Q23fbl9Field_ImpCFQ23fbl26smart_ptr<CQ23fbl7I_Value>Q23fbl25smart_ptr<CQ
> 23fbl6BitSet> 
> + 0x40
> 2   Kernel_Carbon_Debug.shlb       0x02369a58
> Execute__Q23fbl17PNode_Field_ValueFQ23fbl24smart_ptr<Q23fbl6BitSet> +
> 0x58
> 3   Kernel_Carbon_Debug.shlb       0x0228434c
> Execute__Q23fbl4PlanFv + 0x4c
> 4   Kernel_Carbon_Debug.shlb       0x02215c10
> Execute__Q23fbl5QueryFv + 0x7c
> 5   Kernel_Carbon_Debug.shlb       0x0227b234
> Refresh__Q23fbl14Table_IndirectFv + 0x1d0
> 6   Kernel_Carbon_Debug.shlb       0x0227af78
> put_Where__Q23fbl14Table_IndirectFQ23fbl25smart_ptr<Q23fbl7I_ENode> +

-- 
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
-------------------------------------------------------------