← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/t/func_equal.test

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/func_equal.test
 
1
# Initialise
 
2
--disable_warnings
 
3
drop table if exists t1,t2;
 
4
--enable_warnings
 
5
 
 
6
#
 
7
# Testing of the <=> operator
 
8
#
 
9
 
 
10
#
 
11
# First some simple tests
 
12
#
 
13
 
 
14
select 0<=>0,0.0<=>0.0,0E0=0E0,"A"<=>"A",NULL<=>NULL;
 
15
select 1<=>0,0<=>NULL,NULL<=>0;
 
16
select 1.0<=>0.0,0.0<=>NULL,NULL<=>0.0;
 
17
select "A"<=>"B","A"<=>NULL,NULL<=>"A";
 
18
select 0<=>0.0, 0.0<=>0E0, 0E0<=>"0", 10.0<=>1E1, 10<=>10.0, 10<=>1E1;
 
19
select 1.0<=>0E1,10<=>NULL,NULL<=>0.0, NULL<=>0E0;
 
20
 
 
21
#
 
22
# Test with tables
 
23
#
 
24
 
 
25
create table t1 (id int, value int);
 
26
create table t2 (id int, value int);
 
27
 
 
28
insert into t1 values (1,null);
 
29
insert into t2 values (1,null);
 
30
 
 
31
select t1.*, t2.*, t1.value<=>t2.value from t1, t2 where t1.id=t2.id and t1.id=1;
 
32
select * from t1 where id <=>id;
 
33
select * from t1 where value <=> value;
 
34
select * from t1 where id <=> value or value<=>id;
 
35
drop table t1,t2;
 
36
 
 
37
#
 
38
# Bug #12612: quoted bigint unsigned value and the use of "in" in where clause
 
39
#
 
40
create table t1 (a bigint unsigned);
 
41
insert into t1 values (4828532208463511553);
 
42
select * from t1 where a = '4828532208463511553';
 
43
select * from t1 where a in ('4828532208463511553');
 
44
drop table t1;
 
45
 
 
46
# End of 4.1 tests