There seems to be a bug with pragma short_column_names that if it is set, column names are blank. Attached is a patch to
fix this. To be honest, I'm not very familiar with sqlite's codebase, so the P3_STATIC is kind of a guess, but it compiled
and ran just fine. The reason this pragma is important to me is for compatibility with existing codebases. I have a couple large
applications that run on postgres, that I am porting to a desktop application that will use sqlite as the backend. I would rather
not add as aliases to all of the selects in these applications, so short_column_names is exactly what I want. I noticed there
was a FIX ME comment to remove those pragmas...


John
diff -NU3 -r ./select.c ../../sqlite-orig/src/select.c
--- ./select.c  2004-06-19 11:31:48.778990400 -0600
+++ ../../sqlite-orig/src/select.c      2004-06-17 13:03:38.000000000 -0600
@@ -739,7 +739,7 @@
         sqlite3SetString(&zName, zTab, ".", zCol, 0);
         sqlite3VdbeSetColName(v, i, zName, P3_DYNAMIC);
       }else{
-        sqlite3VdbeSetColName(v, i, zCol, P3_STATIC);
+        sqlite3VdbeSetColName(v, i, zCol, 0);
       }
     }else if( p->span.z && p->span.z[0] ){
       sqlite3VdbeSetColName(v, i, p->span.z, p->span.n);

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to