Bug #80091 mysql_cluster_backup_privileges causes incorrect datetime on bigendian

• Submitted: 21 Jan 2016 8:58
• Modified: 4 May 2016 7:55
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 7.5.1
• OS: Any
• CPU Architecture: Any

[21 Jan 2016 8:58] Magnus Blåudd

Description:
The ndb_dist_priv and ndb_rpl_dist_priv tests fails on Solaris 11 since the  mysql.mysql_cluster_backup_privileges() procedure uses '0000-00-00 00:00:00' as value for a timestamp column.

This has something to do with changes to default sql_mode being used in 5.7 but it's interesting to see that it fails only on Solaris Sparc.

How to repeat:
solaris11> mtr ndb_dist_priv
<snip>
ndb.ndb_dist_priv                        w1 [ fail ]
Test ended at 2016-01-21 06:01:43 CURRENT_TEST: ndb.ndb_dist_priv mysqltest: At line 156: query 'call mysql.mysql_cluster_backup_privileges()' failed: 1292: Incorrect datetime value: '0000-00-00 00:00:00' for column 'Timestamp' at row 1

Suggested fix:
Change procedure so that a valid value is used by the mysql_cluster_backup_privileges() procedure.

[4 May 2016 7:55] Jon Stephens

Fixed in NDB 7.5.1. Fix in testing/tools only. Closed.