Bug #45427 Ndb : ndb_select_all and ndb_restore do not display double or float values

• Submitted: 10 Jun 2009 11:21
• Modified: 14 Jun 2012 19:54
• Reporter: Frazer Clement
• Status: Can't repeat
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-7.0
• OS: Any
• CPU Architecture: Any

[10 Jun 2009 11:21] Frazer Clement

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.

[14 Jun 2012 19:54] Sveta Smirnova

This is not repeatable with 7.2.5. anymore:

....
File size 5120 bytes
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_7_3(8) fragment 1
_____________________________________________________
Processing data in table: test/def/yy(10) fragment 1
1	1.100000	1.110000
2	2.200000	2.220000
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(5) fragment 1
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(9) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_head(4) fragment 1
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(7) fragment 1
...