-
1. Re: auto incremented
rareddy Aug 7, 2012 10:22 AM (in response to gtduc)I am thinking this may be a regression. You can workaround by providing a default value for the column.
-
2. Re: auto incremented
shawkins Aug 7, 2012 11:01 AM (in response to rareddy)A default value isn't appropriate if you want to auto populate the incremented value.
What version are you on and are you perfoming the insert through a view?
Steve
-
3. Re: auto incremented
gtduc Aug 7, 2012 11:57 PM (in response to shawkins)Steve,
I'm working on MySQL 5.1, I also implement INSERT for view, I try to insert data with/without ID field, the result still the same. Ofcause that insert clause is tested ok with PHPAdmin
-
4. Re: auto incremented
shawkins Aug 8, 2012 7:33 AM (in response to gtduc)Can you post your vdb/query?
-
5. Re: auto incremented
shawkins Aug 13, 2012 1:39 PM (in response to shawkins)I could not reproduce this on 8.1 either directly against a source table with an auto_increment column or against an inherenetly updatable view with an auto_increment column. If this sill occurring for you, then we'll need the Teiid version and a more complete description of the scenario (a vdb/query) to help reproduce.
Steve
-
6. Re: auto incremented
gtduc Aug 14, 2012 11:16 PM (in response to shawkins)I'm sorry for delay feedback, because of project deadline.
I use Teiid 7.7 with jboss 5.1.0.
I try to create a simple application with 1 table, this bug still happen
-
test_autoincreated.zip 12.1 KB
-