If you change the formula column after you have entered data into the table, you will receive error when you want to enter new data.

You can repeat the error.

1. Create manually a table with a few columns

2. Add a formula column and add a row or 2 to test the formula

3. Delete the first formula column and add a new formula column

4. Now use a standard method of adding/ editing a row

5. The input form pops up for editing. No matter what you do, it gives you error message and refuses to save the new editing.

6. The table is fine and accepting new editing if you use Spreadsheet style editing.

I discover another error:

1. Create manually a table and add data.

2. Use the Create a new table using MySQL query to create a mirror table

3. Query and Select the fields from the table you created manually

4. Start input data to the table you created manually, some how if you skip some fields or enter the row incomplete, you won't see the row on your manually created table. However, it shows up on the MySQL query table and you have no way or editing or deleting the row.

I thought the sorting has some error but after I switched the data type, the sorting function works properly now

...