[Firebird-checkins] CVS: interbase/firebird/patrickgriffin/tcs_tests bug_112177_05,NONE,1.1 bug_112177_06,NONE,1.1 bug_112177_07,NONE,1.1 bug_112177_08,NONE,1.1 bug_112177_09,NONE,1.1 bug_112177_10,NONE,1.1 bug_112177_11,NONE,1.1 bug_112177_12,NONE,1.1 bug_112177_01,1.1,1.2 bug_112177_02,1.1,1.2 bug_112177_03,1.1,1.2 bug_112177_04,1.1,1.2

[Patrick J. P. G. <pat...@us...>]

Update of /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests
In directory slayer.i.sourceforge.net:/tmp/cvs-serv3780/firebird/patrickgriffin/tcs_tests

Modified Files:
	bug_112177_01 bug_112177_02 bug_112177_03 bug_112177_04 
Added Files:
	bug_112177_05 bug_112177_06 bug_112177_07 bug_112177_08 
	bug_112177_09 bug_112177_10 bug_112177_11 bug_112177_12 
Log Message:
Additional tests useful in exercising the different aspects
of the 112177, GBAK fails with non-english defaults, change proposal.

..pat



--- NEW FILE ---
/*
**  Name:		bug_112177_05
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where SET NAMES specifies a different
**                      character set from the default literal.
**
**  Expected result:	GBAK shouldn't abort.
**			Final select * should only include 2nd RÇlph (from win1251 set.)
**
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1252;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null
   collate PXW_CYRL,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_06
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where SET NAMES specifies a different
**                      character set and no collate has been specified.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
set names win1252;
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_07
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where no SET NAMES.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null
   collate PXW_CYRL,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_08
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test where no SET NAMES, and no collate.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_09
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test Alter table command.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create table bug_bugbase ( 
s char(30) character set WIN1251
   default _WIN1251 'RÇbert'
   not null,
i smallint default '1234' not null
); 

alter table bug_bugbase
  add t char(30) default _win1251 'Ç New Column';

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_10
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test default from domain.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _WIN1251 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  abc,
   i smallint default '1234' not null
); 

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_11
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test Alter domain command.
**
**  Expected result:	GBAK shouldn't abort.
**                      Final select * should only include 2nd RÇlph (from win1251 set.)
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _WIN1251 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  abc,
   i smallint default '1234' not null
); 

alter domain abc
    set default _WIN1251 'Ç New Domain Default';

exit;

$ CREATE cf_test2.sql
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test1 no SET NAMES',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test3.sql
set names win1251;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test2 SET NAMES WIN1251',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test4.sql
set names win1252;
connect "WHERE_GDB:cf.gdb";

insert into bug_bugbase (s,i) values('Test3 SET NAMES WIN1252',4321);
insert into bug_bugbase (i) values(4321);
insert into bug_bugbase (s) values('RÇlph');

exit;

$ CREATE cf_test5.sql
connect "WHERE_GDB:cf.gdb";

select * from bug_bugbase;

exit;

$ ISQL -e -m -input cf_test.sql
$ ISQL -e -m -input cf_test2.sql
$ ISQL -e -m -input cf_test3.sql
$ ISQL -e -m -input cf_test4.sql
$ ISQL -e -m -input cf_test5.sql
$ GBAK -b WHERE_GDB:cf.gdb cf.gbak
$ DROP WHERE_GDB:cf.gdb
$ GBAK -r cf.gbak WHERE_GDB:cf.gdb
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql cf.gbak cf_test2.sql cf_test3.sql cf_test4.sql cf_test5.sql

--- NEW FILE ---
/*
**  Name:		bug_112177_11
**  Series:		bugs
**  Meta-Series:
**  Dependencies:	None
**  Description:	Test processing of string introducer for DDL
**			statement.
**
**  Expected result:	ISQL should reject the invalid character set.
**			
**  Author:		Patrick J. P. Griffin
**  Bugs:		[ Bug #112177 ] error with non-english column defaults
**  Change history:
**
*/

$ CREATE cf_test.sql
create database "WHERE_GDB:cf.gdb";

create domain abc
    char(30)
    default _POKEMON 'Ç Domain Default'
    not null;

create table bug_bugbase ( 
   s  char(30) default _POKEMON 'Electric Rat' not null,
   i smallint default '1234' not null
); 

exit;

$ ISQL -e -m -input cf_test.sql
$ DROP WHERE_GDB:cf.gdb
$ DELETE cf_test.sql

Index: bug_112177_01
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_01,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_01	2000/11/02 07:12:46	1.1
--- bug_112177_01	2000/11/06 02:25:46	1.2
***************
*** 4,9 ****
  **  Meta-Series:
  **  Dependencies:	None
! **  Description:	Backup and restore a database with a default
! **                      field containing non-english characters.
  **
  **  Expected result:	GBAK shouldn't abort.
--- 4,9 ----
  **  Meta-Series:
  **  Dependencies:	None
! **  Description:	Load a non-english default value and
! **                      do a gbak backup and restore.
  **
  **  Expected result:	GBAK shouldn't abort.
***************
*** 32,37 ****
  $ ISQL -m -input cf_test.sql
  $ GBAK -b WHERE_GDB:cf.gdb cf.gbak
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ GBAK -r cf.gbak WHERE_GDB:cf.gdb
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf.gbak
--- 32,37 ----
  $ ISQL -m -input cf_test.sql
  $ GBAK -b WHERE_GDB:cf.gdb cf.gbak
! $ DROP WHERE_GDB:cf.gdb
  $ GBAK -r cf.gbak WHERE_GDB:cf.gdb
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf.gbak

Index: bug_112177_02
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_02,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_02	2000/11/02 07:12:46	1.1
--- bug_112177_02	2000/11/06 02:25:46	1.2
***************
*** 51,54 ****
  $ ISQL -m -input cf_test3.sql
  $ ISQL -m -input cf_test2.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 51,54 ----
  $ ISQL -m -input cf_test3.sql
  $ ISQL -m -input cf_test2.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql

Index: bug_112177_03
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_03,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_03	2000/11/02 07:12:46	1.1
--- bug_112177_03	2000/11/06 02:25:46	1.2
***************
*** 58,61 ****
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 58,61 ----
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql

Index: bug_112177_04
===================================================================
RCS file: /cvsroot/firebird/interbase/firebird/patrickgriffin/tcs_tests/bug_112177_04,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** bug_112177_04	2000/11/02 07:12:46	1.1
--- bug_112177_04	2000/11/06 02:25:46	1.2
***************
*** 57,60 ****
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ RUN drop_gdb WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql
--- 57,60 ----
  $ ISQL -m -input cf_test2.sql
  $ ISQL -m -input cf_test3.sql
! $ DROP WHERE_GDB:cf.gdb
  $ DELETE cf_test.sql cf_test2.sql cf_test3.sql