Peter Gulutzan

Lua privilege granting for SQL

2

We depend on Lua/NoSQL for privileges, since GRANT/REVOKE are not implemented. But even if privileges are granted, we can't create tables (perhaps only 'admin' can create tables). On Terminal #1...

WEEKDAY and LOCALTIME functions in SQL

2

Some problems with date and time functions in SQL. These are not SQL-standard functions and I don't know of any other product that has similar syntax, but there are other...

String literals in SQL

4

Possible problems with string literals in SQL statements. Numeric literals may be quoted, one cannot depend on the presence or absence of quote marks to determine whether a literal is...

I have Ubuntu 18.04. I have Tarantool 2.5, pulled from source today. I execute these requests: box.execute([[DROP TABLE add;]]) s="" s = "CREATE TABLE add (c0 INT PRIMARY KEY" for...

Error message when altering a non-empty table

3

I have Ubuntu 20.04. I have Tarantool 2.7 pulled from source. I execute these statements: ```sql CREATE TABLE t1 (s1 INT PRIMARY KEY); INSERT INTO t1 VALUES (1); ALTER TABLE...