{"action":"created","issue":{"url":"https://api.github.com/repos/nextras/dbal/issues/16","labels_url":"https://api.github.com/repos/nextras/dbal/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/nextras/dbal/issues/16/comments","events_url":"https://api.github.com/repos/nextras/dbal/issues/16/events","html_url":"https://github.com/nextras/dbal/pull/16","id":107246207,"number":16,"title":"SqlProcessor: if not values insert defaults","user":{"login":"vitkutny","id":4031169,"avatar_url":"https://avatars.githubusercontent.com/u/4031169?v=3","gravatar_id":"","url":"https://api.github.com/users/vitkutny","html_url":"https://github.com/vitkutny","followers_url":"https://api.github.com/users/vitkutny/followers","following_url":"https://api.github.com/users/vitkutny/following{/other_user}","gists_url":"https://api.github.com/users/vitkutny/gists{/gist_id}","starred_url":"https://api.github.com/users/vitkutny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitkutny/subscriptions","organizations_url":"https://api.github.com/users/vitkutny/orgs","repos_url":"https://api.github.com/users/vitkutny/repos","events_url":"https://api.github.com/users/vitkutny/events{/privacy}","received_events_url":"https://api.github.com/users/vitkutny/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/nextras/dbal/labels/1-bug","name":"1-bug","color":"e11d21"},{"url":"https://api.github.com/repos/nextras/dbal/labels/3-priority-medium","name":"3-priority-medium","color":"DACEFA"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-09-18T17:43:48Z","updated_at":"2015-11-04T20:19:48Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/nextras/dbal/pulls/16","html_url":"https://github.com/nextras/dbal/pull/16","diff_url":"https://github.com/nextras/dbal/pull/16.diff","patch_url":"https://github.com/nextras/dbal/pull/16.patch"},"body":"When $value is empty (entity with primary key only), DBAL creates query\r\n```sql\r\nINSERT INTO \"table\" () VALUES ()\r\n```\r\nwhich is not valid (at least in pgsql - `syntax error at or near \")\"`), the query should be\r\n```sql\r\nINSERT INTO \"table\" DEFAULT VALUES\r\n```"},"comment":{"url":"https://api.github.com/repos/nextras/dbal/issues/comments/153851129","html_url":"https://github.com/nextras/dbal/pull/16#issuecomment-153851129","issue_url":"https://api.github.com/repos/nextras/dbal/issues/16","id":153851129,"user":{"login":"hrach","id":284263,"avatar_url":"https://avatars.githubusercontent.com/u/284263?v=3","gravatar_id":"","url":"https://api.github.com/users/hrach","html_url":"https://github.com/hrach","followers_url":"https://api.github.com/users/hrach/followers","following_url":"https://api.github.com/users/hrach/following{/other_user}","gists_url":"https://api.github.com/users/hrach/gists{/gist_id}","starred_url":"https://api.github.com/users/hrach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hrach/subscriptions","organizations_url":"https://api.github.com/users/hrach/orgs","repos_url":"https://api.github.com/users/hrach/repos","events_url":"https://api.github.com/users/hrach/events{/privacy}","received_events_url":"https://api.github.com/users/hrach/received_events","type":"User","site_admin":false},"created_at":"2015-11-04T20:19:48Z","updated_at":"2015-11-04T20:19:48Z","body":"Current solution does not work for MySQL. The rpoblem is, that PostgreSQL does not support such functionatity: INSERT INTO foo VALUES (), (), () - eg. multi default insert."}}