LibSQL-1.0

What works and what doesn't

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.

You must login to post a comment. Don't have an account? Register to get one!

Facts

Date created
Nov 22, 2010
Last updated
Nov 22, 2010

Author