0004891: Custom fields tables (custom_fields, custom*) Column data type definition differs between mySQL and MSSQL

testlink.org

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0004891

TestLink

Database MS-SQL

public

2012-01-26 10:08

2012-09-01 19:58

Reporter

WLanger

Assigned To

fman

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

Microsoft SQL Server 2008 R2

Microsoft Server 2008 R2

OS Version

Product Version

1.9.3 (2011 Q3 - bug fixing)

Fixed in Version

1.9.4 (2012 Q3 - bug fixing)

Summary

0004891: Custom fields tables (custom_fields, custom*) Column data type definition differs between mySQL and MSSQL

Description

There might be an outdated column definition in Testlink version 1.9.3, table custom_fields.
Two column data types (of column possible_values and default_value) differ between the MSSQL version and the mySQL version (see additional information).
I assume that varchar(4000) is the correct data type since this one is also mentioned in the alter data base schema script testlink-1.9.3\install\sql\alter_tables\1.9\mssql\DB.1.3\step1\db_schema_update.sql

Steps To Reproduce

check sql scripts - no state needs to be reproduced

Additional Information

testlink-1.9.3\install\sql\mssql\testlink_create_tables.sql

CREATE TABLE /*prefix*/custom_fields (
    id int IDENTITY(1,1) NOT NULL,
    name char(64) NOT NULL default '',
    label char(64) NOT NULL default '',
    type smallint NOT NULL default '',
    possible_values char(255) NOT NULL default '',
    default_value char(255) NOT NULL default '',
    valid_regexp char(255) NOT NULL default '',
    length_min int NOT NULL default '',
    length_max int NOT NULL default '',
    show_on_design tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_show_on_design DEFAULT ((1)),
    enable_on_design tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_enable_on_design DEFAULT ((1)),
    show_on_execution tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_show_on_execution DEFAULT ((0)),
    enable_on_execution tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_enable_on_execution DEFAULT ((0)),
    show_on_testplan_design tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_show_on_testplan_design DEFAULT ((0)),
    enable_on_testplan_design tinyint NOT NULL CONSTRAINT /*prefix*/DF_custom_fields_enable_on_testplan_design DEFAULT ((0)),
CONSTRAINT /*prefix*/PK_custom_fields PRIMARY KEY CLUSTERED
(
    id ASC
) ON [PRIMARY]
) ON [PRIMARY];

testlink-1.9.3\install\sql\mysql\testlink_create_tables.sql:

CREATE TABLE /*prefix*/custom_fields (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `label` varchar(64) NOT NULL default '' COMMENT 'label to display on user interface' ,
  `type` smallint(6) NOT NULL default '0',
  `possible_values` varchar(4000) NOT NULL default '',
  `default_value` varchar(4000) NOT NULL default '',
  `valid_regexp` varchar(255) NOT NULL default '',
  `length_min` int(10) NOT NULL default '0',
  `length_max` int(10) NOT NULL default '0',
  `show_on_design` tinyint(3) unsigned NOT NULL default '1' COMMENT '1=> show it during specification design',
  `enable_on_design` tinyint(3) unsigned NOT NULL default '1' COMMENT '1=> user can write/manage it during specification design',
  `show_on_execution` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=> show it during test case execution',
  `enable_on_execution` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=> user can write/manage it during test case execution',
  `show_on_testplan_design` tinyint(3) unsigned NOT NULL default '0' ,
  `enable_on_testplan_design` tinyint(3) unsigned NOT NULL default '0' ,
  PRIMARY KEY (`id`),
  UNIQUE KEY /*prefix*/idx_custom_fields_name (`name`)
) DEFAULT CHARSET=utf8;

Tags

TO BE FIXED on 2.0

Database (MySQL,Postgres,etc)

MSSQL

Browser

PHP Version

TestCaseID

QA Team - Task Workflow Status

READY FOR TESTING

Attached Files

Relationships

Notes
(0016306) fman (administrator) 2012-01-29 15:08	on all cfield* tables value field has to be changed to 4000

(0017247) fman (administrator) 2012-09-01 19:58	1.9.4 released

Issue History
Date Modified	Username	Field	Change
2012-01-26 10:08	WLanger	New Issue
2012-01-29 15:08	fman	Note Added: 0016306
2012-01-29 15:08	fman	Assigned To	=> fman
2012-01-29 15:08	fman	Status	new => assigned
2012-01-29 15:09	fman	Summary	Column data type definition differs between mySQL and MSSQL => Custom fields tables (custom_fields, custom*) Column data type definition differs between mySQL and MSSQL
2012-01-29 15:10	fman	Tag Attached: TO BE FIXED on 2.0
2012-08-18 12:29	fman	Task Workflow Status	=> READY FOR TESTING
2012-08-18 12:29	fman	Status	assigned => resolved
2012-08-18 12:29	fman	Fixed in Version	=> 1.9.4 (2012 Q3 - bug fixing)
2012-08-18 12:29	fman	Resolution	open => fixed
2012-09-01 19:58	fman	Note Added: 0017247
2012-09-01 19:58	fman	Status	resolved => closed