Connector/ODBC 3.51 commit: r462 - trunk/test

[grichter]

Modified:
   trunk/test/my_datetime.c
Log:
Added test case for bug #15773 (can't repeat)


Modified: trunk/test/my_datetime.c
===================================================================
--- trunk/test/my_datetime.c	2007-06-01 02:29:35 UTC (rev 461)
+++ trunk/test/my_datetime.c	2007-06-03 12:03:05 UTC (rev 462)
@@ -643,7 +643,59 @@
   return OK;
 }
 
+/**
+ Bug #15773: Wrong between results
+*/
+DECLARE_TEST(t_bug15773)
+{
+  SQL_DATE_STRUCT a,b,c,d;
+  SQLLEN len1;
+  SQLLEN len, my_time_cb;
+  SQLRETURN rc;
+  SQLCHAR datetime[50];
 
+  ok_sql(hstmt, "DROP TABLE IF EXISTS t_bug15773");
+  ok_sql(hstmt, "CREATE TABLE t_bug15773("
+				"`a` varchar(255) NOT NULL default '',"
+				"`b` datetime NOT NULL default '0000-00-00 00:00:00',"
+				"`c` datetime NOT NULL default '0000-00-00 00:00:00'"
+				") ENGINE=InnoDB DEFAULT CHARSET=latin1");
+  ok_sql(hstmt, "INSERT INTO t_bug15773 VALUES ('a', '2005-12-24 00:00:00', '2008-05-12
00:00:00')");
+  ok_sql(hstmt, "INSERT INTO t_bug15773 VALUES ('b', '2004-01-01 00:00:00', '2005-01-01
00:00:00')");
+  ok_sql(hstmt, "INSERT INTO t_bug15773 VALUES ('c', '2004-12-12 00:00:00', '2005-12-12
00:00:00')");
+
+
+  rc = SQLPrepare(hstmt, "SELECT * FROM t_bug15773 WHERE (?) BETWEEN b AND c" ,SQL_NTS);
+  mystmt(hstmt, rc);
+
+  d.day = 15;
+  d.month = 12;
+  d.year = 2005;
+
+  rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_TYPE_DATE, SQL_TYPE_DATE, 0, 0,
&d, 0, NULL); 
+  mystmt(hstmt, rc);
+  rc = SQLBindCol(hstmt, 1, SQL_C_CHAR, &a, 255, &len1);
+  mystmt(hstmt, rc);
+  rc = SQLBindCol(hstmt, 2, SQL_C_TYPE_DATE, &b, 0, &len1);
+  mystmt(hstmt, rc);
+  rc = SQLBindCol(hstmt, 3, SQL_C_TYPE_DATE, &c, 0, &len1); 
+  mystmt(hstmt, rc);
+
+  rc = SQLExecute(hstmt);
+  mystmt(hstmt, rc);
+
+  rc = SQLFetch(hstmt);
+  myassert(rc != SQL_SUCCESS);
+
+  ok_stmt(hstmt, SQLFreeStmt(hstmt, SQL_UNBIND));
+  ok_stmt(hstmt, SQLFreeStmt(hstmt, SQL_CLOSE));
+
+  ok_sql(hstmt, "DROP TABLE IF EXISTS t_bug15773");
+  return OK;
+
+}
+
+
 BEGIN_TESTS
   ADD_TEST(my_ts)
   ADD_TEST(t_tstotime)
@@ -652,6 +704,7 @@
   ADD_TEST(t_time)
   ADD_TEST(t_time1)
   ADD_TEST(t_bug12520)
+  ADD_TEST(t_bug15773)
 END_TESTS