1 files changed, 72 insertions, 0 deletions
diff --git a/src/test/suite/results/date.sql.out b/src/test/suite/results/date.sql.out
new file mode 100644
index 00000000000..ffd785fc524
--- /dev/null
+++ b/src/test/suite/results/date.sql.out
@@ -0,0 +1,72 @@
+QUERY: create table dd (d date);
+QUERY: insert into dd values ('06-22-1995');
+QUERY: insert into dd values ('05-31-1994');
+QUERY: insert into dd values ('02-29-1996');
+QUERY: insert into dd values ('12-02-1993');
+QUERY: insert into dd values ('05-31-1994');
+QUERY: insert into dd values ('10-20-1970');
+QUERY: select * from dd;
+d           
+----------- 
+06-22-1995  
+05-31-1994  
+02-29-1996  
+12-02-1993  
+05-31-1994  
+10-20-1970  
+QUERY: select * from dd order by d;
+d           
+----------- 
+10-20-1970  
+12-02-1993  
+05-31-1994  
+05-31-1994  
+06-22-1995  
+02-29-1996  
+QUERY: select * from dd order by d using >;
+d           
+----------- 
+02-29-1996  
+06-22-1995  
+05-31-1994  
+05-31-1994  
+12-02-1993  
+10-20-1970  
+QUERY: select * from dd where d = '05-31-1994';
+d           
+----------- 
+05-31-1994  
+05-31-1994  
+QUERY: select * from dd where d <> '05-31-1994';
+d           
+----------- 
+06-22-1995  
+02-29-1996  
+12-02-1993  
+10-20-1970  
+QUERY: select * from dd where d < '05-31-1994';
+d           
+----------- 
+12-02-1993  
+10-20-1970  
+QUERY: select * from dd where d <= '05-31-1994';
+d           
+----------- 
+05-31-1994  
+12-02-1993  
+05-31-1994  
+10-20-1970  
+QUERY: select * from dd where d > '05-31-1994';
+d           
+----------- 
+06-22-1995  
+02-29-1996  
+QUERY: select * from dd where d >= '05-31-1994';
+d           
+----------- 
+06-22-1995  
+05-31-1994  
+02-29-1996  
+05-31-1994  
+QUERY: create index dd_ind on dd using btree (d date_ops);
+QUERY: drop table dd;