differet results depending on the column count???

Post Reply
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

differet results depending on the column count???

Post by MiniMe »

I have an interesting problem.. If I run this query..

bash-2.04# tsql "select CATLG_ISBN from books where CATLG_ISBN = '1565923928'"
Texis Version 04.02.1033654782(20021003) Copyright (c) 1988-2002 Thunderstone EPI

CATLG_ISBN
------------+
1565923928
1565923928
1565923928
1565923928
1565923928
1565923928
1565923928
1565923928


I get what I expect.. If I add a column to the output.. The weirdness begins..


bash-2.04# tsql "select CATLG_ISBN, TITLE from books where CATLG_ISBN = '1565923928'"
Texis Version 04.02.1033654782(20021003) Copyright (c) 1988-2002 Thunderstone EPI

CATLG_ISBN TITLE
------------+------------+
1565923928 Javascript: the Definitive Guide.
Through Magic Glasses and Other Lectures, a Sequel to the Fairyland of Science.
1565923928 Javascript Definitive Guide.
1565923928 Javascript.
1569602182 The Adventures of Sherlock Holmes.
0525483780 The Exile.
0671675389 Blacks in American Film and Television.
1565923928 Javascript: the Definitive Guide.


Any ideas?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

differet results depending on the column count???

Post by mark »

Messed up index on CATLG_ISBN? What if you drop and remake that index?
Post Reply