I have got cause. H2 create index on large table results in incomplete index when using mvstore database pattern.
Thanks a lot,Thomas Mueller ! By the way, what version will solve this bug? On Thursday, June 19, 2014 1:42:32 PM UTC+8, Thomas Mueller wrote: > > Hi, > > Could you post or send me the database file please? > > Regards, > Thomas > > On Tuesday, June 17, 2014, Frank Liu <[email protected] <javascript:>> > wrote: > >> select * from TSV_LTE_CAUSE where protocolid=14 >> when i do not create index on tsv_lte_cause(protocolid) ,i can get a 14 >> data. >> but i create index,i can not get a 14 data. >> at same time,i can get a part of all data that tsv_lte_cause. >> when not create index , i can get all data from tsv_lte_cause. >> Someone can tell me why. >> >> >> attach: >> >> CREATE INDEX PUBLIC.INDEX_6F ON PUBLIC.TSV_LTE_CAUSE(PROTOCOLID)index >> class: org.h2.mvstore.db.MVSecondaryIndex >> >> -- >> 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. >> > -- 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.
