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