Hi, I'm using the 64 bit windows Jan'14 release (v11.17.9 "Jan2014"). I wanted to confirm the following behavior is a bug before I reported it (this is from the mclient terminal): sql>CREATE TABLE test (a int); operation successful (5.230ms) sql>SELECT a AS "#" FROM test; +--+ | | +==+ +--+ 0 tuples (3.320ms) In contrast: sql>SELECT a AS "@" FROM test; +---+ | @ | +===+ +---+ 0 tuples (1.672ms) When there's data in the table, all the *results* are fine, it's just the field names which are wonky. Loosely, it looks like the first alias (I have not tried making columns with '#' in the name, so maybe there too?) to use '#' basically blanks out its and all following column names in the result set--so even if I'm missing something w/r/t escaping "#", it doesn't' seem right that all following columns should also be blank... Thanks, Ed
participants (1)
-
Clarkson, Edward C.