Repository-Metriken
- Stars
- (3.633 Sterne)
- PR-Merge-Metriken
- (Durchschn. Merge 13T 2h) (82 gemergte PRs in 30 T)
Beschreibung
I have Ubuntu 18.04. I have Tarantool 2.1, pulled from source today.
I execute these requests: CREATE TABLE f (s1 CHAR(1) PRIMARY KEY); CREATE INDEX i ON f (s1); PRAGMA index_info(f.i); CREATE TABLE g (s1 CHAR(1) COLLATE "BINARY");
The PRAGMA statement says that the collation is BINARY (upper case). The CREATE TABLE g statement says that there is no such collation as BINARY (upper case).
The correct name is binary (lower case), as seen in PRAGMA collation_list.
Also, the PRAGMA statement says the data type is "string" -- why not CHAR?
Also, the PRAGMA statement would say that the collation of an integer column is BINARY -- why not NULL or 'none'? I don't know what 'none' means, so I'm not sure whether it is correct, but I know what 'binary' means, and it won't work on integers (assuming MessagePack high-endian storage and assuming unsigned but not assuming everything has the same length).