This is only on temporary tables, changing the testcase to use a regular table t1 works as expected.
My testing was on openSuse 11.1 64 bit
jdaly@rx7:~> uname -a Linux rx7 2.6.27.7-9-default #1 SMP 2008-12-04 18:10:04 +0100 x86_64 x86_64 x86_64 GNU/Linux
This is only on temporary tables, changing the testcase to use a regular table t1 works as expected.
My testing was on openSuse 11.1 64 bit
jdaly@rx7:~> uname -a
Linux rx7 2.6.27.7-9-default #1 SMP 2008-12-04 18:10:04 +0100 x86_64 x86_64 x86_64 GNU/Linux