sheldon/sequel-pro

Modify table structure in GUI directly cause table info lose connection when using sphinx

Closed this issue · 1 comments

X-Bird commented

Reproduce Problem;

  1. create table using sphinx connection like this
CREATE TABLE `search_source`
(
    id          INTEGER UNSIGNED NOT NULL,
    weight      INTEGER NOT NULL,
    query       VARCHAR(3072) NOT NULL,
    INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://127.0.0.1:9312/source';

now the GUI'S Table Info panel likes this. Pay attention on Create syntax filed's . It shows the connection using sphinx.
the first step

  1. Alter table structure to add a column like name through Structure panel directly .
    second step
  2. Open up Table Info panel again. Pay attention on Create syntax filed's . It lost the connection ~!
    thrid step

Cause Problems

  • query result should return in name field will bot return any more instead of value 0.

Confirming the problem is this app causes

  • create table using sphinx connection like this add name column in the script
CREATE TABLE `search_source`
(
    id              INTEGER UNSIGNED NOT NULL,
    weight      INTEGER NOT NULL,
    query       VARCHAR(3072) NOT NULL,
    name       VARCHAR(255),
    INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://127.0.0.1:9312/source';
  • open up Table Info panel , it shows the connection still. Now i can get the result should return.
    fourth step