MySQL 4.0.13: select test fails
am 06.07.2003 10:34:12 von Tilman GieseHello,
I recently compiled MySQL 4.0.13 myself and ran the test suite
afterwards. Unfortunately, the select test fails with the following
error message:
>> Error at line 1821: Result length mismatch<<
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/select.result Sat Jul 5 23:42:09 2003
--- r/select.reject Sun Jul 6 00:28:25 2003
***************
*** 1580,1683 ****
accuracies
select distinct substring(fld3,1,3) from t2 where fld3 like "A%";
substring(fld3,1,3)
! aba
! abi
! Abr
! abs
! abu
! acc
! acq
! acu
! Ade
! adj
! Adl
! adm
! Ado
! ads
! adv
! aer
! aff
! afi
! afl
! afo
! agi
! ahe
! aim
! air
! Ald
! alg
! ali
! all
! alp
! alr
! ama
! ame
! amm
! ana
! and
! ane
! Ang
! ani
! Ann
! Ant
! api
! app
! aqu
! Ara
! arc
! Arm
! arr
! Art
! Asi
! ask
! asp
! ass
! ast
! att
! aud
! Aug
! aut
! ave
! avo
! awe
! aye
! Azt
select distinct substring(fld3,1,3) as a from t2 having a like "A%"
order by a limit 10;
a
- aba
- abi
- Abr
- abs
- abu
- acc
- acq
- acu
- Ade
- adj
select distinct substring(fld3,1,3) from t2 where fld3 like "A%"
limit 10;
substring(fld3,1,3)
! aba
! abi
! Abr
! abs
! abu
! acc
! acq
! acu
! Ade
! adj
select distinct substring(fld3,1,3) as a from t2 having a like "A%"
limit 10;
a
- aba
- abi
- Abr
- abs
- abu
- acc
- acq
- acu
- Ade
- adj
create table t3 (
period int not null,
name char(32) not null,
--- 1580,1593 ----
accuracies
select distinct substring(fld3,1,3) from t2 where fld3 like "A%";
substring(fld3,1,3)
!
select distinct substring(fld3,1,3) as a from t2 having a like "A%"
order by a limit 10;
a
select distinct substring(fld3,1,3) from t2 where fld3 like "A%"
limit 10;
substring(fld3,1,3)
!
select distinct substring(fld3,1,3) as a from t2 having a like "A%"
limit 10;
a
create table t3 (
period int not null,
name char(32) not null,
-------------------------------------------------------
The select test is the only one failing. To provide you some information
about my system:
C compiler: gcc (GCC) 3.3 (SuSE Linux)
C++ compiler: g++ (GCC) 3.3 (SuSE Linux)
Environment: System: Linux nefertari 2.4.21-4-athlon #1 Fri Jul 4
11:17:40 UTC 2003 i686 unknown
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3/specs
Configured with: ../configure --enable-threads=posix --prefix=/usr
--with-local-prefix=/usr/local --infodir=/usr/share/info
--mandir=/usr/share/man --libdir=/usr/lib
--enable-languages=c,c++,f77,objc,java,ada --disable-checking
--enable-libgcj --with-gxx-include-dir=/usr/include/g++
--with-slibdir=/lib --with-system-zlib --enable-shared
--enable-__cxa_atexit i586-suse-linux
Thread model: posix
gcc-Version 3.3 (SuSE Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i486 -mcpu=i686 -DPIC
-fPIC' CXX='g++' CXXFLAGS='-O2 -march=i486 -mcpu=i686
-felide-constructors -fno-exceptions -fno-rtti -DPIC -fPIC' LDFLAGS=''
ASFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1475331 2003-03-27 21:39 /lib/libc.so.6
-rw-r--r-- 1 root root 43012516 2003-03-14 00:13 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 2003-03-14 00:13 /usr/lib/libc.so
Configure command: ./configure '--enable-shared' '--enable-assembler'
'--enable-local-infile' '--enable-large-files'
'--enable-thread-safe-client' '--enable-dependency-tracking'
'--prefix=/usr' '--libdir=/usr/lib' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--datadir=/usr/share'
'--libexecdir=/usr/bin' '--sysconfdir=/etc' '--includedir=/usr/include'
'--localstatedir=/var/lib/mysql' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--with-charset=german1' '--with-extra-charsets=complex'
'--with-embedded-server' '--with-libwrap' '--with-gnu-ld'
'--with-openssl' '--with-raid' '--with-vio' '--with-pic'
'--with-berkeley-db' '--with-innodb' 'CFLAGS=-O2 -march=i486 -mcpu=i686
-DPIC -fPIC' 'CXXFLAGS=-O2 -march=i486 -mcpu=i686 -felide-constructors
-fno-exceptions -fno-rtti -DPIC -fPIC'
I do not know yet how this failure effects the real work but I hope that
the information above helps you to solve the problem.
Tilman Giese
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org