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

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

Count Diff
18 (55%)
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(50536)
004+ ZEROFILL
4 (12%)
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(50546)
004+ ZEROFILL
2 (6%)
001+ [006] Found unexpected flags 'NO_DEFAULT_VALUE ' for TIMESTAMP NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL ' with MySQL 50614'
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(50614)
005+ ON_UPDATE_NOW TIMESTAMP ON_UPDATE_NOW
2 (6%)
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
2 (6%)
001+ [006] Found unexpected flags 'BINARY ' for CHAR(1) DEFAULT NULL, found 'BINARY ' with MySQL 50616'
001- done!
002+ [006] Found unexpected flags 'BINARY ' for CHAR(1) NOT NULL, found 'NO_DEFAULT_VALUE BINARY NOT_NULL ' with MySQL 50616'
003+ [006] Found unexpected flags 'BINARY ' for TEXT, found 'BINARY BLOB ' with MySQL 50616'
004+ [006] Found unexpected flags 'BINARY ' for TINYTEXT, found 'BINARY BLOB ' with MySQL 50616'
005+ [006] Found unexpected flags 'BINARY ' for MEDIUMTEXT, found 'BINARY BLOB ' with MySQL 50616'
006+ [006] Found unexpected flags 'BINARY ' for LONGTEXT, found 'BINARY BLOB ' with MySQL 50616'
007+ [006] Found unexpected flags 'BINARY ' for SET("one", "two"), found 'SET BINARY ' with MySQL 50616'
008+ [006] Found unexpected flags 'BINARY ' for SET("one", "two") NOT NULL, found 'NO_DEFAULT_VALUE SET BINARY NOT_NULL ' with MySQL 50616'
009+ [006] Found unexpected flags 'BINARY ' for SET("one", "two") NOT NULL DEFAULT "one", found 'SET BINARY NOT_NULL ' with MySQL 50616'
010+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two"), found 'ENUM BINARY ' with MySQL 50616'
011+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two") NOT NULL, found 'NO_DEFAULT_VALUE ENUM BINARY NOT_NULL ' with MySQL 50616'
012+ [006] Found unexpected flags 'BINARY ' for ENUM("one", "two") NOT NULL DEFAULT "one", found 'ENUM BINARY NOT_NULL ' with MySQL 50616'
013+ [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 50616'
014+ [011] Found unexpected flags 'BINARY ' for col1, found 'PART_KEY BINARY MULTIPLE_KEY '
015+ [011] Found unexpected flags 'BINARY ' for col2, found 'PART_KEY BINARY '
016+ done!
1 (3%)
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(50562)
004+ ZEROFILL
1 (3%)
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(50557)
004+ ZEROFILL
1 (3%)
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(50556)
004+ ZEROFILL
1 (3%)
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(50544)
004+ ZEROFILL
1 (3%)
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(50533)
004+ ZEROFILL