Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 11.10.2002 14:35:51 von Andrea Carpani

>Description:
Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

>How-To-Repeat:
By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will show the problem on test "func_time"

>Fix: none
>Submitter-Id: none
>Originator: none
>Organization: none
>MySQL support: none
>Synopsis: "mysql-test-run --local func_time" fails on 64 bit recompiled mysql on HP-UX 11.00
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.52 (Source distribution)
>Environment:
System: HP-UX xxxxxx B.11.00 U 9000/800 113444601 unlimited-user license

Some paths: /usr/bin/perl /usr/bin/make /opt/make/bin/gmake /opt/gcc/bin/gcc /usr/bin/cc
GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.4/specs
Configured with: ./configure : (reconfigured) ./configure : (reconfigured) ./configure
Thread model: posix
gcc version 3.0.4
Compilation info: CC='/usr/local/pa20_64/bin/gcc' CFLAGS='-fomit-frame-pointer -O3 -fPIC' CXX='/usr/local/pa20_64/bin/gcc' CXXFLAGS='' LDFLAGS='-L/usr/local/pa20_64/lib -lstdc++'
LIBC:
lrwxr-xr-x 1 root sys 8 Mar 28 2002 /lib/libc.0 -> ./libc.1
-r-xr-xr-x 1 bin bin 1867776 May 2 2001 /lib/libc.1
-r-xr-xr-x 1 bin bin 1552384 Nov 27 2001 /lib/libc.2
-r--r--r-- 1 bin bin 2176800 Nov 27 2001 /lib/libc.a
lrwxr-xr-x 1 root sys 15 Mar 28 2002 /lib/libc.sl -> /usr/lib/libc.2
lrwxr-xr-x 1 root sys 8 Mar 28 2002 /usr/lib/libc.0 -> ./libc.1
-r-xr-xr-x 1 bin bin 1867776 May 2 2001 /usr/lib/libc.1
-r-xr-xr-x 1 bin bin 1552384 Nov 27 2001 /usr/lib/libc.2
-r--r--r-- 1 bin bin 2176800 Nov 27 2001 /usr/lib/libc.a
lrwxr-xr-x 1 root sys 15 Mar 28 2002 /usr/lib/libc.sl -> /usr/lib/libc.2
Configure command: ./configure --prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql --without-debug CC=/usr/local/pa20_64/bin/gcc 'CFLAGS=-fomit-frame-pointer -O3 -fPIC' CXX=/usr/local/pa20_64/bin/gcc 'LDFLAGS=-L/usr/local/pa20_64/lib -lstdc++'

> mysql-test-run output

root@xxxxxx:/var/tmp/mysql-3.23.52/mysql-test >mysql-test-run --local func_time
Installing Test Databases
Removing Stale Files
Installing Master Databases
021010 13:40:54 ../sql/mysqld: Shutdown Complete

