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 <[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> > 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 > [email protected]<javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to > [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> > . > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
