content-type: text/html
content-length: 2098
unique key, no value columns, no options
c
name c
group second
d
name d
group third
e
name e
group third
a
name a
group first
b
name b
group first
non-unique key, no value columns, no options
failed, that's OK.
if key not unique $.distinct(1) must be specified
non-unique key, no value columns, options: $.distinct[tables] (backward)
second c
first a,b
third d,e
non-unique key, no value columns, options: $.distinct[tables], $.type[hash]
failed, that's OK.
$.distinct[tables] and $.type[...] can't be specified together
non-unique key, no value columns, options: $.distinct(1) $.type[table]
second c
first a,b
third d,e
non-unique key, no value columns, options: $.distinct(1) $.type[table]
failed, that's OK.
non unique key without distinct option
unique key, no value columns, options: $.type[table]
c c
d d
e e
a a
b b
non-unique key, no value columns, options: $.distinct(1) $.type[hash]
third
name d
group third
second
name c
group second
first
name a
group first
non-unique key, no value columns, options: $.distinct(1) (as above because $.type[hash] == default)
third
name d
group third
second
name c
group second
first
name a
group first
non-unique key, no value columns, options: $.distinct(1) $.type[string]
failed, that's OK.
with $.type[string] only one field must be specified
non-unique key, one value column (name), options: $.distinct(1) $.type[string]
third d
second c
first a