Hi, Could you post or send me the database file please?
Regards, Thomas On Tuesday, June 17, 2014, Frank Liu <[email protected]> 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] > <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.
