Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UNIQUE clause is ignored for CREATE TABLE if SYNC clause is not set #15958

Open
weres-sa opened this issue Mar 19, 2025 · 0 comments
Open

UNIQUE clause is ignored for CREATE TABLE if SYNC clause is not set #15958

weres-sa opened this issue Mar 19, 2025 · 0 comments
Labels

Comments

@weres-sa
Copy link
Contributor

Way to reproduce:

CREATE TABLE `unique_sync`
(
    category_id Int64 NOT NULL,
    id Int64,
    name Utf8,
    INDEX idx_global GLOBAL UNIQUE ON (category_id, id),
    PRIMARY KEY (category_id)
)

Expected:
Query succesfully creates table with unique sync index
OR
Query returns an error

Current behavior:
Query succesfully creates table with non-unique sync index

@weres-sa weres-sa changed the title UNIQUE clause is ignored for CREATE TABLE if SYNC cluase is not set UNIQUE clause is ignored for CREATE TABLE if SYNC clause is not set Mar 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants