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_unsigned.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 
# TINYINT   UNSIGNED   tt013
# SMALLINT  UNSIGNED   tt014
# MEDIUMINT UNSIGNED   tt015
# INT       UNSIGNED   tt016
# BIGINT    UNSIGNED   tt017

--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->new();
my $r = $mc->connect("localhost",$port);

foreach my $test ( "tt013", "tt014", "tt015", "tt016", "tt017") {
    
  $mc->set("$test:0" ,  0);
  $mc->set("$test:1" ,  1);
  $mc->set("$test:2" ,  2);
  
  # Test that you can't store -1 in an unsigned column
  $mc->set("$test:-1", -1);
  ($mc->{error} eq "VALUE_TOO_LARGE") || die "$test:-1 " . $mc->{error};
  
  ($mc->get("$test:0") == 0)   || die "get failed $test/0";
  ($mc->get("$test:1") == 1)   || die "get failed $test/1";
  
}
  
# Overflow tests 
($mc->set("tt013:3", 300) == 0)  || die "expected overflow (TINY)";
($mc->{error} eq "VALUE_TOO_LARGE") || die $mc->{error};

($mc->set("tt014:3", 80000) == 0)  || die "expected overflow (SMALL)";
($mc->{error} eq "VALUE_TOO_LARGE") || die $mc->{error};

($mc->set("tt015:3", 40000000) == 0)  || die "expected overflow (MEDIUM)";
($mc->{error} eq "VALUE_TOO_LARGE") || die $mc->{error};

#  INT overflow test is disabled because strotoul() on linux does not
#  set ERANGE as the spec says it should.  Therefore as currently implemented
#  overflow detection is unreliable.
#  ($mc->set("tt016:3", 2**34) == 0)  || die "expected overflow (INT)";
#  ($mc->{error} eq "VALUE_TOO_LARGE") || die $mc->{error};

EOF

SELECT * FROM tt013 order by mkey;
SELECT * FROM tt014 order by mkey;
SELECT * FROM tt015 order by mkey;
SELECT * FROM tt016 order by mkey;
SELECT * FROM tt017 order by mkey;

${this.title}

Code Editor : type_unsigned.test