explain plan throws ClassCastException.

[GoogleCodeExporter]

Before submitting a bug, please check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. java -cp h2-1.2.140.jar org.h2.tools.Shell -url jdbc:h2:mem:xxxx
2. create table hoge(id int);
3. insert into hoge select x from system_range(1,20000);
4. explain analyze select * from hoge where id between 1 and 1000;

Error: org.h2.jdbc.JdbcSQLException: 一般エラー: 
"java.lang.ClassCastException:org.h2.index.ScanIndex cannot be cast to 
org.h2.index.PageDataIndex"
General error: "java.lang.ClassCastException: org.h2.index.ScanIndex cannot be 
cast to org.h2.index.PageDataIndex" [50000-140]

What is the expected output? What do you see instead?

That error does not occur.

What version of the product are you using? On what operating system, file
system, and virtual machine?

h2-1.2.140

Windows XP SP3

java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) Client VM (build 16.0-b13, mixed mode, sharing)

Do you know a workaround?

Previous explain plan to run again 

How important/urgent is the problem for you?

not so important.

In your view, is this a defect or a feature request?

defect

Please provide any additional information below.

Original issue reported on code.google.com by litail...@gmail.com on 27 Jul 2010 at 10:56

[GoogleCodeExporter]

Original comment by thomas.t...@gmail.com on 30 Jul 2010 at 9:23

• Changed state: Accepted

[GoogleCodeExporter]

Fixed in version 1.2.141.

Original comment by thomas.t...@gmail.com on 23 Aug 2010 at 12:43

• Changed state: Fixed