Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Insertion of Data into WKB-Point Field causes error

kai's profile image kai posted 1 month ago in General Permalink

Not yet worth a bug report, because could be define as "user input error", but:

INSERT INTOdatabase.table(name,ortWKB) VALUES ('sfgh', 0x35332E36333236342C392E3932303339);

/* SQL Fehler (1416): Cannot get geometry object from data you send to the GEOMETRY field */

INSERT INTOdatabase.table(name,ortWKB) VALUES ('sfgh', POINT(53.63264,9.92039));

/* Betroffene Zeilen: 1 Gefundene Zeilen: 0 Warnungen: 0 Dauer von 1 Abfrage: 0,029 Sek. */

Definition: CREATE TABLEtable(datensatzIDSMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,nameCHAR(4) NOT NULL COLLATE 'utf8_general_ci',ortWKBPOINT NOT NULL, PRIMARY KEY (datensatzID) USING BTREE, INDEXdatensatzID(datensatzID) USING BTREE, INDEXname(name) USING BTREE, INDEXortWKB(ortWKB(32)), ) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB AUTO_INCREMENT=2 ; HeidiSQL: 11.3.0.6295 (64 bit, via wine) MariaDB: 10.4.22-MariaDB-1:10.4.22+maria~buster-log

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.