ALTER TABLE creates column with empty name, not possible to edit or delete it

[Former user]

Originally reported on Google Code with ID 266

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?


Please provide any additional information below.
Am using php app on ipad using sqlite admin. I ran sql query ALTER to add a field to
end of existing table. Must have got the format of the field name wrong ( I enclosed
it in double quotes ie "fieldname". It created the field but it had no name. When I
go into admin and press delete it won't let me. Neither will it let me rename the field.

Reported by BarraR4 on 2015-03-26 12:33:05

[Christopher Kramer]

Could you please provide the CREATE TABLE statement of the table?
To get it, open the table in phpLiteAdmin, click "Strcuture" tab and see "Query used
to create this table".

Reported by crazy4chrissi on 2015-03-26 13:19:06

[Christopher Kramer]

Okay, I was able to reproduce it.
I entered this in the SQL tab:
ALTER TABLE "t" ADD "test" INTEGER 
And it produced:
CREATE TABLE 't' ('aD' INTEGER, 'sae' INTEGER, '' INTEGER , PRIMARY KEY ("sae") )
Which was before:
CREATE TABLE 't' ('aD' INTEGER, 'sae' INTEGER, PRIMARY KEY ("sae") )

But I was able to delete this column....

Reported by crazy4chrissi on 2015-03-26 13:32:24 - Status changed: Accepted

[Christopher Kramer]

The current version from git is able to drop empty columns. Not to rename, but this
is not easy to solve and I consider this unnecessary.

I fixed the problems that lead to the creation of the column with the empty name. You
can find the current development version attached.

So I consider this fixed.

Reported by crazy4chrissi on 2015-03-26 15:49:33 - Status changed: Fixed - Labels added: Target-1.9.6

<hr> * Attachment: phpliteadmin.zip