Skip to Content.
Sympa Menu

freetds - Re: [freetds] AS clause in 8.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Richard Stevens <bitwizard AT skybest.com>
  • To: Krzysztof Chodak <krzysztof.chodak AT gmail.com>
  • Cc: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] AS clause in 8.0
  • Date: Tue, 27 Mar 2012 16:55:09 -0400

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<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




Archive powered by MHonArc 2.6.24.

Top of Page