id.979809.stable.out

一个内存数据库的源代码这是服务器端还有客户端

stdout of test 'ID.979809` in directory 'tests/BugsViaSourgeforce` itself:


# 23:38:15 >  
# 23:38:15 >  Mtimeout -timeout 60 Mserver "--config=/var/tmp/_4.3.18_PREFIX__GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_4.3.18_PREFIX__GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_4.3.18_PREFIX__GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_4.3.18_PREFIX__GNU_32_d__/var/MonetDB/log" --set mapi_port=48719 --set sql_port=55270 --set monet_prompt= --trace --dbname=mTests_tests_BugsViaSourgeforce  < ID.979809.milS
# 23:38:15 >  

# Monet Database Server V4.3.18_rc03
# Copyright (c) 1993-2004, CWI. All rights reserved.
# Compiled for i686-pc-linux-gnu/32bit; dynamically linked.
# Visit http://monetdb.cwi.nl for further information.
module("unix");
module(ascii_io);

var cwd := getenv("TSTTRGDIR");
var word_file := sprintf("%s/ID.979809.txt", cwd);


var word_table:= new(oid,str);
word_table.import(word_file);

print("selecting 'nil' words. The result should be 2");
[ "selecting 'nil' words. The result should be 2" ]
word_table.select("nil").count().print();    # should be 2 and it is 0
[ 2 ]

print("selecting nil values. The result should be 0");
[ "selecting nil values. The result should be 0" ]
word_table.select(str(nil)).count().print();    # should be 1 and it is 3
[ 1 ]

print("the table imported");
[ "the table imported" ]
word_table.print();    # the "nil" words are converted to nil values     
#-------------------------#
# h	tmp_29		  # name
# oid	str		  # type
#-------------------------#
[ 0@0,	  "hello"	  ]
[ 1@0,	  "nil"		  ]
[ 2@0,	  "world"	  ]
[ 3@0,	  nil		  ]
[ 4@0,	  "bye"		  ]
[ 5@0,	  "nil"		  ]
[ 6@0,	  "world"	  ]


var names := new(void,str).seqbase(0@0);
names.insert(oid(nil),"one");
names.insert(oid(nil),"two");
var seps := new(void,str).seqbase(0@0);
seps.insert(oid(nil),",");
seps.insert(oid(nil),"\n");
var types := new(void,str).seqbase(0@0);
types.insert(oid(nil),"oid");
types.insert(oid(nil),"str");

var bats := load( names, seps, types, word_file, -1);
print(bats.find("one"),bats.find("two"));
#---------------------------------#
# h	tmp_34	tmp_33		  # name
# void	oid	str		  # type
#---------------------------------#
[ 0@0,	  0@0,	  "hello"	  ]
[ 1@0,	  1@0,	  "nil"		  ]
[ 2@0,	  2@0,	  "world"	  ]
[ 3@0,	  3@0,	  nil		  ]
[ 4@0,	  4@0,	  "bye"		  ]
[ 5@0,	  5@0,	  "nil"		  ]
[ 6@0,	  6@0,	  "world"	  ]


quit();

# 23:38:16 >  
# 23:38:16 >  Done.
# 23:38:16 >