From c894a7cdd8686ea695602a23a511a3f1b0d047be Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?J=C3=B6rg=20Frings-F=C3=BCrst?= Date: Mon, 14 Aug 2023 21:07:46 +0200 Subject: New upstream version 4.1.4 --- sql/droptbl.sql | 9 +++++++++ sql/jointest.sql | 43 +++++++++++++++++++++++++++++++++++++++++++ sql/oneNdxTag.sql | 18 ++++++++++++++++++ sql/testc.sql | 13 +++++++++++++ sql/testd.sql | 12 ++++++++++++ sql/testdd.sql | 14 ++++++++++++++ sql/testflg.sql | 12 ++++++++++++ sql/testmdx.sql | 12 ++++++++++++ sql/testmdx2.sql | 12 ++++++++++++ sql/twotags.sql | 10 ++++++++++ 10 files changed, 155 insertions(+) create mode 100755 sql/droptbl.sql create mode 100755 sql/jointest.sql create mode 100755 sql/oneNdxTag.sql create mode 100755 sql/testc.sql create mode 100755 sql/testd.sql create mode 100755 sql/testdd.sql create mode 100755 sql/testflg.sql create mode 100755 sql/testmdx.sql create mode 100755 sql/testmdx2.sql create mode 100755 sql/twotags.sql (limited to 'sql') diff --git a/sql/droptbl.sql b/sql/droptbl.sql new file mode 100755 index 0000000..d8699cc --- /dev/null +++ b/sql/droptbl.sql @@ -0,0 +1,9 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TestSqlM.DBF; + + + + diff --git a/sql/jointest.sql b/sql/jointest.sql new file mode 100755 index 0000000..de167b5 --- /dev/null +++ b/sql/jointest.sql @@ -0,0 +1,43 @@ +# HELP; + +USE /mnt/1Tdata/xbase/xbase64-4.1.1/data; + +DROP TABLE IF EXISTS MAIN0.DBF; +DROP TABLE IF EXISTS LEFT0.DBF; +DROP TABLE IF EXISTS LEFT1.DBF; +DROP TABLE IF EXISTS LEFT2.DBF; +DROP TABLE IF EXISTS LEFT3.DBF; +DROP TABLE IF EXISTS INNER0.DBF; + + +CREATE TABLE MAIN0 ( ID NUMERIC(6,0), LEFTFK0 CHAR(3), LEFTFK1 CHAR(3), LEFTFK2 CHAR(3), LEFTFK3 CHAR(3), RIGHTFK0 CHAR(3), RIGHTFK1 CHAR(3), RIGHTFK2 CHAR(3), INNERFK0 CHAR(3) ); + +CREATE TABLE LEFT0.DBF ( ID NUMERIC(6,0), LEFTFK0 CHAR(3), CFLD CHAR(10) ); +CREATE TABLE LEFT1.DBF ( ID NUMERIC(6,0), LEFTFK1 CHAR(3), CFLD CHAR(10) ); +CREATE TABLE LEFT2.DBF ( ID NUMERIC(6,0), LEFTFK2 CHAR(3), CFLD CHAR(10) ); +CREATE TABLE LEFT3.DBF ( ID NUMERIC(6,0), LEFTFK3 CHAR(3), CFLD CHAR(10) ); +CREATE TABLE INNER0.DBF( ID NUMERIC(6,0), INNERFK0 CHAR(3), CFLD CHAR(10) ); + + +INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 1, 'L01', 'L11', 'L21', 'L31', 'R01', 'R11', 'R21', 'I01' ); +INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 2, 'L02', 'L12', 'L22', 'L32', 'R02', 'R12', 'R22', 'I02' ); +INSERT INTO MAIN0.DBF ( ID, LEFTFK0, LEFTFK1, LEFTFK2, LEFTFK3, RIGHTFK0, RIGHTFK1, RIGHTFK2, INNERFK0 ) VALUES ( 3, 'L03', 'L13', 'L23', 'L33', 'R03', 'R13', 'R23', 'I03' ); + +INSERT INTO LEFT0.DBF ( ID, LEFTFK0, CFLD ) VALUES ( 1, 'L01', 'REC 1 data' ); +INSERT INTO LEFT0.DBF ( ID, LEFTFK0, CFLD ) VALUES ( 2, 'L02', 'REC 2 data' ); + +INSERT INTO INNER0.DBF ( ID, INNERFK0, CFLD ) VALUES ( 1, 'I01', 'REC 1 data' ); +INSERT INTO INNER0.DBF ( ID, INNERFK0, CFLD ) VALUES ( 2, 'I03', 'REC 2 data' ); + + + +#INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); +#CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; +#DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; + + + +#SELECT M.ID, M.LEFTFK0, L0.CFLD, L1.CFLD AS L1cfld +#FROM MAIN0 M +#LEFT JOIN LEFT0 L0 ON M.LEFTFK0 = L0.LEFTFK0 +#LEFT JOIN LEFT1 L1 ON M.LEFTFK1 = L1.LEFTFK1 AND L1.ID = L0.ID \ No newline at end of file diff --git a/sql/oneNdxTag.sql b/sql/oneNdxTag.sql new file mode 100755 index 0000000..71ff217 --- /dev/null +++ b/sql/oneNdxTag.sql @@ -0,0 +1,18 @@ +# HELP; + +# where the tables live +USE /mnt/1Tdata/xbase/xbase.35/data; + + +DROP TABLE IF EXISTS OneNdxTg.DBF; + +CREATE TABLE OneNdxTg.DBF( CHRFLD CHAR(50), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); + +CREATE INDEX OneNdxTg.NDX ON OneNdxTg.DBF( CHRFLD ) ASSOCIATE; + +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('AAA' ); +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('BBB' ); +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('CCC' ); +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('aaa' ); +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('bbb' ); +INSERT INTO OneNdxTg.DBF ( CHRFLD ) Values ('ccc' ); \ No newline at end of file diff --git a/sql/testc.sql b/sql/testc.sql new file mode 100755 index 0000000..85d9f18 --- /dev/null +++ b/sql/testc.sql @@ -0,0 +1,13 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); + +DROP TABLE IF EXISTS TestSql.DBF; +CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL); +CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; + +# DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; + + diff --git a/sql/testd.sql b/sql/testd.sql new file mode 100755 index 0000000..3bac01c --- /dev/null +++ b/sql/testd.sql @@ -0,0 +1,12 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); + +# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); +# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; + +DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; + + diff --git a/sql/testdd.sql b/sql/testdd.sql new file mode 100755 index 0000000..85c8000 --- /dev/null +++ b/sql/testdd.sql @@ -0,0 +1,14 @@ +HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +# INSERT INTO TestSQL.DBF (CITY, STATE, ZIPCODE, NOTES, LASTUPDATE, ACTIVE ) VALUES ( 'San Diego', 'CA', 92007, 'San Diego is a cool place', '1989-02-09', 'Y'); + +# CREATE TABLE TestSql.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) VCHARFLD VARCHAR, LGFLD LOGICAL ); +# CREATE UNIQUE INDEX TestSql1.NDX ON TestSql.DBF( CHRFLD ) ASSOCIATE; + +#DROP INDEX IF EXISTS TestSql1.NDX ON TestSql.DBF; + +DROP TABLE IF EXISTS TestSql.DBF; + + diff --git a/sql/testflg.sql b/sql/testflg.sql new file mode 100755 index 0000000..2d00290 --- /dev/null +++ b/sql/testflg.sql @@ -0,0 +1,12 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TestFlag.DBF; + +CREATE TABLE TestFlag.DBF( C1 CHAR(1), C2 CHAR(2), C3 CHAR(3), D1 DATE, D2 DATE, D3 DATE, I1 INTEGER, I2 INTEGER, I3 INTEGER, N1 NUMERIC(9,1), N2 NUMERIC(9,2), N3 NUMERIC(9,3)); + +# CREATE INDEX TestSql2 ON TestSql2.DBF( CHRFLD ); + + + diff --git a/sql/testmdx.sql b/sql/testmdx.sql new file mode 100755 index 0000000..859334b --- /dev/null +++ b/sql/testmdx.sql @@ -0,0 +1,12 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TestSqlM.DBF; + +CREATE TABLE TestSqlM.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); + +# CREATE INDEX TestSqlM ON TestSqlM.DBF( CHRFLD ); + + + diff --git a/sql/testmdx2.sql b/sql/testmdx2.sql new file mode 100755 index 0000000..040dddd --- /dev/null +++ b/sql/testmdx2.sql @@ -0,0 +1,12 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TestSql2.DBF; + +CREATE TABLE TestSql2.DBF( CHRFLD CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); + +CREATE INDEX Ctag1 ON TestSql2.DBF( CHRFLD ); + + + diff --git a/sql/twotags.sql b/sql/twotags.sql new file mode 100755 index 0000000..6840709 --- /dev/null +++ b/sql/twotags.sql @@ -0,0 +1,10 @@ +# HELP; + +USE /opt/1Tdata/xbase/xbase.30/data; + +DROP TABLE IF EXISTS TwoTags.DBF; + +CREATE TABLE TwoTags.DBF( CHRFLD1 CHAR(100), CHRFLD2 CHAR(100), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4) LGFLD LOGICAL ); + + + -- cgit v1.2.3