Hi MonetDB people,
again I'm confused. Please have a look below. Maybe my SQL language knowledge is not sufficient, but I'm expecting one row for the last statement. Any idea? Btw, I'm using Feb2013-sp1.
sql>\d auth_user CREATE TABLE "sys"."auth_user" ( "id" INTEGER NOT NULL DEFAULT next value for "sys"."seq_5989", "password" VARCHAR(128) NOT NULL, "last_login" TIMESTAMP NOT NULL, "is_superuser" BOOLEAN NOT NULL, "username" VARCHAR(30) NOT NULL, "first_name" VARCHAR(30) NOT NULL, "last_name" VARCHAR(30) NOT NULL, "email" VARCHAR(75) NOT NULL, "is_staff" BOOLEAN NOT NULL, "is_active" BOOLEAN NOT NULL, "date_joined" TIMESTAMP NOT NULL, CONSTRAINT "auth_user_id_pkey" PRIMARY KEY ("id"), CONSTRAINT "auth_user_username_unique" UNIQUE ("username") );
sql>SELECT id,username FROM auth_user; +------+----------+ | id | username | +======+==========+ | 8 | joe | +------+----------+ 1 tuple (1.183ms)
sql>SELECT id,username FROM auth_user WHERE username='joe'; +------+----------+ | id | username | +======+==========+ | 8 | joe | | 8 | joe | +------+----------+ 2 tuples (0.907ms)