Tests adjustments for Informix IDS

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run ibm_db tests against Informix IDS database server

What version of the product are you using? On what operating system?

Linux 64 (CentOS), IDS 11.50, 11.70, 12.10 

Please provide any additional information below.

1. test_014_KeysetDrivenCursorNegativeRow

That’s OK, but set env variable to DBMONEY=. if your installation DBMONEY 
default is different.

2. test_024_ForeignKeys

Removed  #No Data Found from expected value for IDS.

3. test_034_FetchAssoc.py
test_061_Tables_02.py
test_115_NumericTest_02.py
test_123_FieldNamePos_01.py
test_150_FetchAssocSelect_01.py
test_151_FetchAssocSelect_02.py
test_152_FetchAssocSelect_03.py
test_153_FetchAssocSelect_04.py
test_154_AllFetches.py
test_156_FetchAssocNestedSelects_01.py
test_158_FetchAssocNestedSelects_02.py
test_159_FetchAssocSeveralRows_01.py
test_159a_FetchAssocSeveralRows_02.py
test_160_FetchBoth.py
test_161_FetchBothNestedSelects_01.py
test_162_FetchBothNestedSelects_02.py
test_261_FetchObjectAccess.py
test_264_InsertRetrieveBIGINTTypeColumn.py
test_265_NoAffectedRows.py

ATTR_CASE is a connection option, setting it with “0” type as a statement 
option raises exception. In all named tests where ATTR_CASE is set for IDS to 
force upper case idents last type parametr to set_option should be set to 1.

4. test_048_FetchTupleBinaryData_02.py

In IDS LENGTH function cannot be used on BLOBS so the test generates 
Exception: [IBM][CLI Driver][IDS/UNIX64] Routine (length) can not be resolved.

5. test_053_AttrThruConn.py

That’s OK, but don’t set ClientUserID property of test data source name in 
db2cli.ini because that will be returned as SQL_ATTR_INFO_USERID.

6. test_060_Tables_01.py
test_061_Tables_02.py
test_062_Tables_03.py
test_064_Tables_05.py
test_065_FilterTableName.py

IDS schema names are case sensitive by default, so if you create schema ‘t’ 
you should refer to it as ‘t’ and expect the same.

7. test_080_ConnWrongDbAlias.py

conn_error on failed connection returnes empty sqlstate string???

8. test_090_ConnmsgWrongDbAlias.py

Error message changed to more verbose:

[IBM][CLI Driver] SQL1531N  The connection failed because the name specified 
with the DSN connection string keyword could not be found in either the 
db2dsdriver.cfg configuration file or the db2cli.ini configuration file.  Data 
source name specified in the connection string: "X". SQLCODE=-1531

9. test_102_NumFieldsSelect_01.py

VALUES(1) syntax error on IDS.

10. test_133_ExecuteLongInputParams.py

Here the results depend if your database is ANSI compliant (expected) or not 
(no error on char values exceeding field length).

11. test_148_CallSPDiffBindPattern_01.py

Here we get a crash from memory fault caused by last procedure param of type 
clob.

12. test_197_StatisticsIndexes.py

As ibm_db.statistics returns result set of information for table itself and 
it’s indexes, you shoud skip row with table info.

13. test_265_NoAffectedRows.py

Replaced inserted xml encoding UTF-8 to expected UTF-16

14. test_6792_FieldTypeRetStrDatetimeTimestamp.py

Corrected time formating in datetime/timestamp values to ansi standard

15. test_InsertRetrieveDateTimeTypeColumn.py

In IDS the default datetime FRACTION precision is 3 so changed col3 fraction 
precision to maximal 5. Because of the IDS maximal fraction precision of 5 
python 1microsecond is discarded so changed it to 10 for IDS.

16. test_017_selectRowcountPrefetchSTMTOpt
test_018_selectRowcountPrefetchSetOpt
test_019_selectRowcountPrefetchPrepOpt
test_060_Tables_01
test_061_Tables_02
test_062_Tables_03
test_064_Tables_05
test_065_FilterTableName
test_080_ConnWrongDbAlias
test_133_ExecuteLongInputParams
test_265_NoAffectedRows

In ANSI MODE data base this tests fail.

Adjustments are available in attached patch and in wlodekf-djangoifx clone of 
the ibm_db repository.

--
Thanks
WAF

Original issue reported on code.google.com by wlod...@gmail.com on 27 Oct 2013 at 10:15

Attachments:

• fix_ids_tests.patch

[GoogleCodeExporter]

Thanks WAF for pointing out this, I will look into this.

Please sign the contribution agreement and mail us the scan copy of signed 
agreement after this only we are able to see you changes.

Original comment by rahul.pr...@in.ibm.com on 28 Oct 2013 at 5:01

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Ok, I've sent it to opendev.

Original comment by wlod...@gmail.com on 28 Oct 2013 at 12:35

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Test adjustment is done and released with ibm_db-2.0.5, 
test_148_CallSPDiffBindPattern_01.py is still causing problem which I will look 
later.

Original comment by rahul.pr...@in.ibm.com on 8 Feb 2014 at 6:57

• Changed state: Accepted
• Added labels: ****
• Removed labels: ****