Content-Type: text/html
Content-Length: 2098
unique key, no value columns, no options
a
group first
name a
b
group first
name b
c
group second
name c
d
group third
name d
e
group third
name e
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)
first a,b
second c
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]
first a,b
second c
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]
a a
b b
c c
d d
e e
non-unique key, no value columns, options: $.distinct(1) $.type[hash]
first
group first
name a
second
group second
name c
third
group third
name d
non-unique key, no value columns, options: $.distinct(1) (as above because $.type[hash] == default)
first
group first
name a
second
group second
name c
third
group third
name d
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]
first a
second c
third d