summaryrefslogtreecommitdiff
path: root/mysql-test/r/gis.result
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-02-12 15:41:36 +0400
committerunknown <holyfoot/hf@mysql.com/hfmain.(none)>2007-02-12 15:41:36 +0400
commit07f36668aecfd3d811c4ed5eb23b1bfdb8c86fdd (patch)
tree7dd961ed670d0d28d50bea67201109c50e9296ff /mysql-test/r/gis.result
parenta30830460794651c0e9fc5ec4779cf77680514ee (diff)
downloadmariadb-git-07f36668aecfd3d811c4ed5eb23b1bfdb8c86fdd.tar.gz
bug #20691 (INSERT (DEFAULT) may insert garbage with NO DEFAULT NOT NULL field)
Some fields (GEOMETRY first of all) can't be handled properly in this case at all. So we return an error in this case mysql-test/r/default.result: result fixed mysql-test/r/gis.result: result fixed mysql-test/t/default.test: VIEW test added mysql-test/t/gis.test: testcase added sql/item.cc: set_defaults() changed with the 'reset()'
Diffstat (limited to 'mysql-test/r/gis.result')
-rw-r--r--mysql-test/r/gis.result4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result
index 870e160e563..df39a4d8ca2 100644
--- a/mysql-test/r/gis.result
+++ b/mysql-test/r/gis.result
@@ -717,3 +717,7 @@ desc t1;
Field Type Null Key Default Extra
GeomFromText('point(1 1)') geometry NO
drop table t1;
+create table t1 (g geometry not null);
+insert into t1 values(default);
+ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
+drop table t1;