Skip Menu |

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

Report information
The Basics
Id: 20047
Status: resolved
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: rdhayes [...] ucla.edu
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.07
Fixed in: (no value)



Subject: Build test fails on test scripts 18, 33, 34
Three tests in SQL-Translator 0.07 fail. Perhaps this is related to behaviour of the most recent Template module version (2.15)? Output as follows: $ uname -a Linux <domain> 2.6.12-1.1381_FC3smp #1 SMP Fri Oct 21 04:03:26 EDT 2005 i686 i686 i386 GNU/Linux $ perl -v This is perl, v5.8.5 built for i386-linux (note: I have a rebuilt, non-threaded install) The results of the build test are lengthy, so they are included as an attachment. Thanks for any input!
Subject: sql-translator-testfail.txt
$ ./Build test t/02mysql-parser.........ok t/03mysql-to-oracle......ok t/04file,fh,string.......ok t/05bgep-re..............ok t/06xsv..................ok t/07p_args...............ok t/08postgres-to-mysql....ok t/09sqlt-diagram.........ok t/10excel................ok t/11normalize............ok t/12header_comment.......ok t/13schema...............ok t/14postgres-parser......ok t/15oracle-parser........ok t/16xml-parser...........ok t/17sqlfxml-producer.....ok t/18ttschema-producer....ok 2/6 # Failed test 'Output looks right' # in t/18ttschema-producer.t at line 51. t/18ttschema-producer....NOK 3# +----+-----------------------------------------+---------------------------------------+ # | Ln|Got |Expected | # +----+-----------------------------------------+---------------------------------------+ # | 119|Constraints |Constraints | # | 120| ? | ? | # | 121| type: PRIMARY KEY | type: PRIMARY KEY | # * 122| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: id\n * # | 123| expression: | expression: | # | 124| match_type: | match_type: | # | 125| reference_fields: | reference_fields: | # +----+-----------------------------------------+---------------------------------------+ # | 132| | | # | 133| emailuniqueindex | emailuniqueindex | # | 134| type: UNIQUE | type: UNIQUE | # * 135| fields:\s\s\s\s\s\s\s\s\s\s\s\n | fields: email\n * # | 136| expression: | expression: | # | 137| match_type: | match_type: | # | 138| reference_fields: | reference_fields: | # +----+-----------------------------------------+---------------------------------------+ # t/18ttschema-producer....ok 6/6# Looks like you failed 1 test of 6. t/18ttschema-producer....dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED test 3 Failed 1/6 tests, 83.33% okay t/19sybase-parser........ok t/20format_X_name........ok t/24yaml.................ok t/25storable.............ok t/26sybase...............ok t/27sqlite-parser........ok t/29html.................ok t/30sqlt-diff............ok t/31dumper...............ok t/32schema-lookups.......ok t/33tt-table-producer....Creating /tmp/jHBPsfIlSG/person.txt. Creating /tmp/jHBPsfIlSG/pet.txt. t/33tt-table-producer....ok 2/8 t/33tt-table-producer....NOK 3# Failed test 'Output looks right' # in t/33tt-table-producer.t at line 58. # +---+----------------------------------------------------+----------------------------------------------------+ # | 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....ok 6/8 # Failed test 'person.txt looks right' t/33tt-table-producer....NOK 7# in t/33tt-table-producer.t at line 67. # +---+----------------------------------------------------+----------------------------------------------------+ # | 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| | | # +---+----------------------------------------------------+----------------------------------------------------+ # t/33tt-table-producer....ok 8/8# 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 t/34tt-base..............ok 3/4 # Failed test 'Output looks right' t/34tt-base..............NOK 4# in t/34tt-base.t at line 38. # +---+---------------+--------------------------------------------------------------------------------------+ # | Ln|Got |Expected | # +---+---------------+--------------------------------------------------------------------------------------+ # | 1|Hello World |Hello World | # | 2|Tables: Basic |Tables: Basic | # | 3| | | # * 4|\n |Basic\n * # | 5|------ |------ | # * 6|Fields:\s\n |Fields: id title description email explicitnulldef explicitemptystring emptytagdef\n * # +---+---------------+--------------------------------------------------------------------------------------+ # # Looks like you failed 1 test of 4. t/34tt-base..............dubious Test returned status 1 (wstat 256, 0x100) DIED. FAILED test 4 Failed 1/4 tests, 75.00% okay t/35-access-parser.......ok t/36-filters.............ok t/37-translator-graph....ok t/38-mysql-producer......ok t/42shell................ok Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/18ttschema-producer.t 1 256 6 1 16.67% 3 t/33tt-table-producer.t 2 512 8 2 25.00% 3 7 t/34tt-base.t 1 256 4 1 25.00% 4 Failed 3/34 test scripts, 91.18% okay. 4/1149 subtests failed, 99.65% okay.
From: rdhayes [*AT*] ucla.edu
Hi, I've been able to show that rolling back to template toolkit version 2.14 allows all Sql-Translator 0.07 tests to pass correctly. I'll open a new ticket for the Template folks. On Thu Jun 22 22:27:03 2006, guest wrote: Show quoted text
> Three tests in SQL-Translator 0.07 fail. Perhaps this is related to > behaviour of the most recent Template module version (2.15)? > > Output as follows: > $ uname -a > Linux <domain> 2.6.12-1.1381_FC3smp #1 SMP Fri Oct 21 04:03:26 EDT 2005 > i686 i686 i386 GNU/Linux > > $ perl -v > This is perl, v5.8.5 built for i386-linux > (note: I have a rebuilt, non-threaded install) > > The results of the build test are lengthy, so they are included as an > attachment. > > Thanks for any input!
TT test failures fixed since.