Debian Bug report logs -
#502174
select AS with php5-odbc
Reported by: Eric Meygret <Eric.Meygret@Free.fr>
Date: Tue, 14 Oct 2008 08:36:08 UTC
Severity: normal
Found in version php5/5.2.5-3+lenny2
Fixed in version 5.3.3-7
Done: Ondřej Surý <ondrej@sury.org>
Bug is archived. No further changes may be made.
Toggle useless messages
Report forwarded
to debian-bugs-dist@lists.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#502174; Package php5-odbc.
(Tue, 14 Oct 2008 08:36:10 GMT) (full text, mbox, link).
Acknowledgement sent
to Eric Meygret <Eric.Meygret@Free.fr>:
New Bug report received and forwarded. Copy sent to Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
(Tue, 14 Oct 2008 08:36:11 GMT) (full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
[Message part 1 (text/plain, inline)]
Package: php5-odbc
Version: 5.2.5-3+lenny2
When I use AS keyword in a select, the alias don't work in result.
for exemple
when I do "select firstname, lastname as name from person"
odbc_result_all give :
*firstname* *lastname *
xxxx yyyy
instead of **
*firstname* *name*
xxxx yyyy
**
[Message part 2 (text/html, inline)]
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#502174; Package php5-odbc.
(Wed, 15 Oct 2008 14:39:23 GMT) (full text, mbox, link).
Acknowledgement sent
to Michelle Konzack <linux4michelle@tamay-dogan.net>:
Extra info received and forwarded to list. Copy sent to Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
(Wed, 15 Oct 2008 14:39:23 GMT) (full text, mbox, link).
Message #10 received at 502174@bugs.debian.org (full text, mbox, reply):
[Message part 1 (text/plain, inline)]
Am 2008-10-14 10:35:14, schrieb Eric Meygret:
> Package: php5-odbc
> Version: 5.2.5-3+lenny2
>
> When I use AS keyword in a select, the alias don't work in result.
>
> for exemple
> when I do "select firstname, lastname as name from person"
^^^^^^^^^^^^^^^^^^^
Write it without <SPACE> and it will work.
Also for better readability I suggest to use:
SELECT firstname,lastname AS name FROM person;
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
+49/177/9351947 50, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
[signature.pgp (application/pgp-signature, inline)]
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#502174; Package php5-odbc.
(Wed, 04 Feb 2009 22:03:02 GMT) (full text, mbox, link).
Acknowledgement sent
to Leif Gruenwoldt <leifer@gmail.com>:
Extra info received and forwarded to list. Copy sent to Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
(Wed, 04 Feb 2009 22:03:02 GMT) (full text, mbox, link).
Message #15 received at 502174@bugs.debian.org (full text, mbox, reply):
> Write it without <SPACE> and it will work.
Whitespace does not make a difference (I have tested it just to be sure).
With php-odbc v5.2.6, I have confirmed this bug affects queries to MS
SQL Server 2000. The same query to a MySQL 5 works fine.
On a positive note, I have noticed that this issue is fixed for me
with php-odbc 5.2.8. I have not found the related bug # on
bugs.php.net though.
Unfortunately for me upgrading is not an available option. If anyone
else knows a workaround for this I'd be happy to hear.
--
Leif Gruenwoldt
Information forwarded
to debian-bugs-dist@lists.debian.org, Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>:
Bug#502174; Package php5-odbc.
(Fri, 30 Apr 2010 20:42:07 GMT) (full text, mbox, link).
Acknowledgement sent
to "Jeremy Nelson" <jenelso2@wsc.edu>:
Extra info received and forwarded to list. Copy sent to Debian PHP Maintainers <pkg-php-maint@lists.alioth.debian.org>.
Your message had a Version: pseudo-header with an invalid package
version:
PHP 5.2.6-1+lenny8
please either use found or fixed to the control server with a correct
version, or reply to this report indicating the correct version so the
maintainer (or someone else) can correct it for you.
(Fri, 30 Apr 2010 20:42:07 GMT) (full text, mbox, link).
Message #20 received at 502174@bugs.debian.org (full text, mbox, reply):
[Message part 1 (text/plain, inline)]
Package: php5-odbc
Version: PHP 5.2.6-1+lenny8
I am experiencing the same issue when querying tables on a SQL Server 9.0.4053 (SQL Server 2005).
SELECT ID, Column AS alias FROM Table;
Returns:
ID | Column
-----------
1 | value
2 | value
3 | value
Instead of:
ID | alias
------------
1 | value
2 | value
3 | value
[Message part 2 (text/html, inline)]
Reply sent
to Ondřej Surý <ondrej@sury.org>:
You have taken responsibility.
(Wed, 27 Apr 2011 08:33:33 GMT) (full text, mbox, link).
Notification sent
to Eric Meygret <Eric.Meygret@Free.fr>:
Bug acknowledged by developer.
(Wed, 27 Apr 2011 08:33:34 GMT) (full text, mbox, link).
Message #25 received at 502174-done@bugs.debian.org (full text, mbox, reply):
Version: 5.3.3-7
Hi,
since lenny is oldstable it will not get any updates now (except
security)[1], I am closing all segfault bugs filled against php5 in
lenny. (This is kind of saying that we don't care much about php5 in
lenny anymore).
If you believe the bug is still there, please provide evidence[2] and
a (preferably complete) test case with up-to-date squeeze (and/or
testing or unstable) version of php5 and reopen the bug.
O.
1. http://wiki.debian.org/PHP#Notes_on_PHP_and_security
2. Install php5-dbg and provide backtrace:
http://bugs.php.net/bugs-generating-backtrace.php
--
Ondřej Surý <ondrej@sury.org>
Bug archived.
Request was from Debbugs Internal Request <owner@bugs.debian.org>
to internal_control@bugs.debian.org.
(Thu, 26 May 2011 07:39:46 GMT) (full text, mbox, link).
Send a report that this bug log contains spam.
Debian bug tracking system administrator <owner@bugs.debian.org>.
Last modified:
Sun Jul 2 01:14:57 2023;
Machine Name:
bembo
Debian Bug tracking system
Debbugs is free software and licensed under the terms of the GNU
Public License version 2. The current version can be obtained
from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham,
1997,2003 nCipher Corporation Ltd,
1994-97 Ian Jackson,
2005-2017 Don Armstrong, and many other contributors.