Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 28872
Status: resolved
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: peter [...] dragonstaff.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in:
  • 0.08
  • 0.08_04
Fixed in: (no value)

History Show all quoted text
  Fri Aug 17 07:21:09 2007 peter [...] dragonstaff.co.uk - Ticket created
Subject: make test fails against Mysql 5 on centos 4.4
Make install fails on centos 4.4, perl 5.8.5, Mysql 5.0.45. I've attached the results. Primary key seems to get left out by schema-producer and test t/18ttschema-producer fails then subsequently t/33tt-table-producer. Please let me know if you need further module version details or other help. Regards, Peter
Subject: sqlt_err_008_04.txt

Message body is not shown because it is too large.

Subject: sqlt_err_008.txt
Linux centos44 2.6.9-55.ELsmp #1 SMP Wed May 2 14:28:44 EDT 2007 i686 i686 i386 GNU/Linux mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0 perl 5.8.5 # perl -V Summary of my perl5 (revision 5 version 8 subversion 5) configuration: Platform: osname=linux, osvers=2.6.9-42.elsmp, archname=i386-linux-thread-multi uname='linux build-i386 2.6.9-42.elsmp #1 smp sat aug 12 09:39:11 cdt 2006 i686 i686 i386 gnulinux ' config_args='-des -Doptimize=-O2 -g -pipe -m32 -march=i386 -mtune=pentium4 -Dversion=5.8.5 -Dmyhostname=localhost -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux -Dvendorprefix=/usr -Dsiteprefix=/usr -Duseshrplib -Dusethreads -Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db -Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio -Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less -isr -Dinc_version_list=5.8.4 5.8.3 5.8.2 5.8.1 5.8.0' hint=recommended, useposix=true, d_sigaction=define usethreads=define use5005threads=undef useithreads=define usemultiplicity=define useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm', optimize='-O2 -g -pipe -m32 -march=i386 -mtune=pentium4', cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -I/usr/include/gdbm' ccversion='', gccversion='3.4.6 20060404 (Red Hat 3.4.6-3)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lresolv -lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc perllibs=-lresolv -lnsl -ldl -lm -lcrypt -lutil -lpthread -lc libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so gnulibc_version='2.3.4' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-rpath,/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE' cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT Built under linux Compiled at Aug 12 2006 17:09:08 @INC: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl . Primary key seems to get left out by schema-producer Errors (excerpted) installing 0.08 t/18ttschema-producer......NOK 3/6 # Failed test 'Output looks right' # at t/18ttschema-producer.t line 57. # +----+-----------------------------------------+----------------------------------------+ # | Ln|Got |Expected | # +----+-----------------------------------------+----------------------------------------+ # | 147|Constraints |Constraints | # | 148| ? | ? | # | 149| type: PRIMARY KEY | type: PRIMARY KEY | # * 150| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: id\n * # | 151| expression: | expression: | # | 152| match_type: | match_type: | # | 153| reference_fields: | reference_fields: | # +----+-----------------------------------------+----------------------------------------+ # | 160| | | # | 161| emailuniqueindex | emailuniqueindex | # | 162| type: UNIQUE | type: UNIQUE | # * 163| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: email\n * # | 164| expression: | expression: | # | 165| match_type: | match_type: | # | 166| reference_fields: | reference_fields: | # +----+-----------------------------------------+----------------------------------------+ # | 173| | | # | 174| ? | ? | # | 175| type: FOREIGN KEY | type: FOREIGN KEY | # * 176| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: another_id\n * # | 177| expression: | expression: | # | 178| match_type: | match_type: | # * 179| reference_fields:\s\n | reference_fields: id\n * # | 180| reference_table: Another | reference_table: Another | # | 181| deferrable: 1 | deferrable: 1 | # | 182| on_delete: | on_delete: | # +----+-----------------------------------------+----------------------------------------+ # | 208|Constraints |Constraints | # | 209| ? | ? | # | 210| type: PRIMARY KEY | type: PRIMARY KEY | # * 211| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: id\n * # | 212| expression: | expression: | # | 213| match_type: | match_type: | # | 214| reference_fields: | reference_fields: | # +----+-----------------------------------------+----------------------------------------+ # # Looks like you failed 1 test of 6. t/33tt-table-producer......NOK 3/8 # Failed test 'Output looks right' # at t/33tt-table-producer.t line 62. # +---+----------------------------------------------------+----------------------------------------------------+ # | Ln|Got |Expected | # +---+----------------------------------------------------+----------------------------------------------------+ # | 1|Table: person |Table: person | # * 2| Primary Key:\s\s\n | Primary Key: person_id\n * # | 3| Foreign Keys: | Foreign Keys: | # | 4| Data Fields: name, age, weight, iq, description | Data Fields: name, age, weight, iq, description | # | 5| | | # | 6|Table: pet |Table: pet | # | 7| Primary Key: pet_id, person_id | Primary Key: pet_id, person_id | # | 8| Foreign Keys: | Foreign Keys: | # | 9| Data Fields: name, age | Data Fields: name, age | # | 10| | | # +---+----------------------------------------------------+----------------------------------------------------+ # t/33tt-table-producer......NOK 7/8 # Failed test 'person.txt looks right' # at t/33tt-table-producer.t line 71. # +---+----------------------------------------------------+----------------------------------------------------+ # | Ln|Got |Expected | # +---+----------------------------------------------------+----------------------------------------------------+ # | 1|Table: person |Table: person | # * 2| Primary Key:\s\s\n | Primary Key: person_id\n * # | 3| Foreign Keys: | Foreign Keys: | # | 4| Data Fields: name, age, weight, iq, description | Data Fields: name, age, weight, iq, description | # | 5| | | # +---+----------------------------------------------------+----------------------------------------------------+ # # Looks like you failed 2 tests of 8. t/33tt-table-producer......dubious Test returned status 2 (wstat 512, 0x200) DIED. FAILED tests 3, 7 Failed 2/8 tests, 75.00% okay
  Mon Aug 20 08:10:18 2007 cpan [...] desert-island.me.uk - Correspondence added
