persistentstorage/sql/GROUP/sqltests.iby
changeset 31 ba1c4f4a893f
parent 28 7a522c0700d3
child 51 7d4490026038
equal deleted inserted replaced
29:cce6680bbf1c 31:ba1c4f4a893f
    21 
    21 
    22 #include <testlocale.iby>
    22 #include <testlocale.iby>
    23 #include <charconv.iby>
    23 #include <charconv.iby>
    24 #include <sql.iby>
    24 #include <sql.iby>
    25 
    25 
    26 //Include the following to enable the ulogger server and the client tool. 
    26 data=DATAZ_\test\sqlTests.bat                            \test\sqltests.bat
    27 //This is used to perform tracing using the UTF2
       
    28 
    27 
    29 //#include <uloggerclttool.iby>
    28 data=DATAZ_\test\contacts_schema_to_vendors.sql          \test\contacts_schema_to_vendors.sql
    30 //#include <ulogger.iby>
    29 data=DATAZ_\test\add_simple_contacts.sql                 \test\add_simple_contacts.sql
       
    30 data=DATAZ_\test\contacts_startup_time.sql               \test\contacts_startup_time.sql
       
    31 data=DATAZ_\test\testdb1.db                              \test\testdb1.db
       
    32 data=DATAZ_\test\corruptdb.db                            \test\corruptdb.db
       
    33 data=DATAZ_\test\t_sqlshortnondb.db                      \test\t_sqlshortnondb.db
       
    34 data=DATAZ_\test\t_inc095412.db                          \test\t_inc095412.db
       
    35 data=DATAZ_\test\default_avacon.dbsql                    \test\default_avacon.dbsql
       
    36 data=DATAZ_\test\t_sqlbur_backup_ver0.bak                \test\t_sqlbur_backup_ver0.bak
       
    37 data=DATAZ_\test\t_sqlperformance4.sql                   \test\t_sqlperformance4.sql
       
    38 data=ZPRIVATE\10281e17\[21212122]aadb2.db                \private\10281e17\[21212122]aadb2.db
       
    39 data=ZPRIVATE\10281e17\[21212122]bbdb2.db                \private\10281e17\[21212122]bbdb2.db
       
    40 data=ZPRIVATE\10281e17\[21212125]t_ab.db                 \private\10281e17\[21212125]t_ab.db
       
    41 data=ZPRIVATE\10281e17\[1111cccc]t_ab.db                 \private\10281e17\[1111CCCC]t_ab.db
       
    42 data=ZPRIVATE\21212124\t_sqldb1.db                       \private\21212124\t_sqldb1.db
       
    43 data=ZPRIVATE\10281e17\[21212125]t_onedefpolicy.db       \private\10281e17\[21212125]t_onedefpolicy.db
       
    44 data=ZPRIVATE\10281e17\[98765432]t_2defaultpolicies.db   \private\10281e17\[98765432]t_2defaultpolicies.db
       
    45 data=ZPRIVATE\10281e17\[98765432]t_emptysettings.db      \private\10281e17\[98765432]t_emptysettings.db
       
    46 data=ZPRIVATE\10281e17\[98765432]t_invobject.db          \private\10281e17\[98765432]t_invobject.db
       
    47 data=ZPRIVATE\10281e17\[98765432]t_invversion.db         \private\10281e17\[98765432]t_invversion.db
       
    48 data=ZPRIVATE\10281e17\[98765432]t_longcollation.db      \private\10281e17\[98765432]t_longcollation.db
       
    49 data=ZPRIVATE\10281e17\[98765432]t_nocollation.db        \private\10281e17\[98765432]t_nocollation.db
       
    50 data=ZPRIVATE\10281e17\[98765432]t_nodefaultpolicy.db    \private\10281e17\[98765432]t_nodefaultpolicy.db
       
    51 data=ZPRIVATE\10281e17\[98765432]t_nosettings.db         \private\10281e17\[98765432]t_nosettings.db
    31 
    52 
    32 data=DATAZ_\test\sqlTests.bat                            \TEST\sqlTests.bat
    53 file=ABI_DIR\BUILD_DIR\t_sqlenvcreate.exe           \test\t_sqlenvcreate.exe
    33 
    54 file=ABI_DIR\BUILD_DIR\t_sqlite.exe                 \test\t_sqlite.exe
    34 data=DATAZ_\test\contacts_schema_to_vendors.sql          \TEST\contacts_schema_to_vendors.sql
    55 file=ABI_DIR\BUILD_DIR\t_sqlapi.exe                 \test\t_sqlapi.exe
    35 data=DATAZ_\test\add_simple_contacts.sql                 \TEST\add_simple_contacts.sql
    56 file=ABI_DIR\BUILD_DIR\t_sqlapi2.exe                \test\t_sqlapi2.exe
    36 data=DATAZ_\test\contacts_startup_time.sql               \TEST\contacts_startup_time.sql
    57 file=ABI_DIR\BUILD_DIR\t_sqlpanic.exe               \test\t_sqlpanic.exe
    37 data=DATAZ_\test\TestDb1.DB                              \TEST\TestDb1.dB
    58 file=ABI_DIR\BUILD_DIR\t_sqllang.exe                \test\t_sqllang.exe
    38 data=DATAZ_\test\CorruptDb.DB                            \TEST\CorruptDb.dB
    59 file=ABI_DIR\BUILD_DIR\t_sqloom1.exe                \test\t_sqloom1.exe
    39 data=DATAZ_\test\t_SqlShortNonDb.db                      \TEST\t_SqlShortNonDb.db
    60 file=ABI_DIR\BUILD_DIR\t_sqloom2.exe                \test\t_sqloom2.exe
    40 data=DATAZ_\test\t_inc095412.db                          \TEST\t_inc095412.db
    61 file=ABI_DIR\BUILD_DIR\t_sqloom3.exe                \test\t_sqloom3.exe
    41 data=DATAZ_\test\default_avacon.dbSQL                    \TEST\default_avacon.dbSQL
    62 file=ABI_DIR\BUILD_DIR\t_sqloom4.exe                \test\t_sqloom4.exe
    42 data=DATAZ_\test\t_sqlbur_backup_ver0.bak                \TEST\t_sqlbur_backup_ver0.bak
    63 file=ABI_DIR\BUILD_DIR\t_sqloom5.exe                \test\t_sqloom5.exe
    43 data=DATAZ_\test\t_sqlperformance4.sql                   \TEST\t_sqlperformance4.sql
    64 file=ABI_DIR\BUILD_DIR\t_sqloom6.exe                \test\t_sqloom6.exe
    44 data=ZPRIVATE\10281e17\[21212122]AADb2.db                \PRIVATE\10281e17\[21212122]AADb2.db
    65 file=ABI_DIR\BUILD_DIR\t_sqlmulti.exe               \test\t_sqlmulti.exe
    45 data=ZPRIVATE\10281e17\[21212122]BBDb2.db                \PRIVATE\10281e17\[21212122]BBDb2.db
    66 file=ABI_DIR\BUILD_DIR\t_sqlcollate.exe             \test\t_sqlcollate.exe
    46 data=ZPRIVATE\10281e17\[21212125]T_AB.db                 \PRIVATE\10281e17\[21212125]T_AB.db
    67 file=ABI_DIR\BUILD_DIR\t_sqltrans.exe               \test\t_sqltrans.exe
    47 data=ZPRIVATE\10281e17\[1111CCCC]T_AB.db                 \PRIVATE\10281e17\[1111CCCC]T_AB.db
    68 file=ABI_DIR\BUILD_DIR\t_sqlload.exe                \test\t_sqlload.exe
    48 data=ZPRIVATE\21212124\t_sqldb1.db                       \PRIVATE\21212124\t_sqldb1.db
    69 file=ABI_DIR\BUILD_DIR\t_sqlgetfirststmt.exe        \test\t_sqlgetfirststmt.exe
    49 data=ZPRIVATE\10281e17\[21212125]T_OneDefPolicy.db       \PRIVATE\10281e17\[21212125]T_OneDefPolicy.db
    70 file=ABI_DIR\BUILD_DIR\t_sqlsecurity1.exe           \test\t_sqlsecurity1.exe
    50 data=ZPRIVATE\10281e17\[98765432]t_2defaultpolicies.db   \PRIVATE\10281e17\[98765432]t_2defaultpolicies.db
    71 file=ABI_DIR\BUILD_DIR\t_sqlsecurity2.exe           \test\t_sqlsecurity2.exe
    51 data=ZPRIVATE\10281e17\[98765432]t_emptysettings.db      \PRIVATE\10281e17\[98765432]t_emptysettings.db
    72 file=ABI_DIR\BUILD_DIR\t_sqlsecurity3.exe           \test\t_sqlsecurity3.exe
    52 data=ZPRIVATE\10281e17\[98765432]t_invobject.db          \PRIVATE\10281e17\[98765432]t_invobject.db
    73 file=ABI_DIR\BUILD_DIR\t_sqlsecurity4.exe           \test\t_sqlsecurity4.exe
    53 data=ZPRIVATE\10281e17\[98765432]t_invversion.db         \PRIVATE\10281e17\[98765432]t_invversion.db
    74 file=ABI_DIR\BUILD_DIR\t_sqlsecurity5.exe           \test\t_sqlsecurity5.exe
    54 data=ZPRIVATE\10281e17\[98765432]t_longcollation.db      \PRIVATE\10281e17\[98765432]t_longcollation.db
    75 file=ABI_DIR\BUILD_DIR\t_sqlsecurity6.exe           \test\t_sqlsecurity6.exe
    55 data=ZPRIVATE\10281e17\[98765432]t_nocollation.db        \PRIVATE\10281e17\[98765432]t_nocollation.db
    76 file=ABI_DIR\BUILD_DIR\t_sqlattach.exe              \test\t_sqlattach.exe
    56 data=ZPRIVATE\10281e17\[98765432]t_nodefaultpolicy.db    \PRIVATE\10281e17\[98765432]t_nodefaultpolicy.db
    77 file=ABI_DIR\BUILD_DIR\t_sqlattach2.exe             \test\t_sqlattach2.exe
    57 data=ZPRIVATE\10281e17\[98765432]t_nosettings.db         \PRIVATE\10281e17\[98765432]t_nosettings.db
    78 file=ABI_DIR\BUILD_DIR\t_sqlperformance.exe         \test\t_sqlperformance.exe
    58 
    79 file=ABI_DIR\BUILD_DIR\t_sqlperformance2.exe        \test\t_sqlperformance2.exe
    59 file=ABI_DIR\BUILD_DIR\T_SQLENVCREATE.EXE	\TEST\T_SQLENVCREATE.EXE
    80 file=ABI_DIR\BUILD_DIR\t_sqlperformance3.exe        \test\t_sqlperformance3.exe
    60 file=ABI_DIR\BUILD_DIR\T_SQLITE.EXE		\TEST\T_SQLITE.EXE
    81 file=ABI_DIR\BUILD_DIR\t_sqlperformance4.exe        \test\t_sqlperformance4.exe
    61 file=ABI_DIR\BUILD_DIR\T_SQLAPI.EXE		\TEST\T_SQLAPI.EXE
    82 file=ABI_DIR\BUILD_DIR\t_sqlperformance5.exe        \test\t_sqlperformance5.exe
    62 file=ABI_DIR\BUILD_DIR\T_SQLAPI2.EXE		\TEST\T_SQLAPI2.EXE
    83 file=ABI_DIR\BUILD_DIR\t_sqlood.exe                 \test\t_sqlood.exe
    63 file=ABI_DIR\BUILD_DIR\T_SQLPANIC.EXE		\TEST\T_SQLPANIC.EXE
    84 file=ABI_DIR\BUILD_DIR\t_sqloslayer.exe             \test\t_sqloslayer.exe
    64 file=ABI_DIR\BUILD_DIR\T_SQLLANG.EXE		\TEST\T_SQLLANG.EXE
    85 file=ABI_DIR\BUILD_DIR\t_sqldefect.exe              \test\t_sqldefect.exe
    65 file=ABI_DIR\BUILD_DIR\T_SQLOOM1.EXE		\TEST\T_SQLOOM1.EXE
    86 file=ABI_DIR\BUILD_DIR\t_sqldefect2.exe             \test\t_sqldefect2.exe
    66 file=ABI_DIR\BUILD_DIR\T_SQLOOM2.EXE		\TEST\T_SQLOOM2.EXE
    87 file=ABI_DIR\BUILD_DIR\t_sqlprivcage.exe            \test\t_sqlprivcage.exe
    67 file=ABI_DIR\BUILD_DIR\T_SQLOOM3.EXE		\TEST\T_SQLOOM3.EXE
    88 file=ABI_DIR\BUILD_DIR\t_sqlbadclient.exe           \test\t_sqlbadclient.exe
    68 file=ABI_DIR\BUILD_DIR\T_SQLOOM4.EXE		\TEST\T_SQLOOM4.EXE
    89 file=ABI_DIR\BUILD_DIR\t_sqlbur.exe                 \test\t_sqlbur.exe
    69 file=ABI_DIR\BUILD_DIR\T_SQLOOM5.EXE		\TEST\T_SQLOOM5.EXE
    90 file=ABI_DIR\BUILD_DIR\t_sqlscalarfullselect.exe    \test\t_sqlscalarfullselect.exe
    70 file=ABI_DIR\BUILD_DIR\T_SQLOOM6.EXE		\TEST\T_SQLOOM6.EXE
    91 file=ABI_DIR\BUILD_DIR\t_sqlfserr.exe               \test\t_sqlfserr.exe
    71 file=ABI_DIR\BUILD_DIR\T_SQLMULTI.EXE		\TEST\T_SQLMULTI.EXE
    92 file=ABI_DIR\BUILD_DIR\t_sqlconfig.exe              \test\t_sqlconfig.exe
    72 file=ABI_DIR\BUILD_DIR\T_SQLCOLLATE.EXE		\TEST\T_SQLCOLLATE.EXE
    93 file=ABI_DIR\BUILD_DIR\t_sqlconfigfile.exe          \test\t_sqlconfigfile.exE
    73 file=ABI_DIR\BUILD_DIR\T_SQLTRANS.EXE		\TEST\T_SQLTRANS.EXE
    94 file=ABI_DIR\BUILD_DIR\t_sqldbconfigfile.exe        \test\t_sqldbconfigfile.exe
    74 file=ABI_DIR\BUILD_DIR\T_SQLLOAD.EXE		\TEST\T_SQLLOAD.EXE
    95 file=ABI_DIR\BUILD_DIR\t_sqlcompact1.exe            \test\t_sqlcompact1.exe
    75 file=ABI_DIR\BUILD_DIR\T_SQLGETFIRSTSTMT.EXE	\TEST\T_SQLGETFIRSTSTMT.EXE
    96 file=ABI_DIR\BUILD_DIR\t_sqlcompact2.exe            \test\t_sqlcompact2.exe
    76 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY1.EXE	\TEST\T_SQLSECURITY1.EXE
    97 file=ABI_DIR\BUILD_DIR\t_sqlcompact3.exe            \test\t_sqlcompact3.exe
    77 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY2.EXE	\TEST\T_SQLSECURITY2.EXE
    98 file=ABI_DIR\BUILD_DIR\t_sqlcompact4.exe            \test\t_sqlcompact4.exe
    78 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY3.EXE	\TEST\T_SQLSECURITY3.EXE
    99 file=ABI_DIR\BUILD_DIR\t_sqlblob.exe                \test\t_sqlblob.exe
    79 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY4.EXE	\TEST\T_SQLSECURITY4.EXE
   100 file=ABI_DIR\BUILD_DIR\t_sqlauthorizer.exe          \test\t_sqlauthorizer.exe
    80 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY5.EXE	\TEST\T_SQLSECURITY5.EXE
   101 file=ABI_DIR\BUILD_DIR\t_sqlfilebuf64.exe           \test\t_sqlfilebuf64.exe
    81 file=ABI_DIR\BUILD_DIR\T_SQLSECURITY6.EXE	\TEST\T_SQLSECURITY6.EXE
   102 file=ABI_DIR\BUILD_DIR\t_sqlstartup.exe             \test\t_sqlstartup.exe
    82 file=ABI_DIR\BUILD_DIR\T_SQLATTACH.EXE		\TEST\T_SQLATTACH.EXE
   103 file=ABI_DIR\BUILD_DIR\t_sqldb64.exe                \test\t_sqldb64.exe
    83 file=ABI_DIR\BUILD_DIR\T_SQLATTACH2.EXE		\TEST\T_SQLATTACH2.EXE
   104 file=ABI_DIR\BUILD_DIR\t_sqlfilesrvcrash1.exe       \test\t_sqlfilesrvcrash1.exe
    84 file=ABI_DIR\BUILD_DIR\T_SQLPERFORMANCE.EXE	\TEST\T_SQLPERFORMANCE.EXE
   105 file=ABI_DIR\BUILD_DIR\t_sqlfilesrvcrash2.exe       \test\t_sqlfilesrvcrash2.exe
    85 file=ABI_DIR\BUILD_DIR\T_SQLPERFORMANCE2.EXE	\TEST\T_SQLPERFORMANCE2.EXE
   106 file=ABI_DIR\BUILD_DIR\t_sqlcorrupt.exe             \test\t_sqlcorrupt.exe
    86 file=ABI_DIR\BUILD_DIR\T_SQLPERFORMANCE3.EXE	\TEST\T_SQLPERFORMANCE3.EXE
   107 file=ABI_DIR\BUILD_DIR\t_sqlenvdestroy.exe          \test\t_sqlenvdestroy.exe
    87 file=ABI_DIR\BUILD_DIR\T_SQLPERFORMANCE4.EXE	\TEST\T_SQLPERFORMANCE4.EXE
       
    88 file=ABI_DIR\BUILD_DIR\T_SQLPERFORMANCE5.EXE	\TEST\T_SQLPERFORMANCE5.EXE
       
    89 file=ABI_DIR\BUILD_DIR\T_SQLOOD.EXE		\TEST\T_SQLOOD.EXE
       
    90 file=ABI_DIR\BUILD_DIR\T_SQLOSLAYER.EXE		\TEST\T_SQLOSLAYER.EXE
       
    91 file=ABI_DIR\BUILD_DIR\T_SQLDEFECT.EXE		\TEST\T_SQLDEFECT.EXE
       
    92 file=ABI_DIR\BUILD_DIR\T_SQLDEFECT2.EXE		\TEST\T_SQLDEFECT2.EXE
       
    93 file=ABI_DIR\BUILD_DIR\T_SQLPRIVCAGE.EXE	\TEST\T_SQLPRIVCAGE.EXE
       
    94 file=ABI_DIR\BUILD_DIR\T_SQLBADCLIENT.EXE	\TEST\T_SQLBADCLIENT.EXE
       
    95 file=ABI_DIR\BUILD_DIR\T_SQLBUR.EXE		\TEST\T_SQLBUR.EXE
       
    96 file=ABI_DIR\BUILD_DIR\T_SQLSCALARFULLSELECT.EXE \TEST\T_SQLSCALARFULLSELECT.EXE
       
    97 file=ABI_DIR\BUILD_DIR\T_SQLFSERR.EXE		\TEST\T_SQLFSERR.EXE
       
    98 file=ABI_DIR\BUILD_DIR\T_SQLCONFIG.EXE		\TEST\T_SQLCONFIG.EXE
       
    99 file=ABI_DIR\BUILD_DIR\T_SQLCONFIGFILE.EXE	\TEST\T_SQLCONFIGFILE.EXE
       
   100 file=ABI_DIR\BUILD_DIR\T_SQLDBCONFIGFILE.EXE		\TEST\T_SQLDBCONFIGFILE.EXE
       
   101 file=ABI_DIR\BUILD_DIR\T_SQLCOMPACT1.EXE	\TEST\T_SQLCOMPACT1.EXE
       
   102 file=ABI_DIR\BUILD_DIR\T_SQLCOMPACT2.EXE	\TEST\T_SQLCOMPACT2.EXE
       
   103 file=ABI_DIR\BUILD_DIR\T_SQLCOMPACT3.EXE	\TEST\T_SQLCOMPACT3.EXE
       
   104 file=ABI_DIR\BUILD_DIR\T_SQLCOMPACT4.EXE	\TEST\T_SQLCOMPACT4.EXE
       
   105 file=ABI_DIR\BUILD_DIR\T_SQLBLOB.EXE	\TEST\T_SQLBLOB.EXE
       
   106 file=ABI_DIR\BUILD_DIR\T_SQLAUTHORIZER.EXE \TEST\T_SQLAUTHORIZER.EXE
       
   107 file=ABI_DIR\BUILD_DIR\T_SQLFILEBUF64.EXE 	\TEST\T_SQLFILEBUF64.EXE
       
   108 file=ABI_DIR\BUILD_DIR\T_SQLSTARTUP.EXE 	\TEST\T_SQLSTARTUP.EXE
       
   109 file=ABI_DIR\BUILD_DIR\T_SQLDB64.EXE	\TEST\T_SQLDB64.EXE
       
   110 file=ABI_DIR\BUILD_DIR\T_SQLFILESRVCRASH1.EXE	\TEST\T_SQLFILESRVCRASH1.EXE
       
   111 file=ABI_DIR\BUILD_DIR\T_SQLFILESRVCRASH2.EXE 	\TEST\T_SQLFILESRVCRASH2.EXE
       
   112 file=ABI_DIR\BUILD_DIR\T_SQLCORRUPT.EXE 	\TEST\T_SQLCORRUPT.EXE
       
   113 file=ABI_DIR\BUILD_DIR\T_SQLENVDESTROY.EXE	\TEST\T_SQLENVDESTROY.EXE
       
   114 
   108 
   115 #endif
   109 #endif