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_char.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

# CHAR
--source include/have_ndb.inc
--source suite/ndb_memcache/include/have_memcache.inc
--source suite/ndb_memcache/include/memcached_wait_for_ready.inc
--source suite/ndb_memcache/include/datatypes_tables.inc

--perl

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

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

# Use a binary protocol connection (so keys can contain spaces)
my $mc = My::Memcache::Binary->new();  
my $r = $mc->connect("localhost",$port);

# test CHAR key with VARCHAR value
$mc->set("tck:a","fred")               || $mc->fail("FAILED # 01 (SET)");
$mc->set("tck:1","frederick")          || $mc->fail("FAILED # 02 (SET)");
$mc->set("tck:aa","frederica")         || $mc->fail("FAILED # 03 (SET)");
$mc->set("tck:a b c d","freddy")       || $mc->fail("FAILED # 04 (SET)");
  
($mc->get("tck:aa") == "frederica")    || $mc->fail("FAILED # 05 (GET)");
($mc->get("tck:a b c d") == "freddy")  || $mc->fail("FAILED # 06 (GET)");

# test VARCHAR key with CHAR value
$mc->set("tcv:a", "al")                || $mc->fail("FAILED # 07 (SET)");
$mc->set("tcv:b", "alphonse")          || $mc->fail("FAILED # 08 (SET)");
$mc->set("tcv:c", "allen")             || $mc->fail("FAILED # 09 (SET)");
$mc->set("tcv:d", "alien invasion")    || $mc->fail("FAILED # 10 (SET)");

($mc->get("tcv:d") == "alien invasion")|| $mc->fail("FAILED # 11 (GET)");
($mc->get("tcv:a") == "al")            || $mc->fail("FAILED # 12 (GET)");
($mc->get("tcv:ee") == "NOT_FOUND")    || $mc->fail("FAILED # 13 (GET)");

EOF

--sorted_result
SELECT * FROM ndbmemcache.test_char_key;

--sorted_result
SELECT * FROM ndbmemcache.test_char_val;

${this.title}

Code Editor : type_char.test