Description:
ndb_select_all does not display any information for float or double values stored in
Ndb.
ndb_restore --print_data does not display any information for float or double values
stored in Ndb.
Problem is probably in generic per-type printing code.
Values appear to be printed ok in mysql-5.1-telco-6.3
How to repeat:
mysql> use test
Database changed
mysql> create table yy (a int primary key, b float, c double) engine=ndb;
Query OK, 0 rows affected (1.01 sec)
mysql> insert into yy values (1, 1.1, 1.11);
Query OK, 1 row affected (0.01 sec)
mysql> insert into yy values (2, 2.2, 2.22);
Query OK, 1 row affected (0.00 sec)
mysql> select * from yy;
+---+------+------+
| a | b | c |
+---+------+------+
| 1 | 1.1 | 1.11 |
| 2 | 2.2 | 2.22 |
+---+------+------+
2 rows in set (0.00 sec)
mysql>
>ndb_select_all -dtest yy
a b c
1
2
2 rows returned
NDBT_ProgramExit: 0 - OK
-- NDB Cluster -- Management Client --
ndb_mgm> start backup
Connected to Management Server at: localhost:12500
Waiting for completed, this may take several minutes
Node 1: Backup 1 started from node 3
Node 1: Backup 1 started from node 3 completed
StartGCP: 138 StopGCP: 141
#Records: 2057 #LogRecords: 0
Data: 50872 bytes Log: 0 bytes
ndb_mgm> quit
ndb_restore -n 2 -b 1 --backup_path=var/mysql_cluster.1/BACKUP/BACKUP-1/ --print_data
Nodeid = 2
Backup Id = 1
backup path = var/mysql_cluster.1/BACKUP/BACKUP-1/
Opening file 'var/mysql_cluster.1/BACKUP/BACKUP-1/BACKUP-1.2.ctl'
Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.34 ndb-7.0.7
Stop GCP of Backup: 12740042
Opening file 'var/mysql_cluster.1/BACKUP/BACKUP-1/BACKUP-1-0.2.Data'
_____________________________________________________
Processing data in table: test/def/yy(7) fragment 1
1
2
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(6) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_4_3(5) fragment 1
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(4) fragment 1
NDBT_ProgramExit: 0 - OK
Suggested fix:
Find where problem introduced.
Fix.
Introduce testcase using ndb_select_all and/or ndb_restore to validate type-specific
formatting utilities.
