Bug #7280 Test failure: 'type_ranges' (using '--ps-protocol': Handling of NULL)
Submitted: 14 Dec 2004 16:53 Modified: 14 Jan 2005 19:00
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Linux (Linux / Athlon)
Assigned to: Konstantin Osipov CPU Architecture:Any

[14 Dec 2004 16:53] Joerg Bruehe
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'.
[14 Jan 2005 19:00] Joerg Bruehe
I cannot reproduce it any more, seems to have been corrected (there were corrections for the '--ps-protocol' case).