Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - Cassandra |
| Version | 14.0 |
Replace 'UUID' with a real UUID value in Cassandra
To reproduce:
1. Create a table with below SQL
2. Right click on the newly created table and Select option Script to Window-> Insert. A string UUID is displayed instead of a real UUID.
3. Is it possible to create random UUIDs ?
CREATE TABLE t_uuid (
id int,
name_uuid uuid,
GO
INSERT INTO t_uuid(id, name_uuid)
VALUES(0, UUID)
GO
We will not be generating UUID(s). If there is a server side function in Cassandra to generate UUID that we can call, let me know and we can evaluate further.
Cassandra supports two UUID data types: 'uuid' and 'timeuuid'. There are several kinds of UUIDs:
http://en.wikipedia.org/wiki/Universally_unique_identifier
Based on the test I did a while ago, Cassandra 'uuid' data type only accepts Type 1 UUID and Type 3 UUID. Cassandra 'timeuuid' data type is Type 1 UUID. If we want to support this feature, the generated UUID needs to be a Type 1 UUID.
Cassandra supports two UUID data types: 'uuid' and 'timeuuid'. There are several kinds of UUIDs:
http://en.wikipedia.org/wiki/Universally_unique_identifier
Based on the test I did a while ago, Cassandra 'uuid' data type only accepts Type 1 UUID and Type 3 UUID. Cassandra 'timeuuid' data type is Type 1 UUID. If we want to support this feature, the generated UUID needs to be a Type 1 UUID.
Issue #10283 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #10161
Issue #10161Cassandra: value of timeuuid and uuid cannot be quoted in the generated script on 1.2.3+ servers |
We will not be generating UUID(s). If there is a server side function in Cassandra to generate UUID that we can call, let me know and we can evaluate further.