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
