zzl zzl0

select * from crime_scene_report where date=20180115 and type='murder' and city='SQL City'

Description: Security footage shows that there were 2 witnesses. The first witness lives at the last house on "Northwestern Dr". The second witness, named Annabel, lives somewhere on "Franklin Ave".

select id, name, address_number, address_street_name, transcript
from person join interview

GPDB Version

$ git log --all --graph --decorate
* commit ce261a87769335185480b4b0c7f251669018938f (HEAD -> dev, origin/6X_STABLE)
| Author: Lisa Owen <[email protected]>
| Date:   Wed Aug 19 10:32:32 2020 -0700
|
|     docs - clarify gpcopy supported greenplum versions (#10621)

Date	Country/Region	Province/State	Confirmed	Recovered	Deaths
2020-01-22	Afghanistan		0	0	0
2020-01-23	Afghanistan		0	0	0
2020-01-24	Afghanistan		0	0	0
2020-01-25	Afghanistan		0	0	0
2020-01-26	Afghanistan		0	0	0
2020-01-27	Afghanistan		0	0	0
2020-01-28	Afghanistan		0	0	0
2020-01-29	Afghanistan		0	0	0
2020-01-30	Afghanistan		0	0	0

Why Git doesn't track renames – original email by Linus Torvalds

A copy / backup of Linus' email from 15 Apr 2005.

Version Control Diff, Patch and Merge Analysis (mostly Git)

Inspired by this: https://github.com/mndrix/merge-this

Intrafile-Intraline Change

Where branch A and branch B changes 2 different contiguous sets of characters on the same line, but the changes are non-overlapping. Both changes can change the line length arbitrarily.

	#!/usr/bin/env python
	# encoding: utf-8
	import struct


	class Function:
	def __init__(self, nparams, returns, code):
	self.nparams = nparams
	self.returns = returns
	self.code = code

	Note that this is sandbox. If you have not registered profiles in sandbox you
	will need to do so prior to making these calls. You will also need at least
	one campaign, ad group, and keyword before you see anything in the report.
	While in sandbox, we will return “dummy” data so that you can see how an actual
	report would look.

	To make it look nicer, I always export my access token prior to making calls.
	You could do the same for API-Scope (profile Id) if you wish. Make sure to use
	quotes around the access token if it isn’t URL encoded. It has a \| (pipe)
	symbol and your shell won’t like it.

	#!/usr/bin/python -O

	################################################################################
	################################################################################
	#
	# State-Based Text Merging Algorithm
	# For 6.033 Design Project 2
	# TA: Katherine Fang
	# 9 May 2012
	#