Installing Slave Databases
021010 13:40:54 ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------ ------------
func_time .... .... .... [ fail ]

Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/func_time.result Wed Aug 14 01:24:51 2002
--- r/func_time.reject Thu Oct 10 13:41:07 2002
***************
*** 45,51 ****
dayname("1962-03-03") dayname("1962-03-03")+0
Saturday 5
monthname("1972-03-04") monthname("1972-03-04")+0
! March 3
time_format(19980131000000,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
--- 45,51 ----
dayname("1962-03-03") dayname("1962-03-03")+0
Saturday 5
monthname("1972-03-04") monthname("1972-03-04")+0
! March 4613937818241073200
time_format(19980131000000,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/R/e/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished

> Dump of r/func_time.reject

from_days(to_days("960101")) to_days(960201)-to_days("19960101")
to_days(date_add(curdate(), interval 1 day))-to_days(curdate())
weekday("1997-11-29")
1996-01-01 31 1 5
period_add("9602",-12) period_diff(199505,"9404")
199502 13
now()-now() weekday(curdate())-weekday(now())
unix_timestamp()-unix_timestamp(now())
0 0 0
from_unixtime(unix_timestamp("1994-03-02 10:11:12"))
from_unixtime(unix_timestamp("1994-03-02 10:11:12"),"%Y-%m-%d
%h:%i:%s") from_unixtime(unix_timestamp("1994-03-02 10:11:12"))+0
1994-03-02 10:11:12 1994-03-02 10:11:12 19940302101112
sec_to_time(9001) sec_to_time(9001)+0 time_to_sec("15:12:22")
sec_to_time(time_to_sec("0:30:47")/6.21)
02:30:01 23001 54742 00:04:57
sec_to_time(time_to_sec('-838:59:59'))
-838:59:59
now()-curdate()*1000000-curtime()
0
strcmp(current_timestamp(),concat(current_date()," ",current_time()))
0
date_format("1997-01-02 03:04:05", "%M %W %D %Y %y %m %d %h %i %s %w")
January Thursday 2nd 1997 97 01 02 03 04 05 4
date_format("1997-01-02", concat("%M %W %D ","%Y %y %m %d %h %i %s %w"))
January Thursday 2nd 1997 97 01 02 12 00 00 4
dayofmonth("1997-01-02") dayofmonth(19970323)
2 23
month("1997-01-02") year("98-02-03") dayofyear("1997-12-31")
1 1998 365
month("2001-02-00") year("2001-00-00")
2 2001
DAYOFYEAR("1997-03-03") WEEK("1998-03-03") QUARTER(980303)
62 9 1
HOUR("1997-03-03 23:03:22") MINUTE("23:03:22") SECOND(230322)
23 3 22
week(19980101) week(19970101) week(19980101,1) week(19970101,1)
0 1 1 1
week(19981231) week(19971231) week(19981231,1) week(19971231,1)
52 53 53 53
week(19950101) week(19950101,1)
1 0
yearweek('1981-12-31',1) yearweek('1982-01-01',1)
yearweek('1982-12-31',1) yearweek('1983-01-01',1)
198153 198153 198252 198252
date_format('1998-12-31','%x-%v')
date_format('1999-01-01','%x-%v')
1998-53 1998-53
date_format('1999-12-31','%x-%v')
date_format('2000-01-01','%x-%v')
1999-52 1999-52
yearweek('1987-01-01',1) yearweek('1987-01-01')
198701 198653
dayname("1962-03-03") dayname("1962-03-03")+0
Saturday 5
monthname("1972-03-04") monthname("1972-03-04")+0
March 4613937818241073200
time_format(19980131000000,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
01|01|1|1|02|AM|01:02:03 AM|03|01:02:03
time_format(19980131131415,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
13|01|13|1|14|PM|01:14:15 PM|15|13:14:15
time_format(19980131010015,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
01|01|1|1|00|AM|01:00:15 AM|15|01:00:15
date_format(concat('19980131',131415),'%H|%I|%k|%l|%i|%p|%r| %S|%T|
%M|%W|%D|%Y|%y|%a|%b|%j|%m|%d|%h|%s|%w')
13|01|13|1|14|PM|01:14:15 PM|15|13:14:15|
January|Saturday|31st|1998|98|Sat|Jan|031|01|31|01|15|6
date_format(19980021000000,'%H|%I|%k|%l|%i|%p|%r|%S|%T|
%M|%W|%D|%Y|%y|%a|%b|%j|%m|%d|%h|%s|%w')
NULL
date_add("1997-12-31 23:59:59",INTERVAL 1 SECOND)
1998-01-01 00:00:00
date_add("1997-12-31 23:59:59",INTERVAL 1 MINUTE)
1998-01-01 00:00:59
date_add("1997-12-31 23:59:59",INTERVAL 1 HOUR)
1998-01-01 00:59:59
date_add("1997-12-31 23:59:59",INTERVAL 1 DAY)
1998-01-01 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL 1 MONTH)
1998-01-31 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL 1 YEAR)
1998-12-31 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL "1:1" MINUTE_SECOND)
1998-01-01 00:01:00
date_add("1997-12-31 23:59:59",INTERVAL "1:1" HOUR_MINUTE)
1998-01-01 01:00:59
date_add("1997-12-31 23:59:59",INTERVAL "1:1" DAY_HOUR)
1998-01-02 00:59:59
date_add("1997-12-31 23:59:59",INTERVAL "1 1" YEAR_MONTH)
1999-01-31 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL "1:1:1" HOUR_SECOND)
1998-01-01 01:01:00
date_add("1997-12-31 23:59:59",INTERVAL "1 1:1" DAY_MINUTE)
1998-01-02 01:00:59
date_add("1997-12-31 23:59:59",INTERVAL "1 1:1:1" DAY_SECOND)
1998-01-02 01:01:00
date_sub("1998-01-01 00:00:00",INTERVAL 1 SECOND)
1997-12-31 23:59:59
date_sub("1998-01-01 00:00:00",INTERVAL 1 MINUTE)
1997-12-31 23:59:00
date_sub("1998-01-01 00:00:00",INTERVAL 1 HOUR)
1997-12-31 23:00:00
date_sub("1998-01-01 00:00:00",INTERVAL 1 DAY)
1997-12-31 00:00:00
date_sub("1998-01-01 00:00:00",INTERVAL 1 MONTH)
1997-12-01 00:00:00
date_sub("1998-01-01 00:00:00",INTERVAL 1 YEAR)
1997-01-01 00:00:00
date_sub("1998-01-01 00:00:00",INTERVAL "1:1" MINUTE_SECOND)
1997-12-31 23:58:59
date_sub("1998-01-01 00:00:00",INTERVAL "1:1" HOUR_MINUTE)
1997-12-31 22:59:00
date_sub("1998-01-01 00:00:00",INTERVAL "1:1" DAY_HOUR)
1997-12-30 23:00:00
date_sub("1998-01-01 00:00:00",INTERVAL "1 1" YEAR_MONTH)
1996-12-01 00:00:00
date_sub("1998-01-01 00:00:00",INTERVAL "1:1:1" HOUR_SECOND)
1997-12-31 22:58:59
date_sub("1998-01-01 00:00:00",INTERVAL "1 1:1" DAY_MINUTE)
1997-12-30 22:59:00
date_sub("1998-01-01 00:00:00",INTERVAL "1 1:1:1" DAY_SECOND)
1997-12-30 22:58:59
date_add("1997-12-31 23:59:59",INTERVAL 100000 SECOND)
1998-01-02 03:46:39
date_add("1997-12-31 23:59:59",INTERVAL -100000 MINUTE)
1997-10-23 13:19:59
date_add("1997-12-31 23:59:59",INTERVAL 100000 HOUR)
2009-05-29 15:59:59
date_add("1997-12-31 23:59:59",INTERVAL -100000 DAY)
1724-03-17 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL 100000 MONTH)
NULL
date_add("1997-12-31 23:59:59",INTERVAL -100000 YEAR)
NULL
date_add("1997-12-31 23:59:59",INTERVAL "10000:1" MINUTE_SECOND)
1998-01-07 22:40:00
date_add("1997-12-31 23:59:59",INTERVAL "-10000:1" HOUR_MINUTE)
1996-11-10 07:58:59
date_add("1997-12-31 23:59:59",INTERVAL "10000:1" DAY_HOUR)
2025-05-19 00:59:59
date_add("1997-12-31 23:59:59",INTERVAL "-100 1" YEAR_MONTH)
1897-11-30 23:59:59
date_add("1997-12-31 23:59:59",INTERVAL "10000:99:99" HOUR_SECOND)
1999-02-21 17:40:38
date_add("1997-12-31 23:59:59",INTERVAL " -10000 99:99" DAY_MINUTE)
1970-08-11 19:20:59
date_add("1997-12-31 23:59:59",INTERVAL "10000 99:99:99" DAY_SECOND)
2025-05-23 04:40:38
"1997-12-31 23:59:59" + INTERVAL 1 SECOND
1998-01-01 00:00:00
INTERVAL 1 DAY + "1997-12-31"
1998-01-01
"1998-01-01 00:00:00" - INTERVAL 1 SECOND
1997-12-31 23:59:59
date_sub("1998-01-02",INTERVAL 31 DAY)
1997-12-02
date_add("1997-12-31",INTERVAL 1 SECOND)
1997-12-31 00:00:01
date_add("1997-12-31",INTERVAL 1 DAY)
1998-01-01
date_add(NULL,INTERVAL 100000 SECOND)
NULL
date_add("1997-12-31 23:59:59",INTERVAL NULL SECOND)
NULL
date_add("1997-12-31 23:59:59",INTERVAL NULL MINUTE_SECOND)
NULL
date_add("9999-12-31 23:59:59",INTERVAL 1 SECOND)
NULL
date_sub("0000-00-00 00:00:00",INTERVAL 1 SECOND)
NULL
date_add('1998-01-30',Interval 1 month)
1998-02-28
date_add('1998-01-30',Interval '2:1' year_month)
2000-02-29
date_add('1996-02-29',Interval '1' year)
1997-02-28
extract(YEAR FROM "1999-01-02 10:11:12")
1999
extract(YEAR_MONTH FROM "1999-01-02")
199901
extract(DAY FROM "1999-01-02")
2
extract(DAY_HOUR FROM "1999-01-02 10:11:12")
210
extract(DAY_MINUTE FROM "02 10:11:12")
21011
extract(DAY_SECOND FROM "225 10:11:12")
225101112
extract(HOUR FROM "1999-01-02 10:11:12")
10
extract(HOUR_MINUTE FROM "10:11:12")
1011
extract(HOUR_SECOND FROM "10:11:12")
101112
extract(MINUTE FROM "10:11:12")
11
extract(MINUTE_SECOND FROM "10:11:12")
1112
extract(SECOND FROM "1999-01-02 10:11:12")
12
extract(MONTH FROM "2001-02-00")
2
ctime hour(ctime)
2001-01-12 12:23:40 12
monthname(date)
NULL
January
monthname(date)
NULL
January
month(updated)
NULL
year(updated)
NULL
dayofyear("0000-00-00") dayofyear(d) dayofyear(dt) dayofyear(t)
dayofyear(c)
NULL NULL NULL NULL NULL
dayofmonth("0000-00-00") dayofmonth(d) dayofmonth(dt)
dayofmonth(t) dayofmonth(c)
0 0 0 0 0
month("0000-00-00") month(d) month(dt) month(t)
month(c)
0 0 0 0 0
quarter("0000-00-00") quarter(d) quarter(dt) quarter(t)
quarter(c)
0 0 0 0 0
week("0000-00-00") week(d) week(dt) week(t) week(c)
NULL NULL NULL NULL NULL
year("0000-00-00") year(d) year(dt) year(t) year(c)
0 0 0 0 0
yearweek("0000-00-00") yearweek(d) yearweek(dt) yearweek(t)
yearweek(c)
NULL NULL NULL NULL NULL
to_days("0000-00-00") to_days(d) to_days(dt) to_days(t)
to_days(c)
NULL NULL NULL NULL NULL
extract(MONTH FROM "0000-00-00") extract(MONTH FROM d)
extract(MONTH FROM dt) extract(MONTH FROM t) extract(MONTH FROM c)
0 0 0 0 0




--
- .a.c.
- Andrea Carpani
-

http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie]
http://www.peoplesound.com
http://www.iuma.com
http://www.zipmind.it
http://www.francemp3.com (www.mp3france.com)
_______________________________________
DISCLAIMER, PLEASE NOTE: This communication is intended only for use by
the
addressee. It may contain confidential or privileged information.
Transmission, distribution and/or copy cannot be permitted. Please
notify
Vitaminic Spa immediately by reply e-mail if you are not the intended
recipient. Vitaminic Spa does not accept liability for corruption,
interception or amendment, if any, or the consequences thereof.
_______________________________________



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12696@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 11.10.2002 20:23:23 von Sinisa Milivojevic

Andrea Carpani writes:
> >Description:
> Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00
>
> >How-To-Repeat:
> By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will show the problem on test "func_time"
>
> >Fix: none
> >Submitter-Id: none
> >Originator: none
> >Organization: none
> >MySQL support: none
> >Synopsis: "mysql-test-run --local func_time" fails on 64 bit recompiled mysql on HP-UX 11.00
> >Severity: <[ non-critical | serious | critical ] (one line)>
> >Priority: <[ low | medium | high ] (one line)>
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.52 (Source distribution)
> >Environment:
> System: HP-UX xxxxxx B.11.00 U 9000/800 113444601 unlimited-user license
>
> Some paths: /usr/bin/perl /usr/bin/make /opt/make/bin/gmake /opt/gcc/bin/gcc /usr/bin/cc
> GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.4/specs
> Configured with: ./configure : (reconfigured) ./configure : (reconfigured) ./configure
> Thread model: posix
> gcc version 3.0.4

This problem (according to GCC docs) should have been fixed in 3.1 and
3.2.

Can you try 3.2 and let us know ???

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12700@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 10:50:48 von Andrea Carpani

On Fri, 2002-10-11 at 20:23, Sinisa Milivojevic wrote:

> > Some paths: /usr/bin/perl /usr/bin/make /opt/make/bin/gmake /opt/gcc/bin/gcc /usr/bin/cc
> > GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.4/specs
> > Configured with: ./configure : (reconfigured) ./configure : (reconfigured) ./configure
> > Thread model: posix
> > gcc version 3.0.4
>
> This problem (according to GCC docs) should have been fixed in 3.1 and
> 3.2.
>
> Can you try 3.2 and let us know ???
>

I'm sure I'm compiling mysql with the 64 bit gcc 3.2 taken from
http://h21007.www2.hp.com/dspp/tech/tech_TechSoftwareDetailP age_IDX/1,1703,547,00.html

I don't know where mysqlbug gets the above info. I've compiled mysql
with:

../configure --prefix=/opt/mysql --disable-shared \
--with-mysqld-user=mysql --without-debug CC=/usr/local/pa20_64/bin/gcc \
'CFLAGS=-fomit-frame-pointer -O3 -fPIC' CXX=/usr/local/pa20_64/bin/gcc \
'LDFLAGS=-L/usr/local/pa20_64/lib -lstdc++'

The other gcc, 3.0.4 is on the default path, but isn't used during mysql
compilation: any ideas? Maybe library isues?

--
- .a.c.
- Andrea Carpani
-

http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie]
http://www.peoplesound.com
http://www.iuma.com
http://www.zipmind.it
http://www.francemp3.com (www.mp3france.com)
_______________________________________
DISCLAIMER, PLEASE NOTE: This communication is intended only for use by
the
addressee. It may contain confidential or privileged information.
Transmission, distribution and/or copy cannot be permitted. Please
notify
Vitaminic Spa immediately by reply e-mail if you are not the intended
recipient. Vitaminic Spa does not accept liability for corruption,
interception or amendment, if any, or the consequences thereof.
_______________________________________



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12714@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 11:01:45 von Andrea Carpani

On Fri, 2002-10-11 at 20:23, Sinisa Milivojevic wrote:

> This problem (according to GCC docs) should have been fixed in 3.1 and
> 3.2.
>
> Can you try 3.2 and let us know ???


Libraries linked look right (64 bit ones):
root@xxxxxx:/var/tmp/mysql-3.23.52-64bit >ldd /opt/mysql/libexec/mysqld
libstdc++.sl.5 => /usr/local/pa20_64/lib/libstdc++.sl.5
libdl.1 => /lib/pa20_64/libdl.1
libpthread.1 => /lib/pa20_64/libpthread.1
libnsl.1 => /lib/pa20_64/libnsl.1
libm.2 => /lib/pa20_64/libm.2
libc.2 => /lib/pa20_64/libc.2
libxti.2 => /usr/lib/pa20_64/libxti.2
libdl.1 => /usr/lib/pa20_64/libdl.1




--
- .a.c.
- Andrea Carpani
-

http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie]
http://www.peoplesound.com
http://www.iuma.com
http://www.zipmind.it
http://www.francemp3.com (www.mp3france.com)
_______________________________________
DISCLAIMER, PLEASE NOTE: This communication is intended only for use by
the
addressee. It may contain confidential or privileged information.
Transmission, distribution and/or copy cannot be permitted. Please
notify
Vitaminic Spa immediately by reply e-mail if you are not the intended
recipient. Vitaminic Spa does not accept liability for corruption,
interception or amendment, if any, or the consequences thereof.
_______________________________________



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12716@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 15:21:38 von Sinisa Milivojevic

