Your numerical workaround seems to work for me. I was curious as to
what the simplest expression might be and found that I didn't even
have to reference a column...'42 + 0' was enough, but it needs parens:
SELECT a, b, (42 + 0) As c
I think I can avoid or otherwise workaround using string constants.
Thanks again!
On Thu, Aug 30, 2012 at 9:08 AM, K. John Wu <[email protected]> wrote:
> Huhh, sounds interesting.
>
> You probably can fake the numerical constant expression with something
> like
>
> SELECT a, b, 42 + 0*a As c
>
> The string version is going to be a little harder, we will have to
> think about it a little. Hope you have some reasonable work-around
> for these constant expressions in the meantime.
>
> John
>
>
>
> On 8/30/12 6:12 AM, Michael Beauregard wrote:
>> There are various places that my application relies upon selecting
>> constants as columns, such as:
>>
>> SELECT a, b, 42 AS c
>>
>> or
>>
>> SELECT a, b, "String" AS c
>>
>> However Fastbit doesn't seem to support this. Both of those queries
>> execute, but the results do not contain the 'c' column in the results.
>> The string version also issues the following warning:
>>
>> Warning -- ibis::selectParser encountered syntax error, unexpected
>> $undefined, expecting end of input at location a, b, "string" AS
>> c:1.6-7
>>
>> Is it possible to support this feature in the future?
>>
>> Thanks,
>>
>> Michael
>> _______________________________________________
>> 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
