Null and concat

[Bart Pietercil]

On 5-okt-07, at 15:20, Thorsten Hohage wrote:

> Hi Nobody,

:-)

>
> On 2007-10-05, at 14:55, Bart Pietercil wrote:
>
>> Hi Thorsten,
>> On 5-okt-07, at 14:38, Thorsten Hohage wrote:
>>
>>> Hi Bart,
>>>
>>> On 2007-10-05, at 14:03, Bart Pietercil wrote:
>>>
>>>> SELECT CONCAT('Va’, NULL, ‘na’);
>>>>
>>>> crashes VStudio
>>>
>>> no - I got a "unexpected token NULL"
>>>
>>>> SELECT CONCAT('Va’, NULL)
>>>> I get unexpected token NULL.
>>>
>>> same here and IMHO this is ok, because NOBODY would type a  
>>> constant NULL in a concat statement.
>>>
>>
>>
>> call me NOBODY
> done!
>
> but ...
>
>> ... Since objptr_organisation can be NULL my... (but mind you  
>> objptr_organisation is NULL, so unique_name_organisation is also  
>> NULL)
>
> you didn't TYPE "concat(..., NULL, ...)" as a constant! Of course  
> some rows, or variables, or results, ... could be NULL but that's  
> different, from what I've written. I didn't said anything about a  
> value being NULL, only about a constant "NULL".
>

Okay, it is a distinction, I give you that. But problem remains and  
that is worse.

I don't see another way of setting up compounded unique indexes and  
the way I set it up is failing miserably.


Bart