← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/null.test

  • Committer: Brian Aker
  • Date: 2010-10-06 07:52:09 UTC
  • mto: (1821.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1822.
  • Revision ID: brian@tangent.org-20101006075209-0fu3u7zg9r8rw3i8
Fix issue with divide by zero not being an error.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/null.test
7
7
# Testing of NULL in a lot of different places
8
8
#
9
9
 
 
10
--error ER_DIVISION_BY_ZERO
10
11
select null,\N,isnull(null),isnull(1/0),isnull(1/0 = null),ifnull(null,1),ifnull(null,"TRUE"),ifnull("TRUE","ERROR"),1/0 is null,1 is not null;
 
12
--error ER_DIVISION_BY_ZERO
11
13
explain extended select null,\N,isnull(null),isnull(1/0),isnull(1/0 = null),ifnull(null,1),ifnull(null,"TRUE"),ifnull("TRUE","ERROR"),1/0 is null,1 is not null;
12
14
select CONCAT(1, NULL),1+NULL,1-NULL;
13
15
select NULL=NULL,NULL<>NULL,IFNULL(NULL,1.1)+0,CONCAT(IFNULL(NULL,1), 0);