WowAce

Latest revision checked: r16.

CREATE

Works:

• Creating tables using either db:Create(tablename) or db:Execute("CREATE tablename (fields)")

Doesn't work:

• Multiple field flags

DROP

Works:

• DROP tablename

TRUNCATE

Works:

• TRUNCATE tablename

UPDATE

Works:

• UPDATE tablename SET fielda = "data", fieldb = 123, fieldc = function(moo) WHERE clause SORT BY stuff LIMIT a,b
• tbl:Find("clause"):Update({ fielda = "data", fieldb = 123, fieldc = function(moo)})

Doesn't work:

REMOVE

Works:

• REMOVE FROM tablename WHERE clause SORT BY stuff LIMIT a,b
• tbl:Find(clause)[[:Sort(direction)]:Limit(a,b)]:Remove()

Doesn't work:

SELECT

Works:

• SELECT fielda, fieldb as fieldc, function(args), function(args) as fieldd FROM tablename WHERE clause SORT BY stuff LIMIT a,b
• tbl:Find(clause)[[:Sort(direction)]:Limit(a,b)]:Select(fields)

Doesn't work:

FOLD

Works: Nothing yet.