diff options
| author | unknown <holyfoot@deer.(none)> | 2006-06-22 22:11:27 +0500 |
|---|---|---|
| committer | unknown <holyfoot@deer.(none)> | 2006-06-22 22:11:27 +0500 |
| commit | 9a4b76ed64c58204868236f092f3f64dcfea96e2 (patch) | |
| tree | eae218212f618dd122fc6b4577476b4ebd0ae5f5 /mysql-test/r/gis.result | |
| parent | 5375bcad698da2c1ebbe33aff5d86ebccc896f4b (diff) | |
| download | mariadb-git-9a4b76ed64c58204868236f092f3f64dcfea96e2.tar.gz | |
bug #10166 (Signed byte values cause data to be padded)
The AsBinary function returns VARCHAR data type with binary collation.
It can cause problem for clients that treat that kind of data as
different from BLOB type.
So now AsBinary returns BLOB.
mysql-test/r/gis.result:
result fixed
mysql-test/t/gis.test:
test case added
sql/item_geofunc.h:
Now we return MYSQL_TYPE_BLOB for asBinary function
Diffstat (limited to 'mysql-test/r/gis.result')
| -rw-r--r-- | mysql-test/r/gis.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index bf2f3e2bf03..f7066e7edca 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -661,3 +661,13 @@ POINT(10 10) select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))); (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) POINT(10 10) +create table t1 (g GEOMETRY); +select * from t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def test t1 t1 g g 255 4294967295 0 Y 144 0 63 +g +select asbinary(g) from t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def asbinary(g) 252 8192 0 Y 128 0 63 +asbinary(g) +drop table t1; |