[Monetdb-developers] incorrectly marked keyed

Stefan Manegold Stefan.Manegold at cwi.nl
Wed Jan 17 09:10:48 CET 2007


Henning,

- you print the BAT *after* BATpropcheck has complained about (and fixed!)
  wrong properties

- it might be either head or tail that BATpropcheck complains about 
  (internally, it checks only on head, but it's called for B & reverse(B))

- void columns are only key in case the seqbase is not NIL

- who/which code generates the BAT?

Stefan

On Wed, Jan 17, 2007 at 09:04:55AM +0100, Henning Rode wrote:
> I don't really understand the monetdb warning below, which I get when
> running test cases for pf/tijah. it's actually nice that monetdb
> performs all these BATpropchecks when running the test cases, but what's
> actually the problem here? I printed the BAT and its info() now to check
> myself, but can't find any problem. A void-headed BAT will always be
> keyed, or not?
> 
> best -henning
> 
> # Shredded 1 XML document (dilbert.xml), total time after commit=0.007s
> !WARNING: BATpropcheck: BAT tj_testcoll1_size1(-79) was incorrectly
> marked keyed!
> bat("tj_testcoll1_size1").info().print();
> #-------------------------------------------------#
> # h                     t                         # name
> # str                   str                       # type
> #-------------------------------------------------#
> [ "version",              "25105"                 ]
> [ "batId",                "tj_testcoll1_size1"    ]
> [ "batCacheid",           "79"                    ]
> [ "batParentid",          "0"                     ]
> [ "batSharecnt",          "0"                     ]
> [ "head",                 "void"                  ]
> [ "tail",                 "int"                   ]
> [ "batPersistence",       "persistent"            ]
> [ "batRestricted",        "read-only"             ]
> [ "batRefcnt",            "1"                     ]
> [ "batLRefcnt",           "2"                     ]
> [ "batDirty",             "clean"                 ]
> [ "batSet",               "0"                     ]
> [ "void_tid",             "1"                     ]
> [ "void_cnt",             "1"                     ]
> [ "hsorted",              "65"                    ]
> [ "hident",               "h"                     ]
> [ "hdense",               "1"                     ]
> [ "hseqbase",             "1 at 0"                   ]
> [ "hkey",                 "1"                     ]
> [ "hloc",                 "0"                     ]
> [ "hvarsized",            "1"                     ]
> [ "halign",               "1013524"               ]
> [ "hnosorted",            "0"                     ]
> [ "hnosorted_rev",        "0"                     ]
> [ "hnodense",             "0"                     ]
> [ "hnokey[0]",            "0"                     ]
> [ "hnokey[1]",            "0"                     ]
> [ "tident",               "t"                     ]
> [ "tdense",               "0"                     ]
> [ "tseqbase",             "0 at 0"                   ]
> [ "tsorted",              "0"                     ]
> [ "tkey",                 "0"                     ]
> [ "tloc",                 "0"                     ]
> [ "tvarsized",            "0"                     ]
> [ "talign",               "1013523"               ]
> [ "tnosorted",            "1"                     ]
> [ "tnosorted_rev",        "0"                     ]
> [ "tnodense",             "0"                     ]
> [ "tnokey[0]",            "3"                     ]
> [ "tnokey[1]",            "6"                     ]
> [ "batInserted",          "44"                    ]
> [ "batDeleted",           "0"                     ]
> [ "batFirst",             "0"                     ]
> [ "top",                  "44"                    ]
> [ "batStamp",             "-784"                  ]
> [ "lastUsed",             "621603"                ]
> [ "curStamp",             "1210"                  ]
> [ "batCopiedtodisk",      "1"                     ]
> [ "batDirtydesc",         "clean"                 ]
> [ "batDirtybuns",         "clean"                 ]
> [ "batBuns.free",         "176"                   ]
> [ "batBuns.size",         "4096"                  ]
> [ "batBuns.maxsize",      "4096"                  ]
> [ "batBuns.storage",      "malloced"              ]
> [ "batBuns.filename",     "01/117.buns"           ]
> [ "hheapdirty",           "clean"                 ]
> [ "theapdirty",           "clean"                 ]
> bat("tj_testcoll1_size1").print();
> #-----------------#
> # h     t         # name
> # void  int       # type
> #-----------------#
> [ 1 at 0,    43      ]
> [ 2 at 0,    11      ]
> [ 3 at 0,    1       ]
> [ 4 at 0,    0       ]
> [ 5 at 0,    8       ]
> [ 6 at 0,    3       ]
> [ 7 at 0,    0       ]
> [ 8 at 0,    0       ]
> [ 9 at 0,    0       ]
> [ 10 at 0,   3       ]
> [ 11 at 0,   0       ]
> [ 12 at 0,   0       ]
> [ 13 at 0,   0       ]
> [ 14 at 0,   12      ]
> [ 15 at 0,   1       ]
> [ 16 at 0,   0       ]
> [ 17 at 0,   9       ]
> [ 18 at 0,   1       ]
> [ 19 at 0,   0       ]
> [ 20 at 0,   6       ]
> [ 21 at 0,   0       ]
> [ 22 at 0,   0       ]
> [ 23 at 0,   0       ]
> [ 24 at 0,   0       ]
> [ 25 at 0,   0       ]
> [ 26 at 0,   0       ]
> [ 27 at 0,   17      ]
> [ 28 at 0,   1       ]
> [ 29 at 0,   0       ]
> [ 30 at 0,   6       ]
> [ 31 at 0,   3       ]
> [ 32 at 0,   0       ]
> [ 33 at 0,   0       ]
> [ 34 at 0,   0       ]
> [ 35 at 0,   1       ]
> [ 36 at 0,   0       ]
> [ 37 at 0,   7       ]
> [ 38 at 0,   1       ]
> [ 39 at 0,   0       ]
> [ 40 at 0,   4       ]
> [ 41 at 0,   0       ]
> [ 42 at 0,   0       ]
> [ 43 at 0,   0       ]
> [ 44 at 0,   0       ]
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> 
> 

-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold at cwi.nl |
| CWI,  P.O.Box 94079 | http://www.cwi.nl/~manegold/  |
| 1090 GB Amsterdam   | Tel.: +31 (20) 592-4212       |
| The Netherlands     | Fax : +31 (20) 592-4312       |




More information about the developers-list mailing list