Changeset: 4e8e99b6b109 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4e8e99b6b109 Removed Files: sql/test/numeric.sql sql/test/schema.sql sql/test/seq.sql sql/test/sys-schema.sql sql/test/test.sql sql/test/thinksql-examples.sql sql/test/type_length.sql Branch: mtest Log Message:
Removed unused files. They are covered by other tests diffs (truncated from 662 to 300 lines): diff --git a/sql/test/numeric.sql b/sql/test/numeric.sql deleted file mode 100644 --- a/sql/test/numeric.sql +++ /dev/null @@ -1,11 +0,0 @@ -select 3836*8141; ---select 3836L*8141; - -create table t( i int, l NUMERIC(20)); -insert into t values(3836,8141); -insert into t values(1, 38368141); -insert into t values(1, 2147483647); -insert into t values(1, 2147483648); -insert into t values(1, 2147483649); -insert into t values(1, 21474000083649); -select * from t; diff --git a/sql/test/schema.sql b/sql/test/schema.sql deleted file mode 100644 --- a/sql/test/schema.sql +++ /dev/null @@ -1,17 +0,0 @@ -select * from schemas; -select * from tables; -select * from columns; -select schemas.name, tables.name, columns.name -from schemas, tables, columns -where - schemas.id = tables.schema_id -AND tables.id = columns.table_id; - -select s.name, t.name -from (schemas as s FULL OUTER JOIN tables as t ON s.id = t.schema_id); - -select s.name, t.name, c.name -from ((schemas as s FULL OUTER JOIN tables as t ON s.id = t.schema_id) - FULL OUTER JOIN columns as c ON t.id = c.table_id ); - -commit; diff --git a/sql/test/seq.sql b/sql/test/seq.sql deleted file mode 100644 --- a/sql/test/seq.sql +++ /dev/null @@ -1,9 +0,0 @@ -create sequence seq as integer; -create table tst (i integer, v varchar(32)); -insert into tst values (next value for seq, 'testing'); -select * from tst; -insert into tst values (next value for seq, 'testing'); -select * from tst; -insert into tst values (next value for seq, 'testing'); -select * from tst; -commit; diff --git a/sql/test/sys-schema.sql b/sql/test/sys-schema.sql deleted file mode 100644 --- a/sql/test/sys-schema.sql +++ /dev/null @@ -1,21 +0,0 @@ -select * from sys.schemas; -select * from sys.schemas; -select * from sys.tables; -select * from sys.columns; -select s.name, t.name, c.name -from sys.schemas as s, sys.tables as t, sys.columns as c -where - s.id = t.schema_id -AND t.id = c.table_id; - -select s.name, t.name -from (sys.schemas as s FULL OUTER JOIN sys.tables as t ON s.id = t.schema_id); - -select s.name, t.name, c.name -from ((sys.schemas as s FULL OUTER JOIN sys.tables as t ON s.id = t.schema_id) - FULL OUTER JOIN sys.columns as c ON t.id = c.table_id ); - -SELECT S.NAME AS TABLE_SCHEM, T.NAME AS TABLE_NAME, T.TYPE AS TABLE_TYPE - FROM SYS.SCHEMAS S, SYS.TABLES T - WHERE T.SCHEMA_ID = S.ID - ORDER BY S.NAME, T.NAME, T.TYPE; diff --git a/sql/test/test.sql b/sql/test/test.sql deleted file mode 100644 --- a/sql/test/test.sql +++ /dev/null @@ -1,127 +0,0 @@ -/* -CREATE SCHEMA schema1 AUTHORIZATION sqlusers - CREATE TABLE test (n INTEGER); -CREATE SCHEMA niels AUTHORIZATION sqlusers - CREATE TABLE image (n INTEGER NOT NULL); -DROP SCHEMA niels CASCADE; - -create table synch -( - val1 int, - val2 int, - val3 int -); -create table comment -( - timestamp datetime, - comment varchar(30) -); -create table master_sync -( - - function char(22), - ramp_up int, - steady_state int, - ramp_down int, - scale int, - history int -); -create table run_id ( val int); -create table stat_table -( - tran_count int, - tot_res float, - min_res int, - max_res int, - not_done int, - tran_sqr float, - tran_2sec int, - test_OK int -); -create table histogram -( - interval int, - tran_count int -); -create table resp_hist -( - bucket int, - value int -); -*/ -/* -SELECT * INTO :ka FROM test; -SELECT * INTO :ka FROM test, test2 WHERE a = 10 AND b = 20; -SELECT * INTO :ka FROM test, test2 WHERE a BETWEEN 10 AND 20; -SELECT * INTO :ka FROM test, test2 WHERE a LIKE 20; -SELECT * INTO :ka FROM test WHERE a IS NOT NULL; -*/ -create table people -( - first_name varchar(30), - last_name varchar(30), - pc varchar(8), - street_nr int, - bank_nr int -); -create table address -( - place varchar(30), - street_nr int, - pc varchar(8) -); -create table account -( - bank_nr int, - account_nr varchar(30), - saldo int -); -INSERT INTO people ( last_name, first_name, pc, street_nr, bank_nr ) VALUES ( 'nes', 'niels', '1628VT', 162, 0 ); -INSERT INTO people VALUES ( 'lilian', 'nes', '1628VT', 162, 0 ); -INSERT INTO people VALUES ( 'lilian', 'nes', '1628VT', 162, 0 ); -INSERT INTO account VALUES ( 0, '12344', 2000 ); -INSERT INTO account VALUES ( 0, '12345', 4000 ); -INSERT INTO account VALUES ( 0, '12346', 10000 ); - -SELECT * -FROM people -WHERE first_name = 'niels' -; - -SELECT first_name, last_name, account_nr, saldo - 10000 -FROM people, account -WHERE last_name = 'nes' -AND saldo > 10000 -AND people.bank_nr = account.bank_nr -; - -SELECT first_name, last_name, account_nr, saldo - 10000 -FROM people, account -WHERE last_name = 'nes' -AND people.bank_nr = account.bank_nr -AND saldo > 10000 -; - -SELECT first_name, last_name, account_nr, saldo - 10000 -FROM people, account, address -WHERE address.place = 'HOORN' -AND people.bank_nr = account.bank_nr -AND people.street_nr = address.street_nr -AND people.pc = address.pc -AND saldo > 10000 -ORDER BY last_name DESC, first_name -; - -SELECT first_name, last_name, account_nr, saldo - 10000 -FROM people, account -WHERE last_name = 'nes' -AND people.bank_nr = account.bank_nr -AND (saldo > 10000 OR first_name = 'niels') -; - -SELECT max(saldo) -FROM account -WHERE saldo > 10000 -; - -commit; diff --git a/sql/test/thinksql-examples.sql b/sql/test/thinksql-examples.sql deleted file mode 100644 --- a/sql/test/thinksql-examples.sql +++ /dev/null @@ -1,430 +0,0 @@ -CREATE SCHEMA restaurant AUTHORIZATION restaurant; - -CREATE TABLE CHECK_DETAIL ( -CHECK_NO INTEGER NOT NULL REFERENCES CHECK_HEADER ON DELETE CASCADE, -LINE_NO INTEGER NOT NULL, -MENU_ITEM_NO INTEGER REFERENCES MENU_ITEM, -QTY DECIMAL(5) DEFAULT 1, -PRIMARY KEY (CHECK_NO, LINE_NO) ); - -CREATE TABLE "SERVER" ( -SERVER_NO INTEGER NOT NULL PRIMARY KEY, -SERVER_NAME VARCHAR(20), -PRIMARY KEY (SERVER_NO) ); - -CREATE TABLE MENU_ITEM ( -MENU_ITEM_NO INTEGER NOT NULL, -MENU_ITEM_NAME VARCHAR(40), -MENU_ITEM_GROUP_NO INTEGER, -PRICE DECIMAL(6,2), -PRIMARY KEY (MENU_ITEM_NO), -FOREIGN KEY (MENU_ITEM_GROUP_NO) -REFERENCES MENU_GROUP (MENU_ITEM_GROUP_NO), -CHECK (PRICE>0) ); - -CREATE TABLE CHECK_HEADER ( -CHECK_NO INTEGER NOT NULL, -SERVER_NO INTEGER REFERENCES "SERVER", -START_TIME TIMESTAMP(0), -PRIMARY KEY (CHECK_NO) ); - -INSERT INTO "SERVER" VALUES -(1,'John Smith'), -(2,'Mary Jones'); - -DELETE FROM menu_item WHERE menu_item_no=102; - ---SET CONSTRAINTS ALL DEFERRED ---SET CONSTRAINTS ALL IMMEDIATE -/* -CREATE PROCEDURE setPrice ( item_no INTEGER, -new_price DECIMAL(6,2) ) -BEGIN -UPDATE menu_item SET price = new_price WHERE menu_item_no = item_no; -INSERT INTO audit VALUES (CURRENT_TIMESTAMP, item_no, new_price); -END; -CALL setPrice ( 303, 1.95 ); -*/ - -SELECT MENU_ITEM_NO, MENU_ITEM_NAME, MENU_ITEM_GROUP_NO, PRICE -FROM MENU_ITEM; - -SELECT * -FROM MENU_ITEM; - -SELECT * -FROM MENU_ITEM -WHERE PRICE>5.00; - -SELECT * -FROM MENU_ITEM -WHERE PRICE>5.00 -ORDER BY PRICE; - -SELECT * -FROM MENU_ITEM -WHERE PRICE>5.00 -ORDER BY PRICE DESC, MENU_ITEM_NAME; - -SELECT * -FROM MENU_ITEM -WHERE -MENU_ITEM_GROUP_NO>=5 -AND MENU_ITEM_GROUP_NO<=7 -AND PRICE>2.00; - -SELECT * -FROM MENU_ITEM -WHERE -MENU_ITEM_GROUP_NO=1 -OR MENU_ITEM_GROUP_NO=2; - -SELECT * -FROM MENU_ITEM -WHERE -(MENU_ITEM_GROUP_NO=1 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
