Changeset: 36b4de6bfd1e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36b4de6bfd1e
Modified Files:
clients/src/mapiclient/mclient.mx
Branch: Jun2010
Log Message:
Use sys._tables instead of sys.tables with check on temporary column.
diffs (17 lines):
diff -r 8c79637bf83d -r 36b4de6bfd1e clients/src/mapiclient/mclient.mx
--- a/clients/src/mapiclient/mclient.mx Tue Jul 13 10:51:23 2010 +0200
+++ b/clients/src/mapiclient/mclient.mx Tue Jul 13 10:53:50 2010 +0200
@@ -1848,12 +1848,11 @@
if ((hdl = mapi_query(mid,
"SELECT
\"t\".\"name\", \"t\".\"type\", "
"\"s\".\"name\" "
- "FROM
\"sys\".\"tables\" \"t\", "
+ "FROM
\"sys\".\"_tables\" \"t\", "
"\"sys\".\"schemas\" \"s\" "
"WHERE
\"t\".\"schema_id\" = \"s\".\"id\" "
"AND
\"s\".\"name\" = \"current_schema\" "
"AND
\"t\".\"system\" = false "
- "AND
\"t\".\"temporary\" = 0 "
"ORDER BY
\"t\".\"name\"")) != NULL &&
mapi_error(mid) == MOK) {
char *type, *name,
*schema;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
