Similar, not the same.

Currently using the driver version: OdbcFb-LIB-2.0.0151.amd64.tar.gz
lets see if I can find an older version.

+------------+--+
| TEST_NO | |
+------------+--+
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|
| 14001593384| X|

On Wed, 2011-05-04 at 12:31 -0600, Hans wrote:
>
> Does
>
> > SELECT FIRST 10 TEST_NO, 'X' FROM TESTS
>
> give you a similar results ?
>
> +------------+------+
> | TEST_NO | 'X' |
> +------------+------+
> | 1 | 'X' |
> | 2 | 'X' |
>
> Then I would expect an ODBC problem
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of t_wright_1973
> Sent: May-04-11 11:13 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Odd select results
>
> Hi,
> Using firebird server running on a linux server, not sure what version
> but
> <2.1.
> The client is iSQL using unix ODBC.
>
> Can anyone explain what is happening to TEST_NO in the two statements
> below?
>
> Thanks
>
> SQL> SELECT FIRST 10 TEST_NO FROM TESTS
> +------------+
> | TEST_NO |
> +------------+
> | 1 |
> | 2 |
> | 3 |
> | 4 |
> | 5 |
> | 6 |
> | 7 |
> | 8 |
> | 9 |
> | 10 |
> +------------+
>
> SQL> SELECT FIRST 10 TEST_NO, SUBJECT_NO FROM TESTS
> +------------+------------+
> | TEST_NO | SUBJECT_NO |
> +------------+------------+
> | 4294967297 | 1 |
> | 8589934594 | 2 |
> | 4294967299 | 1 |
> | 25769803780| 6 |
> | 30064771077| 7 |
> | 34359738374| 8 |
> | 12884901895| 3 |
> | 17179869192| 4 |
> | 17179869193| 4 |
> | 21474836490| 5 |
> +------------+------------+
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the
> main
> (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>



[Non-text portions of this message have been removed]