Changeset: 88efecdd07d4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=88efecdd07d4
Modified Files:
sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err
sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.out
Branch: sq2default
Log Message:
approved error messages, python loader will not handle the default values as
defined
the sql.
diffs (197 lines):
diff --git
a/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err
b/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err
---
a/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err
+++
b/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.err
@@ -64,6 +64,114 @@ MAPI = (monetdb) /var/tmp/mtest-17575/.
QUERY = insert into t (a) values (-1);
ERROR = !INSERT INTO: PRIMARY KEY constraint 't.t_a_pkey' violated
CODE = M0M29
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-30,'abcdeg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-40,'abcdfg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-50,'abcefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-60,'abdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-70,'acdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-80,'bcdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = x - i
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-300,'abcdeg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-400,'abcdfg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-500,'abcefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-600,'abdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-700,'acdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
+MAPI = (monetdb) /var/tmp/mtest-2039/.s.monetdb.39283
+QUERY = COPY LOADER INTO t FROM myloader(-800,'bcdefg');
+ERROR = !Python exception
+ ! 6. if j in y:
+ ! 7. z[j] = numpy.array([ x - 10 - i , x - 20 - i ])
+ !> 8. _emit.emit(z)
+ ! 9.
+ !Failed conversion: Inserting into columns with default values is not
supported currently.
+CODE = PY000
# 17:58:15 >
# 17:58:15 > "Done."
diff --git
a/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.out
b/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.out
---
a/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.out
+++
b/sql/test/BugTracker-2017/Tests/python_loader_clobbers_default_with_null.Bug-6464.stable.out
@@ -271,21 +271,7 @@ stdout of test 'python_loader_clobbers_d
# g integer
#);
#COPY LOADER INTO t FROM myloader(-10,'abcdefg');
-[ 1 ]
#COPY LOADER INTO t FROM myloader(-20,'abcdef');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-30,'abcdeg');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-40,'abcdfg');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-50,'abcefg');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-60,'abdefg');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-70,'acdefg');
-[ 1 ]
-#COPY LOADER INTO t FROM myloader(-80,'bcdefg');
-[ 1 ]
#select * from t;
% sys.t, sys.t, sys.t, sys.t, sys.t, sys.t, sys.t # table_name
% a, b, c, d, e, f, g # name
@@ -293,12 +279,6 @@ stdout of test 'python_loader_clobbers_d
% 3, 3, 3, 3, 3, 3, 3 # length
[ -11, -12, -13, -14, -15, -16, -17 ]
[ -21, -22, -23, -24, -25, -26, NULL ]
-[ -31, -32, -33, -34, -35, 6, -37 ]
-[ -41, -42, -43, -44, 5, -46, -47 ]
-[ -51, -52, -53, 4, -55, -56, -57 ]
-[ -61, -62, 3, -64, -65, -66, -67 ]
-[ -71, 2, -73, -74, -75, -76, -77 ]
-[ 1, -82, -83, -84, -85, -86, -87 ]
#drop table t;
#drop loader myloader;
#CREATE LOADER myloader(x integer, y string) LANGUAGE PYTHON {
@@ -320,21 +300,7 @@ stdout of test 'python_loader_clobbers_d
# g integer
#);
#COPY LOADER INTO t FROM myloader(-100,'abcdefg');
-[ 2 ]
#COPY LOADER INTO t FROM myloader(-200,'abcdef');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-300,'abcdeg');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-400,'abcdfg');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-500,'abcefg');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-600,'abdefg');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-700,'acdefg');
-[ 2 ]
-#COPY LOADER INTO t FROM myloader(-800,'bcdefg');
-[ 2 ]
#select * from t;
% sys.t, sys.t, sys.t, sys.t, sys.t, sys.t, sys.t # table_name
% a, b, c, d, e, f, g # name
@@ -344,18 +310,6 @@ stdout of test 'python_loader_clobbers_d
[ -121, -122, -123, -124, -125, -126, -127 ]
[ -211, -212, -213, -214, -215, -216, NULL ]
[ -221, -222, -223, -224, -225, -226, NULL ]
-[ -311, -312, -313, -314, -315, 6, -317 ]
-[ -321, -322, -323, -324, -325, 6, -327 ]
-[ -411, -412, -413, -414, 5, -416, -417 ]
-[ -421, -422, -423, -424, 5, -426, -427 ]
-[ -511, -512, -513, 4, -515, -516, -517 ]
-[ -521, -522, -523, 5, -525, -526, -527 ]
-[ -611, -612, 3, -614, -615, -616, -617 ]
-[ -621, -622, 4, -624, -625, -626, -627 ]
-[ -711, 2, -713, -714, -715, -716, -717 ]
-[ -721, 3, -723, -724, -725, -726, -727 ]
-[ 1, -812, -813, -814, -815, -816, -817 ]
-[ 2, -822, -823, -824, -825, -826, -827 ]
#drop table t;
#drop loader myloader;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
