Description:
Test 'type_range' fails for me in current 5.0, when I run the test suite with
'--ps-protocol'.
In a standard run, this test passes.
This is a non-debug build: 'compile-pentium-max'.
Failure report:
-------------------------------------------------------
*** r/type_ranges.result 2004-12-10 18:05:58.000000000 +0300
--- r/type_ranges.reject 2004-12-14 13:44:15.000000000 +0300
***************
*** 317,324 ****
2 NULL
drop table t3;
create table t3 select t1.id as id_A, t2.id as id_B from t1 left join t2 using ( id );
select * from t3;
id_A id_B
1 1
! 2 NULL
drop table t1,t2,t3;
--- 317,326 ----
2 NULL
drop table t3;
create table t3 select t1.id as id_A, t2.id as id_B from t1 left join t2 using ( id );
+ Warnings:
+ Warning 1263 Column set to default value; NULL supplied to NOT NULL column 'id_B' at row 2
select * from t3;
id_A id_B
1 1
! 2 0
drop table t1,t2,t3;
-------------------------------------------------------
Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
Fix for bug #7223: information_schema: error in "views"
The error is older, as I got it already yesterday but did not yet report.
How to repeat:
Run the test suite with '--ps-protocol'.