[freetds] AS clause in 8.0

Randy Syring rsyring at gmail.com
Fri Mar 23 15:55:44 EDT 2012


Instructions on creating a TDS trace:

http://www.freetds.org/userguide/logging.htm

---------------------------------------------
Randy Syring
Development&  Executive Director
Level 12 Technologies  <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913

Principled People, Technology that Works


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<bitwizard at skybest.com>  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
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list