Mike McCormack : msi: Add more tests for temporary columns.

[Alexandre Julliard]

Module: wine
Branch: master
Commit: 0fc2bd760c5029084b7d54081c32ac2746f27041
URL:    http://source.winehq.org/git/?p=wine.git;a=commit;h=0fc2bd760c5029084b7d5408...

Author: Mike McCormack 
Date:   Fri Sep  8 18:55:57 2006 +0900

msi: Add more tests for temporary columns.

---

dlls/msi/tests/db.c |   40 +++++++++++++++++++++++++++++++++++++++-
 1 files changed, 39 insertions(+), 1 deletions(-)

diff --git a/dlls/msi/tests/db.c b/dlls/msi/tests/db.c
index aea08a3..3635f59 100644
--- a/dlls/msi/tests/db.c
+++ b/dlls/msi/tests/db.c
@@ -1917,9 +1917,11 @@ static void test_join(void)
 static void test_temporary_table(void)
 {
     MSICONDITION cond;
-    MSIHANDLE hdb;
+    MSIHANDLE hdb = 0, view = 0, rec;
     const char *query;
     UINT r;
+    char buf[0x10];
+    DWORD sz;

cond = MsiDatabaseIsTablePersistent(0, NULL);
     todo_wine ok( cond == MSICONDITION_ERROR, "wrong return condition\n");
@@ -1992,6 +1994,42 @@ static void test_temporary_table(void)
     query = "CREATE TABLE `T5` ( `B` SHORT NOT NULL TEMP, `C` CHAR(255) TEMP PRIMARY KEY `C`) HOLD";
     r = run_query(hdb, 0, query);
     ok(r == ERROR_BAD_QUERY_SYNTAX, "failed to add table\n");
+
+    query = "select * from `T`";
+    r = MsiDatabaseOpenView(hdb, query, &view);
+    ok(r == ERROR_SUCCESS, "failed to query table\n");
+    r = MsiViewGetColumnInfo(view, MSICOLINFO_TYPES, &rec);
+    ok(r == ERROR_SUCCESS, "failed to get column info\n");
+
+    sz = sizeof buf;
+    r = MsiRecordGetString(rec, 1, buf, &sz);
+    ok(r == ERROR_SUCCESS, "failed to get string\n");
+    todo_wine ok( 0 == strcmp("G255", buf), "wrong column type\n");
+
+    sz = sizeof buf;
+    r = MsiRecordGetString(rec, 2, buf, &sz);
+    ok(r == ERROR_SUCCESS, "failed to get string\n");
+    todo_wine ok( 0 == strcmp("j2", buf), "wrong column type\n");
+
+    MsiCloseHandle( rec );
+    MsiCloseHandle( view );
+
+    /* query the table data */
+    rec = 0;
+    r = do_query(hdb, "select * from `_Tables` where `Name` = 'T'", &rec);
+    ok( r == ERROR_SUCCESS, "temporary table exists in _Tables\n");
+    MsiCloseHandle( rec );
+
+    todo_wine {
+    /* query the column data */
+    rec = 0;
+    r = do_query(hdb, "select * from `_Columns` where `Table` = 'T' AND `Name` = 'B'", &rec);
+    ok( r == ERROR_NO_MORE_ITEMS, "temporary table exists in _Columns\n");
+
+    r = do_query(hdb, "select * from `_Columns` where `Table` = 'T' AND `Name` = 'C'", &rec);
+    ok( r == ERROR_NO_MORE_ITEMS, "temporary table exists in _Columns\n");
+    }
+
     MsiCloseHandle( hdb );

DeleteFile(msifile);