Gecko [ www.jdcpatala.org ]

Name	Size	Permission
basic.test	851 B	-rw-r--r--
disabled.def	0 B	-rw-r--r--
external_values.test	8.12 KB	-rw-r--r--
lib_ascii.test	2.1 KB	-rw-r--r--
lib_binary.test	2.04 KB	-rw-r--r--
math1.test	806 B	-rw-r--r--
math2.test	961 B	-rw-r--r--
math3.test	1.36 KB	-rw-r--r--
mpart_key.test	1.29 KB	-rw-r--r--
reconf1.test	1.66 KB	-rw-r--r--
tsv1.test	940 B	-rw-r--r--
tsv2.test	1.41 KB	-rw-r--r--
ttls_flags.test	1.65 KB	-rw-r--r--
type_binary.test	740 B	-rw-r--r--
type_char.test	1.83 KB	-rw-r--r--
type_numeric.test	1.46 KB	-rw-r--r--
type_signed.test	1.17 KB	-rw-r--r--
type_temporal.test	2.61 KB	-rw-r--r--
type_unsigned.test	2.03 KB	-rw-r--r--
unique_idx.test	3.2 KB	-rw-r--r--

Code Editor : type_numeric.test

# The include statement below is a temp one for tests that are yet to
#be ported to run with InnoDB,
#but needs to be kept for tests that would need MyISAM in future.
--source include/force_myisam_default.inc

--source include/have_ndb.inc
--source suite/ndb_memcache/include/have_memcache.inc

# Basic data type tests for 
# tt007 float
# tt008 double
# tt009 decimal

--source suite/ndb_memcache/include/datatypes_tables.inc
--perl

use strict;
use lib "lib";
use My::Memcache;

my $port = $ENV{NDB_MEMCACHED_1_PORT} or die "Need NDB_MEMCACHED_1_PORT";

my $mc = My::Memcache::Binary->new();
my $r = $mc->connect("localhost",$port);

foreach my $test ("tt007", "tt008", "tt009") {
  print "Table $test: \n";
  
  $mc->set("$test:0"  ,  0)            || die;  # zero
  $mc->set("$test:1"  , 0.5)           || die;  # fractional value
  $mc->set("$test:2"  , -1)            || die;  # negative value
  $mc->set("$test:3"  , -3.55)         || die;  # negative fractional value
  $mc->set("$test:3.6", -15559.41)     || die;  # fractional key
  $mc->set("$test:-11", 1500.01)       || die;  # negative key
  
  print "   " . $mc->get("$test:-11") . "\n";
  print "   " . $mc->get("$test:0")   . "\n";
  print "   " . $mc->get("$test:1")   . "\n";
  print "   " . $mc->get("$test:2")   . "\n";
  print "   " . $mc->get("$test:3")   . "\n";
  print "   " . $mc->get("$test:3.6") . "\n";
}

EOF

SELECT * FROM tt007 order by mkey;
SELECT * FROM tt008 order by mkey;
SELECT * FROM tt009 order by mkey;

${this.title}

Code Editor : type_numeric.test