sqlite fails tests date-6.1, date-6.4, date-6.5, date-6.8, date-6.13, and date-6.16 for me. Upon investigating, I saw this comment before those tests: # localtime->utc and utc->localtime conversions. These tests only work # if the localtime is in the US Eastern Time (the time in Charlotte, NC # and in New York.) However, the guard around the tests is: if {$tzoffset_new==4} This is a problem because (America/Indianapolis or America/Indiana/Indianapolis) Indianapolis only started doing daylight savings time in 2006 or so. As a result, the guard that is based on today's offsets will be true even though in the past, the offsets for DST did not apply. This results in the expected results not matching the actual results. Reproducible: Always Steps to Reproduce: 1. Set timezone to America/Indianapolis. 2. Merge sqlite with FEATURES="test" Actual Results: Several date tests fail. Expected Results: Tests pass either by using more appropriate guard logic or by setting TZ=America/New_York prior to those tests that depend on that being the timezone. I will report this upstream as well.
Please post your `emerge --info' in a comment.
Portage 2.2_rc93 (default/linux/amd64/2008.0, gcc-4.4.5, glibc-2.11.2-r2, 2.6.36-gentoo-r4 x86_64) ================================================================= System uname: Linux-2.6.36-gentoo-r4-x86_64-Intel-R-_Core-TM-2_Quad_CPU_Q9650_@_3.00GHz-with-gentoo-2.1.8 Timestamp of tree: Thu, 09 Dec 2010 19:00:20 +0000 app-shells/bash: 4.1_p9 dev-lang/python: 2.6.5-r3 dev-util/cmake: 2.8.1-r2 sys-apps/baselayout: 2.1.8-r2 sys-apps/openrc: 0.6.5-r1 sys-apps/sandbox: 2.4 sys-devel/autoconf: 2.13, 2.68 sys-devel/automake: 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1 sys-devel/gcc: 4.4.5 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82 virtual/os-headers: 2.6.32 (sys-kernel/linux-headers) Repositories: funtoo ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="* -@EULA AdobeFlash-10.1" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=native -O3 -pipe -ggdb3 -fstack-protector-all" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c /etc/udev/rules.d" CXXFLAGS="-march=native -O3 -pipe -ggdb3 -fstack-protector-all" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests binpkg-logs buildpkg collision-protect compress-build-logs distlocks fixlafiles fixpackages installsources mini-manifest multilib-strict news parallel-fetch preserve-libs protect-owned sandbox severe sfperms split-elog split-log splitdebug strict test unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync" GENTOO_MIRRORS="http://gentoo.mirrors.tds.net/gentoo http://mirrors.cs.wmich.edu/gentoo http://gentoo.netnitco.net" LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--sort-common -Wl,--as-needed" LINGUAS="en_US en" MAKEOPTS="--jobs 5" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="X a52 aac aalib acl acpi adns alac alsa amd64 apache2 avahi bash-completion berkdb bzip2 cairo caps cdda cdr cjk cli cracklib crypt cups curl cvs cxx dbus dga djvu dri dvd dvdr dvdread eds encode esd exif expat fam ffmpeg fftw firefox flac fontconfig gd gdbm geoip gif gimp gmp gnome gnome-keyring gnutls gpm graphviz gsm gstreamer gtk hal hardened iconv icu idn imagemagick imlib ipv6 jbig jpeg jpeg2k lame lcms libcaca libnotify libsamplerate lirc lzma lzo mad mikmod milter mmap mmx mng modules mono mp3 mpeg msn mudflap multilib ncurses nls nntp nptl nptlonly nsplugin offensive ogg openexr opengl openmp pam pch pcre pdf perl plotutils png policykit pppd profile pulseaudio python raw readline scanner session smp sndfile soap speex spell sqlite sse sse2 ssl startup-notification subversion svg sysfs syslog taglib tcpd theora threads tiff tk truetype unicode usb vcd vorbis wavpack wifi wmf wxwidgets x264 xattr xft xine xinerama xml xmp xorg xpm xscreensaver xv xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="dmix rate plug ioplug" APACHE2_MODULES="dav auth_basic authn_file log_config" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_US en" LIRC_DEVICES="devinput" PHP_TARGETS="php5-2" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nvidia" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Please report this problem to upstream.
It was already reported upstream on the sqlite-dev list: http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-dev/2010-December/001087.html If there's a better place to report it, let me know. I have not seen anybody reply to it nor have I seen it corrected in the source tree.
Is this bug still valid?
Might want to use their ticket service rather than the mailinglist: https://www.sqlite.org/src/reportlist
Is this problem reproducible with dev-db/sqlite-3.11.0?
