Github user kaknikhil commented on a diff in the pull request: https://github.com/apache/madlib/pull/282#discussion_r199019606 --- Diff: src/ports/postgres/modules/utilities/test/utilities.sql_in --- @@ -0,0 +1,77 @@ +/* ----------------------------------------------------------------------- */ +/** + * + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + * + */ +/* ----------------------------------------------------------------------- */ + +CREATE TABLE "__madlib_temp_Quoted"(b varchar); +CREATE TABLE __madlib_temp_non_quoted(a text); +-- assert that madlib_temp tables are created +SELECT assert(count(*) >= 2, 'Error setting up madlib_temp in schema ' || quote_ident(current_schema())) +FROM pg_tables +WHERE tablename LIKE '%madlib\_temp%' + AND quote_ident(schemaname) = quote_ident(current_schema()); + +-- cleanup +SELECT cleanup_madlib_temp_tables(quote_ident(current_schema())); + +-- assert that madlib_temp tables are dropped +SELECT assert(count(*) = 0, 'Error cleaning up madlib_temp in schema ' || quote_ident(current_schema())) +FROM pg_tables +WHERE tablename LIKE '%madlib\_temp%' + AND quote_ident(schemaname) = quote_ident(current_schema()); + +-- test dropcols +DROP TABLE IF EXISTS dt_golf CASCADE; +CREATE TABLE dt_golf ( + id integer NOT NULL, + id_2 integer, + "OUTLOOK" text, + temperature double precision, + humidity double precision, + "Cont,features" double precision[], + cat_features text[], + windy boolean, + class text +) ; + +INSERT INTO dt_golf (id,"OUTLOOK",temperature,humidity,"Cont,features",cat_features, windy,class) VALUES --- End diff -- should we add some more special chars like https://github.com/apache/madlib/pull/281 ?
---