Bug #60064 [Opn->Asn]: constants SQLSRV_NULLABLE_YES, SQLSRV_NULLABLE_NO are reversed!

From: Date: Sat, 15 Oct 2011 17:35:01 +0000
Subject: Bug #60064 [Opn->Asn]: constants SQLSRV_NULLABLE_YES, SQLSRV_NULLABLE_NO are reversed!
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-164342@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=60064&edit=1

 ID:                 60064
 Updated by:         felipe@php.net
 Reported by:        android at mikedev dot com
 Summary:            constants SQLSRV_NULLABLE_YES, SQLSRV_NULLABLE_NO
                     are reversed!
-Status:             Open
+Status:             Assigned
 Type:               Bug
 Package:            sqlsrv
 Operating System:   Windows 2003/2008
 PHP Version:        5.3.8
-Assigned To:        
+Assigned To:        jguerin
 Block user comment: N
 Private report:     N



Previous Comments:
------------------------------------------------------------------------
[2011-10-14 15:40:44] android at mikedev dot com

Description:
------------
---
From manual page: http://www.php.net/function.sqlsrv-field-metadata#refsect1-function.sqlsrv-field-metadata-returnvalues
---

constants SQLSRV_NULLABLE_YES, SQLSRV_NULLABLE_NO are actually reversed!

in my database, I set a field that is 'NOT NULL',
sqlsrv_field_metadata() reports it is SQLSRV_NULLABLE_YES and vice versa for the SQLSRV_NULLABLE_NO.

Test script:
---------------
// open database and make connection, etc.
// select * from mytable
// etc.


foreach( sqlsrv_field_metadata($stmt) as $fieldMetadata ) {
  print($fieldMetadata['Name'] . " is ");
  if ( $fieldMetadata['Nullable'] === SQLSRV_NULLABLE_YES )
    print("NULLABLE_YES\n");
  else if ( $fieldMetadata['Nullable'] === SQLSRV_NULLABLE_NO )
    print("NULLABLE_NO\n");
  else
    print("NULLABLE_UNKNOWN\n");
}


Expected result:
----------------
field1 is NULLABLE_YES
field2 is NULLABLE_NO
field3 is NULLABLE_NO


Actual result:
--------------
field1 is NULLABLE_NO
field2 is NULLABLE_YES
field3 is NULLABLE_YES



------------------------------------------------------------------------



-- 
Edit this bug report at https://bugs.php.net/bug.php?id=60064&edit=1

Thread (3 messages)

« previous php.bugs (#164342) next »