Hi, Sorry the information you provided is not sufficient to reproduce the issue. We would need your database or a reproducible test case.
Regards, Thomas On Mon, Apr 28, 2014 at 7:36 AM, vinay saharan <vsahar...@gmail.com<javascript:_e(%7B%7D,'cvml','vsahar...@gmail.com');> > wrote: > its clearly shows data with yearid=64 is present inside table > > <https://lh4.googleusercontent.com/-XGsFVvaJ0lA/U13m-2y3vqI/AAAAAAAAAIc/1E2Sq_Tiko8/s1600/Untitled2.png> > but when i run query 'select * from cases where yearid=64 ' it shows 0 > rows (even with yearid=63) > > > <https://lh3.googleusercontent.com/-1WwtN3qpqiI/U13npNj1x-I/AAAAAAAAAIs/vOkCcu-ft70/s1600/Untitled3.png> > > > <https://lh4.googleusercontent.com/-Z4wI3NcATaQ/U13nkYZh-4I/AAAAAAAAAIk/jXJYBpujQrw/s1600/Untitled4.png> > yearid 62 has about 1000 records but when i run this query for yearid = 62 > it shows 117 records (yearid 64 has 117 records) > > > <https://lh5.googleusercontent.com/-0AMU6am6tMk/U13ojnXxfvI/AAAAAAAAAI8/yHZaiu5fV54/s1600/Untitled5.png> > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > h2-database+unsubscr...@googlegroups.com<javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to > h2-database@googlegroups.com<javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
