1 files changed, 47 insertions, 0 deletions
diff --git a/db-4.8.30/test/scr038/data/17925.sql b/db-4.8.30/test/scr038/data/17925.sql
new file mode 100644
index 0000000..d76949d
--- /dev/null
+++ b/db-4.8.30/test/scr038/data/17925.sql
@@ -0,0 +1,47 @@
+CREATE DATABASE numismatics;  
+
+CREATE TABLE coin (cid INT(8) PRIMARY KEY,
+                       unit VARCHAR2(20),
+                       value NUMERIC(8,2),  
+                       mintage_year INT(8),
+                       mint_id INT(8),
+                       CONSTRAINT mint_id_fk FOREIGN KEY(mint_id)
+                           REFERENCES mint(mid));
+
+CREATE INDEX unit_index ON coin(unit);
+
+CREATE TABLE mint (mid INT(8) PRIMARY KEY,
+       country VARCHAR2(20),
+       city VARCHAR2(20)); 
+
+CREATE INDEX mid_index ON mint(mid); 
+
+CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY,
+       chunk bin(127));
+
+CREATE TABLE table1 (att_int INT(8) PRIMARY KEY,
+		 	att_char CHAR(20),
+			att_varchar VARCHAR(20),
+			att_bit BIT,
+			att_tinyint TINYINT,
+			att_smallint SMALLINT(2),
+			att_integer INTEGER(4),
+			att_bigint BIGINT,
+			att_real REAL,
+			att_double DOUBLE,
+			att_float FLOAT,
+			att_decimal DECIMAL,
+			att_numeric NUMERIC,
+			att_bin bin(5));
+
+CREATE TABLE table2(att_int INT(8) PRIMARY KEY);
+		
+CREATE TABLE table3(att_char CHAR(20) PRIMARY KEY);
+
+CREATE TABLE table4(att_bin bin(10) PRIMARY KEY);
+
+CREATE TABLE table5(att_bin bin(10) PRIMARY KEY,
+			att_bit BIT);
+
+CREATE TABLE table6(att_bin bin(10),
+                        att_bit BIT PRIMARY KEY);