Andrea Carpani writes:
> On Fri, 2002-10-11 at 20:23, Sinisa Milivojevic wrote:
>
> > This problem (according to GCC docs) should have been fixed in 3.1 and
> > 3.2.
> >
> > Can you try 3.2 and let us know ???
>
>
> Libraries linked look right (64 bit ones):
> root@xxxxxx:/var/tmp/mysql-3.23.52-64bit >ldd /opt/mysql/libexec/mysqld
> libstdc++.sl.5 => /usr/local/pa20_64/lib/libstdc++.sl.5
> libdl.1 => /lib/pa20_64/libdl.1
> libpthread.1 => /lib/pa20_64/libpthread.1
> libnsl.1 => /lib/pa20_64/libnsl.1
> libm.2 => /lib/pa20_64/libm.2
> libc.2 => /lib/pa20_64/libc.2
> libxti.2 => /usr/lib/pa20_64/libxti.2
> libdl.1 => /usr/lib/pa20_64/libdl.1
>
>
>
>
> --
> - .a.c.
> - Andrea Carpani
> -
>

Can you verify that you were using 3.2 and not 3.0.4 ??

What is the output from :

gcc -v

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12720@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 15:29:10 von Andrea Carpani

On Mon, 2002-10-14 at 15:21, Sinisa Milivojevic wrote:

