db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rob <fury...@gmail.com>
Subject row not ordered by primary key in a general query
Date Wed, 11 Nov 2009 00:36:03 GMT
Hi,

i have a table and i noted that if i do a query like   "select * from
table"  i get the data from this table not ordered by primary key (the
primary key field is not auto increment).
I know that i am not specifying any ORDER BY clause, but i saw, in
general, that this is the default behaviour in other databases system
(mysql, postgres, etc).

This was just an example query but i was just wondering if the table
may be corrupt or i can have some problems on the database or this is
normal.

Thanks for the help.
Bye.

Mime
View raw message