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