This looks like the usual: It's a Template-Toolkit > v2.15, and they broke compat. Sorry, I put a skip in the tests for 2.16, and then they released several more versions with it still broken. This is a duplicate bug, so I'll close and note on the other one(s). Jess On Fri Aug 17 07:21:09 2007, PEDWARDS wrote: Show quoted text
> Make install fails on centos 4.4, perl 5.8.5, Mysql 5.0.45. > I've attached the results. > Primary key seems to get left out by schema-producer and test > t/18ttschema-producer fails then subsequently t/33tt-table-producer. > Please let me know if you need further module version details or
other Show quoted text
> help. > Regards, Peter
  Mon Aug 20 08:10:20 2007 The RT System itself - Status changed from 'new' to 'open'
  Mon Aug 20 09:17:48 2007 peter [...] dragonstaff.com - Correspondence added
Subject: RE: [rt.cpan.org #28872] make test fails against Mysql 5 on centos 4.4
Date: Mon, 20 Aug 2007 14:15:44 +0100
To: <bug-SQL-Translator [...] rt.cpan.org>
From: "Peter Edwards" <peter [...] dragonstaff.com>
Thanks Jess, that's cool. You are bang on the money - I have TT 2.18 installed. I did a force install, I guess it works anyway? Thanks, Peter Show quoted text
-----Original Message----- From: Jess Robinson via RT [mailto:bug-SQL-Translator@rt.cpan.org] Sent: 20 August 2007 13:10 To: peter@dragonstaff.com Cc: DARREN@cpan.org Subject: [rt.cpan.org #28872] make test fails against Mysql 5 on centos 4.4 <URL: http://rt.cpan.org/Ticket/Display.html?id=28872 > This looks like the usual: It's a Template-Toolkit > v2.15, and they broke compat. Sorry, I put a skip in the tests for 2.16, and then they released several more versions with it still broken. This is a duplicate bug, so I'll close and note on the other one(s). Jess On Fri Aug 17 07:21:09 2007, PEDWARDS wrote:
> Make install fails on centos 4.4, perl 5.8.5, Mysql 5.0.45. > I've attached the results. > Primary key seems to get left out by schema-producer and test > t/18ttschema-producer fails then subsequently t/33tt-table-producer. > Please let me know if you need further module version details or
other
> help. > Regards, Peter
  Thu Dec 02 06:37:19 2010 ribasushi [...] leporine.io - Correspondence added
TT test fails resolved since.
  Thu Dec 02 06:37:20 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'