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]. 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.