> Can you verify that you were using 3.2 and not 3.0.4 ??
>
> What is the output from :
>
> gcc -v

There are 2 gcc installed on the HP server:
- 3.0.4 installed in /opt got from http://hpux.cs.utah.edu.
root@xxxxxx:/ >/opt/gcc/bin/gcc -v
Reading specs from
/opt/gcc/lib/gcc-lib/hppa2.0n-hp-hpux11.00/3.0.4/specs
Configured with: ./configure : (reconfigured) ./configure :
(reconfigured) ./configure
Thread model: posix
gcc version 3.0.4

- 3.2 (prerelease) installed in /usr/local/pa20_64 got from
http://h21007.www2.hp.com/dspp/tech/tech_TechSoftwareDetailP age_IDX/1,1703,547,00.html
root@xxxxxx:/ >/usr/local/pa20_64/bin/gcc -v
Reading specs from
/usr/local/pa20_64/lib/gcc-lib/hppa64-hp-hpux11.00/3.2/specs
Configured with: ../gcc/configure --prefix=/usr/local/pa20_64
--enable-languages=c,c++ --host=hppa64-hp-hpux11.00
--target=hppa64-hp-hpux11.00 --with-ld=/usr/ccs/bin/ld --with-gnu-as
--enable-libstdcxx-v3 --disable-checking
Thread model: single
gcc version 3.2 20020708 (experimental)

