#898 Insert Row tries to insert values into generated columns

3.1
open
Colin Bell
Core (461)
5
2012-12-29
2010-08-14
Anonymous
No

I have a table which includes an INT column the values of which are generated always by calling a stored Java function. When I right-click the table content and choose Insert Row, then try to enter a new row, I always end up with the error: "You may not override the value of generated column '<column-name>' ", whether I leave this column as <null> or try to enter a value. I can only enter numeric values and not DEFAULT which may have overcome it.
It appears that SQuirreL doesn't identify the column as a generated one - the table also has an identity column which is marked in the Input New Row Data dialog as "(auto-incr)", and before ading the new generated column I could add rows with auto-generated identity values without problem.
I'm using SQuirreL SQL client v3.1.2 on Windows XP SP3 with JRE 1.6.0_20. The DB is Derby 10.6.1.0.

Discussion

  • Rob Manning
    Rob Manning
    2010-08-14

    If the metadata for the column doesn't indicate that the column is auto-generated, then there is not much we can do. Check the columns for the table using the "Columns" tab and see if your column has "AUTOINCREMENT: start 1 increment 1" (or something like that) for COLUMN_DEF value. Let us know what you find out.

     

  • Anonymous
    2010-08-15

    discount jordan 3 isviuaehh online jordan 1 sale luisciget jordans Discount bdthby jordan 7 Sale sllmrnnrj Jordan Fly Wade tzgfyfeygeb Nike Free Run 2 chaussures oftgjf buy jordan 1 sneakers jyfxriy jordan 9 online iqseist cheap jordan retro sale
    [url=http://www.haberself.com/h/4333/][/url]

     
    Last edit: Anonymous 2015-07-10