Test: /ext/mysqli/tests/mysqli_fetch_field_flags.phpt - Version 5.6.0    

There are 6 different diffs reported by users for this test.

Count Diff
1 (17%)
001+ [007] The flags 'ZEROFILL' have not been reported for TIMESTAMP NOT NULL, found 'ON_UPDATE_NOW TIMESTAMP BINARY UNSIGNED NOT_NULL '
001- done!
002+ string(50) "CREATE TABLE test(id INT, col1 TIMESTAMP NOT NULL)"
003+ int(50565)
004+ ZEROFILL
1 (17%)
001+ [007] The flags 'ZEROFILL' have not been reported for TIMESTAMP NOT NULL, found 'ON_UPDATE_NOW TIMESTAMP BINARY UNSIGNED NOT_NULL '
001- done!
002+ string(50) "CREATE TABLE test(id INT, col1 TIMESTAMP NOT NULL)"
003+ int(50505)
004+ ZEROFILL
1 (17%)
001+ [006] Found unexpected flags 'NO_DEFAULT_VALUE ' for TIMESTAMP NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL ' with MySQL 50620'
001- done!
002+ [007] The flags 'ON_UPDATE_NOW TIMESTAMP ON_UPDATE_NOW' have not been reported for TIMESTAMP NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL '
003+ string(50) "CREATE TABLE test(id INT, col1 TIMESTAMP NOT NULL)"
004+ int(50620)
005+ ON_UPDATE_NOW TIMESTAMP ON_UPDATE_NOW
1 (17%)
001+ [006] Found unexpected flags 'NO_DEFAULT_VALUE ' for TIMESTAMP NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL ' with MySQL 50612'
001- done!
002+ [007] The flags 'ON_UPDATE_NOW TIMESTAMP ON_UPDATE_NOW' have not been reported for TIMESTAMP NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL '
003+ string(50) "CREATE TABLE test(id INT, col1 TIMESTAMP NOT NULL)"
004+ int(50612)
005+ ON_UPDATE_NOW TIMESTAMP ON_UPDATE_NOW
1 (17%)
001+ [006] Found unexpected flags 'BINARY ' for CHAR(1) DEFAULT NULL, found 'BINARY ' with MySQL 100100'
001- done!
002+ [006] Found unexpected flags 'BINARY ' for CHAR(1) NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL ' with MySQL 100100'
003+ [006] Found unexpected flags 'UNSIGNED ' for TIMESTAMP NOT NULL, found 'ON_UPDATE_NOW TIMESTAMP BINARY UNSIGNED NOT_NULL ' with MySQL 100100'
004+ [006] Found unexpected flags 'BINARY ' for TEXT, found 'BINARY BLOB ' with MySQL 100100'
005+ [006] Found unexpected flags 'BINARY ' for TINYTEXT, found 'BINARY BLOB ' with MySQL 100100'
006+ [006] Found unexpected flags 'BINARY ' for MEDIUMTEXT, found 'BINARY BLOB ' with MySQL 100100'
007+ [006] Found unexpected flags 'BINARY ' for LONGTEXT, found 'BINARY BLOB ' with MySQL 100100'
008+ [006] Found unexpected flags 'BINARY ' for SET("one", "two"), found 'SET BINARY ' with MySQL 100100'
009+ [006] Found unexpected flags 'BINARY ' for SET("one", "two") NOT NULL, found 'NO_DEFAULT_VALUE SET BINARY NOT_NULL ' with MySQL 100100'
010+ [006] Found unexpected flags 'BINARY ' for SET("one", "two") NOT NULL DEFAULT "one", found 'SET BINARY NOT_NULL ' with MySQL 100100'
011+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two"), found 'ENUM BINARY ' with MySQL 100100'
012+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two") NOT NULL, found 'NO_DEFAULT_VALUE ENUM BINARY NOT_NULL ' with MySQL 100100'
013+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two") NOT NULL DEFAULT "one", found 'ENUM BINARY NOT_NULL ' with MySQL 100100'
014+ [006] Found unexpected flags 'BINARY ' for VARCHAR(2) NOT NULL PRIMARY KEY, found 'PART_KEY NO_DEFAULT_VALUE BINARY PRI_KEY NOT_NULL ' with MySQL 100100'
015+ [011] Found unexpected flags 'BINARY ' for col1, found 'PART_KEY BINARY MULTIPLE_KEY '
016+ [011] Found unexpected flags 'BINARY ' for col2, found 'PART_KEY BINARY '
017+ done!
1 (17%)
001+ Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50173 Library:50636 in /root/php-5.6.0/ext/mysqli/tests/connect.inc on line 94