[#MDEV-5499] install_spider.sql tries to create tables with DEFAULT clause for TEXT columns

[MDEV-5499] install_spider.sql tries to create tables with DEFAULT clause for TEXT columns Created: 2014-01-02 Updated: 2014-02-06 Resolved: 2014-02-06
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.0.7
Fix Version/s:	10.0.8

Type:

Bug

Priority:

Major

Reporter:

Federico Razzoli

Assignee:

Sergei Golubchik

Resolution:

Fixed

Votes:

Labels:

spider

Description

When executing install_spider.sql, this error is returned:

ERROR 1101 (42000) at line 149: BLOB/TEXT column 'socket' can't have a default value

Each socket column is a TEXT with DEFAULT clause. Remove default and the code works.

Generated at Thu Feb 08 07:04:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.