Hi Max, could you please send me the output of the explain for both statements, i.e. the results of the commands
"explain select * from test where a = 39251" and "explain select a from test where a between 39251 and 39252" executed via SQL Studio. With kind regards Holger SAP Labs Berlin > -----Original Message----- > From: Max Nitribitt [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 19. Februar 2002 08:39 > To: [EMAIL PROTECTED] > Subject: select problem > > > Hi, > > I upgradeded to 7.3.00.20 recently. Now I have > problems retrieving my data!?! > > table test > a integer primary key > > > select a from test where a between 39251 and 39252 > will result in: 39.251 > > select * from test where a = 39251 > produces no result. This seems very strange to me! I > uploaded the data via the ReplicationManager. Can you > help me? > > greetings > > Max > > > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
