Re: TRUTH about ROWID
>
> [Charles Francis (ancrcs4!cfrancis@ancrcs4.attmail.com) wrote]
>
big snip...
>
> I have not tested it, but I understand that when you do this, you are
> actually creating a new column in the table. The rowid is *already*
> there! The problem is that it is not unique within the fragmented
> table. It *is* unique within the fragment, though. When you add the
> rowid as mentioned above you are asking the engine to add a column
> which is stored as a serial value. And, as we all know, you can
> have only one serial column per table. Yes, this *does* count as the
> serial column.
>
> Long story short: If you add the unique rowid, you cannot have an
> additional serial column.
WRONG!
create table bob_payne
(
col1 serial,col2 integer
)
with rowids
fragment by round robin in rootdbs,bsi_01,bsi_02
;
works fine under 7.1 on a sun 2000....
> Can anyone verify this?
^^^^^
QED
> +------------------------------------------------------------------------+
> | Bob Payne Internet: bobp@dev.dsc.dalsys.com |
> | Systems Engineer : bpayne@netcom.com |
> | Dallas Systems Corporation Voice: (214) 383-2238 |
> +------------------------------------------------------------------------+
>
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | |
+----------------------------------------------------------------------------+
| Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 |
+----------------------------------------------------------------------------+