When I configure and compile MySQL I use:

LDFLAGS="-L/usr/local/pa20_64/lib -lstdc++" \
CXX=/usr/local/pa20_64/bin/gcc CC=/usr/local/pa20_64/bin/gcc \
CFLAGS="-fomit-frame-pointer -O3 -fPIC" ./configure \
--prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql \
--without-debug

And I can see that gmake uses the 3.2 versione. I suppose that mysqlbug
does a gcc -v of whatever comes in the path (3.0.4 version) and not of
the gcc actually used for MySQL compilation.

To be perfectly sure I'm going to remove the first gcc and recompile
again.


--
- .a.c.
- Andrea Carpani
-

http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie]
http://www.peoplesound.com
http://www.iuma.com
http://www.zipmind.it
http://www.francemp3.com (www.mp3france.com)
_______________________________________
DISCLAIMER, PLEASE NOTE: This communication is intended only for use by
the
addressee. It may contain confidential or privileged information.
Transmission, distribution and/or copy cannot be permitted. Please
notify
Vitaminic Spa immediately by reply e-mail if you are not the intended
recipient. Vitaminic Spa does not accept liability for corruption,
interception or amendment, if any, or the consequences thereof.
_______________________________________



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12721@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 17:06:38 von Andrea Carpani

