Re: AS clause in 8.0

Thanks, all, for the suggestions.
What I discovered after much confusion is this:

In FreeTDS protocol versions AFTER 4.2, running on PHP5:
(at least in our environment)

this works:
  select sum(kilometers) as my_kilometers ...
but this does not:
  select kilometers as my_kilometers ...  (it returns a column named 
"miles, not my_miles")
however, this does work:
  select rtrim(kilometers) as my_kilometers

It seems that somewhere between FreeTDS and PHP, it is determined that 
if there is no function, then the column name could not possibly need to 
be changed or aliased in the resultset.  Should be easy enough to wrap 
your column name in an rtrim() if you need to alias it.

-Richard






On 03/23/2012 03:17 PM, Krzysztof Chodak wrote:
> Again - check your tds trace. Maybe PHP is somehow rewriting
> (sanitizing) the query on the fly?
>
> On Fri, Mar 23, 2012 at 20:15, Richard Stevens<[email protected]>  wrote:
>> Thank you, Ken, for such a quick reply.
>> I just discovered that this behavior ONLY occurs when querying through PHP5.
>> The same query run from isql (unixODBC's utility) returns the correct
>> column name.
>> Perhaps I should be posting this in a PHP forum - unless someone has
>> seen this before and figured out the solution?
>>
>> -Richard
>>
>> On 03/23/2012 02:30 PM, Ken Collins wrote:
>>> I can verify that this is not the case with both FreeTDS 0.82 or 0.91 using either TDS Version 7.0 or 8.0 with DBLIB.
>>>
>>>    - Ken
>>>
>>> On Mar 23, 2012, at 1:46 PM, Richard Stevens wrote:
>>>
>>>> I am having a (big) problem with FreeTDS 8.0 that I did not have with 7.0.
>>>> The "AS" clause does not work correctly.
>>>> By example, "select apples as oranges from table"  will return a column
>>>> named oranges in 7.0, but returns a column named apples in 8.0.
>>>> Everything else is the same - same machine, OS, etc.  Just changing the
>>>> "tds version = 8.0" in freetds.conf causes the behavior.
>>>>
>>>> Anyone have ideas on a solution?
>>>>
>>>> Thanks,
>>>> Richard
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds