Details
Description
In contrast to generated column, which are evaluated when the next row from the result set to be inserted, currently default values and identity columns are generated "early", that is as part of avaluating the subquery (SELECT or VALUES as the case may be).
This does not currently cause a user visible bug in Derby, but it lies behind DERBY-3 and the effect Bryan observed in DERBY-4.
Additionally, "early" computation has given rise to much special handling and ensuing bugs, cf. DERBY-1644, DERBY-4413, DERBY-4419, DERBY-4425 and others.
DERBY-4397 requires this fix for correct behaviour with INSERT.
Attachments
Attachments
Issue Links
- is duplicated by
-
DERBY-4433 Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
- Closed
-
DERBY-3 Identity column not filled consecutively with "insert ... select distinct"
- Closed
- is related to
-
DERBY-4413 INSERT from SELECT DISTINCT gives assertFailure (sane), or NPE (insane) in presence of generated columns
- Closed
-
DERBY-4419 NullPointerException with INSERT INTO ... from UNION and identity columns
- Closed
-
DERBY-4425 NullPointerException with INSERT INTO ... from UNION and columns generated from expressions
- Closed
-
DERBY-4433 Cannot insert from EXCEPT/INTERSECT when target table has more columns than the source
- Closed
-
DERBY-4457 'Column value mismatch' in 'testDistinctInsertWithGeneratedColumn(...lang.DistinctTest)' on Jvm 1.5, 1.4, phoneME.
- Closed
-
DERBY-4460 test_031_derby_4413 failed in nightly regression run : ComparisonFailure: expected: 1 but was: 2
- Closed
-
DERBY-1644 NPE when inserting values to a table that has a column declared as generated by default as identity
- Closed
-
DERBY-4426 With generated columns, INSERT with DEFAULT inside a VALUES clause inside a UNION fails.
- Closed
-
DERBY-3 Identity column not filled consecutively with "insert ... select distinct"
- Closed
-
DERBY-4 "order by" is not supported for "insert ... select"
- Closed
- is required by
-
DERBY-4728 10.5 backport effort tracking issue
- Closed