<commit_before>CREATE TABLE nocapped (
id INTEGER NOT NULL, 
wage INTEGER not null,
dept INTEGER NOT NULL
);

CREATE TABLE capped0 (
id INTEGER NOT NULL, 
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit0 LIMIT PARTITION ROWS 0
);

CREATE TABLE capped2 (
id INTEGER NOT NULL, 
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit2 LIMIT PARTITION ROWS 2
);

CREATE TABLE capped3 (
id INTEGER NOT NULL, 
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit3 LIMIT PARTITION ROWS 3
);

<<<<<<< HEAD
CREATE TABLE capped3_limit_rows_exec (
purge_me TINYINT DEFAULT 0 NOT NULL,
wage INTEGER NOT NULL PRIMARY KEY,
dept INTEGER NOT NULL,
CONSTRAINT tblimit3_exec LIMIT PARTITION ROWS 3
  EXECUTE (DELETE FROM capped3_limit_rows_exec WHERE purge_me <> 0)
);

=======
>>>>>>> master
CREATE TABLE RTABLE (
    ID INTEGER DEFAULT 0 NOT NULL,
    AGE INTEGER NOT NULL,
    WAGE FLOAT NOT NULL,
    NAME VARCHAR(32) DEFAULT NULL,
    CITY VARCHAR(300) DEFAULT NULL,
    CONSTRAINT PK_RTABLE PRIMARY KEY (ID)
);

CREATE INDEX RTABLE_INDEX_1 ON RTABLE (AGE);
CREATE INDEX RTABLE_INDEX_2 ON RTABLE (NAME);
CREATE INDEX RTABLE_INDEX_3 ON RTABLE (WAGE, substring(name, 0,1));

CREATE VIEW V_RTABLE (V_AGE, V_CITY, V_CNT, V_SUM_AGE, V_MIN_WAGE)
    AS SELECT AGE, CITY, COUNT(*), SUM(WAGE), MIN(WAGE)  
    FROM RTABLE  GROUP BY AGE, CITY;


CREATE TABLE PTABLE (
    ID INTEGER DEFAULT 0 NOT NULL,
    AGE INTEGER NOT NULL,
    WAGE FLOAT NOT NULL,
    NAME VARCHAR(32) DEFAULT NULL,
    CITY VARCHAR(300) DEFAULT NULL,
    CONSTRAINT PK_PTABLE PRIMARY KEY (ID)
);
PARTITION TABLE PTABLE ON COLUMN ID;

CREATE INDEX PTABLE_INDEX_1 ON PTABLE (AGE);
CREATE INDEX PTABLE_INDEX_2 ON PTABLE (NAME);
CREATE INDEX PTABLE_INDEX_3 ON PTABLE (WAGE, substring(name, 0,1));

CREATE VIEW V_PTABLE (V_AGE, V_CITY, V_CNT, V_SUM_AGE, V_MIN_WAGE)
    AS SELECT AGE, CITY, COUNT(*), SUM(WAGE), MIN(WAGE)  
    FROM PTABLE  GROUP BY AGE, CITY;<commit_msg>Fix sqlfeatures-new-ddl.sql after incomplete merge<commit_after>CREATE TABLE nocapped (
id INTEGER NOT NULL,
wage INTEGER not null,
dept INTEGER NOT NULL
);

CREATE TABLE capped0 (
id INTEGER NOT NULL,
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit0 LIMIT PARTITION ROWS 0
);

CREATE TABLE capped2 (
id INTEGER NOT NULL,
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit2 LIMIT PARTITION ROWS 2
);

CREATE TABLE capped3 (
id INTEGER NOT NULL,
wage INTEGER not null,
dept INTEGER NOT NULL,
CONSTRAINT tblimit3 LIMIT PARTITION ROWS 3
);

CREATE TABLE capped3_limit_rows_exec (
purge_me TINYINT DEFAULT 0 NOT NULL,
wage INTEGER NOT NULL PRIMARY KEY,
dept INTEGER NOT NULL,
CONSTRAINT tblimit3_exec LIMIT PARTITION ROWS 3
  EXECUTE (DELETE FROM capped3_limit_rows_exec WHERE purge_me <> 0)
);

CREATE TABLE RTABLE (
    ID INTEGER DEFAULT 0 NOT NULL,
    AGE INTEGER NOT NULL,
    WAGE FLOAT NOT NULL,
    NAME VARCHAR(32) DEFAULT NULL,
    CITY VARCHAR(300) DEFAULT NULL,
    CONSTRAINT PK_RTABLE PRIMARY KEY (ID)
);

CREATE INDEX RTABLE_INDEX_1 ON RTABLE (AGE);
CREATE INDEX RTABLE_INDEX_2 ON RTABLE (NAME);
CREATE INDEX RTABLE_INDEX_3 ON RTABLE (WAGE, substring(name, 0,1));

CREATE VIEW V_RTABLE (V_AGE, V_CITY, V_CNT, V_SUM_AGE, V_MIN_WAGE)
    AS SELECT AGE, CITY, COUNT(*), SUM(WAGE), MIN(WAGE)
    FROM RTABLE  GROUP BY AGE, CITY;


CREATE TABLE PTABLE (
    ID INTEGER DEFAULT 0 NOT NULL,
    AGE INTEGER NOT NULL,
    WAGE FLOAT NOT NULL,
    NAME VARCHAR(32) DEFAULT NULL,
    CITY VARCHAR(300) DEFAULT NULL,
    CONSTRAINT PK_PTABLE PRIMARY KEY (ID)
);
PARTITION TABLE PTABLE ON COLUMN ID;

CREATE INDEX PTABLE_INDEX_1 ON PTABLE (AGE);
CREATE INDEX PTABLE_INDEX_2 ON PTABLE (NAME);
CREATE INDEX PTABLE_INDEX_3 ON PTABLE (WAGE, substring(name, 0,1));

CREATE VIEW V_PTABLE (V_AGE, V_CITY, V_CNT, V_SUM_AGE, V_MIN_WAGE)
    AS SELECT AGE, CITY, COUNT(*), SUM(WAGE), MIN(WAGE)
    FROM PTABLE  GROUP BY AGE, CITY;
{'fraction_non_alphanumeric': 0.07316449219749296, 'fraction_numerical': 0.018930672806344334, 'mean_word_length': 4.408022130013832, 'pattern_counts': {'":': 0, '<': 12, '<?xml version=': 0, '>': 12, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1570897', 'n_tokens_mistral': 1548, 'n_tokens_neox': 1351, 'n_words': 521}