On Mon, 2002-10-14 at 15:21, Sinisa Milivojevic wrote:

> Can you verify that you were using 3.2 and not 3.0.4 ??
>
> What is the output from :
>
> gcc -v


Sorry. I've removed the old gcc and rebuilt it and I get the same
problem.


--
- .a.c.
- Andrea Carpani
-

http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie]
http://www.peoplesound.com
http://www.iuma.com
http://www.zipmind.it
http://www.francemp3.com (www.mp3france.com)
_______________________________________
DISCLAIMER, PLEASE NOTE: This communication is intended only for use by
the
addressee. It may contain confidential or privileged information.
Transmission, distribution and/or copy cannot be permitted. Please
notify
Vitaminic Spa immediately by reply e-mail if you are not the intended
recipient. Vitaminic Spa does not accept liability for corruption,
interception or amendment, if any, or the consequences thereof.
_______________________________________



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12722@lists.mysql.com
To unsubscribe, e-mail

Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 14.10.2002 17:43:12 von Sinisa Milivojevic

Andrea Carpani writes:
> On Mon, 2002-10-14 at 15:21, Sinisa Milivojevic wrote:
>
>
> Sorry. I've removed the old gcc and rebuilt it and I get the same
> problem.
>
>
> --
> - .a.c.
> - Andrea Carpani
> -
>

