Changeset: 799341da8b59 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/799341da8b59
Modified Files:
sql/server/rel_select.c
sql/test/file_loader/Tests/file_loader_function.test
sql/test/file_loader/Tests/file_loader_string.test
Branch: default
Log Message:
Added some more tests. Simplified error message.
diffs (93 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -588,7 +588,7 @@ rel_file_loader(mvc *sql, list *exps, li
if (list_length(exps) == 1 && f && f->func->varres &&
strlen(f->func->mod) == 0 && strlen(f->func->imp) == 0) {
char *err =
file_loader_add_table_column_types(sql, f, nexps, res_exps, tname);
if (err)
- return sql_error(sql, ERR_NOTFOUND,
SQLSTATE(42000) "SELECT: file_loader function type resolutions failed '%s'",
err);
+ return sql_error(sql, ERR_NOTFOUND,
SQLSTATE(42000) "SELECT: file_loader function failed '%s'", err);
}
sql_exp *e = exp_op(sql->sa, nexps, f);
sql_rel *rel = rel_table_func(sql->sa, NULL, e,
res_exps, TABLE_PROD_FUNC);
diff --git a/sql/test/file_loader/Tests/file_loader_function.test
b/sql/test/file_loader/Tests/file_loader_function.test
--- a/sql/test/file_loader/Tests/file_loader_function.test
+++ b/sql/test/file_loader/Tests/file_loader_function.test
@@ -1,21 +1,30 @@
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename missing'
+statement error 42000!SELECT: file_loader function failed 'Filename missing'
select * from file_loader('')
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename extension missing'
+statement error 42000!SELECT: file_loader function failed 'Filename extension
missing'
select * from file_loader('FileNotFound')
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from file_loader('/tmp/FileNotFound.csv')
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename extension 'gz' missing'
+statement error 42000!SELECT: file_loader function failed 'Filename extension
'gz' missing'
select * from file_loader('/tmp/FileNotFound.gz')
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from file_loader('/tmp/FileNotFound.csv.gz')
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from file_loader(R'C:\temp\FileNotFound.csv.gz')
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from file_loader('/tmp/FileNotFound.csv.gz') as file
+
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from file_loader('/tmp/FileNotFound.csv.gz') as file(col1, col2)
+
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from file_loader('/tmp/FileNotFound.csv') file(col1, col2)
+
statement error 42000!SELECT: no such table returning function
'sys'.'file_loader'(char)
select * from sys.file_loader('')
diff --git a/sql/test/file_loader/Tests/file_loader_string.test
b/sql/test/file_loader/Tests/file_loader_string.test
--- a/sql/test/file_loader/Tests/file_loader_string.test
+++ b/sql/test/file_loader/Tests/file_loader_string.test
@@ -1,21 +1,30 @@
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename missing'
+statement error 42000!SELECT: file_loader function failed 'Filename missing'
select * from ''
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename extension missing'
+statement error 42000!SELECT: file_loader function failed 'Filename extension
missing'
select * from 'FileNotFound'
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename extension missing'
+statement error 42000!SELECT: file_loader function failed 'Filename extension
missing'
select * from '/tmp/FileNotFound'
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from '/tmp/FileNotFound.csv'
-statement error 42000!SELECT: file_loader function type resolutions failed
'Filename extension 'gz' missing'
+statement error 42000!SELECT: file_loader function failed 'Filename extension
'gz' missing'
select * from '/tmp/FileNotFound.gz'
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from '/tmp/FileNotFound.csv.gz'
-statement error 42000!SELECT: file_loader function type resolutions failed
'File not found'
+statement error 42000!SELECT: file_loader function failed 'File not found'
select * from R'C:\temp\FileNotFound.csv.gz'
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from '/tmp/FileNotFound.csv.gz' as file
+
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from '/tmp/FileNotFound.csv.gz' as file(col1, col2)
+
+statement error 42000!SELECT: file_loader function failed 'File not found'
+select * from '/tmp/FileNotFound.csv' file(col1, col2)
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
