postgresql - Different effects of ORDER BY clause on two servers -


my query:

select * table group id;

id field primary key, of course;

in 9.4.4 expected error:

column "table.name" must appear in group clause or used in aggregate function

but! in 9.4.5 works, in mysql.

can tell me - why? :)

postgres version not matter here. tables not identical. in 9.4.5 table column id primary key, while in 9.4.4 not.


Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

c# - Abstract method in public abstract class implementing an internal interface doesn't compile? -

internal interface i_foo { void bar(); } public abstract class a_foo : i_foo { public a_foo() { } abstract void i_foo.bar(); } public class foo : a_foo { public foo() : base() { } internal override void bar() { } } hello! i'm trying have methods visible outside code, , other visible assembly. purpose, made internal interface i_foo serve contract other parts of assembly, public abstract a_foo serve abstraction external code, , centralize constructor functionality, , several different classes foo implement a_foo , i_foo explicitly retain internal modifier. however, in a_foo class, get 'a_foo.i_foo.bar()' must declare body because not marked abstract, extern, or partial even though method marked "abstract". if add body, "abstract not valid modifier". i need method explicitly declared, in order internal in public class, , need abstract can override in actual implementation foo. why doesn't compiler let m...
Read more

authentication - Mongodb revoke acccess to connect test database -

i have ec2 instance mongodb 3.2.0 installed. have user admin access. can connect user , perform operation remotely. 1 can connect database test remote if knows ip mongo 11.11.11.11. although not able make operations, want restrict access user credentials can connect server. first need create users , grant roles users, example: use admin db.createuser( { user: "myuseradmin", pwd: "abc123", roles: [ { role: "useradminanydatabase", db: "admin" } ] } ) then need start server --auth parameter mongod --auth more information here
Read more