-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2013-04-23 14:30, Gijs Molenaar wrote:
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.
Can you try Feb2013-SP2 from http://dev.monetdb.org/downloads/testing/? I can't quickly reproduce the problem.
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)
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/ iQCVAwUBUXaIjj7g04AjvIQpAQKekAP9GkzgiIa/dmCDff1c/5vVUMh0/MTwxJzD DShIDBJXCo9us+xroNXhxKKPgXKrxu+7Kvc5gg1AfSjwYb1wdnbK97kK9tVdEkdV 3wAgCYCqE18HOQGMh2H9c59PfL1Lvw9x7CEkYUI1VoPk1oX75VYTHJL4ph6qIXBt rpeIjyP76Ps= =BkfI -----END PGP SIGNATURE-----