diff options
| author | unknown <bell@sanja.is.com.ua> | 2006-04-13 15:07:50 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2006-04-13 15:07:50 +0300 |
| commit | 1cc27df05df05061f0cc240ab6fec36c83f81839 (patch) | |
| tree | d096b4ad76ab8747e5598eb10f6c70cc55978bd0 /mysql-test/r/func_op.result | |
| parent | 93409ee7bebcf8df98ab532884ecfdaaae1f96cc (diff) | |
| parent | c2ee905473ca0b380c3b952a27691f3411592b8c (diff) | |
| download | mariadb-git-1cc27df05df05061f0cc240ab6fec36c83f81839.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-5.0
BitKeeper/deleted/.del-acinclude.m4~f4ab416bac5003:
Auto merged
configure.in:
Auto merged
mysql-test/r/func_op.result:
Auto merged
sql/item_func.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/func_op.result')
| -rw-r--r-- | mysql-test/r/func_op.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_op.result b/mysql-test/r/func_op.result index 61b29e9380d..24685d07f3d 100644 --- a/mysql-test/r/func_op.result +++ b/mysql-test/r/func_op.result @@ -35,3 +35,14 @@ select -1 >> 0, -1 << 0; select -1 >> 1, -1 << 1; -1 >> 1 -1 << 1 9223372036854775807 18446744073709551614 +drop table if exists t1,t2; +create table t1(a int); +create table t2(a int, b int); +insert into t1 values (1), (2), (3); +insert into t2 values (1, 7), (3, 7); +select t1.a, t2.a, t2.b, bit_count(t2.b) from t1 left join t2 on t1.a=t2.a; +a a b bit_count(t2.b) +1 1 7 3 +2 NULL NULL NULL +3 3 7 3 +drop table t1, t2; |