Can you provide us with access to your computer ??

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12724@lists.mysql.com
To unsubscribe, e-mail

Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 16.10.2002 00:51:09 von Michael Widenius

Hi!

>>>>> "Andrea" == Andrea Carpani writes:

>> Description:
Andrea> Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

>> How-To-Repeat:
Andrea> By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will show the problem on test "func_time"



Andrea> Saturday 5
Andrea> monthname("1972-03-04") monthname("1972-03-04")+0
Andrea> ! March 3
Andrea> time_format(19980131000000,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
Andrea> 00|12|0|12|00|AM|12:00:00 AM|00|00:00:00
Andrea> time_format(19980131010203,'%H|%I|%k|%l|%i|%p|%r|%S|%T')
Andrea> --- 45,51 ----
Andrea> dayname("1962-03-03") dayname("1962-03-03")+0
Andrea> Saturday 5
Andrea> monthname("1972-03-04") monthname("1972-03-04")+0
Andrea> ! March 4613937818241073200

The above comes probably from the following code:

sql/item_timefunc.h:

class Item_func_month :public Item_func
{
....
double val() { return (double) Item_func_month::val_int(); }
...
}

We have with gcc 3.x noticed that on some platforms it has a problem
converting a long long values to a double.

To verify if this is the case for you:

- configure MySQL with --with-debug
- start mysqld under gdb
- put a breakpoint at 'Item_func_month::val_int()
- execute run

In another window, start mysql and do:

select monthname("1972-03-04")+0;

After you hit the breakpoint you have to single step to find out why
the val_int() function doesn't return 3.

As sinisa said, another option is if you can give us access to your
compute to test this...

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12746@lists.mysql.com
To unsubscribe, e-mail

Re: Re: Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00

am 22.10.2002 21:32:31 von Sinisa Milivojevic

Hi!

Thanks for reporting a bug.

A problem of the building with gcc 3.2 and HP-UX 11 with PA RISC 2.0
64 bit CPU is resolved.

It is a bug in GCC. When optimisation is lowered from -O3 to -O1 all
tests pass with flying colours.

You will find all binaries in /var/tmp on your machine.

Thank you for letting us use this very nice system.

You should report this bug to GCC people.

Bug happens on the line which Monty has sent to you alredy. To remind
you:


sql/item_timefunc.h:

class Item_func_month :public Item_func
{
....
double val() { return (double) Item_func_month::val_int(); }
...
}

How-To-Repeat: for the filter

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12819@lists.mysql.com
To unsubscribe, e-mail