Hi, Alexandre,
The main difference between "Inhibitor IN ('Imatinib')" and "Inhibitor
= 'Imatinib'" is that the right-hand side is recognized as a string
literal while second is considered to be either a column name or a
string literal. Sounds like we should recognize quoted strings as a
string literals, what do you think?
In this particular case, if 'Imatinib' is recognized as a string
literal then FastBit will not attempt to see if it is also a column
name. It would solve your problem -- it is probably a more natural
way to solve your problem too ;-)
John
On 11/19/2009 3:47 AM, Alexandre Maurel wrote:
> Hi John,
>
> I came back to the original column name , and I have changed the
> previous query into :
>
> select Inhibitor,Barcode,Row,Col,Sample_name where ( ( !
> (Inhibitor IN ('DMSO') AND Barcode IN ('105006101') AND Row = 1 AND Col
> = 1 AND Sample_name IN ('PA97'))) AND ( !(Inhibitor IN ('Imatinib') AND
> Barcode IN ('105006101') AND Row = 4 AND Col = 4 AND Sample_name IN
> ('FP83'))))
>
> replacing "=" (in the case of category) by the key word IN .
>
> It's working :).
>
> Is there any other way to solve such problem ?
>
> Regards,
>
> Alexandre
>
> Alexandre Maurel a écrit :
>> Hi John,
>>
>> I found the problem, there is a column named Imatinib which is also a
>> value of the column Inhibitor !
>> I have rename the column Imatinib into Imatinib2 and the problem is gone.
>>
>> Regards,
>>
>> Alexandre
>>
>>
>> Alexandre Maurel a écrit :
>>> Hi John,
>>>
>>> As attachment document , you will find the data and the logs from ibis.
>>> In the log file I have highlighted the problem.
>>>
>>> Imatinib, 105006101, 4, 4, FP83, 6 error , this row should not
>>> be there ( ! (Inhibitor = 'Imatinib' AND Barcode = '105006101' AND
>>> Row = 4 AND Col = 4 AND Sample_name = 'FP83'))
>>>
>>> Note , I have run the following queries which are identical, and they
>>> give the same error.
>>>
>>> select Inhibitor,Barcode,Row,Col,Sample_name where ( ( ! (Inhibitor =
>>> 'DMSO' AND Barcode = '105006101' AND Row = 1 AND Col = 1 AND
>>> Sample_name = 'PA97')) AND ( ! (Inhibitor = 'Imatinib' AND Barcode =
>>> '105006101' AND Row = 4 AND Col = 4 AND Sample_name = 'FP83')))
>>>
>>> select Inhibitor,Barcode,Row,Col,Sample_name where ((Inhibitor !=
>>> 'DMSO' OR Barcode != '105006101' OR Row != 1 OR Col != 1 OR
>>> Sample_name != 'PA97') AND (Inhibitor != 'Imatinib' OR Barcode !=
>>> '105006101' OR Row != 4 OR Col != 4 OR Sample_name != 'FP83'))
>>>
>>> Regards,
>>>
>>> Alexandre
>>>
>>> [email protected] a écrit :
>>>> Send FastBit-users mailing list submissions to
>>>> [email protected]
>>>>
>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>>>> or, via email, send a message with subject or body 'help' to
>>>> [email protected]
>>>>
>>>> You can reach the person managing the list at
>>>> [email protected]
>>>>
>>>> When replying, please edit your Subject line so it is more specific
>>>> than "Re: Contents of FastBit-users digest..."
>>>>
>>>>
>>>> Today's Topics:
>>>>
>>>> 1. Re: bundle segment method reorder the raw data (Alexandre Maurel)
>>>>
>>>>
>>>> ----------------------------------------------------------------------
>>>>
>>>> Message: 1
>>>> Date: Wed, 18 Nov 2009 09:54:37 +0100
>>>> From: Alexandre Maurel <[email protected]>
>>>> Subject: Re: [FastBit-users] bundle segment method reorder the raw
>>>> data
>>>> To: [email protected]
>>>> Message-ID: <[email protected]>
>>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>>>
>>>> Hi John,
>>>>
>>>> Problem is solved ,
>>>>
>>>> Thanks,
>>>>
>>>> Alexandre
>>>>
>>>> [email protected] a ?crit :
>>>>
>>>>> Send FastBit-users mailing list submissions to
>>>>> [email protected]
>>>>>
>>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>>>>> or, via email, send a message with subject or body 'help' to
>>>>> [email protected]
>>>>>
>>>>> You can reach the person managing the list at
>>>>> [email protected]
>>>>>
>>>>> When replying, please edit your Subject line so it is more specific
>>>>> than "Re: Contents of FastBit-users digest..."
>>>>>
>>>>>
>>>>> Today's Topics:
>>>>>
>>>>> 1. Re: bundle segment method reorder the raw data (K. John Wu)
>>>>>
>>>>>
>>>>> ----------------------------------------------------------------------
>>>>>
>>>>> Message: 1
>>>>> Date: Mon, 16 Nov 2009 17:25:27 -0800
>>>>> From: "K. John Wu" <[email protected]>
>>>>> Subject: Re: [FastBit-users] bundle segment method reorder the raw
>>>>> data
>>>>> To: FastBit Users <[email protected]>
>>>>> Message-ID: <[email protected]>
>>>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>>>>
>>>>> Hi, Alexandre,
>>>>>
>>>>> I have implemented some changes that I think will address the
>>>>> problem you've encountered. The code has been checked in to SVN.
>>>>> If you get the chance, please give the nightly snapshot a try and
>>>>> let us know if it does address the problem.
>>>>>
>>>>> The nightly snapshot is available at
>>>>> <https://codeforge.lbl.gov/snapshots.php?group_id=44>. You might
>>>>> have to wait till the new snapshot is built during the middle of
>>>>> the night pacific time.
>>>>>
>>>>> John
>>>>>
>>>>>
>>>>> On 11/16/2009 1:24 AM, Alexandre Maurel wrote:
>>>>>
>>>>>> Hi John,
>>>>>>
>>>>>> I think I found a problem in function ibis::column::selectValuesT.
>>>>>> When a query does not specify a where clause or when mask.cnt() ==
>>>>>> mask.size(), the method ibis::column::selectValuesT return a
>>>>>> pointer on raw data ...
>>>>>> Which cause the bundle segment method to reorder the raw data !
>>>>>>
>>>>>> template <typename T>
>>>>>> long ibis::column::selectValuesT(const bitvector& mask,
>>>>>> ibis::array_t<T>& vals) const {
>>>>>> ...
>>>>>> ...
>>>>>> if (mask.cnt() == mask.size())
>>>>>> return getValuesArray(&vals);
>>>>>> ...
>>>>>> ...
>>>>>> if (tot == mask.size()) { // read all values
>>>>>> ierr = ibis::fileManager::instance().getFile(dfn, vals);
>>>>>> return ierr;
>>>>>> }
>>>>>>
>>>>>> }
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Alexandre
>>>>>> _______________________________________________
>>>>>> FastBit-users mailing list
>>>>>> [email protected]
>>>>>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>>>>>>
>>>>> ------------------------------
>>>>>
>>>>> _______________________________________________
>>>>> FastBit-users mailing list
>>>>> [email protected]
>>>>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>>>>>
>>>>>
>>>>> End of FastBit-users Digest, Vol 27, Issue 15
>>>>> *********************************************
>>>>>
>>>>>
>>>>
>>>> ------------------------------
>>>>
>>>> _______________________________________________
>>>> FastBit-users mailing list
>>>> [email protected]
>>>> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
>>>>
>>>>
>>>> End of FastBit-users Digest, Vol 27, Issue 16
>>>> *********************************************
>>>>
>>>>
> _______________________________________________
> FastBit-users mailing list
> [email protected]
> https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
